Pandas practice by skill

Bamboo Weekly has published 183+ weekly Pandas practice exercises, each built on a real-world dataset. This page organizes them by skill so you can practice exactly what you want to improve. Each skill links to its full archive; a few recent issues are listed to get you started. New here? Start with the overview or the FAQ.

Plotting & visualization

137 Pandas plotting & visualization exercises. Recent issues:

See all 137 plotting & visualization exercises →

Grouping & aggregation

Learn the method: Pandas groupby — explanation, worked example on real data, and a practice exercise.

92 Pandas grouping & aggregation exercises. Recent issues:

See all 92 grouping & aggregation exercises →

Dates & times

Learn the method: Pandas to_datetime and Pandas set_index — explanation, worked example on real data, and a practice exercise.

79 Pandas dates & times exercises. Recent issues:

See all 79 dates & times exercises →

Reading CSV files

Learn the method: Pandas read_csv — explanation, worked example on real data, and a practice exercise.

56 Pandas reading csv files exercises. Recent issues:

See all 56 reading csv files exercises →

Pivot tables

Learn the method: Pandas pivot_table — explanation, worked example on real data, and a practice exercise.

62 Pandas pivot tables exercises. Recent issues:

See all 62 pivot tables exercises →

Working with Excel

Learn the method: Pandas read_excel — explanation, worked example on real data, and a practice exercise.

51 Pandas working with excel exercises. Recent issues:

See all 51 working with excel exercises →

Window functions

41 Pandas window functions exercises. Recent issues:

See all 41 window functions exercises →

Joining & merging data

40 Pandas joining & merging data exercises. Recent issues:

See all 40 joining & merging data exercises →

Text & strings

35 Pandas text & strings exercises. Recent issues:

See all 35 text & strings exercises →

Cleaning messy data

Learn the method: Pandas drop and Pandas value_counts — explanation, worked example on real data, and a practice exercise.

37 Pandas cleaning messy data exercises. Recent issues:

See all 37 cleaning messy data exercises →

Multi-indexes

Learn the method: Pandas set_index — explanation, worked example on real data, and a practice exercise.

35 Pandas multi-indexes exercises. Recent issues:

See all 35 multi-indexes exercises →

Filtering & selecting

Learn the method: Pandas loc and pd.col — explanation, worked example on real data, and a practice exercise.

27 Pandas filtering & selecting exercises. Recent issues:

See all 27 filtering & selecting exercises →

More Pandas skills

Bamboo Weekly also covers many other Pandas and data-analysis topics:

Web scraping — 18 exercises
Regular expressions — 35 exercises
Multiple files — 32 exercises
Correlations — 16 exercises
Sorting — 13 exercises · Pandas sort_values
APIs — 15 exercises
JSON — 6 exercises
Stack / unstack — 11 exercises
Missing data — 10 exercises
Method chaining — 10 exercises · Pandas assign and pd.col
Apply — 8 exercises
PyArrow — 12 exercises
Polars — 3 exercises
GeoPandas — 5 exercises
Seaborn — 5 exercises
Memory optimization — 12 exercises
Interpolation — 4 exercises
Styling — 4 exercises

Or simply browse every issue by date, or look up a specific Pandas method.

More Pandas skills