0
folder = r'C:/Users/User1/folder/'

files = os.listdir(folder)

for file in files:
    if file.endswith('.xlsx'):
        df = pd.read_excel(os.path.join(folder,file))
Cimbali
  • 10,545
  • 37
  • 62
Swarlos
  • 17
  • 4
  • Use `dfs = [pd.read_excel(os.path.join(folder,file)) for file in files if file.endswith('.xlsx')]` – jezrael Aug 18 '21 at 08:45

0 Answers0