How to convert a time serie with daily data to a time serie with weekly data by taking the average of every 7 values of the daily vector?

2 次查看（过去 30 天）
Fernanda Suarez Jaimes
评论： Fernanda Suarez Jaimes 2020-3-12
I have a vector with daily data. I need to average every 7 values of it to obtain a new vector with weekly data.
  2 个评论
Fernanda Suarez Jaimes
Fernanda Suarez Jaimes 2020-3-10
Sure!
%Time Vector
xtime1= [1:1:6000]'; %daily
xtime2= [1:1:42000]'; %weekly
%Time Series 1- daily entries
%comand randn generats 42000 random numbers that are normaly distributed.
rng('default')
time_series1=randn(42000,1);
%generating time series with 6000 entries log-normal distributed
%the code for this distribution is based on the code available at
%mathworks.com
rng('default'); % So that numbers can be repeated
time_series2 = lognrnd(0,0.25, [6000 1]); %generating time series with mu set to zero and sigma 0.25

请先登录，再进行评论。

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

采纳的回答

Ameer Hamza
Ameer Hamza 2020-3-11
As you mentioned in your comment, you have a vector of type double. In that case, you can average 7 elements as follow:
x = rand(1000,1); % random data
x = padarray(x, [ceil(numel(x)/7)*7 - numel(x) 0], 0, 'post'); % make sure that number of elements are multiple of 7
mean_x = mean(reshape(x, 7, []), 1)';
  3 个评论
显示 1更早的评论
Ameer Hamza
Ameer Hamza 2020-3-12
Fernanda, the second x does not need to be the same, your code is correct. But you will get an error because you are giving extra spaces between function name and the input arguments. This is generally not a problem, but it will cause an error when done inside [ ] brackets. So change the third line
time_series3 = padarray (time_series1, [ceil(numel (time_series1) / 7) * 7 - numel(time_series1) 0], 0, 'post' );

请先登录，再进行评论。

更多回答（1 个）

Stephan
Stephan 2020-3-10
编辑：Stephan 2020-3-10
The usual way to do this is by using the retime function.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by