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. It covers 91 methods across 172 weekly issues. 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 issues: #172 World Cup, #171 Hantavirus, #170 Port of Long Beach, #169 Press freedom
• read_excel — 58 issues: #158 University endowments, #157 Government corruption, #155 Gold, #154 University rankings
• read_html — 19 issues: #168 US gas prices, #163 Daylight saving time, #159 State of the Union, #147 Presidential pardons
• 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

Creating & reshaping

• pivot_table — 68 issues: #172 World Cup, #171 Hantavirus, #170 Port of Long Beach, #169 Press freedom
• join — 44 issues: #172 World Cup, #167 Oil prices, #166 Income tax, #162 Spotify and car accidents
• concat — 42 issues: #169 Press freedom, #168 US gas prices, #166 Income tax, #162 Spotify and car accidents
• unstack — 22 issues: #154 University rankings, #140 Stack Overflow survey, #139 Chinese exports, #133 Wind power
• explode — 19 issues: #172 World Cup, #171 Hantavirus, #163 Daylight saving time, #161 Missiles in Israel
• DataFrame — 15 issues: #165 Artemis II, #159 State of the Union, #150 Kalshi, #129 Tom Lehrer
• merge — 12 issues: #170 Port of Long Beach, #166 Income tax, #165 Artemis II, #158 University endowments
• 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

Selecting & filtering

• pd.col — new in Pandas 3.0; 19 issues: #172 World Cup, #171 Hantavirus, #170 Port of Long Beach, #169 Press freedom
• loc — 150 issues: #172 World Cup, #171 Hantavirus, #170 Port of Long Beach, #169 Press freedom
• head — 68 issues: #166 Income tax, #161 Missiles in Israel, #159 State of the Union, #154 University rankings
• nlargest — 53 issues: #172 World Cup, #169 Press freedom, #168 US gas prices, #164 Fertilizer
• isin — 47 issues: #171 Hantavirus, #170 Port of Long Beach, #166 Income tax, #164 Fertilizer
• iloc — 46 issues: #167 Oil prices, #166 Income tax, #160 Strait of Hormuz, #159 State of the Union
• filter — 35 issues: #167 Oil prices, #164 Fertilizer, #163 Daylight saving time, #157 Government corruption
• xs — 26 issues: #169 Press freedom, #168 US gas prices, #164 Fertilizer, #160 Strait of Hormuz
• tail — 17 issues: #154 University rankings, #141 Argentina, #130 Jobs reporting, #119 Python conferences
• idxmax — 14 issues: #119 Python conferences, #74 UK elections, #54 Household debt, #48 Aviation accidents
• nsmallest — 13 issues: #169 Press freedom, #163 Daylight saving time, #157 Government corruption, #151 PyPI in 2025
• 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

Grouping, aggregation & windows

• groupby — 95 issues: #172 World Cup, #166 Income tax, #164 Fertilizer, #163 Daylight saving time
• agg — 55 issues: #167 Oil prices, #157 Government corruption, #156 Winter Olympics, #153 Venezuela
• pct_change — 53 issues: #168 US gas prices, #167 Oil prices, #155 Gold, #153 Venezuela
• pipe — 50 issues: #172 World Cup, #171 Hantavirus, #170 Port of Long Beach, #169 Press freedom
• resample — 43 issues: #170 Port of Long Beach, #167 Oil prices, #161 Missiles in Israel, #155 Gold
• apply — 34 issues: #168 US gas prices, #164 Fertilizer, #163 Daylight saving time, #162 Spotify and car accidents
• diff — 29 issues: #157 Government corruption, #155 Gold, #148 US Manufacturing, #144 Museum Heists
• map — 10 issues: #166 Income tax, #160 Strait of Hormuz, #127 European comparisons, #121 Research funding
• 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

Cleaning & transforming

• assign — 102 issues: #172 World Cup, #171 Hantavirus, #170 Port of Long Beach, #169 Press freedom
• sort_values — 100 issues: #172 World Cup, #170 Port of Long Beach, #169 Press freedom, #168 US gas prices
• set_index — 99 issues: #172 World Cup, #170 Port of Long Beach, #169 Press freedom, #168 US gas prices
• astype — 68 issues: #172 World Cup, #171 Hantavirus, #168 US gas prices, #166 Income tax
• drop — 66 issues: #172 World Cup, #169 Press freedom, #165 Artemis II, #164 Fertilizer
• replace — 54 issues: #172 World Cup, #171 Hantavirus, #163 Daylight saving time, #161 Missiles in Israel
• dropna — 53 issues: #171 Hantavirus, #167 Oil prices, #163 Daylight saving time, #159 State of the Union
• reset_index — 47 issues: #172 World Cup, #171 Hantavirus, #170 Port of Long Beach, #169 Press freedom
• to_datetime — 39 issues: #172 World Cup, #170 Port of Long Beach, #165 Artemis II, #163 Daylight saving time
• rename — 28 issues: #169 Press freedom, #168 US gas prices, #166 Income tax, #161 Missiles in Israel
• sort_index — 25 issues: #170 Port of Long Beach, #162 Spotify and car accidents, #161 Missiles in Israel, #155 Gold
• fillna — 15 issues: #171 Hantavirus, #163 Daylight saving time, #144 Museum Heists, #133 Wind power
• isna — 13 issues: #163 Daylight saving time, #156 Winter Olympics, #138 Federal workers, #122 Economic growth
• drop_duplicates — 11 issues: #156 Winter Olympics, #111 State taxes, #86 FEMA, #74 UK elections
• set_axis — 11 issues: #167 Oil prices, #163 Daylight saving time, #153 Venezuela, #145 Economic indicators
• 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

Statistics & math

• mean — 80 issues: #172 World Cup, #167 Oil prices, #166 Income tax, #162 Spotify and car accidents
• value_counts — 70 issues: #172 World Cup, #171 Hantavirus, #169 Press freedom, #168 US gas prices
• sum — 67 issues: #170 Port of Long Beach, #166 Income tax, #164 Fertilizer, #162 Spotify and car accidents
• corr — 34 issues: #172 World Cup, #170 Port of Long Beach, #167 Oil prices, #162 Spotify and car accidents
• count — 32 issues: #161 Missiles in Israel, #156 Winter Olympics, #142 Hurricanes, #137 UN Security Council
• max — 21 issues: #165 Artemis II, #161 Missiles in Israel, #157 Government corruption, #156 Winter Olympics
• round — 9 issues: #172 World Cup, #171 Hantavirus, #169 Press freedom, #167 Oil prices
• describe — 8 issues: #171 Hantavirus, #165 Artemis II, #150 Kalshi, #97 Drones
• median — 7 issues: #169 Press freedom, #166 Income tax, #162 Spotify and car accidents, #158 University endowments
• min — 7 issues: #145 Economic indicators, #142 Hurricanes, #115 Sahm rule, #100 Sports betting
• 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

Working with text (.str)

• str.contains — 32 issues: #170 Port of Long Beach, #155 Gold, #147 Presidential pardons, #143 Phones in school
• str.replace — 30 issues: #171 Hantavirus, #161 Missiles in Israel, #158 University endowments, #152 Congestion pricing
• str.split — 23 issues: #172 World Cup, #171 Hantavirus, #161 Missiles in Israel, #159 State of the Union
• str.strip — 18 issues: #172 World Cup, #171 Hantavirus, #165 Artemis II, #161 Missiles in Israel
• str.get — 12 issues: #172 World Cup, #160 Strait of Hormuz, #134 Taiwan weather, #120 Pennies
• str.len — 10 issues: #159 State of the Union, #137 UN Security Council, #129 Tom Lehrer, #106 Flu season
• 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

Working with dates & times (.dt)

• dt.year — 37 issues: #172 World Cup, #170 Port of Long Beach, #160 Strait of Hormuz, #156 Winter Olympics
• dt.month — 15 issues: #152 Congestion pricing, #151 PyPI in 2025, #128 Extreme heat, #125 Shrinking dollars
• 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

Plotting & inspection

• memory_usage — 11 issues: #154 University rankings, #131 Canadian border crossings, #128 Extreme heat, #112 Programming jobs
• hist — 3 issues: #86 FEMA, #73 Avocado hand, #7 Bank failures