Guest User

Untitled

a guest
Dec 11th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. userID browser slot n_clicks n_queries n_nonclk_queries
  2. 0 1 Browser #2 exp 23 32 19
  3. 1 3 Browser #4 exp 3 4 2
  4. 2 5 Browser #4 exp 29 35 16
  5. 3 6 Browser #4 control 12 6 0
  6. 4 7 Browser #4 exp 54 68 30
  7.  
  8. In [221]: df
  9. Out[221]:
  10. userID browser slot n_clicks n_queries n_nonclk_queries
  11. 0 1 Browser #2 exp 23 32 19
  12. 1 1 Browser #33 exp 100 100 100
  13. 2 3 Browser #4 exp 3 4 2
  14. 3 5 Browser #4 exp 29 35 16
  15. 4 6 Browser #4 control 12 6 0
  16.  
  17. In [222]: df.groupby('userID', as_index=False).sum()
  18. Out[222]:
  19. userID n_clicks n_queries n_nonclk_queries
  20. 0 1 123 132 119
  21. 1 3 3 4 2
  22. 2 5 29 35 16
  23. 3 6 12 6 0
Add Comment
Please, Sign In to add comment