Guest User

Untitled

a guest
Jan 20th, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. df =
  2. name amount date
  3. 0 A 10 1
  4. 1 B 15 1
  5. 2 A 5 2
  6. 3 C 7 3
  7. 4 A 8 4
  8. 5 B 10 4
  9. 6 C 11 4
  10.  
  11. df_result =
  12. name amount date
  13. 0 A 10 1
  14. 1 B 15 1
  15. 2 A 15 2
  16. 3 B 15 2
  17. 4 A 15 3
  18. 5 B 15 3
  19. 6 C 7 3
  20. 7 A 23 4
  21. 8 B 25 4
  22. 9 C 18 4
  23.  
  24. >>> df.groupby(by=['name','date']).sum().groupby(level=[0]).cumsum().reset_index()
  25. name date amount
  26. 0 A 1 10
  27. 1 A 2 15
  28. 2 A 4 23
  29. 3 B 1 15
  30. 4 B 4 25
  31. 5 C 3 7
  32. 6 C 4 18
Add Comment
Please, Sign In to add comment