Output multiple pandas DataFrames to CSV with custom name

Question

I am trying to output multiple csvs from a function - but also name the csv per the name of the df.

dfs = ( df1, df2 , df3 , df4)

for df in dfs:

    def to_csvs(df, 'df name as csv name'):
        df.to_csv('example.csv')
        return df

I want to use a loop to feed in my multiple dfs and have a parameter in the function input that would name the csv output as well - is that possible?

What have you tried? Also, I recommend not defining a function inside a for-loop. Do it outside and then call the function inside the loop. — Ian Thompson
– Ian Thompson, Commented Feb 20, 2019 at 22:33

Toby Petty · Accepted Answer · 2019-02-20 22:34:36Z

2

If you want to customize the CSV names you could store your DFs in a dict with the key as the CSV name, e.g.:

dfs = {"df1 name":df1, "df2 name":df2}  # ..etc

for k, v in dfs.items():
    v.to_csv('./{}.csv'.format(k)))

answered Feb 20, 2019 at 22:34

Toby Petty

4,6901 gold badge19 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Output multiple pandas DataFrames to CSV with custom name

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related