remove rows that a particular column has NA

Asked Sep 23 '14 at 18:27

Active Sep 23 '14 at 18:29

Viewed 89 times

I want to remove rows in the dataset where a column 'ABC' contains NA,

so I write:

dataset = dataset[dataset$ABC !='NA',]

the result:

instead of removing those rows that column 'ABC' is NA, it changes every column of those rows to NA

Example:

row     AAA   BBB   ABC
1        3     2     1
2        3     3     NA
3        1     2     3

result:

row     AAA   BBB   ABC
1        3     2     1
2        NA    NA    NA
3        1     2     3

where am I wrong? Thanks

edited Sep 23 '14 at 18:29

MrFlick

asked Sep 23 '14 at 18:27

lserlohn

`data[!is.na(data$ABC),]` `NA` is not a character string in your data, like you're using it. – Rich Scriven Sep 23 '14 at 18:32
Use `is.na` : `dataset[!is.na(dataset$ABC),]` – agstudy Sep 23 '14 at 18:32
For just a single column, use `dataset = dataset[!is.na(dataset$ABC ),]`. The `NA` value is a special one. To test use `is.na()` rather than `!="NA"` – MrFlick Sep 23 '14 at 18:32
1

I like the diagonal nature of our three comments. – Rich Scriven Sep 23 '14 at 18:35

0 Answers0