Uneven time series averaging

Question

0 个投票

Need to get hourly averages of data which have uneven frequency over a given hour. Id is the 'sample' which is repeated over and over. Here is example data:

 id  hour  data
17  376.2
17  376.1
17  375.9
17  375.7
17  375.9
17  375.7
18  375.9
18  376.1
18  376.3
18  376.6
18  377.0
18  377.2
19  377.5
19  377.7
19  378.0
19  378.1
19  378.4
19  378.6
19  378.7
20  378.8

I want to arrive at something this this in which the hours having 2 samples get a mean value:

hour  id1  id2  id3  id4  id5
376.0  376.1  375.9  375.7  375.9
377.0  376.5  376.1  376.3  376.6
378.1  378.4  378.0  378.2  378.0
379.1  379.1  379.3  378.8  379.3

I have unique value index for HH and id having already used accumarray to collect the data as shown. Is there a way to use the 'aggregation function' of unstack() to do this?

newdata = unstack(data, {'data1'}, 'id');

I can't figure out the syntax based on mathworks help. Thanks....