Guest User

Untitled

a guest
Nov 15th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. df1 = pd.DataFrame(columns=["A", "B", "C"], data=[['a1' , 'b1', 'c1'], ['a2', 'b2', 'c2'], ['a3', 'b3', 'c3']], index=[1,2,3])
  2. df2 = pd.DataFrame(columns=["D", "E"], data=[['d2' , 'e2'], ['d3' , 'e3']], index=[2,3])
  3. print (df1)
  4. print (df2)
  5.  
  6. Out:
  7. A B C
  8. 1 a1 b1 c1
  9. 2 a2 b2 c2
  10. 3 a3 b3 c3
  11.  
  12. D E
  13. 2 d2 e2
  14. 3 d3 e3
  15.  
  16. A B C D E
  17. 2 a2 b2 c2 d2 e2
  18. 3 a3 b3 c3 d3 e3
  19.  
  20. merge = df1.merge(df2, how='inner', left_on=df1.index, right_on=df2.index)
Add Comment
Please, Sign In to add comment