llms.txt
Compare with other sites' llms.txt files →# Bamboo Weekly
> Level up your data-analysis skills with Python and Pandas, solving problems with real-world data sets based on current events.
Public Ghost content for AI and LLM tooling. Use `/llms-full.txt` for consolidated page and post context.
Append `.md` to any post or page URL to get the content in Markdown (for example, `/example-post.md`).
## Pages
- [Pandas Practice & Exercises](https://www.bambooweekly.com/about.md) - Bamboo Weekly is a weekly Pandas practice newsletter — hands-on Pandas exercises built on real-world data, with detailed worked solutions and a Jupyter notebook the next day. Here is the problem it solves. Pandas is immense, and using it can be overwhelming. Plenty of people have written Python for…
- [Back issues of Bamboo Weekly](https://www.bambooweekly.com/archive.md)
- [Bamboo Weekly – Frequently Asked Questions](https://www.bambooweekly.com/faq.md) - What is Bamboo Weekly? Bamboo Weekly is a weekly pandas (Python data analysis) practice series, delivered in two emails per week: * Wednesdays: you get the questions based on a real, often current, public data set. * Thursdays: you get the detailed solutions, with clean, idiomatic pandas code and e…
- [Readers rave about Bamboo Weekly](https://www.bambooweekly.com/home-reviews.md) - Wayne Odhiambo I’ve found the weekly exercises and your detailed walkthroughs incredibly helpful. They’ve significantly boosted my confidence with Pandas and data analysis in general, and I genuinely appreciate the way you connect real-world data to practical, hands-on learning. Bernie Lawson I lov…
- [pandas assign](https://www.bambooweekly.com/pandas-assign.md) - Add or replace columns inside a method chain, without mutating the original data frame. How do you add a column in the middle of a method chain? That question is the whole reason assign exists, and the answer changes how you write Pandas. The familiar df['millions'] = ... is a statement, not an exp…
- [pandas groupby](https://www.bambooweekly.com/pandas-groupby.md) - Split rows into groups, apply a function to each group, and combine the results back together. groupby is the method you reach for whenever a question contains the words "for each" — total sales for each region, average temperature for each month, number of plants for each country. If you find your…
- [pandas loc](https://www.bambooweekly.com/pandas-loc.md) - Select rows and columns by label — and, most often, by a condition. .loc is how you say "the rows where this is true" and "these columns, by name". It is also the piece that makes method chaining work, because .loc accepts a deferred expression, letting you filter a data frame that has no name yet.…
- [pandas mean](https://www.bambooweekly.com/pandas-mean.md) - The six reducers that turn a column into a number — and the one default they all share. What is the average? That is usually the second question anyone asks of a data set, right after "how big is it?" Pandas answers it with .mean(), and answers the neighboring questions with .sum(), .median(), .std…
- [Pandas Methods Index](https://www.bambooweekly.com/pandas-methods.md) - 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. Re…
- [pandas pivot_table](https://www.bambooweekly.com/pandas-pivot-table.md) - Turn one long column of values into a grid, summarized across two dimensions at once. pivot_table answers questions with two "for each" clauses in them: total capacity for each region, broken down for each status. Where groupby gives you one row per group, pivot_table spreads a second grouping key…
- [pandas read_csv](https://www.bambooweekly.com/pandas-read-csv.md) - Load a CSV file — from your disk, or straight from a URL — into a data frame. What does the first line of a Pandas project usually look like? It is pd.read_csv, and in nearly every Bamboo Weekly solution that line does not name a file at all. It names a URL: import pandas as pd url = ('https://eart…
- [pandas set_index](https://www.bambooweekly.com/pandas-set-index.md) - Promote one or more columns to be the data frame's index. The index is not just row labels — it is what .loc selects by, what joins align on, and what makes time-based slicing possible. Choosing the right index is often the difference between a fiddly query and a one-liner. Official documentation:…
- [pandas sort_values](https://www.bambooweekly.com/pandas-sort-values.md) - Sort rows by the values in one or more columns. sort_values is the method that turns a correct answer into a readable one. A grouped total sorted alphabetically tells you almost nothing; the same total sorted descending tells you who the biggest players are at a glance. Official documentation: Data…
- [pandas value_counts](https://www.bambooweekly.com/pandas-value-counts.md) - Count how often each distinct value appears in a column. value_counts is usually the second thing you run on an unfamiliar dataset, right after head. It tells you what is in a column, how lopsided it is, and whether the categories are as tidy as you assumed — which, with real data, they rarely are.…
- [Pandas Practice by Skill](https://www.bambooweekly.com/practice-by-skill.md) - Bamboo Weekly has published 188+ 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 wit…
- [Welcome to Bamboo Weekly!](https://www.bambooweekly.com/premium-welcome.md)
- [Data and privacy policy](https://www.bambooweekly.com/privacy-policy.md) - Bamboo weekly is all about data and data analysis. Not just because it's fun, but because these topics are worth a lot of money, and you can get great jobs with such skills. Many sites are thus tempted to sell their data to third parties. I want to make it clear that I won't sell, rent, or otherwis…
- [Tags](https://www.bambooweekly.com/tags.md)
- [Terms and conditions](https://www.bambooweekly.com/terms-and-conditions.md) - Bamboo Weekly is all about analyzing data with Python and Pandas. The first two questions and answers that I publish each week are free of charge, open to anyone who has a (free) Bamboo Weekly subscription. Paid subscribers get the full questions and answers, plus downloadable Jupyter notebooks, pl…
- [Welcome to Bamboo Weekly!](https://www.bambooweekly.com/welcome-to-bamboo-weekly.md) - Thanks so much for becoming a subscriber to Bamboo Weekly. My goal is to help you improve your data-analysis skills using Python, Pandas, and real-world data sets. I try to make BW interesting, educational, relevant, and even a bit entertaining. For me, one of the most important aspects of Bamboo W…
## Posts
- [Bamboo Weekly #195: Crypto heists (solutions)](https://www.bambooweekly.com/bamboo-weekly-195-crypto-heists-solutions.md) - Get better at: Retrieving from APIs, working with JSON data, grouping, using datetime data, and plotting with Plotly
- [Bamboo Weekly #195: Crypto heists](https://www.bambooweekly.com/bamboo-weekly-195-crypto-heists.md) - Get better at: Retrieving from APIs, working with JSON data, grouping, using datetime data, and plotting with Plotly
- [Bamboo Weekly #194: GitHub (solutions)](https://www.bambooweekly.com/bamboo-weekly-194-github-solutions.md) - Get better at: Excel files, plotting with Plotly, Marimo widgets, window functions, and sorting.
- [Bamboo Weekly #194: GitHub](https://www.bambooweekly.com/bamboo-weekly-194-github.md) - Get better at: Excel files, plotting with Plotly, Marimo widgets, window functions, and sorting.
- [Bamboo Weekly #193: World economic outlook (solutions)](https://www.bambooweekly.com/bamboo-weekly-193-world-economic-outlook-solutions.md) - Get better at: Excel files, plotting with Plotly, Marimo widgets, window functions, and sorting.
- [Bamboo Weekly #193: World economic outlook (update)](https://www.bambooweekly.com/bamboo-weekly-193-world-economic-outlook-update.md) - Get better at: Excel files, plotting with Plotly, Marimo widgets, window functions, and sorting.
- [Bamboo Weekly #193: World economic outlook](https://www.bambooweekly.com/bamboo-weekly-193-world-economic-outlook.md) - Get better at: Excel files, plotting with Plotly, Marimo widgets, window functions, and sorting.
- [Bamboo Weekly #192: Nobel Prize winners (solutions)](https://www.bambooweekly.com/bamboo-weekly-192-nobel-prize-winners-solutions.md) - Get better at: Using Polars, working with APIs, handling JSON, cleaning, grouping, and plotting with Plotly.
- [Pandas office hours — Thursday (today!), October 15th](https://www.bambooweekly.com/pandas-office-hours-thursday-today-october-15th.md) - Join me for office hours, where you can ask any questions you have about Pandas!
- [Bamboo Weekly #192: Nobel Prize winners](https://www.bambooweekly.com/bamboo-weekly-192-nobel-prize-winners.md) - Get better at: Using Polars, working with APIs, handling JSON, cleaning, grouping, and plotting with Plotly.
- [Bamboo Weekly #191: Election financing (solutions)](https://www.bambooweekly.com/bamboo-weekly-191-election-financing-solutions.md) - Get better at: Agentic coding and plotting with plotly
- [Bamboo Weekly #191: Election financing](https://www.bambooweekly.com/bamboo-weekly-191-election-financing.md) - Get better at: Agentic coding and plotting with plotly
- [Bamboo Weekly #190: Data centers (solutions)](https://www.bambooweekly.com/bamboo-weekly-190-data-centers-solution.md) - Get better at: Agentic coding and plotting with plotly
- [Bamboo Weekly #190: Data centers — update](https://www.bambooweekly.com/bamboo-weekly-190-data-centers-update.md) - Get better at: Agentic coding and plotting with plotly
- [Bamboo Weekly #190: Data centers](https://www.bambooweekly.com/bamboo-weekly-190-data-centers.md) - Get better at: Agentic coding and plotting with plotly
- [Bamboo Weekly #189: AI security incidents (solutions)](https://www.bambooweekly.com/bamboo-weekly-189-ai-security-incidents-solutions.md) - Get better at: Working with BSON files, JSON, grouping, plotting, joins, dates and times
- [Bamboo Weekly #189: AI security incidents](https://www.bambooweekly.com/bamboo-weekly-189-ai-security-incidents.md) - Get better at: Working with BSON files, JSON, grouping, plotting, joins, dates and times
- [Bamboo Weekly #188: Hurricane season (solutions)](https://www.bambooweekly.com/bamboo-weekly-188-hurricane-season-solutions.md) - Get better at: Working with CSV files, cleaning data, plotting with Plotly, grouping, and dates and times.
- [Bamboo Weekly #188: Hurricane season](https://www.bambooweekly.com/bamboo-weekly-188-hurricane-season.md) - Get better at: Working with CSV files, cleaning data, plotting with Plotly, grouping, and dates and times.
- [Pandas office hours — Thursday, September 10th (recording)](https://www.bambooweekly.com/pandas-office-hours-thursday-september-10th-recording.md) - Join me for office hours, where you can ask any questions you have about Pandas!
- [Bamboo Weekly #187: PISA 2025 (solutions)](https://www.bambooweekly.com/bamboo-weekly-187-pisa-2025-solutions.md) - Get better at: Working with Excel files, cleaning data, correlations, and plotting with Plotly.
- [Pandas office hours — Thursday, September 10th](https://www.bambooweekly.com/pandas-office-hours-thursday-september-10th.md) - Join me for office hours, where you can ask any questions you have about Pandas!
- [Bamboo Weekly #187: PISA 2025](https://www.bambooweekly.com/bamboo-weekly-187-pisa-2025.md) - Get better at: Working with Excel files, cleaning data, correlations, and plotting with Plotly.
- [Bamboo Weekly #186: Renaming places (solutions)](https://www.bambooweekly.com/bamboo-weekly-186-renaming-places-solutions.md) - Get better at: Working with multiple CSV files, dates and times, joins, grouping, and plotting.
- [Bamboo Weekly #186: Renaming places](https://www.bambooweekly.com/bamboo-weekly-186-renaming-places.md) - Get better at: Working with multiple CSV files, dates and times, joins, grouping, and plotting.
- [Bamboo Weekly #185: US-Canada trade (solutions)](https://www.bambooweekly.com/bamboo-weekly-185-us-canada-trade-solutions.md) - Get better at: Working with multiple CSV files, joins, and plotting with Plotly.
- [Bamboo Weekly #185: US-Canada trade](https://www.bambooweekly.com/bamboo-weekly-185-us-canada-trade.md) - Get better at: Working with multiple CSV files, and plotting with Plotly.
- [A Polars solution to BW #184 — the first contest winner](https://www.bambooweekly.com/a-polars-solution-to-bw-184-the-first-contest-winner.md) - A reader's solution to BW 184 using Polars.
- [Pandas office hours — Wednesday, August 26](https://www.bambooweekly.com/pandas-office-hours-wednesday-august-26.md) - Join me for office hours, where you can ask any questions you have about Pandas!
- [Bamboo Weekly #184: Parmesan cheese (solutions)](https://www.bambooweekly.com/bamboo-weekly-184-parmesan-cheese-solutions.md) - Get better at: Working with CSV and Excel, plotting with Plotly, cleaning, joining, and working with dates and times.
- [Bamboo Weekly #184: Parmesan cheese](https://www.bambooweekly.com/bamboo-weekly-184-parmesan-cheese.md) - Get better at: Working with CSV and Excel, plotting with Plotly, cleaning, joining, and working with dates and times.
- [Bamboo Weekly #183: Hiring (solutions)](https://www.bambooweekly.com/bamboo-weekly-183-hiring-solutions.md) - Get better at: Working with multiple CSV files, dates and times, pivot tables, cleaning, and plotting with Plotly.
- [Bamboo Weekly #183: Hiring](https://www.bambooweekly.com/bamboo-weekly-183-hiring.md) - Get better at: Working with multiple CSV files, dates and times, pivot tables, cleaning, and plotting with Plotly.
- [Announcing: Even more Pandas practice problems](https://www.bambooweekly.com/announcing-even-more-pandas-practice-problems.md) - One of the high points of my week is writing Bamboo Weekly. It's fun for me to explore topics that I've heard about in the news, and even to reproduce their findings. It's even more fun to read a story in the newspaper a few days or weeks after I've explored a topic, and be able to assess their jud…
- [Bamboo Weekly #182: Surveillance technology (solutions)](https://www.bambooweekly.com/bamboo-weekly-182-surveillance-technology-solutions.md) - Get better at: Working with CSV files, dates and times, grouping, and cleaning.
- [Bamboo Weekly #182: Surveillance technology](https://www.bambooweekly.com/bamboo-weekly-182-surveillance-technology.md) - Get better at: Working with CSV files, dates and times, grouping, pivot tables, and cleaning.
- [Pandas office hours — Thursday, July 30th (recording)](https://www.bambooweekly.com/pandas-office-hours-thursday-july-30th-2.md) - Join me for office hours, where you can ask any questions you have about Pandas!
- [Bamboo Weekly #181: Housing costs (solutions)](https://www.bambooweekly.com/bamboo-weekly-181-housing-costs-solution.md) - Get better at: Working with CSV files, dates and times, grouping, pivot tables, cleaning, and regular expressions
- [Pandas office hours — Thursday, July 30th](https://www.bambooweekly.com/pandas-office-hours-thursday-july-30th.md) - Join me for office hours, where you can ask any questions you have about Pandas!
- [Bamboo Weekly #181: Housing costs](https://www.bambooweekly.com/bamboo-weekly-181-housing-costs.md) - Get better at: Working with CSV files, dates and times, grouping, pivot tables, cleaning, and regular expressions
- [Bamboo Weekly #180: Movies (solutions)](https://www.bambooweekly.com/bamboo-weekly-180-movies-solutions.md) - Get better at: Working with CSV files, dates and times, grouping, pivot tables, and regular expressions
- [Bamboo Weekly #180: Movies](https://www.bambooweekly.com/bamboo-weekly-180-movies.md) - Get better at: Working with CSV files, dates and times, grouping, pivot tables, and regular expressions
- [Bamboo Weekly #179: Krakow tourism (solutions)](https://www.bambooweekly.com/bamboo-weekly-179-krakow-tourism-solution.md) - Get better at: Working with CSV files, dates and times, grouping, pivot tables, and regular expressions
- [Bamboo Weekly #179: Krakow tourism](https://www.bambooweekly.com/bamboo-weekly-179-krakow-tourism.md) - Get better at: Working with CSV files, dates and times, grouping, pivot tables, and regular expressions
- [Bamboo Weekly #178: Harmful algal bloom (solutions)](https://www.bambooweekly.com/bamboo-weekly-178-harmful-algal-bloom-solution.md) - Get better at: Working with Excel files, dates and times, and regular expressions
- [Bamboo Weekly #178: Harmful algal bloom](https://www.bambooweekly.com/bamboo-weekly-178-harmful-algal-bloom.md) - Get better at: Working with Excel files, dates and times, and regular expressions
- [Bamboo Weekly #177: European Summer (solutions)](https://www.bambooweekly.com/bamboo-weekly-177-european-summer-solution.md) - Get better at: Working with Excel files, APIs, GeoPandas, plotting with Plotly, and multi-indexes.
- [Bamboo Weekly #177: European Summer](https://www.bambooweekly.com/bamboo-weekly-177-european-summer.md) - Get better at: Working with Excel files, APIs, GeoPandas, plotting with Plotly, and multi-indexes.
- [Bamboo Weekly #176: Religious restrictions (solutions)](https://www.bambooweekly.com/bamboo-weekly-176-religious-restrictions-solutions.md) - Get better at: Working with CSV files, reshaping data, pivot tables, grouping, and plotting.
- [Bamboo Weekly #176: Religious restrictions](https://www.bambooweekly.com/bamboo-weekly-176-religious-restrictions.md) - Get better at: Working with CSV files, reshaping data, pivot tables, grouping, and plotting.
- [Bamboo Weekly #175: Inflation (solutions)](https://www.bambooweekly.com/bamboo-weekly-175-inflation-solution.md) - Get better at: scraping, pivot tables, Plotly, regular expressions, and joins.
- [Bamboo Weekly #175: Inflation](https://www.bambooweekly.com/bamboo-weekly-175-inflation.md) - Get better at: scraping, pivot tables, Plotly, regular expressions, and joins.
- [Bamboo Weekly #174: Vacation (solutions)](https://www.bambooweekly.com/bamboo-weekly-174-vacation-solution.md) - Get better at: scraping, pivot tables, Plotly, regular expressions, and joins.
- [Bamboo Weekly #174: Vacation](https://www.bambooweekly.com/bamboo-weekly-174-vacation.md) - Get better at: scraping, pivot tables, Plotly, regular expressions, and joins.
- [Pandas office hours — Thursday, June 11th](https://www.bambooweekly.com/pandas-office-hours-thursday-june-11th.md) - Join me for office hours, where you can ask any questions you have about Pandas!
- [Bamboo Weekly #173: IPOs (solutions)](https://www.bambooweekly.com/bamboo-weekly-173-ipos-solution.md) - Get better at: multiple files, pivot tables, plotting, filtering, and working with dates and times.
- [Bamboo Weekly #173: IPOs](https://www.bambooweekly.com/bamboo-weekly-173-ipos.md) - Get better at: multiple files, pivot tables, plotting, filtering, and working with dates and times.
- [Bamboo Weekly #172: World Cup (solutions)](https://www.bambooweekly.com/bamboo-weekly-172-world-cup-solutions.md) - Get better at: CSV files, pivot tables, grouping, plotting, filtering, and working with dates and times.
- [Bamboo Weekly #172: World Cup](https://www.bambooweekly.com/bamboo-weekly-172-world-cup.md) - Get better at: CSV files, pivot tables, plotting, filtering, and working with dates and times.
- [Bamboo Weekly #171: Hantavirus (solutions)](https://www.bambooweekly.com/bamboo-weekly-171-hantavirus-solutions.md) - Get better at: CSV files, pivot tables, joins, working with dates and times, handling missing data, and plotting with Plotly
- [Bamboo Weekly #171: Hantavirus](https://www.bambooweekly.com/bamboo-weekly-171-hantavir