Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. import pandas as pd
  2. import numpy as np
  3. import matplotlib
  4. %matplotlib inline
  5.  
  6. data.groupby(['DATE','REVENUE']).sum().unstack()
  7.  
  8. import pandas as pd
  9. import numpy as np
  10. import matplotlib
  11. %matplotlib inline
  12.  
  13. data.groupby(['DATE','REVENUE']).sum().unstack()
  14.  
  15. import pandas as pd
  16. import numpy as np
  17. import matplotlib
  18. %matplotlib inline
  19.  
  20. data.groupby(['DATE','REVENUE']).sum().unstack()
  21.  
  22. # Do this first, if necessary.
  23. df['Date'] = pd.to_datetime(df['Date'], errors='coerce')
  24.  
  25. (df.groupby([pd.Grouper(key='Date', freq='MS'), 'Description'])['Revenue']
  26. .sum()
  27. .reset_index())
  28.  
  29. Date Description Revenue
  30. 0 2010-01-01 A 197.379999
  31. 1 2010-01-01 B 79.040000
  32. 2 2010-02-01 A 79.040000
  33. 3 2010-02-01 B 39.520000
  34. 4 2010-02-01 C 39.520000
  35. 5 2010-02-01 D 39.520000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement