Daily average of 24 hours, for a year of data

Question

Tushar Agarwal 2016-9-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305075-daily-average-of-24-hours-for-a-year-of-data

回答： Steven Lord 2016-9-29

Hi,

I have a data sheet of 8760 hours, and another col of 8769 electrical values - and I wanted to cummulate every 24 hours to find the daily avg, thus leaving me with only 365 rows.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2016-9-29

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305075-daily-average-of-24-hours-for-a-year-of-data#answer_236672

在 MATLAB Online 中打开

Use the reshape function.

If I understand correctly what your data are, this should do what you want:

hrs = [1:8760]';                            % Create Column Vector
days = reshape(hrs, 365, []);

I assume the 8769 electrical values was an error, and you meant 8760. If that is correct, you can do the same with it as with the ‘hrs’ vector.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Steven Lord 2016-9-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305075-daily-average-of-24-hours-for-a-year-of-data#answer_236700

If you're using release R2016b and have your data stored in a timetable, use the retime function on your timetable. See the "Aggregate Timetable Data and Calculate Mean Values" example on the retime documentation page for more information.