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@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.

______________________________________________
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.

Reply via email to