Try this:

Lines <- "ID;record
1;20
;30
;25
2;26
;15
3;21"

x <- read.table(textConnection(Lines), sep = ";", header = TRUE)

library(zoo)
x$ID <- na.locf(x$ID)

On Sun, Dec 14, 2008 at 11:56 PM, Zhixin Liu <zliu@efs.mq.edu.au> 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.
>



-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O

	[[alternative HTML version deleted]]

