library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.5
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.5.1 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ tidyr 1.3.1
## ✔ purrr 1.0.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
netflix_data <- read.csv("Netflix.csv")
actor_data <- netflix_data %>%
separate_rows(cast, sep = ", ") %>%
rename(actor = cast)
actor_counts <- actor_data %>%
group_by(actor) %>%
summarise(appearances = n()) %>%
arrange(desc(appearances)) %>%
slice_head(n = 6)
print(actor_counts)
## # A tibble: 6 × 2
## actor appearances
## <chr> <int>
## 1 "" 570
## 2 "Anupam Kher" 33
## 3 "Shah Rukh Khan" 30
## 4 "Naseeruddin Shah" 27
## 5 "Om Puri" 27
## 6 "Akshay Kumar" 26