Select every night data from a timetable with 1 minutes time step
조회 수: 3 (최근 30일)
이전 댓글 표시
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
채택된 답변
Walter Roberson
2018년 6월 20일
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,:);
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Time Series에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!