How to populate column values in one data frame from column values of another data frame based on key if the exist

Question

I have two dataframes df and df1 as shown below. The key for populating the value is Name

df

ID Name   City  Country_Code
1  Rahul  
2  Rachel 
3  Mathew
4  James
5  Rose
6  David

df1

Name   City_Name  CC
Rahul  Delhi      IND
Rachel Munich     GR
Mathew
James  Paris      FR
David  London     GB

Expected Result

df

ID Name   City       Country_Code
1  Rahul   Delhi     IND
2  Rachel  Munich    GR
3  Mathew
4  James    Paris    FR
5  Rose
6  David   London    GB

How can this be done in python?