Tables with Pandas
Where does my allowance go?
🎓 School maths · Years 5–6Statistics — Group data into categories, total each and rank them.Maths by year →
The Case. Your pocket money vanishes by Wednesday and you're not even sure what on — snacks? a game? Where does it actually go? Let's log it in a table and add it up by category — the same trick your banking app uses to show a spending breakdown.
Your tools. pandas is a spreadsheet you can ask questions to. groupby adds up spending by category.
Investigate. Press Run. The chart ranks where your money went, biggest last.
- Add your own rows to the table.
- Which single category eats the most?
This case is part of the Family plan
Unlock every 12–15 case and the full AI, machine-learning, and deep-learning path — one subscription for the whole family.
Need a hint?
groupby('item') puts all the 'snacks' rows together, then ['cost'].sum() adds them up.