search

e7dal / bubble3

bubble3, PY3 only version
GNU General Public License v3.0
0 stars 0 forks source link

use pandas.io for storage and export #6

Open e7dal opened 6 years ago

e7dal commented 6 years ago
use https://pandas.pydata.org/pandas-docs/stable/io.html for export Format Type Data Description Reader Writer
text CSV read_csv to_csv
text JSON read_json to_json
text HTML read_html to_html
text Local clipboard read_clipboard to_clipboard
binary MS Excel read_excel to_excel
binary HDF5 Format read_hdf to_hdf
binary Feather Format read_feather to_feather
binary Parquet Format read_parquet to_parquet
binary Msgpack read_msgpack to_msgpack
binary Stata read_stata to_stata
binary SAS read_sas  
binary Python Pickle Format read_pickle to_pickle
SQL SQL read_sql to_sql
SQL Google Big Query read_gbq to_gbq
e7dal commented 6 years ago

reading and writing jsonlines is also trivial: https://stackoverflow.com/questions/20037430/pandas-reading-multiple-json-records-into-dataframe#22135309

https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_json.html lines : boolean, default False

Read the file as a json object per line.

New in version 0.19.0.

add pandas and eventuall remove dataset and tablib