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))
Asked
Active
Viewed 15 times
0
-
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