Average values per hour per day from a timeseries

Question

Hammad Khan 2020-2-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506368-average-values-per-hour-per-day-from-a-timeseries

回答： Mihir 2023-6-18

My table consists of 3 rows. One date, time (hour) and then precipitation value. I want to average the precipitation value for each hour for 365 days. I want to create a new table where I have the averaged precipitation values for each hour of 365 days of year averaged from 10 years. I have used ‘find’ to index the cell location of each value but is there any way I can use this in a loop wthout having to manually write the code for each value 24*365 times? Help would be very appreciated.

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

请先登录，再进行评论。

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

Answer 1

Mihir 2023-6-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506368-average-values-per-hour-per-day-from-a-timeseries#answer_1258149

Yes, you can use a loop to calculate the hourly averages for 365 days using the find function. Here's an example code that should work:

for day = 1:365

% calculate the indices of the precipitation values for the current day

for hour = 1:24

% calculate the indices of the precipitation values for the current hour of the day

% calculate the hourly average

end

You can use nested loops so that you need not write code manually for 24*365 times. We can use a loop to iterate through all 365 days of the year. For each day, we use the find function to calculate the indices of the precipitation values for this day, and then another loop to iterate through all 24 hours of the day. For each hour, we again use the find function to calculate the indices of the precipitation values for this hour, and then calculate the hourly average using the mean function.