pd read_excel (filename, sheet_name = 'sheet1') pd read_excel (filename, sheet_name = 'sheet2') Problem description First of all, right now there is PR # to homogenize arguments names, but in 03 both arguments are accepted although only sheetname is documented Understanding read_excel The read_excel function is a feature packed pandas function For this specific case, we can use the sheet_name parameter to streamline the reading in of all the sheets in our Excel file Most of the time, you Previous Write a Pandas program to get the data types of the given excel data (coalpublic13xlsx ) fields Next Write a Pandas program to find the sum, mean, max, min value of 'Production (short tons)' column of coalpublic13xlsx file
Combine Multiple Excel Worksheets Into A Single Pandas Dataframe Geeksforgeeks