Guest User

Untitled

a guest
Jul 18th, 2018
8,882
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. Name: ID: emails:
  2. apple 372 frt@apple.com
  3. yandex 295 drft@yandex.com
  4. mail 215 sdrf@mail.ru
  5. king 352 king@king@com
  6. mac 097 srt@mac.com
  7. yandex 295 info@yandex.com
  8. mail 215 ivanov@mail.ru
  9.  
  10. Name: ID: emails:
  11. apple 372 frt@apple.com
  12. yandex 295 drft@yandex.com,info@yandex.com
  13. mail 215 sdrf@mail.ru, ivanov@mail.ru
  14. king 352 king@king@com
  15. mac 097 srt@mac.com
  16.  
  17. In [161]: (df.groupby(['Name','ID'])
  18. ['emails']
  19. .apply(','.join)
  20. .reset_index(name='emails'))
  21. Out[161]:
  22. Name ID emails
  23. 0 apple 372 frt@apple.com
  24. 1 king 352 king@king@com
  25. 2 mac 97 srt@mac.com
  26. 3 mail 215 sdrf@mail.ru,ivanov@mail.ru
  27. 4 yandex 295 drft@yandex.com,info@yandex.com
  28.  
  29. In [24]: df
  30. Out[24]:
  31. Name ID emails phone
  32. 0 apple 372 frt@apple.com +1111
  33. 1 yandex 295 drft@yandex.com +2222
  34. 2 mail 215 sdrf@mail.ru +3333
  35. 3 king 352 king@king@com +4444
  36. 4 mac 97 srt@mac.com +5555
  37. 5 yandex 295 info@yandex.com +6666
  38. 6 mail 215 ivanov@mail.ru +7777
  39.  
  40. In [25]: (df.groupby(['Name','ID'])
  41. ...: [['emails','phone']]
  42. ...: .agg(','.join)
  43. ...: .reset_index())
  44. ...:
  45. ...:
  46. Out[25]:
  47. Name ID emails phone
  48. 0 apple 372 frt@apple.com +1111
  49. 1 king 352 king@king@com +4444
  50. 2 mac 97 srt@mac.com +5555
  51. 3 mail 215 sdrf@mail.ru,ivanov@mail.ru +3333,+7777
  52. 4 yandex 295 drft@yandex.com,info@yandex.com +2222,+6666
Add Comment
Please, Sign In to add comment