Intermediate · 25 min · 4 steps
Finding which grocery items are bought together
Kunal Mehra, Recommendation Systems Engineer at DashMart Instant
It is Thursday, 10:15 AM. Kunal Mehra is an engineer at DashMart Instant, a grocery app with over 280 small warehouses (dark stores) that deliver in 10 minutes across Indian cities. The merchandising director has a problem: the average order value is stuck at Rs 385, and the cost of winning a new customer has gone up by 15%.
The question
Which pairs of products are most often bought together in the same order?
- Self JOIN
- Cartesian management
- Market basket analysis
- HAVING
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.