How to rename columns that have the same name?

Question

I would like to rename the column names, but the Data Frame contains similar column names. How do I rename them?

df.columns

Output:

Index([ 'Goods',
       'Durable goods','Services','Exports', 'Goods', 'Services', 'Imports', 'Goods', 'Services']

Here, there are three goods columns that have similar names. How can I rename a specific column?

Cross site duplicate: stackoverflow.com/questions/30650474. – Ynjxsjmh Apr 26 '21 at 15:16 — Ynjxsjmh, Apr 26 '21 at 15:16

score 11 · Accepted Answer · edited Aug 23 '19 at 13:11

11

You can use this:

df.columns = ['Goods_1', 'Durable goods','Services','Exports', 'Goods_2', 'Services', 'Imports', 'Goods_3', 'Services']

or if you have too many columns:

cols = []
count = 1
for column in df.columns:
    if column == 'Goods':
        cols.append(f'Goods_{count}')
        count+=1
        continue
    cols.append(column)
df.columns = cols

edited Aug 23 '19 at 13:11

Yury Wallet

103
2

answered Nov 20 '18 at 11:19

Mohit Motwani

601
1
7
23

i'd say this is the simplest and most straightforward solution. – Uralan Jul 09 '20 at 11:23
Is there any way to make it more dynamic? – Debuggerrr Mar 17 '21 at 12:00

score 2 · Answer 2 · edited May 30 '19 at 01:32

2

You can rename column name based on its position too:

df.rename(columns={ df.columns[1]: "new_col_name" })

Note: If you have similar columns names, all of them will be renamed.

edited May 30 '19 at 01:32

Stephen Rauch

1,783
11
21
34

answered Nov 20 '18 at 16:21

mannu

108
5

2

doesn't worked for me. – Michael D Oct 06 '19 at 10:49
2

The whole point is renaming columns with the same name, so this doesn't really help... – Danny David Leybzon May 29 '20 at 15:43
df.columns[1] will give a column name, and then it replaces all the columns with that name as "new_col_name" which defeats the whole purpose of this question. This answer is not useful – niths4u Nov 28 '20 at 15:52

How to rename columns that have the same name?

2 Answers2