This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to select rows which has NA in any column in the dataframe in R?

How to select rows which has NA in any column in the dataframe in R?

for example:

enter image description here

dataframe na r
• 5,886 views • link
updated by rpolicastro rpolicastro • written by Amr • Amr

3 answers

you can use the

library(dplyr)

data %>%
 filter_all(any_vars(is.na(.)))
• 0 views • link
written by LDT • LDT

Thanks genius

• 0 views • link
written by Amr • Amr

filter_all and any_vars are deprecated. Instead use filter(df, if_any(everything(), is.na)).

• 0 views • link
written by rpolicastro rpolicastro

We could negate complete.cases:

data[ !complete.cases(data), ]
• 0 views • link
written by zx8754 zx8754

No NAs:

data[rowSums(apply(data,1,is.na)) == 0,]

Any NAs:

data[rowSums(apply(data,1,is.na)) > 0,]
• 0 views • link
written by benformatics benformatics

Log in to answer this question.

More posts like this