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