How to specify does not contain in dplyr filter

Question

I am quite new to R     Using the table called SE CSVLinelist clean  I want to extract the rows where the Variable called where case travelled 1 DOES NOT contain the strings  Outside Canada  OR  Outside province territory of residence but within Canada    Then create a new table called SE CSVLinelist filtered   SE CSVLinelist filtered  lt - filter SE CSVLinelist clean   where case travelled 1  in  -c  Outside Canada   Outside province territory of residence but within Canada      The code above works when I just use  c  and not  -c   So  how do I specify the above when I really want to exclude rows that contains that outside of the country or province

User · Answer

Try putting the search condition in a bracket  as shown below  This returns the result of the conditional query inside the bracket  Then test its result to determine if it is negative  i e  it does not belong to any of the options in the vector   by setting it to FALSE  SE CSVLinelist filtered  lt - filter SE CSVLinelist clean    where case travelled 1  in  c  Outside Canada   Outside province territory of residence but within Canada       FALSE

User · Answer

Note that  in  returns a logical vector of TRUE and FALSE  To negate it  you can use   in front of the logical statement   SE CSVLinelist filtered  lt - filter SE CSVLinelist clean     where case travelled 1  in      c  Outside Canada   Outside province territory of residence but within Canada      Regarding your original approach with -c       - is a unary operator that  performs arithmetic on numeric or complex vectors  or objects which can be coerced to them    from help  -     Since you are dealing with a character vector that cannot be coerced to numeric or complex  you cannot use -

[r] How to specify "does not contain" in dplyr filter

Examples related to r

Examples related to filter

Examples related to dplyr