[R] Filling in Gapped Interval of a Data Frame As Series

[Dimitris Rizopoulos]

one way is the following:

dat. <- data.frame(V1 = min(dat$V1):max(dat$V1), V2 = 0)
newdat <- merge(dat, dat., by = "V1", all.y = TRUE, suffixes = c("", "."))
newdat$V2[na.ind] <- newdat$V2.[na.ind <- is.na(newdat$V2)]
newdat[-3]


I hope it helps.

Best,
Dimitris


Gundala Viswanath wrote:
> Dear all,
> 
> I have a data frame that looks like this:
> 
>> dat
>     V1     V2
> 1  -8      100
> 2  -6      20.2
> 3  -1      1.5
> 4   2      3.00
> 5   3      78.8
> 6   5      33.2
> 7   6      44.5
> 8   7     5.00
> 
> Now I want to fill the V1 column  in series (note that it is gapped),
> with the corresponding value in V2 as 0.
> 
> So in the end we would like to have:
> 
>> newdat
>     V1     V2
> 1   -8      100
> 2   -6      20.2
> 3   -7      0
> 4   -6      0
> 5   -5      0
> 6    -4     0
> 7    -3     0
> 8    -2     0
> 9    -1     1.5
> 10    0     0
> 11    1     0
> 12   2      3.00
> 13   3      78.8
> 14   4      0
> 15   5      33.2
> 16   6      44.5
> 17   7      5.00
> 
> Is there a way to do it in R?
> - Gundala Viswanath
> Jakarta - Indonesia
> 
> ______________________________________________
> 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.
> 

-- 
Dimitris Rizopoulos
Assistant Professor
Department of Biostatistics
Erasmus University Medical Center

Address: PO Box 2040, 3000 CA Rotterdam, the Netherlands
Tel: +31/(0)10/7043478
Fax: +31/(0)10/7043014