Delete rows containing specific strings in R

Question

I would like to exclude lines containing a string  REVERSE   but my lines do not match exactly with the word  just contain it   My input data frame      Value   Name      55     REVERSE223        22     GENJJS     33     REVERSE456     44     GENJKI   My expected output      Value   Name      22     GENJJS     44     GENJKI

User · Accepted Answer

This should do the trick   df - grep  REVERSE   df Name      Or a safer version would be   df  grepl  REVERSE   df Name

User · Answer

You can use stri detect fixed function from stringi package  stri detect fixed c  REVERSE223   GENJJS    REVERSE    1   TRUE FALSE

User · Answer

You could use dplyr  filter   and negate a grepl   match   library dplyr   df   gt      filter  grepl  REVERSE   Name     Or with dplyr  filter   and negating a stringr  str detect   match   library stringr   df   gt      filter  str detect Name   REVERSE

User · Answer

You can use this function if it s multiple string df  grepl  quot REVERSE GENJJS quot   df Name

User · Answer

Actually I would use   df  grep  REVERSE   df Name  invert   TRUE        This will avoid deleting all of the records if the desired search word is not contained in any of the rows

User · Answer

You can use it in the same datafram  df  using the previously provided code  df  grepl  REVERSE   df Name      or you might assign a different name to the datafram using this code  df1 lt -df  grepl  REVERSE   df Name

[r] Delete rows containing specific strings in R

Examples related to r

Examples related to string

Examples related to match

Examples related to rows