Group by sum with running calculation

Viewed 48

I have df as

Sales | Users |   DT
40000    234     1/4/2018
500      100     1/23/2018
4000     555     2/4/2018
234      1000    6/4/2018
1000     2000    6/14/2018
50000    1200    9/12/2018
40000    234     1/14/2019
500      100     2/23/2019
2145     555     2/26/2019
344      1000    6/14/2019
1234     1233    6/21/2019
432      5000     11/12/2019

Is there method to group-by to both sum up sales by yr and also create a rolling total of users as my users column is composed of both new users, and users from previous date so basically group by year, sum sales, and then sum users from next date - prev date users

Thank you

0 Answers
Related