How to read EXCEL files in for-loop with python?

Question

I am a beginner of Python.
Now, I have files "Pref1" and "Pref2".
I would like to read files and define data frame's names with for-loop fuction (there are so many files).
I tried below.

for i in [1,2]:
    f"df{i} = pd.read_excel('Pref{i}.xlsx', sheet_name= 'Sheet2').dropna(axis=0)

However, codes do not work. If you have good ideas, please tell me. Thank you.

for i in range(1,2):

user4136999
– user4136999

2022-07-16 09:37:16 +00:00
Commented Jul 16, 2022 at 9:37 — user4136999
– user4136999, Commented Jul 16, 2022 at 9:37

vignesh kanakavalli · Accepted Answer · 2022-07-16 07:13:54Z

2

Use a dictionary to save your data frames with preferred names and get them later

CODE

import pandas as pd

df_dict = {}

for i in [1, 2]:
    df_dict["df"+str(i)] = pd.read_excel(f'Pref{i}.xlsx', sheet_name='Sheet2').dropna(axis=0)

df1 = df_dict["df1"]
df2 = df_dict["df2"]

answered Jul 16, 2022 at 7:13

vignesh kanakavalli

5274 silver badges12 bronze badges

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

2 Comments

Hiroki Over a year ago

Thank you very much!! The code works!! But is it difficult to save data and name at once?

vignesh kanakavalli Over a year ago

A dictionary or List is the only way for achieving this

Collectives™ on Stack Overflow

How to read EXCEL files in for-loop with python?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related