BK<- [1 2 3;
4 NA 6;
7 8 NA;
10 11 NA]
How to remove rows containing NAs from column 2 without removing rows containing NAs from column 3 in R?
Many thanks!
Asked
Active
Viewed 54 times
-1
-
tool? I'm using R studio? – Brooke Oct 03 '16 at 05:20
-
ok, added the R tag, you might get some answers now :) – Cine Oct 03 '16 at 05:21
-
2Related? http://stackoverflow.com/questions/15773189/remove-na-nan-inf-in-a-matrix?rq=1 – Cine Oct 03 '16 at 05:21
-
1That's not how you construct a matrix in R, but `BK[!is.na(BK[, 2]), ]` – alistaire Oct 03 '16 at 05:31
-
R-fugee from Matlab no doubt. – IRTFM Oct 03 '16 at 05:38
1 Answers
0
Try this
BK[is.na(BK[,1:2])] <- 0
[,1] [,2] [,3]
[1,] 1 4 7
[2,] 2 0 8
[3,] 3 6 NA
data
BK <- matrix(c(1,2,3,4,NA,6,7,8,NA),3,3)
Arun kumar mahesh
- 2,289
- 2
- 14
- 22
-
Maybe I'm being slow, but this doesnt answer my question? NAs are still removed from column 3? – Brooke Oct 03 '16 at 05:41
-
-
@Brooke How about the updated code, do you feel it right way to implement – Arun kumar mahesh Oct 03 '16 at 10:06