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

3 次查看（过去 30 天）
Andy
Andy 2018-5-30
评论： Peter Perkins 2018-6-4
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?

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

采纳的回答

Ameer Hamza
Ameer Hamza 2018-5-30
编辑：Ameer Hamza 2018-5-30
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 个评论
显示 3更早的评论
Ameer Hamza
Ameer Hamza 2018-5-30
Yes, The command posted in comments was just an example that timetable can use same indexing as matrices. Without watching a sample dataset, it is hard to suggest an exact solution. Please refer to updated answer.

请先登录，再进行评论。

更多回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by