i have a huge problem. I have multiple excel files with same sheet names enter image description here I need to combine only sheets, not to create only one huge for examplae. Sheet Summer with Summer, Winter with Winter, not creating one sheet with all walues
import pandas as pd
import glob
import os
import xlrd
location = ("direction\*.xlsx")
excles_files = glob.glob(location)
How can i even have the sheet names to try
Pd.combine_sheet
xls = xlrd.open_workbook(location, on_demand=True)
print(xls.sheet_names())
This is not working Thank you