Chapter 4 Missing values
In the process of web scraping the tables of winners and nominees of Oscars Best Actor/Actress and Best Supporting Actor/Actress over the years(overall and people of color), we found several missing values in the actress_lead and actress_sup data sets. We believe it happened while scraping multiple tables that were separated by year. The missing values were taken care of using drop_na(). For the box office data of the highest grossing film and Best Picture nominations each year, we had no missing values. Since we collected the variables that we want to use for the Best Picture winners with female lead and the rows with the corresponding years of the box office data for the nominations, there were no missing values for those data sets. The imdb data was not in the form of table, but we were also able to collect every data for the variables we wanted to use.
## [1] 0
## [1] 0
## [1] 0
## [1] 0
## [1] 0
## [1] 0
## [1] 0
## [1] 0
## [1] 2
## [1] 0
## [1] 5
## [1] 0
## [1] 0
## [1] 0
## [1] 0
## [1] 04.1 Missing Values in Actress Lead and Actress Supporting
## # A tibble: 10 x 3
## Year Actress Film
## <dbl> <chr> <chr>
## 1 2020 Andra Day The United States vs. Billie Holiday
## 2 2020 Vanessa Kirby Pieces of a Woman
## 3 2020 Carey Mulligan Promising Young Woman
## 4 2021 <NA> <NA>
## 5 2021 Jessica Chastain The Eyes of Tammy Faye
## 6 2021 Olivia Colman The Lost Daughter
## 7 2021 Penélope Cruz Parallel Mothers
## 8 2021 Nicole Kidman Being the Ricardos
## 9 2021 Kristen Stewart Spencer
## 10 NA <NA> <NA>## # A tibble: 10 x 3
## Year Actress Film
## <dbl> <chr> <chr>
## 1 2020 Maria Bakalova Borat Subsequent Moviefilm
## 2 2020 Glenn Close Hillbilly Elegy
## 3 2020 Olivia Colman The Father
## 4 2020 Amanda Seyfried Mank
## 5 2021 <NA> <NA>
## 6 2021 Ariana DeBose West Side Story
## 7 2021 Jessie Buckley The Lost Daughter
## 8 2021 Judi Dench Belfast
## 9 2021 Kirsten Dunst The Power of the Dog
## 10 2021 Aunjanue Ellis King Richard