Py
Py
Run
What do you want to learn?
Lessons
⌄
Browse the curriculum
Find your level
Practice problems
Interview prep
Cheat sheets
Career paths
Explore by role
All lessons
Fundamentals
Web development
Data
Engineering
Data science
Machine learning
GenAI & RAG
Automation
DSA / interview
Tools
new
⌄
Online compiler
Playground
Revise
Terminal
SQL playground
Notebook
Build
⌄
Workspaces
Guided projects
My published sites
Blog
Pricing
AI
en
Sign in
Start free
→
Start free
→
loading…
Feedback
💬
Ask PyRun
Home
›
All lessons
›
Data
›
Cleaning messy data
Cleaning messy data
Advanced
14 min
Data
data · pandas · cleaning · missing-values
Try it
↓
Lesson
7
of
10
In this track
▾
1
SQLite with Python's sqlite3
12 min
2
SQL joins that actually make sense
15 min
3
SQLAlchemy Core — SQL as Python
15 min
4
SQLAlchemy ORM — objects that persist
18 min
5
Database migrations with Alembic
15 min
6
Series & DataFrame: the two shapes of pandas
12 min
7
Cleaning messy data
14 min
8
Filtering, querying & top-N
12 min
9
groupby & aggregation
15 min
10
Combining tables: merge, join & concat
15 min
←
→
Loading lesson…
←
Previous lesson
Series & DataFrame: the two shapes of pandas
Advanced · 12 min
Next lesson
→
Filtering, querying & top-N
Advanced · 12 min
Related lessons
Advanced · 12 min
Series & DataFrame: the two shapes of pandas
The two objects you'll use every day — a labeled column (Series) and a labeled table (DataFrame) — plus loc/iloc selection.
Advanced · 12 min
Filtering, querying & top-N
Slice rows with boolean masks, read them cleanly with query(), then rank with sort_values and head() to answer top-N questions.
Advanced · 15 min
groupby & aggregation
Split rows into groups, aggregate each with sum/mean/count, compute several stats at once with named agg, and sort the summary.