df1
index
age
name
1
15
BOB
2
19
ALICE
3
20
CHARLIE
df2
index
age
name
1
15
Bob
2
19
Alice
4
21
John
result
index
age
name
name1
1
15
BOB
Bob
2
19
ALICE
Alice