Skip to content

Instantly share code, notes, and snippets.

@jiffyclub

jiffyclub/Excel to Pandas.ipynb

Created July 15, 2017 05:08
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save jiffyclub/9ab668f63c3d0f9adf3e730dc37cd419 to your computer and use it in GitHub Desktop.
Save jiffyclub/9ab668f63c3d0f9adf3e730dc37cd419 to your computer and use it in GitHub Desktop.
Download ZIP
Using pandas and xlrd to concatenate multiple excel sheets into a single dataframe. In answer to this Stack Overflow question: https://stackoverflow.com/questions/45113070/how-do-i-make-this-function-for-concatenating-excel-sheets-from-a-single-file-mo#
Display the source blob
Display the rendered blob
Raw
Excel to Pandas.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@carlosawb
Copy link

carlosawb commented Jun 6, 2019 •
edited

A small correction, it should be df_dict.items() instead of dfs.items() on cell 7

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment