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

1 次查看（过去 30 天）
pavlos
pavlos 2017-5-19
回答： Sean de Wolski 2017-5-19
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

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

采纳的回答

Sean de Wolski
Sean de Wolski 2017-5-19
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)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by