How to calculate average of data over a given time period?

Question

benjamin giroud 2020-5-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/534573-how-to-calculate-average-of-data-over-a-given-time-period

回答： Eric Sofen 2020-6-9

I have a large data file that contains thousands of records for each hour. The first six columns are date and time and the others are measured data. I need to make an average on an hourly basis (one hour, one row). I've tried datenum but it consumes a lot of time and process. Is there any faster solution instead of mine? without datenum??

This is my solution:

Average_data=[ ];

for i3=Start_time:0.041666666627862:Stop_time %one hour step%

Average_data=[Average_data; i3 mean(Raw_data((datenum(datetime(Raw_data(:,1:6)))<i3&...

datenum(datetime(Raw_data(:,1:6)))>i3-0.041666666627862&~isnan(Raw_data(:,6+input_column))),7:end))];

end

Thanks in advance

Benjamin

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

Star Strider 2020-5-26

Explor the many capabilities of the retime function.

请先登录，再进行评论。

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

Answer 1

Eric Sofen 2020-6-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/534573-how-to-calculate-average-of-data-over-a-given-time-period#answer_448766

It would be helpful to see what your data looks like (are different time components) split into different table variables?) But as Star Strider recommended, consider using timetable and retime.