Pandas Methods Index

Every Pandas method below links to real Bamboo Weekly exercises that use it — so you can practice the method on messy, real-world data, then study the worked solution. The most-used methods have their own page listing every exercise that uses them. See also practice by skill or the full archive.

Reading & writing data · Creating & reshaping · Selecting & filtering · Grouping, aggregation & windows · Cleaning & transforming · Statistics & math · Working with text (.str) · Working with dates & times (.dt) · Plotting & inspection

Reading & writing data

• read_csv — 89 exercises
• read_excel — 58 exercises
• read_html — 19 exercises
• read_json — 4 issues: #160 Strait of Hormuz, #120 Pennies, #61 Solar eclipse, #48 Aviation accidents
• read_parquet — 4 issues: #151 PyPI in 2025, #128 Extreme heat, #112 Programming jobs, #86 FEMA
• to_parquet — 3 issues: #151 PyPI in 2025, #128 Extreme heat, #112 Programming jobs
• json_normalize — 2 issues: #120 Pennies, #76 Aging legislators

Creating & reshaping

• pivot_table — 69 exercises
• join — 44 exercises
• concat — 42 exercises
• unstack — 22 exercises
• explode — 19 exercises
• DataFrame — 16 exercises
• merge — 12 exercises
• Series — 7 issues: #162 Spotify and car accidents, #130 Jobs reporting, #124 NATO Spending, #115 Sahm rule
• cut — 5 issues: #172 World Cup, #169 Press freedom, #157 Government corruption, #140 Stack Overflow survey
• melt — 4 issues: #172 World Cup, #171 Hantavirus, #166 Income tax, #19 Working women
• stack — 4 issues: #146 Thanksgiving travel, #82 Broadband, #75 Refugees, #72 City travel
• pivot — 2 issues: #156 Winter Olympics, #80 Inflation
• crosstab — 2 issues: #173 IPOs, #91 Roller coasters
• get_dummies — 1 issue: #13 Python developers

Selecting & filtering

• pd.col new in Pandas 3.0 — 20 exercises
• loc — 151 exercises
• head — 68 exercises
• nlargest — 54 exercises
• isin — 47 exercises
• iloc — 46 exercises
• filter — 35 exercises
• xs — 26 exercises
• tail — 17 exercises
• idxmax — 14 exercises
• nsmallest — 13 exercises
• select_dtypes — 9 issues: #171 Hantavirus, #154 University rankings, #150 Kalshi, #140 Stack Overflow survey
• idxmin — 6 issues: #119 Python conferences, #71 Holidays, #50 Red Sea shipping, #29 Auto accidents
• query — 4 issues: #151 PyPI in 2025, #69 Election participation, #20 World inflation, #14 JOLTS
• where — 1 issue: #66 Pittsburgh
• between — 1 issue: #159 State of the Union

Grouping, aggregation & windows

• groupby — 96 exercises
• agg — 55 exercises
• pct_change — 53 exercises
• pipe — 51 exercises
• resample — 44 exercises
• apply — 35 exercises
• diff — 29 exercises
• map — 11 exercises
• rank — 5 issues: #167 Oil prices, #136 Indian vehicles, #134 Taiwan weather, #64 Coal power
• rolling — 3 issues: #115 Sahm rule, #98 Retail sales, #50 Red Sea shipping
• expanding — 2 issues: #124 NATO Spending, #103 CDC data
• shift — 2 issues: #115 Sahm rule, #84 Central banks
• transform — 1 issue: #157 Government corruption

Cleaning & transforming

• assign — 103 exercises
• sort_values — 101 exercises
• set_index — 100 exercises
• astype — 68 exercises
• drop — 67 exercises
• replace — 55 exercises
• dropna — 53 exercises
• reset_index — 47 exercises
• to_datetime — 40 exercises
• rename — 28 exercises
• sort_index — 25 exercises
• fillna — 16 exercises
• isna — 13 exercises
• drop_duplicates — 11 exercises
• set_axis — 11 exercises
• interpolate — 8 issues: #145 Economic indicators, #125 Shrinking dollars, #97 Drones, #95 Tariffs
• notna — 5 issues: #166 Income tax, #159 State of the Union, #139 Chinese exports, #133 Wind power
• ffill — 4 issues: #159 State of the Union, #122 Economic growth, #111 State taxes, #84 Central banks
• to_numeric — 2 issues: #173 IPOs, #154 University rankings
• duplicated — 1 issue: #91 Roller coasters
• clip — 1 issue: #24 Wildfire smoke

Statistics & math

• mean — 80 exercises
• value_counts — 70 exercises
• sum — 68 exercises
• corr — 35 exercises
• count — 33 exercises
• max — 21 exercises
• round — 10 exercises
• describe — 9 issues: #173 IPOs, #171 Hantavirus, #165 Artemis II, #150 Kalshi
• min — 8 issues: #173 IPOs, #145 Economic indicators, #142 Hurricanes, #115 Sahm rule
• median — 7 issues: #169 Press freedom, #166 Income tax, #162 Spotify and car accidents, #158 University endowments
• quantile — 4 issues: #56 Rent increases, #42 Plant hardiness, #35 Terrorism, #25 Entrepreneurship
• nunique — 4 issues: #156 Winter Olympics, #55 IVF, #51 Academy Awards, #45 Netflix
• std — 3 issues: #167 Oil prices, #60 Iceland, #40 Sovereign Bonds
• abs — 3 issues: #163 Daylight saving time, #144 Museum Heists, #141 Argentina
• unique — 2 issues: #156 Winter Olympics, #55 IVF
• mode — 1 issue: #94 Strategic Wine Reserve

Working with text (.str)

• str.contains — 32 exercises
• str.replace — 30 exercises
• str.split — 23 exercises
• str.strip — 18 exercises
• str.get — 13 exercises
• str.len — 10 exercises
• str.slice — 9 issues: #108 Measles, #79 Cyber attacks, #78 Stock markets, #54 Household debt
• str.lower — 7 issues: #159 State of the Union, #144 Museum Heists, #137 UN Security Council, #129 Tom Lehrer
• str.startswith — 5 issues: #143 Phones in school, #140 Stack Overflow survey, #108 Measles, #81 School
• str.removesuffix — 5 issues: #123 Missiles, #108 Measles, #54 Household debt, #40 Sovereign Bonds
• str.title — 4 issues: #121 Research funding, #105 Federal employees, #63 Ukraine aid, #33 Fracking
• str.removeprefix — 3 issues: #168 US gas prices, #165 Artemis II, #143 Phones in school
• str.extract — 1 issue: #172 World Cup
• str.upper — 1 issue: #32 Unions
• str.endswith — 1 issue: #159 State of the Union
• str.zfill — 1 issue: #101 Los Angeles Fires

Working with dates & times (.dt)

• dt.year — 38 exercises
• dt.month — 15 exercises
• dt.day_name — 6 issues: #162 Spotify and car accidents, #152 Congestion pricing, #151 PyPI in 2025, #118 Flight delays
• dt.hour — 4 issues: #172 World Cup, #161 Missiles in Israel, #113 US airport traffic, #48 Aviation accidents
• dt.date — 3 issues: #163 Daylight saving time, #113 US airport traffic, #101 Los Angeles Fires
• dt.month_name — 2 issues: #134 Taiwan weather, #108 Measles
• dt.dayofweek — 2 issues: #172 World Cup, #152 Congestion pricing
• dt.quarter — 2 issues: #66 Pittsburgh, #63 Ukraine aid
• dt.total_seconds — 2 issues: #161 Missiles in Israel, #61 Solar eclipse
• dt.day — 1 issue: #71 Holidays
• dt.days — 1 issue: #76 Aging legislators

Plotting & inspection

• memory_usage — 11 exercises
• hist — 3 issues: #86 FEMA, #73 Avocado hand, #7 Bank failures
• plot — 2 issues: #92 Climate disaster costs, #24 Wildfire smoke
• info — 2 issues: #140 Stack Overflow survey, #115 Sahm rule