MATLAB: How to take an average every four columns

averaging rows

Hi, I have seen similar questions but I am getting stuck altering the code for what I want. I have a matrix of (64 x 18144), each row is a met station and each column is a 15 minute data measurement – I want to convert this to hourly data for each station – so I want to have an output matrix of (64 x 4536). I have seen some solutions but I don't have the 'tools' they require. Any help/ideas would be very much appreciated! 🙂

Best Answer

  • x = your 64x1844 matrix
    result = reshape(mean(reshape(x.',4,[])),size(x,2)/4,[]).';