Can't Rename Columns of Dataframe

Question

I can't seem to rename my columns in a dataframe.

I tried this: df2.columns['Rating','Spread','Cnt']

When I look at the dataframe, the Cnt is not there.

I also tried this: df2.rename(columns={'Rating','Spread','Cnt'}, inplace=True)

Again, after I run the script, the Cnt doesn't show up. All I have is the first two field names; the third one keeps dropping off. How can I fix this?

Does this answer your question? [Renaming columns in pandas](https://stackoverflow.com/questions/11346283/renaming-columns-in-pandas) — AMC, Feb 08 '20 at 01:13

score 3 · Accepted Answer · answered Jan 10 '20 at 18:52

3

You need to pass a dictionary to the columns argument in the rename function, like this:

df.rename(columns={"old_name": "new_name"})

Check the documentation

answered Jan 10 '20 at 18:52

MkWTF

1,372
7
11

score 1 · Answer 2 · answered Jan 10 '20 at 18:52

1

Try this

df2.rename(columns={'OldName1':'Rating','OldName2':'Spread','OldName3':'Cnt'}, inplace=True)

Also check this out

Pandas documentation

answered Jan 10 '20 at 18:52

Manuel

730
7
25

score 1 · Answer 3 · answered Jan 10 '20 at 18:54

1

You have to tell pandas what you want to change the name to.

df = df.rename(columns={'some_column': 'new_column'}, axis=1)

answered Jan 10 '20 at 18:54

alex067

3,159
1
11
17

FYI, `axis=1` is redundant in this case since you have passed `columns` as an argument – rahlf23 Jan 10 '20 at 19:18
I got it working. Thanks to all. – ASH Jan 11 '20 at 00:26

Can't Rename Columns of Dataframe

3 Answers3