Re: [R] Interpolating hourly basis

2011-11-21 Thread R. Michael Weylandt
201005080300  2.44 233.86  1  0 > 2010-05-01 06:00:00 201005080600  0.96 194.43  1  0 > 2010-05-01 06:00:00 201005080900  1.76 138.89  1  0 > 2010-05-01 06:00:00 201005081200  2.79 146.98  1  0 > 2010-05-01 06:00:00 201005081500  3.45 226.90  1  0 > 2010-05-01 06:00:00 201005081800  2.5

Re: [R] Interpolating hourly basis

2011-11-16 Thread MacQueen, Don
One option would be, after you have converted one of your date/time variables (V2 I would assume) to POSIXct class, you can use the interp() function in the akima package for linear interpolation between adjacent time points. -Don -- Don MacQueen Lawrence Livermore National Laboratory 7000 East

Re: [R] Interpolating hourly basis

2011-11-16 Thread R. Michael Weylandt
Can you provide a dput() example of your data and put it in a workable form -- I have no idea what that long list of numbers nor the 1 / 0 on the end represent. I think if you do this with a real time series class like xts you can create a new object with the interpolated times; fill in the values

Re: [R] Interpolating hourly basis

2011-11-16 Thread David Winsemius
On Nov 16, 2011, at 8:56 AM, abcdef ghijk wrote: I have a huge data set in the form of V1 V2 V3 V4 V5 V6 1 2010050120100501 1.68291.38 1 0 2 20100501201005010300 0.93335.10 1 0 3 20100501201005010600 2.25 57.38 1 0 4 2010050

[R] Interpolating hourly basis

2011-11-16 Thread abcdef ghijk
I have a huge data set in the form of            V1           V2         V3   V4     V5  V6 1     2010050120100501 1.68291.38 1  0 2     20100501201005010300 0.93335.10 1  0 3     20100501201005010600 2.25 57.38 1  0 4     20100501201005010900 0.43 13.76 1  0 5     20100501