Q:

Replace Index values with matched values in other dataframe

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?

A:

You need rename by dictionary created by set_index with to_dict:
df1 = df1.rename(index=df1.set_index('Letter')['Names'].to_dict())

