csvbase
A simple web database.
What it's about
- Paste your CSV file
- Get a table on the web you can share with people via url
- They can export it into pandas/excel/spark/whatever
In short: making it really easy to share dataframes.
For example
A good demo is meripaterson/stock-exchanges, which is an up-to-date list of the world's stock exchanges.
If you wanted to load that dataset into pandas, for example, you would run:
>>> import pandas as pd
>>> # you just put in the same url as on the website, bit of magic here
>>> stock_exchanges = pd.read_csv("https://csvbase.com/meripaterson/stock-exchanges")
>>> stock_exchanges
csvbase_row_id Continent Country Name MIC Last changed
0 1 Africa Lesotho HYBSE NaN 2019-03-25
1 2 Asia Kazakhstan Astana International Financial Centre AIXK 2018-11-18
2 3 Africa South Africa ZAR X ZARX 2018-11-18
3 4 South America Argentina Bolsas y Mercados Argentinos NaN 2018-04-02
4 5 North America United States of America Delaware Board of Trade NaN 2018-04-02
.. ... ... ... ... ... ...
246 247 North America United States of America Long-Term Stock Exchange LTSE 2020-09-14
247 248 North America United States of America Miami International Securities Exchange MIHI 2020-09-24
248 249 North America United States of America Members' Exchange NaN 2020-09-24
249 250 Africa Zimbabwe Victoria Falls Stock Exchange NaN 2020-11-01
250 251 Asia China Beijing Stock Exchange NaN 2021-12-27
[251 rows x 6 columns]It's just as easy to:
- Export to XLSX (MS Excel)
- Export to R
- Execute create/read/update/delete operations via a simple REST API
- And get the CSV back as well, of course
A few more details
This repo has the full sourcecode for the website. There is no other repo with more stuff in it. Except the client code.
For tips on how to get started, see HACKING.md.
Csvbase is licensed under the AGPLv3 or later. You're free to reuse it as you like under that licence but please bear in mind the one-man-and-his-dog nature of this operation: I can't support you and there is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.