Use dict to replace column names

Asked Feb 04 '21 at 16:25

Active Feb 04 '21 at 16:31

Viewed 29 times

I have a dataframe that I'd like to replace column names with based on a dictionary mapping

df = 
     A_  B_  C29  D_9
0    01  01  01   01
1    02  01  01   01 
2    03  01  01   01 
3    04  01  01   01

dict = 
    A_ : A
    B_ : B
    C29 : C
    D_9 : D

I've tried using replace and rename which haven't worked

df= df.rename(columns = dict)
df= df.replace(dict)

edited Feb 04 '21 at 16:28

Ch3steR

20,090
4
28
58

asked Feb 04 '21 at 16:25

Squidf20

2

`df.rename(columns=dict)`? And don't use built-in keywords as variable names. – Ch3steR Feb 04 '21 at 16:29
Your rename coded should work as long as your aren't having whitespace issues. – Scott Boston Feb 04 '21 at 16:30

Use dict to replace column names

0 Answers0