Bamboo Weekly has published 170+ 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
126 Pandas plotting & visualization exercises. Recent issues:
- Bamboo Weekly #172: World Cup
- Bamboo Weekly #171: Hantavirus
- Bamboo Weekly #170: Port of Long Beach
- Bamboo Weekly #169: Press freedom
- Bamboo Weekly #168: US gas prices
- Bamboo Weekly #167: Oil prices
See all 126 plotting & visualization exercises →
Grouping & aggregation
84 Pandas grouping & aggregation exercises. Recent issues:
- Bamboo Weekly #168: US gas prices
- Bamboo Weekly #167: Oil prices
- Bamboo Weekly #166: Income tax
- Bamboo Weekly #164: Fertilizer
- Bamboo Weekly #163: Daylight saving time
- Bamboo Weekly #162: Spotify and car accidents
See all 84 grouping & aggregation exercises →
Dates & times
72 Pandas dates & times exercises. Recent issues:
- Bamboo Weekly #172: World Cup
- Bamboo Weekly #171: Hantavirus
- Bamboo Weekly #170: Port of Long Beach
- Bamboo Weekly #167: Oil prices
- Bamboo Weekly #165: Artemis II
- Bamboo Weekly #164: Fertilizer
See all 72 dates & times exercises →
Reading CSV files
56 Pandas reading csv files exercises. Recent issues:
- Bamboo Weekly #172: World Cup
- Bamboo Weekly #171: Hantavirus
- Bamboo Weekly #170: Port of Long Beach
- Bamboo Weekly #166: Income tax
- Bamboo Weekly #156: Winter Olympics
- Bamboo Weekly #153: Venezuela
See all 56 reading csv files exercises →
Pivot tables
54 Pandas pivot tables exercises. Recent issues:
- Bamboo Weekly #172: World Cup
- Bamboo Weekly #171: Hantavirus
- Bamboo Weekly #170: Port of Long Beach
- Bamboo Weekly #169: Press freedom
- Bamboo Weekly #166: Income tax
- Bamboo Weekly #160: Strait of Hormuz
See all 54 pivot tables exercises →
Working with Excel
50 Pandas working with excel exercises. Recent issues:
- Bamboo Weekly #158: University endowments
- Bamboo Weekly #157: Government corruption
- Bamboo Weekly #155: Gold
- Bamboo Weekly #154: University rankings
- Bamboo Weekly #144: Museum Heists
- Bamboo Weekly #143: Phones in school
See all 50 working with excel exercises →
Window functions
41 Pandas window functions exercises. Recent issues:
- Bamboo Weekly #154: University rankings
- Bamboo Weekly #153: Venezuela
- Bamboo Weekly #152: Congestion pricing
- Bamboo Weekly #149: Flu season
- Bamboo Weekly #148: US Manufacturing
- Bamboo Weekly #139: Chinese exports
See all 41 window functions exercises →
Joining & merging data
38 Pandas joining & merging data exercises. Recent issues:
- Bamboo Weekly #170: Port of Long Beach
- Bamboo Weekly #167: Oil prices
- Bamboo Weekly #165: Artemis II
- Bamboo Weekly #164: Fertilizer
- Bamboo Weekly #163: Daylight saving time
- Bamboo Weekly #162: Spotify and car accidents
See all 38 joining & merging data exercises →
Text & strings
35 Pandas text & strings exercises. Recent issues:
- Bamboo Weekly #159: State of the Union
- Bamboo Weekly #134: Taiwan weather
- Bamboo Weekly #132: JetBrains survey
- Bamboo Weekly #129: Tom Lehrer
- Bamboo Weekly #121: Research funding
- Bamboo Weekly #120: Pennies
See all 35 text & strings exercises →
Cleaning messy data
35 Pandas cleaning messy data exercises. Recent issues:
- Bamboo Weekly #168: US gas prices
- Bamboo Weekly #160: Strait of Hormuz
- Bamboo Weekly #159: State of the Union
- Bamboo Weekly #156: Winter Olympics
- Bamboo Weekly #153: Venezuela
- Bamboo Weekly #152: Congestion pricing
See all 35 cleaning messy data exercises →
Multi-indexes
34 Pandas multi-indexes exercises. Recent issues:
- Bamboo Weekly #169: Press freedom
- Bamboo Weekly #168: US gas prices
- Bamboo Weekly #161: Missiles in Israel
- Bamboo Weekly #160: Strait of Hormuz
- Bamboo Weekly #147: Presidential pardons
- Bamboo Weekly #144: Museum Heists
See all 34 multi-indexes exercises →
Filtering & selecting
27 Pandas filtering & selecting exercises. Recent issues:
- Bamboo Weekly #157: Government corruption
- Bamboo Weekly #155: Gold
- Bamboo Weekly #141: Argentina
- Bamboo Weekly #140: Stack Overflow survey
- Bamboo Weekly #139: Chinese exports
- Bamboo Weekly #132: JetBrains survey
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 — 30 exercises
- Multiple files — 31 exercises
- Correlations — 15 exercises
- Sorting — 13 exercises
- APIs — 13 exercises
- JSON — 6 exercises
- Stack / unstack — 11 exercises
- Missing data — 10 exercises
- Method chaining — 10 exercises
- Apply — 8 exercises
- PyArrow — 12 exercises
- Polars — 3 exercises
- GeoPandas — 4 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.