Select every night data from a timetable with 1 minutes time step

Question

Jian Teng 2018-6-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406444-select-every-night-data-from-a-timetable-with-1-minutes-time-step

评论： Jian Teng 2018-6-20

I have a timetable that has 4 months of data. It has a 1 minute time step. I would like to select data for each night from 8PM to 5PM. How can I do it?

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2018-6-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406444-select-every-night-data-from-a-timetable-with-1-minutes-time-step#answer_325375

在 MATLAB Online 中打开

Assuming that you mean 5 AM, and that you want 8 PM exactly but not 5 AM exactly, then:

rt = YourTable.Properties.RowTimes;
rth = hour(rt);
mask = rth >= 20 | rth < 5;
subTable = YourTable(mask,:);

If you do want 5:00 AM to be included then

rt = YourTable.Properties.RowTimes;
rth = hour(rt);
rtm = minute(rt);
mask = rth >= 20 | rth < 5 | (rth == 5 & rtm == 0);
subTable = YourTable(mask,:);