having a 2 months timetable with 10 minute data points, is it possible to extract first half of each day using subscripting?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Andy
el 30 de Mayo de 2018
Comentada: Peter Perkins
el 4 de Jun. de 2018
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?
0 comentarios
Respuesta aceptada
Ameer Hamza
el 30 de Mayo de 2018
Editada: Ameer Hamza
el 30 de Mayo de 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 comentarios
Ameer Hamza
el 30 de Mayo de 2018
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.
Peter Perkins
el 4 de Jun. de 2018
Nothing wrong with Ameer's answer, but you might also try out
tr = timerange(hours(8),hours(10),'closed')
TTnew = TT(tr,:)
Más respuestas (1)
Ver también
Categorías
Más información sobre Time Series Events en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!