Roadmap
Day 43 · Summarising and joining 60 min 40 XP
🧩groupby, merge and pivot
Everything you did with GROUP BY, JOIN and pivot tables comes together in three pandas tools. After today you can answer 'revenue by product' from raw order rows in a few lines.
What you'll learn
- Summarise with groupby and agg
- Combine tables with merge
- Build a pivot_table like the one from Sheets
A peek inside
merge is JOIN
The rest of Day 43 is a Pro lesson
You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).
- 3 deep-dive lessons
- A copy-paste worked example
- 3 hands-on practice tasks
- Studio task: Revenue by product, three ways
- 3-question quiz, up to 45 XP
- 4 quick-glance glossary cards
- 40 XP + streak tracking
Already Pro? Sign in