pandas multiple dataframes one excel sheet code example
Example 1: merge multiple excel workssheets into a single dataframe
df = pd.concat(pd.read_excel(workbook_url, sheet_name=None), ignore_index=True)
Example 2: how to read excel with multiple pages on pandas
pd.read_excel('filename.xlsx', sheet_name = 'sheetname')