Sending multiple Pandas DataFrames .to_csv() in a loop

Question

I have five DataFrames, df1, df2, df3, df4, df5.

I can save each one individually with:

df1.to_csv('~/Desktop/df1.tsv', index=False, header=False, sep='\t')
df2.to_csv('~/Desktop/df2.tsv', index=False, header=False, sep='\t')
...

Can I do this in a loop where the file path ends with the name of the variable that holds the Dataframe?

Aviad Rozenhek · Accepted Answer · 2019-11-22 23:24:37Z

4

when you say

the name of the DataFrame

do you mean the name of the variable that holds the dataframe? that won't work.

but here's something that will work:

dfs = [df1, df2, df3, df4, df5]
for i, df in enumerate(dfs):
   df.to_csv(f'~/Desktop/df{i}.tsv', index=False, header=False, sep='\t')

if you wanted unique names

dfs = [df1, df2, df3, df4, df5]
names = ["apple", "bananna", "cherry", "drizz", "ebola"]
for name, df in zip(names, dfs):
   df.to_csv(f'~/Desktop/df{name}.tsv', index=False, header=False, sep='\t')

edited Nov 22, 2019 at 23:24

answered Nov 22, 2019 at 23:12

Aviad Rozenhek

2,4493 gold badges28 silver badges44 bronze badges

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

2 Comments

Cactus Philosopher Over a year ago

Rereading your answer, if I wanted to save the DataFrames with unique names, e.g. apple, orange, peach, pear - is this possible? So instead of df1,df2,dfN, what if the variable names were apple, orange, peach, etc.

Aviad Rozenhek Over a year ago

@TipsyHyena easy. check the answer

Collectives™ on Stack Overflow

Sending multiple Pandas DataFrames .to_csv() in a loop

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