having a 2 months timetable with 10 minute data points, is it possible to extract first half of each day using subscripting?

1 view (last 30 days)
having a timetable, one can do sub-scripting once on the hole interval. can one take a sub-script of the daily data of such a timetable, and save it in another timetable?

Accepted Answer

Ameer Hamza
Ameer Hamza on 30 May 2018
Edited: Ameer Hamza on 30 May 2018
Yes, you can use subscript in MATLAB timetable class, similar to subscript in a MATRIX. For example to get the first half of the timetable you can use subscript like this
TT(1:end/2, :)
The exact detail of which subscript to use depends on the values you want to extract.
Edit: the updated answer according to your dataset is
TT_hours = hour(TT.Time);
index = d_hours <= 10 & d_hours >= 8;
TT_new = TT(index,:)
This will extract rows in which the hour is between 8 and 10.
  5 Comments
Peter Perkins
Peter Perkins on 4 Jun 2018
Nothing wrong with Ameer's answer, but you might also try out
tr = timerange(hours(8),hours(10),'closed')
TTnew = TT(tr,:)

Sign in to comment.

More Answers (1)

Andy
Andy on 30 May 2018
that's the Pandas equivalent:
https://stackoverflow.com/questions/19179214/selecting-data-between-specific-hours-in-a-pandas-dataframe

Categories

Find more on Timetables in Help Center and File Exchange

Products


Release

R2018a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!