How to delete rows of R dataframe based on string match?
Last Updated :
26 Apr, 2022
In this article, we will discuss how to delete rows of a dataframe based on string match in R Programming Language.
For this grep() function can be used. This function searches for matches of certain character patterns in a vector of character strings and returns a boolean value as TRUE if that string is present else it returns FALSE.
Syntax: grepl(pattern, string, ignore.case=FALSE)
Parameter:
- pattern: regular expressions pattern
- string: character vector to be searched
First with the help of grepl() we have obtained the rows which consist of specified substrings in it. Then with Not operator(!) we have removed those rows in our data frame and stored them in another data frame.
Data frame in use:
Data frame
Example 1:
R
Strings<- c ( "Geeks" , "For" , "Geeks" , "GFG" , "Ram" ,
"Ramesh" , "Gene" , "Siri" )
Id<-1:8
df<- data.frame (Id,Strings)
print (df)
new_df=df[! grepl ( "Ra" ,df$Strings),]
print (new_df)
|
Output:
Example 2:
R
Strings<- c ( "Geeks" , "For" , "Geeks" , "GFG" , "Ram" ,
"Ramesh" , "Gene" , "Siri" )
Id<-1:8
df<- data.frame (Id,Strings)
print (df)
new_df=df[! grepl ( "Ge" ,df$Strings),]
print (new_df)
|
Output:
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...