[R] How to "bin"/average" time points?

DonDolowy kevin.dalgaard at gmail.com
Thu Nov 25 21:49:51 CET 2010


Dear all,

I am pretty new to R only having an introduction course, so please bare with
me. I am doing my PhD at The Max Planck Institute of Immunobiology where I
am analyzing some calorimetry data from some mice. 
I have a spreadsheet consisting of measurements of the respiratory exchange
rate at different time points measured every 9 minutes over some days.
My goal is "bin"/average the time points of each hour to only one
measurements. 

E.g.
[Time] - [Measurement]
12.09 - 0.730
12.18 - 0.732
12.27 - 0.743
12.36 - 0.757
12.45 - 0.781
12.54 - 0.731
--> should be averaged to fx one time point and one value, fx:
12.30 - [average of the six measurements]

I know how to average the measurements in a whole column but how to average
every six measurements automatically and also how to average every six time
points and make a new sheet consisting of these data?

I hope you guys are able to help, since we are really stuck here. I can of
course do it manually but with >8000 measurements it will take lots of time.

Thank you very much.

Best regards,
Kevin Dalgaard
-- 
View this message in context: http://r.789695.n4.nabble.com/How-to-bin-average-time-points-tp3059509p3059509.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list