dataframe - combine 2 or more in operator in R -

i want select rows data frame according conditions. select values using % in % operator. used many %in% selecting values.

  val1 <- portdata [portdata$pmkval %in% c(na),]   val2 <- val1 [val1$quantity %in% c(na),]   weigtagedata <- val2 [val2$mktval %in% c(na),] 

can write these statements in 1 line , select data frame portdata instead of writing inefficient code?

first since you're checking na, can use nice handy function is.na(.). is,

val1 <- portdata [is.na(portdata$pmkval), ] val2 <- val1[is.na(val1$quantity), ] weigtagedata <- val2[is.na(val2$mktval), ] 

---

now, can use & connect these in single command follows:

weigtagedate <- portdata[is.na(portdata$pmkval) &                           is.na(portdata$quantity) &                           is.na(portdata$mktval), ] 

---

even nicer use with here, dont have use portdata$ every time.

weigtagedata <- portdata[with(portdata, is.na(pmkval) &                             is.na(quantity) & is.na(mktval)), ] 

of course same translates %in% well. it's not necessary here.