pandas.merage

import pandas as pd
df1=pd.DataFrame({'name':['kate','herz','catherine','sally'],
'age':[25,28,39,35]})

df2=pd.DataFrame({'name':['kate','herz','sally'],
'score':[70,60,90]})

print("df1:\n", df1)
print("df2:\n", df2)
temp = pd.merge(df1,df2, how="right")

print("temp:", temp)
NaN
temp = pd.merge(df1,df2, how="left")

print("temp:", temp)
df1:
    age       name
0   25       kate
1   28       herz
2   39  catherine
3   35      sally
df2:
     name  score
0   kate     70
1   herz     60
2  sally     90
temp:    age   name  score
0   25   kate     70
1   28   herz     60
2   35  sally     90
temp:    age       name  score
0   25       kate   70.0
1   28       herz   60.0
2   39  catherine    NaN
3   35      sally   90.0