Guest User

Untitled

a guest
Jul 18th, 2018
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 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
Add Comment
Please, Sign In to add comment