data every second. want matrix with mean data of every minute.

Question

torres 2018-6-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/404584-data-every-second-want-matrix-with-mean-data-of-every-minute

评论： torres 2018-6-9

I have a matrix of 7 colums. aaaa mm dd hh mm ss , the last column is a value. I have a data every second, and I need to extract one value every minute. This value has to be the mean of every data in this minute. Result must be rows:aaaa mm dd HH MM value.

Thank you very much in advance

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

jonas 2018-6-7

have a look here ( link )

请先登录，再进行评论。

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

Answer 1

sloppydisk 2018-6-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/404584-data-every-second-want-matrix-with-mean-data-of-every-minute#answer_323704

在 MATLAB Online 中打开

Use retime and datetime:

a = ones(100, 7);
a(:, 7) = randi(15, 100, 1);
mins = repmat(1:10, 10, 1); a(:, 5) = mins(:);
b = datetime(a(:, 1),a(:, 2),a(:, 3),a(:, 4),a(:, 5),a(:, 6));
value = a(:, 7);
TT1 = timetable(b,value);
newTimes = b(1, :):minutes(1): b(end, :);
TT2 = retime(TT1,newTimes,'mean')