Reading multi-sheet Excel files in Pandas with sheet_name

Reading multi-sheet Excel files in Pandas with sheet_name

Reading a multi-sheet Excel file into Python Pandas?

Ask for a specific sheet by name or index:

df = pd.read_excel('file.xlsx', sheet_name='profits') 

Get a dict of data frames with specific sheets:

df_dict = pd.read_excel('file.xlsx', sheet_name=['profits', 'salaries'])