Skip to content

Instantly share code, notes, and snippets.

@wkarney

wkarney/excel_pd_import.py

Created March 16, 2020 15:23
Show Gist options
  • Save wkarney/15e5b9e5836c5c83d2a01a84bb2d99df to your computer and use it in GitHub Desktop.
Save wkarney/15e5b9e5836c5c83d2a01a84bb2d99df to your computer and use it in GitHub Desktop.
Download ZIP
[Dealing with Excels with Multiple Tabs etc. in Pandas] #pandas #python
Raw
excel_pd_import.py
import pandas as pd
# Read in excel file and gathering sheet names
xls = pd.ExcelFile('file_path')
sheet_names = xls.sheet_names
sheet_names
for name in sheet_names:
<df_name> = pd.read_excel('file_path', name)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment