R, remove row if there is a certain character

Asked Nov 30 '15 at 20:06

Active Nov 30 '15 at 20:15

Viewed 2,093 times

if my data frame looks like this, I want to remove the rows if there is "A" in the A column

df    
   A            B       C
1 "4:10:05A"  James    Math
2 "3:10:45"   Tony    Science
3 "3:10:55"   Hong     Math
4 "1:34:23A"  Kim      Math
5 "2:34:13A:  Min     English

the result would look like this

df    
   A            B       C

2 "3:10:45"   Tony    Science
3 "3:10:55"   Hong     Math

edited Nov 30 '15 at 20:15

Jaap

81,064
34
182
193

asked Nov 30 '15 at 20:06

Joe

6

`df[!grepl("A", df$A), ]`? – David Arenburg Nov 30 '15 at 20:10
@DavidArenburg That totally solves OP's problem. You should post an answer. – nicola Nov 30 '15 at 20:12

R, remove row if there is a certain character

0 Answers0

Linked