Guest User

Untitled

a guest
Oct 5th, 2018
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. df = df1[['username', 'date', 'time', 'duration']].merge(df2, left_on='username', right_on='username')
  2.  
  3. date duration email phone time username
  4. 0 2015 5 14:00 aa
  5. 1 2016 10 16:00 bb
  6.  
  7. email phone username
  8. 0 rrr@ 333444 aa
  9. 1 tt@ 555533 bb
  10.  
  11. username date time duration email phone
  12. 0 aa 2015 14:00 5 rrr@ 333444
  13. 1 bb 2016 16:00 10 tt@ 555533
  14.  
  15. df1 = pd.DataFrame({
  16. 'username':list('abccdd'),
  17. 'email address':[''] * 6,
  18. 'phone number':[''] * 6,
  19. 'duration':[5,3,6,9,2,4],
  20. })
  21. print (df1)
  22. username email address phone number duration
  23. 0 a 5
  24. 1 b 3
  25. 2 c 6
  26. 3 c 9
  27. 4 d 2
  28. 5 d 4
  29.  
  30. df2 = pd.DataFrame({
  31. 'username':list('abcd'),
  32. 'email address':['a@a.sk','b@a.sk','c@a.sk','d@a.sk'],
  33. 'phone number':range(4)
  34. })
  35. print (df2)
  36. username email address phone number
  37. 0 a a@a.sk 0
  38. 1 b b@a.sk 1
  39. 2 c c@a.sk 2
  40. 3 d d@a.sk 3
  41.  
  42. df = (df1.merge(df2, on='username', how='left', suffixes=('_',''))
  43. .drop(['email address_','phone number_'], axis=1))
  44. print (df)
  45. username duration email address phone number
  46. 0 a 5 a@a.sk 0
  47. 1 b 3 b@a.sk 1
  48. 2 c 6 c@a.sk 2
  49. 3 c 9 c@a.sk 2
  50. 4 d 2 d@a.sk 3
  51. 5 d 4 d@a.sk 3
Add Comment
Please, Sign In to add comment