Filtering a data frame by values in a column using wildcards

Question

From this post I was made aware you can filter data out of a data frame based on a value using data frame indexing.

e.g.:

studentdata[studentdata$Drink == 'water',]

How would I perform the same task but filter for e.g. water_cold and water_hot?

This does not work

studentdata[studentdata$Drink == 'water*',]

Use `grepl` i.e. `studentdata[grepl("water.*", studentdata$Drink),]` — akrun, Jul 03 '22 at 20:36
Or `library(tidyverse); dplyr::filter(studentdata, str_detect(Drink, "water_*"))` — AndrewGB, Jul 03 '22 at 20:58

score 1 · Answer 1 · answered Jul 03 '22 at 21:30

1

You can use str_detect from stringr as such:

library(tidyr) 

studentdata %>% 
    filter(str_detect(Drink, "water"))

answered Jul 03 '22 at 21:30

Fursham Hamid

1 Answers1