Change a half hourly table to hourly time table

2 次查看（过去 30 天）

Fraser McMurray 2018-2-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/380916-change-a-half-hourly-table-to-hourly-time-table

评论： Steven Lord 2018-2-6

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2018-2-5

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/380916-change-a-half-hourly-table-to-hourly-time-table#answer_303587

The easiest way is to use a timetable object and the retime() function.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Peter Perkins 2018-2-6

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 2018-2-6

The retime function is defined for timetable arrays. It is not defined for table arrays. A timetable is required to contain some date and/or time information by the way it is constructed, while a table is not.

请先登录，再进行评论。