清空筛选条件
清空筛选条件

30-day running mean from hourly data

1 次查看（过去 30 天）
Poulomi Ganguli
Poulomi Ganguli 2017-8-18
回答： Nalini KS 2020-6-19
Hello, I have a hourly meteorological data as attached. The first column is year, 2nd is month, 3rd is day, 4th is hour and the last is the value. I need to calculate the 30-day running mean from the hourly data and then subtract hourly data from the running mean values. Any help?

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

采纳的回答

KL
KL 2017-8-18
编辑：KL 2017-8-18
dt = datetime([Yrly_slr(:,1:4) zeros(length(Yrly_slr),2)]);
TT = timetable(dt,Yrly_slr(:,5));
TT2 = retime(TT,'monthly','mean')
This is not a 30 day running mean but rather the monthly mean. I hope this is what you intended to do
  4 个评论
显示 2更早的评论
Poulomi Ganguli
Poulomi Ganguli 2017-8-18
First of all, the value in column 5 are hourly values, so there are 24 hours in each day, if we reshape it to 30, it won't convert into 30-d value. I don't think the suggested code is correct. I will wait for some more suggestions. Thanks
KL
KL 2017-8-18
编辑：KL 2017-8-18
Yes, that's right but still the idea is the same with reshape!
load('slr.mat')
newMat = reshape(Yrly_slr(1:24*30*12,5),24*30,12);
meanMat = repmat(mean(newMat),24*30,1);
res = newMat-meanMat;

请先登录，再进行评论。

更多回答（2 个）

Steven Lord
Steven Lord 2017-8-18
You might find the "Sample Points for Moving Average" example in the documentation for the movmean function to be of interest.
Nalini KS
Nalini KS 2020-6-19
How to do this for data having NaN values

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by