Read multiple csvs into multiple dataframes in Pandas

Question

Is there a way to read multiple csv files into Pandas through a loop and define them as such?

for i in ['a', 'b', 'c', 'd']:
    csv_(i) = pd.read_csv('C:/test_{}.csv'.format(i))

I see multiple questions about reading and appending multiple csvs into a single dataframe. Not the other way around.

jezrael · Accepted Answer · 2017-03-21 17:25:43Z

8

You can use dict comprehension for dict of DataFrames:

dfs = {i: pd.read_csv('C:/test_{}.csv'.format(i)) for i in ['a', 'b', 'c', 'd']}

print (dfs['a'])

answered Mar 21, 2017 at 17:25

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

4 Comments

Charlie G Over a year ago

Relevant: stackoverflow.com/questions/1373164/…

cpt_python Over a year ago

Oh wonderful! Initially I dismissed the idea but after playing with it a little all I had to do was add each dict/DataFrames into a list to perform multiple merge.

jezrael Over a year ago

Thank you, If need one big dataframe, maybe help this

cpt_python Over a year ago

Much appreciated!

Collectives™ on Stack Overflow

Read multiple csvs into multiple dataframes in Pandas

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related