saving each minutes value as hourly average for individual dates.

In my analysis i want to find out the hourly average of my data point for each individual day. My data points are in minutes. (For each hour, i have to average my minutes data points) .I have to find this hourly averages of data point for an entire day. The same thing should repeat for other days too. I have put the theme of the trouble . Kindy help.

data set :

Date=20-dec Hour=[1AM, 2AM] values for 1AM=[1,2,3,4,5] value for 2AM=[10,15,20,25,30]

Date= 21- Dec Hour=[1AM, 2AM] values for 1AM=[10,20,30,40,50] value for 2AM=[100,150,200,250,300]

I want to identify the average value for each hour corresponding to date.

Ans expected: date:20 dec-1AM- 3 (3 is the average value of 1AM of Dec 20th). date:20 dec-2AM-20 (20 is the average value of 2AM of dec 20th). date:21 dec-1AM- 30 (30 is the average value of 1AM of Dec 20th). date:20 dec-2AM-200 (200 is the average value of 2AM of dec 20th).

Answer 1

[Chad Greene]

If you can get your time into datenum format, you can use my downsample_ts function.