Selection of data in timetable
3 views (last 30 days)
Show older comments
Hi! I have a file in .mat format. This file contais mesurement every 15 min ouver a year. For my analysis, i need to choose only the measurements from 9:00 to 14:00 of each day. Created an example variable of how I have it.
TT = rand(35136,1);
TT = table(TT);
TT = table2timetable(TT,'TimeStep',calendarDuration(0,0,0,0,15,0),"StartTime",datetime(2012,1,1));
I hope your help and I thank you in advance.
0 Comments
Answers (1)
J. Alex Lee
on 7 Jun 2020
Hmm, so the question is about periodic time ranges...there might be a better way, but maybe you can use "isbetween" on an auxiliary table column that holds the "time" part of your datetime as a duration type...you can extract the "time" part by subtracting the date part of the datetime from the datetime using "dateshift":
TT.TimeOfDay = TT.Time - dateshift(TT.Time,"start","day");
mask = isbetween(TT.TimeOfDay,duration(9,0,0),duration(14,0,0))
Sorry I haven't tested this though, it should be quick to try.
0 Comments
See Also
Categories
Find more on Data Type Conversion in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!