Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- df1 = pd.DataFrame(columns=["A", "B", "C"], data=[['a1' , 'b1', 'c1'], ['a2', 'b2', 'c2'], ['a3', 'b3', 'c3']], index=[1,2,3])
- df2 = pd.DataFrame(columns=["D", "E"], data=[['d2' , 'e2'], ['d3' , 'e3']], index=[2,3])
- print (df1)
- print (df2)
- Out:
- A B C
- 1 a1 b1 c1
- 2 a2 b2 c2
- 3 a3 b3 c3
- D E
- 2 d2 e2
- 3 d3 e3
- A B C D E
- 2 a2 b2 c2 d2 e2
- 3 a3 b3 c3 d3 e3
- merge = df1.merge(df2, how='inner', left_on=df1.index, right_on=df2.index)
Add Comment
Please, Sign In to add comment