Intermediate · 30 min · 5 steps
A rising total chart hid the day sales fell by two thirds
Deepak Soni, Senior Revenue Analytics Lead at QuickKart Daily
It is 8:45 AM on a Monday. Deepak Soni, who leads revenue analytics at QuickKart Daily, walks into the boardroom for the monthly revenue review. QuickKart delivers groceries in Western India and fulfils over 140,000 orders a day. The VP of Growth shows a smooth cumulative chart: total sales for August are climbing towards ₹4.2 crore.
The question
How do we use pandas to get revenue for each day, the percentage change from the day before, and a 3-day average, so that a sudden drop is easy to see?
- Time series
- Pandas pct_change
- Daily revenue
- Growth rates
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.