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)?
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)?