How to subset a data frame by taking only the Non NA values of 2 columns in this data frame

r missing-data subset
EnginO picture EnginO · Feb 13, 2015 · Viewed 89.4k times · Source

I am trying to subset a data frame by taking the integer values of 2 columns om my data frame

Subs1<-subset(DATA,DATA[,2][!is.na(DATA[,2])] & DATA[,3][!is.na(DATA[,3])])

but it gives me an error : longer object length is not a multiple of shorter object length.

How can I construct a subset which is composed of NON NA values of column 2 AND column 3?

Thanks a lot?

Answer

cogitovita picture cogitovita · Feb 13, 2015

Try this:

Subs1<-subset(DATA, (!is.na(DATA[,2])) & (!is.na(DATA[,3])))

The second parameter of subset is a logical vector with same length of nrow(DATA), indicating whether to keep the corresponding row.

Related questions

Remove rows with all or some NAs (missing values) in data.frame

I'd like to remove the lines in this data frame that: a) contain NAs across all columns. Below is my example data frame. gene hsap mmul mmus rnor cfam 1 ENSG00000208234 0 NA NA NA NA 2 ENSG00000199674 0 2 2 2 2 3 ENSG00000221622 0 NA NA NA NA 4 …

Read More
How do I replace NA values with zeros in an R dataframe?

I have a data frame and some columns have NA values. How do I replace these NA values with zeroes?

Read More
Remove NA values from a vector

I have a huge vector which has a couple of NA values, and I'm trying to find the max value in that vector (the vector is all numbers), but I can't do this because of the NA values. How can …

Read More