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

2013-11-14 Thread Jim Lemon
On 11/14/2013 04:02 PM, dila radi 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

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

2013-11-14 Thread Frans Marcelissen
R purists forbid the use of the for loop, but I am afraid this is the most simple solution: for (i in 1:(length(V6)-1)) if(is.na(V6[i])) V6[i]-V6[i+1] 2013/11/14 Jim Lemon j...@bitwrit.com.au On 11/14/2013 04:02 PM, dila radi wrote: Hi all, I have a data set which treat missing value as

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

2013-11-14 Thread Bert Gunter
On Thu, Nov 14, 2013 at 1:13 AM, Frans Marcelissen frans.marcelis...@digipsy.nl wrote: R purists forbid the use of the for loop, That is utter nonsense. Please do not make such statements when you have no idea what you're talking about. It just promulgates confusion. -- Bert simple solution:

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

2013-11-14 Thread 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)

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

2013-11-13 Thread dila radi
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