Change a half hourly table to hourly time table
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Fraser McMurray
am 5 Feb. 2018
Kommentiert: Steven Lord
am 6 Feb. 2018
I have a table which consists of 220 columns of half-hourly values over the course of a year. Is there a way to change the table to hourly values which are the average across two of the half hourly values.
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 5 Feb. 2018
3 Kommentare
Peter Perkins
am 6 Feb. 2018
Assuming you have R2016b or later, use table2timetable to create a timetable first, then call retime, using 'hourly'.
Pre-R2016b, you can create a new variable in your table that is your timestamps rounded down to the previous hour (use dateshift), then use varfun and group by that new variable to compute the mean of all the data variables.
Steven Lord
am 6 Feb. 2018
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!