Uneven time series averaging

Question

Colin Edgar 2015-11-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/254569-uneven-time-series-averaging

回答： Colin Edgar 2015-12-17

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