deleting rows of a data frame with specific condition

Question

I've seen similar questions here, but I couldn't find any help.

I have a df like this:

df <- data.frame(CSF1=c(-9,-9,-9,-9), CSF2=c(-9,-1,-9,-9), 
               D13S1=c(-9,-9,11,11), D13S2=c(-9,-9,11,12))

         CSF1 CSF2 D13S1 D13S2 
10398     -9   -9   -9    -9                   
10398     -9   -1   -9    -9                             
20177     -9   -9   11    11                  
20361     -9   -9   11    12

I want to delete all the rows with values -9 or -1 for all columns, like the first 2 rows.

Thanks!

Dov Chelst · Accepted Answer · 2013-05-02 06:46:57Z

3

All I will add is that the which function doesn't appear to be necessary. Removing it yields the same result.

There is a secondary problem that you would have in situations with missing data. If, you add an NA to the 3rd row (try it with df[3,4] <- NA), then the output of the above solution will omit the 3rd row as well regardless of the other entries' values. I won't suggest alternatives as this may not be a problem for your data set.

answered May 2, 2013 at 6:46

Dov Chelst

461 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Arun Over a year ago

Dov, I think you should suggest alternatives. That's the point of SO (to get the best answer) :).

Arun · Accepted Answer · 2013-05-02 06:57:46Z

2

Try this (edited by Arun to account for Dov's post):

df[rowSums(df == -1 | df == -9, na.rm = TRUE) != ncol(df), ]
##   CSF1 CSF2 D13S1 D13S2
## 3   -9   -9    11    11
## 4   -9   -9    11    12

(df == -1 | df == -9) will give you logical matrix. rowSums will give you count of TRUE in each row since TRUE is evaluated as 1. The na.rm=TRUE is to ensure that rows with NA are not omitted (see Dov's post). Use resultant row numbers to subset df.

edited May 2, 2013 at 6:57

Arun

119k28 gold badges290 silver badges396 bronze badges

answered May 2, 2013 at 5:08

CHP

17.2k4 gold badges42 silver badges59 bronze badges

Collectives™ on Stack Overflow

deleting rows of a data frame with specific condition

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related