count the number of hours in a day (multiple values per hour)

Question

pavlos 2017-5-19

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/341019-count-the-number-of-hours-in-a-day-multiple-values-per-hour

回答： Sean de Wolski 2017-5-19

采纳的回答： Sean de Wolski

Hello,

Please help me with the following.

Consider a matrix

M= [ 0 0 1 2 2 2 2 3 3 ... 23 0 1 1 2 2 2 3 3 3 3 ... 23 ];

These values corresponds to hours and my real matrix reaches up to 23.

I need to find per day how many values per hours existing. For example, the 1st day has two 0, one 1, three 2, two 3, etc, up to 23. The 2nd day has one 0, two 1, etc.

Thank you very much.

Best,

Pavlos

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Sean de Wolski 2017-5-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/341019-count-the-number-of-hours-in-a-day-multiple-values-per-hour#answer_267671

在 MATLAB Online 中打开

M = [0 0 1 2 2 2 2 3 3 23 0 1 1 2 2 2 3 3 3 3 23];
M = M(:); % columns are better
daybreaks = sign([diff(M); -5])==-1; % where do days split?
dayidx = repelem((1:sum(daybreaks)).',diff([0; find(daybreaks)]),1); % Which day
[mhour, ~, houridx] = unique(M); % unique hours
RecordsBYDay = accumarray([houridx, dayidx],1); % number of records for hour/day
table(mhour,RecordsBYDay)