I have two dataframes, with one column that has unique values in each dataframe but is the same in both dataframe (some of the values match), I want to merge the two dataframes matching the values on the columns (x must match y column)
df1 = pd.DataFrame({'x': ['1', '2', '3', '4', '5', '6'],
'y': ['A', 'B', 'C', 'D', 'E', 'F']})
df2 = pd.DataFrame({'x': ['3', '4', '10', '2', '12', '6', '8', '9'],
'y': ['A', 'G', 'H', 'E', 'F', 'J', 'L', 'B']})
x y
0 1 A
1 2 B
2 3 C
3 4 D
4 5 E
5 6 F
x y
0 3 A
1 4 G
2 10 H
3 2 E
4 12 F
5 6 J
6 8 L
7 9 B
The result I want is:
x y_1 y_2
0 3 A C
1 4 G D
2 2 E B
3 6 J F
You need to sign in to view this answers