Change column names of Pandas dataframes contained in a list

Question

I have a list of Pandas dataframes:

df_list = [df1, df2, df3]

The dataframes have the same column names; let's call them "col1", "col2" and "col3".

How can I change the column names to "colnew1", "colnew2" and "colnew3", without using a loop?

Does this answer your question? [Renaming columns in pandas](https://stackoverflow.com/questions/11346283/renaming-columns-in-pandas) — sushanth, Jun 20 '20 at 14:24
List comprehension and using inplace. `[d.rename(columns=lamdba x: x[:3] + 'new' + x[-1], inplace=True) for d in df_list]` Maybe... on phone can't test. — Scott Boston, Jun 20 '20 at 14:31
Thanks Scott, that was helpful. It was the kind of compact code I was looking for. — user4832512, Jun 20 '20 at 19:36

score 1 · Answer 1 · answered Jun 20 '20 at 14:29

1

df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
df.rename(columns={"A": "a", "B": "c"})
   a  c
0  1  4
1  2  5
2  3  6

This is taken right from the pandas website.

answered Jun 20 '20 at 14:29

unltd_J

1 Answers1