Delete Non NA rows from a data frame

Asked Apr 12 '17 at 20:18

Active Apr 12 '17 at 20:32

Viewed 25 times

I'm new to R and I'm trying to use R to do some analysis for the job.

I have a data frame loaded from a TXT file.

  A  B  C  D
1 1  NA 3  NA
2 5  6  7  8
3 9  NA 11 NA
4 13 NA 15 NA

How can I take out the row 2 in the example? I can take out row 1,3,4 by na.omit(df) now.

The expected output likes below.

  A  B  C  D
1 1  NA 3  NA
2 9  NA 11 NA
3 13 NA 15 NA

I need to keep the rows with NA inside.

Thanks

edited Apr 12 '17 at 20:32

d.b

asked Apr 12 '17 at 20:18

YIYANG Gong

it's not clear what you mean by "take out", please provide an example of the desired output. – Mouad_Seridi Apr 12 '17 at 20:22
2

`?complete.cases` – zx8754 Apr 12 '17 at 20:22
1

The duplicate question shows how to use `complete.cases` in order to keep rows that do not contain NA. For this question you have to negate complete cases like this: `final[!complete.cases(final),]`, where "final" is your data frame. – R. Schifini Apr 12 '17 at 20:30
final[!complete.cases(final),] works. Thanks a lot – YIYANG Gong Apr 12 '17 at 20:37

0 Answers0