Select every night data from a timetable with 1 minutes time step
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Jian Teng
am 19 Jun. 2018
Kommentiert: Jian Teng
am 20 Jun. 2018
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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 20 Jun. 2018
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,:);
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Time Series finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!