Advertisement
Guest User

Untitled

a guest
Apr 17th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. email cat class_price
  2. 0 email1@gmail.com cat1 1
  3. 1 email2@gmail.com cat2 2
  4. 2 email3@gmail.com cat2 4
  5. 3 email1@gmail.com cat2 4
  6. 4 email2@gmail.com cat2 1
  7. 5 email3@gmail.com cat1 3
  8. 6 email1@gmail.com cat1 2
  9. 7 email2@gmail.com cat2 1
  10. 8 email3@gmail.com cat2 4
  11. 9 email1@gmail.com cat2 2
  12. 10 email2@gmail.com cat3 1
  13. 11 email3@gmail.com cat1 1
  14.  
  15. test_df2 = test_df.groupby(['email','cat'])['class_price'].max()
  16.  
  17. email cat
  18. email1@gmail.com cat1 2
  19. cat2 4
  20. email2@gmail.com cat2 2
  21. cat3 1
  22. email3@gmail.com cat1 3
  23. cat2 4
  24.  
  25. email cat maxvalue
  26. email1@gmail.com cat2 2
  27. email2@gmail.com cat2 2
  28. email3@gmail.com cat3 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement