Message-ID: <970785581.13352621229307167550.JavaMail.javamailuser@localhost>
Date: 2008-12-15T02:12:47Z
From: Mark Leeds
Subject: how to create duplicated ID in multi-records per subject dataset
hi: change your dots to NAs and then use na.locf in the zoo package. i
didn't test it but i think that should work.
DF$ID[DF$ID == .]<-NA
DF$ID<-na.locf(DF$ID)
On Sun, Dec 14, 2008 at 8:56 PM, Zhixin Liu wrote:
> Hi R helpers,
>
> If I have a dataset looks like:
> ID record 1 20
> . 30
> . 25
> 2 26
> . 15
> 3 21
> 4.....................
>
> And I want it becomes ID record 1 20
> 1 30
> 1 25
> 2 26
> 2 15
> 3 21
> 4.....................
>
> That is, I have to duplicate IDs for those with multiple records. I am
> wondering it is possible to be done in R, and I am grateful if you
> would like to show me the direction.
>
> Many thanks!
>
> Zhixin
>
> ______________________________________________
> 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.