> ## Content Index
> Fetch the complete content index at: https://www.bambooweekly.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Bamboo Weekly #51: Academy Awards
- URL: https://www.bambooweekly.com/bw-51-academy-awards/
- Published: 2024-01-31T15:58:46.000Z
- Updated: 2026-08-06T10:45:32.000Z
- Description: Get better at: CSV, PyArrow, missing values, cleaning, grouping, memory optimization, and plotting
- Author: Reuven M. Lerner
- Tags: csv, pyarrow, missing-data, cleaning, grouping, memory-optimization, plotting

It has been quite some time since I last saw a movie in a theater. But that doesn't mean I've stopped watching movies. On the contrary, thanks to streaming services and a projector, I've watched lots of movies over the last few years from the comfort of my own home.

I'm not the only one avoiding the cinema; industry data from The Numbers ([https://www.the-numbers.com/market/](https://www.the-numbers.com/market/?ref=bambooweekly.com)) makes it pretty clear that even though North American ticket sales have rebounded somewhat since the pandemic, we still aren't at pre-pandemic levels.

Just because people aren’t going to the theater doesn’t mean movie makers are sitting idle, though.

The Academy Awards, whose nominations were announced last week ([https://www.nytimes.com/2024/01/23/movies/2024-oscar-nominees-list.html?unlocked\_article\_code=1.R00.b7Z6.51ltAGMr6vjb&bgrp=a&smid=url-share](https://www.nytimes.com/2024/01/23/movies/2024-oscar-nominees-list.html?unlocked%5Farticle%5Fcode=1.R00.b7Z6.51ltAGMr6vjb&bgrp=a&smid=url-share&ref=bambooweekly.com)), are undoubtedly a way to market the film industry and encourage us to watch more movies. But there are also many talented people working in the film industry, and it's nice to be able to give them some recognition.

This week, I decided to take a break from the often heavy and difficult news that fills the world, and to look at something a bit lighter, namely the history of Academy Award nominees.

### Data and eight questions

In looking for data about the Academy Awards, I found a source on Kaggle that includes data from 1927 through 2023:

[https://www.kaggle.com/datasets/unanimad/the-oscar-award](https://www.kaggle.com/datasets/unanimad/the-oscar-award?ref=bambooweekly.com)

I was a bit disappointed that the data set hadn't yet been updated to include this year's nominees, but then discovered that David Lu (https://davidlu.dev/), a software developer with an interest in open source, had put together a similar data set -- and it included the latest nominations. That data is available here:

[https://github.com/DLu/oscar\_data/tree/main](https://github.com/DLu/oscar%5Fdata/tree/main?ref=bambooweekly.com)

The documentation on this page serves as a data dictionary, describing the columns in the data set, and how we could/should use them.

This week, I have eight questions and tasks for you based on this data set. The learning goals include working with PyArrow, strings and regular expressions, grouping, and sorting.

I’ll be back tomorrow with my full solutions, including the Jupyter notebook I used to solve these questions myself.

- Download the \`oscars.csv\` file, and turn it into a data frame. We'll only use the Year, CanonicalCategory (which should then be renamed "Category"), Film, FilmId, Name, and Winner columns. Use PyArrow for the backend data storage. The "Winner" column should have True/False values, rather than True/NA values.
- The "Year" column should contain integers, but it doesn't, because the first few awards were listed as having two years (e.g., "1927/28"). Change the values in this column to reflect the second date (e.g., "1927/28" should become "1928") and then change the column to contain integers.
- Film names are allowed to repeat. (That's why we kept the "FilmID" column.) How many film names have been used multiple times? What film name has been used the greatest number of times?
- What film has been nominated for the greatest number of awards? Which film actually won the greatest number of awards?
- Who has been nominated the most times for best actor/actress (of any sort, leading or supporting)? Who has won the greatest number of times?
- What was the greatest span of time between someone's first nomination and their last one?
- It sometimes seems like the number of awards has gone up over the years. Count the number of awards at each year's ceremony, and plot a line graph showing any changes.
- Finally, how much memory did the data frame use with PyArrow? How much would it have used with the standard NumPy backend?

I’ll be back tomorrow with my solutions and explanations.

Reuven