[R] Add missing values/timestamps

[Uwe Ligges]

j.k wrote:
> Hello alltogheter,
> I have the following problem and maybe someone can help me with it.
> I have a list of values with times. They look like that:
> 
>                                V1           V2
> 1 2008-10-14 08:45:00 94411.08
> 2 2008-10-14 08:50:00 90745.45
> 3 2008-10-14 08:55:00 82963.35
> 4 2008-10-14 09:00:00 75684.38
> 5 2008-10-14 09:05:00 78931.82
> 6 2008-10-14 09:20:00 74580.11
> 7 2008-10-14 09:25:00 69666.48
> 8 2008-10-14 09:30:00 77794.89
> 
> I have these data combined from different series of measurements.
> As you can see the problem is that between these series are gaps which I
> want to fill.
> 
> The format of the time is POSIXct
> 
> Are there any suggestions how I can fill these missing times and afterwards
> interpolate/predict their values?


1. Generate a second data.frame with a sequence of all timestamps you 
want to have and merge() afterwards.
2. Don't know which method is good for imputation / prediction on your 
data, hence cannot answer the second part of the question.

Uwe Ligges


> Thanks in advance
> Johannes