How to rename columns in Pandas automatically?

Question

I have a Dataframe with 240 columns. But they are named by number from 0 to 239.

How can I rename it to respectively 'column_1', 'column_2', ........, 'column_239', 'column_240' automatically?

more details at : https://stackoverflow.com/questions/11346283/renaming-column-names-in-pandas — invertedOwlCoding, Jul 15 '22 at 20:02

score 5 · Accepted Answer · answered Jul 15 '22 at 20:08

You can use:

df.columns = df.columns.map(lambda x: f'column_{x+1}')

Example output:

   column_1  column_2  column_3  column_4  column_5  column_6  column_7  column_8  column_9  column_10
0         0         1         2         3         4         5         6         7         8          9

Used input:

df = pd.DataFrame([range(10)])

Tortar · Answer 2 · 2022-07-15T21:19:39.437

3

To do it with one column you can use

df.rename(columns = {0:'column_1'}, inplace = True)

Instead, for multiple columns

df.rename(columns = {x: "column_"+str(x+1) for x in range(0,240)}, inplace = True)

edited Jul 15 '22 at 21:19

answered Jul 15 '22 at 20:01

Tortar

625
5
15

2

I believe this is the most elegant solution. Just for clarity I'd like to leave the most basic example of renaming one column manually `df.rename(columns = {'0':'column_1'}, inplace = True)` – tebkanlo Jul 15 '22 at 20:16
It doesn't work... – tiber septim Jul 15 '22 at 20:53
@Alexander APS then I think that the type of the columns is int, see edit, now it should work – Tortar Jul 15 '22 at 21:19

How to rename columns in Pandas automatically?

2 Answers2