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.