Roadmap
Day 53 · Cleaning with pandas 70 min 40 XP
🧹Capstone: collect and clean
Here is the raw shop export, with the mess a real export has: a duplicate row, a missing quantity, and city and status written five different ways. You clean it in pandas, check each step, and save a file the next two days will reuse.
What you'll learn
- Audit a raw table for duplicates, gaps and inconsistent labels
- Fix each problem in pandas and record the decision
- Save clean_orders.csv for days 54 to 56
A peek inside
Audit first
The rest of Day 53 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: Clean the raw orders
- 3-question quiz, up to 45 XP
- 4 quick-glance glossary cards
- 40 XP + streak tracking
Already Pro? Sign in