[R] Replace NA's with value in the next row

[arun]

Hi,

I think you used a column that doesn't exist in the dataset.

Targetstation <- read.table(text="V1 V2 V3 V4 V5 V6 V7  
0 0 0 1.2 0 0 0.259
0 0 12.8 0 23.7 0 8.495
 6 0 81.7 0.2 0 20 19.937
 0 1.5 60.9 0 0 15.5 13.900
 1 13 56.8 17.5 32.8 6.4 27.654
  4 3 66.4 2 0.3 NA 17.145",sep="",header=TRUE)


within(Targetstation, V6 <- replace(V6,is.na(V6),V7[is.na(V6)]))
  V1   V2   V3   V4   V5     V6     V7
1  0  0.0  0.0  1.2  0.0  0.000  0.259
2  0  0.0 12.8  0.0 23.7  0.000  8.495
3  6  0.0 81.7  0.2  0.0 20.000 19.937
4  0  1.5 60.9  0.0  0.0 15.500 13.900
5  1 13.0 56.8 17.5 32.8  6.400 27.654
6  4  3.0 66.4  2.0  0.3 17.145 17.145

#if you use:
 !is.na(Targetstation$v6) #'v6' and 'V6' are different
logical(0)
Warning message:
In is.na(Targetstation$v6) :
  is.na() applied to non-(list or vector) of type 'NULL'



A.K.









On Thursday, November 14, 2013 2:26 AM, dila radi <dilaradi21 at gmail.com> wrote:
Hi all,

I have a data set which treat missing value as NA and now I need to replace
all these NA's by using number in the same row but different column.

Here is the part of my data:
V1 V2 V3 V4 V5 V6 V7  0 0 0 1.2 0 0 0.259  0 0 12.8 0 23.7 0 8.495  6 0
81.7 0.2 0 20 19.937  0 1.5 60.9 0 0 15.5 13.900  1 13 56.8 17.5 32.8 6.4
27.654  4 3 66.4 2 0.3 NA 17.145


I want to replace (V6, 6) with (V7, 6). I have about 1000 NA's in V6 which
I want to replace  with the same row in V7. The other values in V6, I want
to keep remain the same.

How to achieve this? Assuming my data is called "Targetstation",  I have
tried this:

Targetstation <- within(Targetstation, v6 <- replace(v6, is.na(v6), v7[is.na
(v6)]))

But R gives me this:

Warning messages:

1: In is.na(v6) : is.na() applied to non-(list or vector) of type 'NULL'

2: In is.na(v6) : is.na() applied to non-(list or vector) of type 'NULL'


How to solve this?

Thank you in advance.

Regards,

Dila.

    [[alternative HTML version deleted]]

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.