43zombiegit
43zombiegit

Reputation: 127

How to change the columns of multiple dataframes?

I have 8 dataframes I am working with. I want to rename all of the columns of each data frame to the same strings. I have tried:

dfs = [df1, df2, df3, df4, df5, df6, df7, df8, df9]
renames_dfs = []
for df in dfs:
    renames_dfs.append(df.rename(columns={'column1':'column2','column3':'column4'}))

#renames_dfs

Where I would keep going with the column names beyond 4. It also would put the new renamed dataframes in a list, whereas I want them to be new variables.

Upvotes: 1

Views: 2182

Answers (1)

oppressionslayer
oppressionslayer

Reputation: 7222

Do you mean this, to rename those columns:

dfs = [df1, df2, df3, df4, df5, df6, df7, df8, df9]
renames_dfs = []
for df in dfs:
    df.rename(columns={'column1':'column2','column3':'column4'}), inplace=True)

Upvotes: 1

Related Questions