Removing rows from a data set with respect to multiple conditions in R

Question

I need to remove rows in my data which satisfy more than one condition

the variables are

comorbidity
date_of_comorbidity 
date_of_birth

i want to remove the rows where both comorbidity is equal to 10 AND date of comorbidity is less than date of birth

I have tried

newdata<-subset(df, !(comorbidity1==10 & date_of_comorbidity<date_of_birth))

This seems to remove the observations when it is one or the other

I need it to be only when both of these criteria occur in the same row.

EugenR · Accepted Answer · 2020-11-25 12:58:23Z

1

Try

newdata<-subset(df, comorbidity1 !=10 | date_of_comorbidity >= date_of_birth)

answered Nov 25, 2020 at 12:58

EugenR

1766 bronze badges

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

3 Comments

Annie Wright Over a year ago

This seems to be the same as what I have tried. I need it to check the date only when the comorbidity=10

EugenR Over a year ago

This is strange, I have played around with a simulated dataset, and it worked out fine. If you try subset(df, !(comorbidity1 !=10 | date_of_comorbidity >= date_of_birth)), do you see instances with comorbidity == 10 and date of comorbidity less than date of birth?

Annie Wright Over a year ago

The code above works for me (I can see when comorbidity == 10 and date of comorbidity less than date of birth) but when I try the first bit of code you gave me the number of observations drops by too much?

Escurisse · Accepted Answer · 2020-11-25 21:51:48Z

0

A similar solution with dplyr is:

library(dplyr)

newdata <- df %>% filter(comorbidity1 !=10 & date_of_comorbidity >= date_of_birth)

answered Nov 25, 2020 at 21:51

Escurisse

156 bronze badges

Collectives™ on Stack Overflow

Removing rows from a data set with respect to multiple conditions in R

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related