Import your data

data <- read_excel("myData.xlsx")

Chapter 14

Tools

Detect matches

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

Extract matches

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

Replacing matches

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