On 11/29/2010 10:00 AM, Gabor Grothendieck wrote:
On Mon, Nov 29, 2010 at 9:45 AM, Jason Edgecombe
<ja...@rampaginggeek.com>  wrote:
Hi Everyone,

I have a some data from a sports gps device like the following:

        time latitude longitude altitude  distance heartrate
1 1277648884 0.304048 -0.793819      260  0.000000        94
2 1277648885 0.304056 -0.793772      262  4.307615        95
3 1277648888 0.304060 -0.793696      263 11.262347        97
4 1277648894 0.304075 -0.793544      263 25.237911       103
5 1277648898 0.304085 -0.793455      263 33.322525       108
6 1277648902 0.304064 -0.793387      256 40.042988       115

As you can see, the samples have irregular holes in the time column. How can
I fill in the missing samples using na.approx?

I've tried to creating a blank series with no gaps and combine them, but
"merge" just adds columns and "rbind" compains about duplicate indexes.

P.S. My GPS still has holes in the data when I turn off "smart recording" :(

Try this:

Lines<- "time latitude longitude altitude  distance heartrate
1277648884 0.304048 -0.793819      260  0.000000        94
1277648885 0.304056 -0.793772      262  4.307615        95
1277648888 0.304060 -0.793696      263 11.262347        97
1277648894 0.304075 -0.793544      263 25.237911       103
1277648898 0.304085 -0.793455      263 33.322525       108
1277648902 0.304064 -0.793387      256 40.042988       115"

# read in data
library(zoo)
z<- read.zoo(textConnection(Lines), header = TRUE)

na.approx(z, xout = seq(min(time(z)), max(time(z))))



No change:
> na.approx(z, xout = seq(min(time(z)), max(time(z))))
           latitude longitude altitude  distance heartrate
1277648884 0.304048 -0.793819      260  0.000000        94
1277648885 0.304056 -0.793772      262  4.307615        95
1277648888 0.304060 -0.793696      263 11.262347        97
1277648894 0.304075 -0.793544      263 25.237911       103
1277648898 0.304085 -0.793455      263 33.322525       108
1277648902 0.304064 -0.793387      256 40.042988       115

There should be 19 samples after the na.approx.

I'm guessing that na.approx is what I need, but I'm open to suggestions.

Thanks,
Jason

______________________________________________
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.

Reply via email to