Advertisement
Guest User

Untitled

a guest
Jun 19th, 2018
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. df_test = pd.DataFrame({'id':[1,1,1,2,2,2,2,3,4],'value':[1,2,3,1,2,3,4,1,1]})
  2. id value
  3. 0 1 1
  4. 1 1 2
  5. 2 1 3
  6. 3 2 1
  7. 4 2 2
  8. 5 2 3
  9. 6 2 4
  10. 7 3 1
  11. 8 4 1
  12.  
  13. df_test.groupby(['id'])['value'].count()
  14. id
  15. 1 3
  16. 2 4
  17. 3 1
  18. 4 1
  19. Name: value, dtype: int64
  20.  
  21. What I want to do: select one for each id
  22. df_test.groupby(['id'])['value'].count()
  23. id
  24. 1 1
  25. 2 1
  26. 3 1
  27. 4 1
  28. Name: value, dtype: int64
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement