remove row with nan value

Question

let's say, for example, i have this data:

data <- c(1,2,3,4,5,6,NaN,5,9,NaN,23,9) attr(data,"dim") <- c(6,2) data       [,1] [,2] [1,]    1  NaN [2,]    2    5 [3,]    3    9 [4,]    4  NaN [5,]    5   23 [6,]    6    9 

Now i want to remove the rows with the NaN values in it: row 1 and 4. But i don't know where these rows are, if it's a dataset of 100.000+ rows, so i need to find them with a function and remove the complete row.

Can anybody point me in the right direction?

Answer 1

The function complete.cases will tell you where the rows are that you need:

data <- matrix(c(1,2,3,4,5,6,NaN,5,9,NaN,23,9), ncol=2) data[complete.cases(data), ]       [,1] [,2] [1,]    2    5 [2,]    3    9 [3,]    5   23 [4,]    6    9