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
index1
age1
name1
1
15
BOB
1
15
Bob
2
19
ALICE
2
19
Alice