CODEWITHSUNDEEP
rfilterdplyr
Carlos Araya
Carlos Araya

Reputation: 881

dplyr filter : value is contained in a vector

Is there a straight way to filter using dplyr::filter given an specific vector?

I'm looking for something like the code below:

top.food <- c('pizza', 'bacon', 'burger')

filter(orders, dish == 'pizza' | dish == 'bacon' | dish == 'burger')

I've chosen a character vector but it could be of any class.

I've thought about using grepl as a logical predicate grepl(dish, top.food) but it doesn't work since dish doesn't match a valid pattern (it takes just the 1st element).

Any ideas? thnx!

Upvotes: 27

Views: 50517

Answers (1)

Rich Scriven
Rich Scriven

Reputation: 99331

I think you are looking for the value matching function %in%.

filter(orders, dish %in% top.food)

Or you can switch to slice() and use match().

slice(orders, match(dish, top.food, 0L))

I believe that slice() is a bit faster than filter(), so that might be beneficial to you. See help(match) for all the details on value matching.

Upvotes: 48

Related Questions