Replace Index values with matched values in other dataframe

Question

I have the following DataFrame:

df1:

   Index   ColA  
     a      10   
     b       9   
     c      12   
     d      13

df2:

   Index  Letter  Names    
     0      d     Waylon    
     1      a     Marcus 
     2      z     Eddie 
     3      q     Justine 
     4      c     Angela 
     5      b     Joanna

I want to make to replace the index values in df1 with the corresponding values in df2, so the result would look like:

df1:

   Index   ColA  
   Marcus   10   
   Joanna    9   
   Angela   12   
   Waylon   13

Any ideas?

jezrael · Accepted Answer · 2017-11-17 12:31:28Z

1

You need rename by dictionary created by set_index with to_dict:

df1 = df1.rename(index=df1.set_index('Letter')['Names'].to_dict())

edited Nov 17, 2017 at 12:31

answered Nov 17, 2017 at 12:20

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gerard Over a year ago

Hi Jezrael, thanks for your swift response. I tried this, but keep getting the following error: 'Series' object is not callable. I might be because the column you called Index, is the actual index of the column..Do you know how to solve this?

Collectives™ on Stack Overflow

Replace Index values with matched values in other dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related