Learn pandas, the Python library analysts and data scientists use every day. Each lesson explains one idea with diagrams, real pandas code you can edit and run in your browser, and a quick knowledge check.
- 14 days
- ~30 min / day
- Beginner
- Free account required
The big picture
Everything you'll cover, and how it fits together.
Day by day
Go at your own pace. Your progress is remembered on this device.
- 3Day 3Coming soon 30 min
Selecting Data
Pick the rows and columns you need.
loc / ilocBoolean filtersquery() - 4Day 4Coming soon 30 min
Cleaning Data
Fix missing values, duplicates and wrong types.
Missing valuesDuplicatesData types - 5Day 5Coming soon 30 min
Transforming Columns
Create and change columns the pandas way.
Vectorised mathsassign()String methods - 6Day 6Coming soon 30 min
Dates & Times
Parse, extract and resample dates.
to_datetime().dt accessorresample() - 7Day 7Coming soon 30 min
Sorting & Ranking
Order data and find the top and bottom.
sort_values()nlargest()rank() - 8Day 8Coming soon 30 min
Grouping & Aggregating
Split, apply, combine with groupby.
groupby()agg()transform() - 9Day 9Coming soon 30 min
Reshaping Data
Pivot, melt and cross-tabulate.
pivot_table()melt()crosstab() - 10Day 10Coming soon 30 min
Combining Data
Merge, join and concatenate tables.
merge()Join typesconcat() - 11Day 11Coming soon 30 min
Time-Series Analysis
Rolling averages, growth and comparisons over time.
rolling()shift()pct_change() - 12Day 12Coming soon 30 min
Visualising Data
Turn DataFrames into clear charts.
plot()Chart typesMatplotlib - 13Day 13Coming soon 30 min
Writing Better pandas
Fast, readable code and common pitfalls.
Method chainingCategoricalsPerformance - 14Day 14Coming soon 30 min
Capstone: Analyse a Dataset
Answer real questions from raw data, end to end.
CleanAnalysePresent