Rename column header from another dataframe

Question

I have two dataframes where 1, 2, 3 is the connection between the dataframes:

              1    2    3 
2016-10-03   12   10   10 
2016-10-04   4     4    5 
......

and
     name    year
1   apple    2001
2   lemon    2002
3   kiwi     1990

The end result should be:

              apple    lemon    kiwi 
2016-10-03       12       10      10 
2016-10-04        4        4       5 
......

I can't figure out how to do this.

check also: http://stackoverflow.com/questions/11346283/renaming-columns-in-pandas — Nikos Tavoularis, Oct 14 '16 at 07:52

score 2 · Answer 1 · answered Oct 12 '16 at 21:28

2

You can use rename, which does not require the two DataFrames to have the keys in the same order:

df1 = df1.rename(columns=df2['name'])

answered Oct 12 '16 at 21:28

root

32,715
6
74
87

Rename column header from another dataframe

1 Answers1