What you’ll learn
- Load CSV and Excel data into pandas DataFrames
- Clean missing values, wrong types and duplicates
- Group, aggregate and join data to answer business questions
- Create clear charts with matplotlib
- Share your analysis as a reproducible notebook
Course content
3 sections · 9 lessons · 45 min
Getting data in3 lessons · 12 min
- Setting up Jupyter and pandasVideo · 10 min
- DataFrames in five minutesReading · 1 min
- Selecting and filteringReading · 1 min
Cleaning data3 lessons · 18 min
- A real cleaning sessionVideo · 16 min
- Missing valuesReading · 1 min
- Types and duplicatesReading · 1 min
Analysis and charts3 lessons · 15 min
- groupby: the analyst's favourite toolVideo · 13 min
- Grouping and aggregatingReading · 1 min
- Charts that make a pointReading · 1 min
Requirements
- Basic Python (variables, loops, functions)
- Python 3 with Jupyter or VS Code
Description
Learn the Python workflow analysts use every day: load a messy dataset, clean it, ask questions of it and turn the answers into clear charts. You'll work with a public dataset throughout, so every technique is practised on realistic data. The course assumes you've written a little Python before. If you can write a loop and a function, you're ready.
Instructor
Data scientist · Analytics lead
- 4.5 instructor rating
- 28 reviews
- 64 learners
- 2 courses
I work with data every day, from messy spreadsheets to production analytics. Before that I taught statistics. I focus on the techniques that answer real business questions, practised on realistic datasets.
4.4 course rating · 17 reviews
- Sofia Chen5.0 · Oct 22, 2026
Loved the reading notes, easy to come back to later.
- Aditya Clarke4.0 · Oct 22, 2026
Clear and friendly teaching style.
- Mei Rossi4.0 · Oct 22, 2026
Useful and to the point. I'd recommend it to colleagues.
- Rohan Menon5.0 · Oct 22, 2026
Practical from the very first lesson.
- Leila Banerjee3.0 · Oct 22, 2026
Decent introduction, but I already knew most of it.
- Sneha Smith3.0 · Oct 22, 2026
Decent introduction, but I already knew most of it.
- Neel Singh5.0 · Oct 22, 2026
Well structured and easy to follow. Exactly what I needed.
- Ingrid Kim5.0 · Oct 22, 2026
The instructor explains things really clearly.
- Ishaan Wang5.0 · Oct 22, 2026
Practical from the very first lesson.
- Isha Garcia4.0 · Oct 22, 2026
Very practical; the dataset kept it interesting.
- Alex Ahmed5.0 · Oct 22, 2026
Practical from the very first lesson.
- Tara Iyer3.0 · Oct 22, 2026
Good, though a bit basic for my level.
- Amara Rao5.0 · Oct 22, 2026
Well structured and easy to follow. Exactly what I needed.
- Karan Hassan5.0 · Oct 22, 2026
Daniel's chart advice improved every report I send.
- Adaeze Chen4.0 · Oct 22, 2026
Great pace. A little more on joins would make it perfect.
- Pablo Murphy5.0 · Oct 22, 2026
groupby finally makes sense. I use it daily now.
- Liam Costa5.0 · Oct 22, 2026
The cleaning session was exactly what real work looks like. Brilliant.