search

impactlab / eemeter

‼️ MOVED TO https://github.com/openeemeter/eemeter - Core computation engine for the Open Energy Efficiency Meter
https://eemeter.readthedocs.io/
MIT License
25 stars 13 forks source link

Excel spreadsheet importer #82

Closed philngo closed 9 years ago

philngo commented 9 years ago

Import directly from Excel spreadsheets; can mimic schema of csv importer.

philngo commented 9 years ago

We could accelerate development here by piggybacking on pandas, which comes with an excellent array of table importers which all end up in a pandas dataframe:

    read_csv
    read_excel
    read_hdf
    read_sql
    read_json
    read_msgpack (experimental)
    read_html
    read_gbq (experimental)
    read_stata
    read_clipboard
    read_pickle

We could then write a single import_pandas_dataframe(df) function which we wrap for each of these read_{format} functions.

philngo commented 9 years ago

e161938fd3fe16de8c6f06d63b2bdd0aee78365b implements this