This article describes how to use pandas to read in multiple Excel tabs and combine into a single dataframe.
Source : Combine Multiple Excel Worksheets Into a Single Pandas Dataframe – Practical Business Python
This article describes how to use pandas to read in multiple Excel tabs and combine into a single dataframe.
Source : Combine Multiple Excel Worksheets Into a Single Pandas Dataframe – Practical Business Python