I have a folder that contains n Excel files. The variable 'n' changes every day. Each Excel file has just one sheet with the same number of columns.
I want to write code that creates n different dataframes (df1, df2, df3, ... , dfn) according to n numbers of Excel files that exist in the folder.
I just want to create different dataframes. I don't want to merge the Excel files into one.
I tried this solution: Create multiple dataframes in loop
This is the code so far:
import os
import pandas as pd
import glob
df = pd.DataFrame()
path = os.getcwd()
filenames = glob.glob(path + "\*.xlsx")
d = {}
for file in filenames:
df = pd.read_excel(file)
d = {file: pd.DataFrame() for file in filenames}
This is what I'm getting: empty dataframe
Columns: []
Index: []
