How to obtain moving average smoothing of daily time series?

10 visualizaciones (últimos 30 días)
Smith J
Smith J el 14 de Sept. de 2020
Respondida: Johannes Hougaard el 14 de Sept. de 2020
I have daily time series, how can I obtain seven day and monthly moving averaged time series.
I have tried the smooth command in matlab but it only provides the value and I also need the time.

Respuestas (1)

Johannes Hougaard
Johannes Hougaard el 14 de Sept. de 2020
I think the function you need is filter - but that requires a numeric input (for which I would use the datenum function)
timeseries = datetime(2020,01,01):datetime(2020,09,11);
dataseries = randn(size(timeseries));
N = 7; % A seven day average (could be altered to any number you'd like)
average_time = datetime(filter(ones(N,1),N,datenum(timeseries),nan(N-1,1)),'ConvertFrom',"datenum"); %the NaN assures that data are not calculated when data are insufficient
average_data = filter(ones(N,1),N,dataseries,nan(N-1,1));

Categorías

Más información sobre Time Series en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by