Calculating an average week with datapoint every 15 minutes

Question

Thomas Steip 2020-12-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/697220-calculating-an-average-week-with-datapoint-every-15-minutes

回答： Rishabh Mishra 2020-12-21

I have a dataset with values every 15 minutes for 3 months and I need to compute a dataset for the average week.

This means with each data point being the average of all the data points at the same time. (For example the data point of the average week at monday 12:15 is the average of all data points at monday 12:15 during the 3 months)

Does someone know a way to do this?

Attached is the dataset over the three months and the corresponding datetime dataset.

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

请先登录，再进行评论。

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

Answer 1

Rishabh Mishra 2020-12-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/697220-calculating-an-average-week-with-datapoint-every-15-minutes#answer_580825

在 MATLAB Online 中打开

Hi,

Use the code below to find the average values recorded at 00:15 on all the Mondays in the given datetime array.

load NO2_roadside_replaced.mat; 
load t.mat; 
  
% find indices for datetimes with day = Monday & time = 00:15 
% Weekday of Monday = 2 
% Hour-value of time = 0 
% Minute-value of time = 15 
index = weekday(t) == 2 & hour(t) == 0 & minute(t) == 15; 
  
% Find average ignoring NaN values 
avg = nanmean(NO2_roadside_raw(index)); 