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 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' >> >> >> Hi Dila, > You could do this like this: > > V6NA<-is.na(Targetstation$V6) > Targetstation$V6[V6NA]<-Targetstation$V7[V6NA] > > but if you want to use the above, I think you will have to replace the > is.na(V6) with is.na(Targetstation$V6) or use the method above. > > Jim > > > ______________________________________________ > R-help@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. > -- ------------------- dr F.H.G. (Frans) Marcelissen DigiPsy (www.DigiPsy.nl <http://www.digipsy.nl/>) Pomperschans 26 5595 AV Leende tel: 040 2065030/06 2325 06 53 skype adres: frans.marcelissen email: frans.marcelis...@digipsy.nl [[alternative HTML version deleted]] ______________________________________________ R-help@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.