How can I average a matrix of 105108X6 constructed every 5 minutes measured data to 15 min?

1 次查看（过去 30 天）

显示更早的评论

Gina Cabas 2017-12-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/371428-how-can-i-average-a-matrix-of-105108x6-constructed-every-5-minutes-measured-data-to-15-min

评论： KL 2017-12-6

采纳的回答： KL

在 MATLAB Online 中打开

Hello Matlab community,

I have a matrix (105108X6) of climate variables gathered every 5 minutes of one year, I wanna average this information every 15 minutes and store the info in a new matrix, how can I do that? I tried doing a loop like this:

dat_cal_15 = zeros(round(length(dat_cal)/3),1)
for i=1:round(length(dat_cal)/3)
    for a = 3*((i-1)+1)-2
        for b = 3*i
            dat_cal(i,1)= round(mean(dat_cal(a:b)));
        end
    end 
end

but is not working for all the columns....

thank you for your help

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

请先登录，再进行评论。

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

采纳的回答

KL 2017-12-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/371428-how-can-i-average-a-matrix-of-105108x6-constructed-every-5-minutes-measured-data-to-15-min#answer_294983

编辑：KL 2017-12-6

在 MATLAB Online 中打开

I's suggest using a timetable.

https://www.mathworks.com/help/matlab/timetables.html

Frist convert your matrix to timetable using array2timetable,

https://www.mathworks.com/help/matlab/ref/array2timetable.html

dat_cal_TT = array2timetable(X,'RowTimes',time_column_here)

and then use retime,

https://www.mathworks.com/help/matlab/ref/retime.html

TT_15min_mean = retime(dat_cal_TT,min_15_time_vector,'mean')

create a time vector (min_15_time_vector) with your desired sample time.

4 个评论
显示 2更早的评论隐藏 2更早的评论

Gina Cabas 2017-12-6

Thank KL for your help, I got what I needed, and then, to be able to use the new dataset and have again an array matrix with data, should I use timetable2table function?

KL 2017-12-6