Function to delete multiple specific rows?

Question

When I clean my data, which is called total, I need to delete rows where Column V9's string length is less than 10. Is there any function to do this?

I already tried the subset function, but I get the error mentioned below:

subset(total$V9, str_length < 10)

Error in str_length < 10 : comparison (3) is possible only for atomic and list types.

`subset(total, str_length(V9)>=10)` or `total[str_length(total$V9)>=10, ]` — jogo, Aug 19 '19 at 11:59

Chelmy88 · Answer 1 · 2019-08-19T12:18:58.427

1

If you use:

total[which(nchar(total$V9))>=10,]

it will return only line where the string length is >= 10

edited Aug 19 '19 at 12:18

answered Aug 19 '19 at 12:01

Chelmy88

1,106
1
6
17

1

Am I wrong or is it missing a `=` to have >=10? – s__ Aug 19 '19 at 12:07
correct, thanks a lot. I'll edit the answer. – Chelmy88 Aug 19 '19 at 12:18

ArunPratap · Answer 2 · 2019-08-19T12:08:25.303

0

yes you can remove Multiple Rows by selecting a subset
you can also use subset function with multiple conditions

  # remove rows in r - subset function with multiple conditions
 subset(total$V9, your condition) //you can check your conditions here

you can select your subset as per your requirement

Update from Jogo Comment

subset(total, str_length(V9)>=10) or total[str_length(total$V9)>=10, ]

edited Aug 19 '19 at 12:08

answered Aug 19 '19 at 12:03

ArunPratap

4,816
7
25
43

Function to delete multiple specific rows?

2 Answers2