how can i make pandas dataframe objects using for loop in python

Question

I want to create multiple pandas data frames df1,df2,df3,... from multiple files file1.xlsx, file2.xlsx ... using for loop

filenames = {'file1.xlsx','file2.xlsx','file3.xlsx','file4.xlsx','file5.xlsx'}

for i in range(len(filenames)):
    df+str(i) = pd.read.excel(filenames[i])

and get the syntax error 'can't assign to operator' how can I solve this problem?

BENY · Accepted Answer · 2020-05-18 14:13:05Z

1

Try locals but not recommend

filenames = {'file1.xlsx','file2.xlsx','file3.xlsx','file4.xlsx','file5.xlsx'}
variables = locals()
for i in range(len(filenames)):
   variables["df{0}".format(i)]  = pd.read.excel(filenames[i])

We usually save it into dict

filenames = {'file1.xlsx','file2.xlsx','file3.xlsx','file4.xlsx','file5.xlsx'}
d={'df'+str(i) :  pd.read.excel(filenames[i]) for i in range(len(filenames))}

answered May 18, 2020 at 14:13

BENY

324k22 gold badges176 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JQadrad · Accepted Answer · 2020-05-18 14:14:51Z

0

Could you try something like this? Use exec to assign the value to the variable?

filenames = ['file1.xlsx','file2.xlsx','file3.xlsx','file4.xlsx','file5.xlsx']

for fname in filenames:
    dfname = fname.split('.')[0]
    df = pd.read_excel(fname)
    exec("%s=%s" % (dfname , df))

answered May 18, 2020 at 14:14

JQadrad

5413 silver badges16 bronze badges

Collectives™ on Stack Overflow

how can i make pandas dataframe objects using for loop in python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related