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

[Gabor Grothendieck]

Try this:
> library(zoo)
> Lines <- "-8      100
+   -6      20.2
+   -1      1.5
+    2      3.00
+    3      78.8
+    5      33.2
+    6      44.5
+    7     5.00"
> DF <- read.table(textConnection(Lines))
> z <- zoo(DF$V2, DF$V1)
> zz <- merge(z, zoo(, seq(min(time(z)), max(time(z)))), fill = 0); zz
   -8    -7    -6    -5    -4    -3    -2    -1     0     1     2     3     4
100.0   0.0  20.2   0.0   0.0   0.0   0.0   1.5   0.0   0.0   3.0  78.8   0.0
    5     6     7
 33.2  44.5   5.0


If you want to create a data frame from that try this:

newDF <- data.frame(Time = time(zz), Value = coredata(zz))

although you might be best off to just leave it as a zoo object
so that you can make use of other zoo methods too.

> plot(zz, type = "o")

See the three zoo vignettes (PDF documents) for more info.


On Sun, Apr 5, 2009 at 3:22 AM, Gundala Viswanath <gundalav at gmail.com> 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.
>