Sorting time in 1 hour time slots.

Question

vidit kedia 2020-11-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/662448-sorting-time-in-1-hour-time-slots

编辑： Steven Lord 2020-11-25

I have a column matrix in datetime format, specifying time. I want to count the frequency of these time in 1hour time slots, that I have defined in a 24 x 2 matrix (datetime format). I tried using 'isbetween', but it gives only 0 as ouput.

For eg. :

A = [06:36:00 ; 09:45:23 ; .............. ; 15:17:07]; %Column matrix with time.

B = [00:00:00 , 01:00:00 , 02:00:00 , 03:00:00 , .................... , 23:00:00;

01:00:00 , 02:00:00 , 03:00:00 , 04:00:00 , .................... , 00:00:00;] % time slots. First column is start time and second column is end time.

Output should be a 24 x 1 matrix, with frequency for each time slot.

output = [0 0 0 12 6 ................. 2];

Kinldy help.

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

请先登录，再进行评论。

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

Answer 1

Sean de Wolski 2020-11-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/662448-sorting-time-in-1-hour-time-slots#answer_556233

在 MATLAB Online 中打开

Look at retime.

doc retime

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

请先登录，再进行评论。

Answer 2

Star Strider 2020-11-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/662448-sorting-time-in-1-hour-time-slots#answer_556268

在 MATLAB Online 中打开

One approach:

A = datetime([zeros(100,4) randi(1440, 100, 1) zeros(100,1)]);          % Create Data
[H,~,ix] = unique(hour(A));                                             % Unique Hours
Output = accumarray(ix, 1);                                             % Tally

.

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

请先登录，再进行评论。

Answer 3

Steven Lord 2020-11-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/662448-sorting-time-in-1-hour-time-slots#answer_556278

编辑：Steven Lord 2020-11-25

在 MATLAB Online 中打开

minutesPerDay = minutes(days(1));

m = minutes(randi(minutesPerDay, 100, 1));

n = datetime('now');

t = n + m;

h = histogram(t, 'BinWidth', hours(1));

tickloc = dateshift(n, 'start', 'hour') + hours(0:6:24);

tickloc.Format = 'HH';

xticks(tickloc)

The tick label formatting isn't perfect, but I believe that's partly because this figure is smaller than the figure you would create in a desktop MATLAB session. If you just need the binning information use histcounts or discretize instead of histogram.