How to use str_detect with multiple words

#1

Hi,

I want to remove few rows that contain different words. For example, variable Country has several countries in it and I want to exclude the rows with Mexico and Cambodia. I was trying to do something like this:
df <- df %>%
filter(str_detect(Country, "Mexico", "Cambodia", negate = TRUE))

How can I remove rows with specific words in it?

Thanks!

#2

In a regular expression, | means OR.

library(stringr)
library(dplyr)

DF <- data.frame(Country = c("Austria", "Cambodia", "Congo", "Mexico", "Nepal"))
DF
#>    Country
#> 1  Austria
#> 2 Cambodia
#> 3    Congo
#> 4   Mexico
#> 5    Nepal
DF <- DF %>%
  filter(str_detect(Country, "Mexico|Cambodia", negate = TRUE))
DF
#>   Country
#> 1 Austria
#> 2   Congo
#> 3   Nepal

Created on 2020-06-15 by the reprex package (v0.3.0)

#4

Do not put quotes around each country name. Put quotes around the entire regular expression.
Not this

"MEX"|"ExportCamexca"

Use this

"MEX|ExportCamexca"
#6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

#3

Thanks @FJCC! Why didn't I think about including OR? Anyhow, it seems like str_detect doesn't work right for me for some reason. Here is my code and Error:

image
image923×619 44.2 KB

Thanks for your help!

#5

Perfect! It works...Thank you!