data <- read_excel("myData.xlsx")
data$film
## [1] "Toy Story" "A Bug's Life" "Toy Story 2"
## [4] "Monsters, Inc." "Finding Nemo" "The Incredibles"
## [7] "Cars" "Ratatouille" "WALL-E"
## [10] "Up" "Toy Story 3" "Cars 2"
## [13] "Brave" "Monsters University" "Inside Out"
## [16] "The Good Dinosaur" "Finding Dory" "Cars 3"
## [19] "Coco" "Incredibles 2" "Toy Story 4"
## [22] "Onward" "Soul" "Luca"
## [25] "Turning Red" "Lightyear" "NA"
str_detect(data$film, "Toy")
## [1] TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
## [13] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [25] FALSE FALSE FALSE
sum(str_detect(data$film, "Toy"))
## [1] 4
data %>%
summarise(num_Toy = sum(str_detect(film, "Toy")))
## # A tibble: 1 × 1
## num_Toy
## <int>
## 1 4
data %>%
mutate(col_Toy = str_extract(film, "Toy")) %>%
select(film, col_Toy) %>%
filter(!is.na(col_Toy))
## # A tibble: 4 × 2
## film col_Toy
## <chr> <chr>
## 1 Toy Story Toy
## 2 Toy Story 2 Toy
## 3 Toy Story 3 Toy
## 4 Toy Story 4 Toy
data %>%
mutate(col_Cars = str_replace(film, "Toy", "Cars")) %>%
select(film, col_Cars)
## # A tibble: 27 × 2
## film col_Cars
## <chr> <chr>
## 1 Toy Story Cars Story
## 2 A Bug's Life A Bug's Life
## 3 Toy Story 2 Cars Story 2
## 4 Monsters, Inc. Monsters, Inc.
## 5 Finding Nemo Finding Nemo
## 6 The Incredibles The Incredibles
## 7 Cars Cars
## 8 Ratatouille Ratatouille
## 9 WALL-E WALL-E
## 10 Up Up
## # ℹ 17 more rows