MATLAB: Data every second. want matrix with mean data of every minute.

Data Acquisition Toolboxextracting dataextracting every minute data from every second data

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

Best Answer

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')
Related Question