30-day running mean from hourly data
4 views (last 30 days)
Show older comments
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?
0 Comments
Accepted Answer
KL
on 18 Aug 2017
Edited: KL
on 18 Aug 2017
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
More Answers (2)
Steven Lord
on 18 Aug 2017
You might find the "Sample Points for Moving Average" example in the documentation for the movmean function to be of interest.
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!