How can I divide a week of a timetable into hours

2 次查看（过去 30 天）

显示更早的评论

Antonio Melieni 2019-5-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462237-how-can-i-divide-a-week-of-a-timetable-into-hours

评论： Peter Perkins 2019-5-20

采纳的回答： Guillaume

Hi,

is it possible to devide a week of a timetable into 168 hours?

I would need the means of a timetable from monday to sunday on an hourly basis so I can show how its behaving of the week

Thx :)

2 个评论
显示无隐藏无

Andrei Bobrov 2019-5-15

Please attach your timetable as mat-file.

Antonio Melieni 2019-5-15

Volatility.mat.zip

So what I need is the mean over each of the 168 hours of the week from these data

请先登录，再进行评论。

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

采纳的回答

Guillaume 2019-5-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462237-how-can-i-divide-a-week-of-a-timetable-into-hours#answer_375117

在 MATLAB Online 中打开

hourlytimetable = retime(yourtimetable, 'hourly', 'mean')

9 个评论
显示 7更早的评论隐藏 7更早的评论

Guillaume 2019-5-16

在 MATLAB Online 中打开

Peter, a suggestion: an option to specify bin indices instead of bin intervals for groupsummary at least. That would avoid having to create the binning variable:

hourofweek = ...
groupsummary(Volatility, 'BinNumbers', hourofweek, 'mean')

Peter Perkins 2019-5-20

Yes, this would be useful in many contexts. Thanks.

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Data Type Conversion

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

Community Treasure Hunt

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

Start Hunting!

Translated by