0

df1:

A B
1 2

df2:

C D
3 2 

to:

B A C
2 1 3

i try:

df = df1.merge(df2, how='left', left_on='B', right_on='D')

but it make:

D A C
2 1 3

how "D" change on "B", is it merge can do (without suffixes=('_x', '_y') using)?

0 Answers0