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,[]).';

Related Solutions

MATLAB: Average of 3d matrix

  result = reshape(data,61,57,7,39);
  Data_mean = permute(nanmean(result,3), [1 2 4 3])  %permute gets rid of the singleton dimension that results

MATLAB: How to create filename with variable within loop

How about the following?

T = readtable('Stations coordinates.txt');
fileName = append('Hourly Data ',T.Station,' 2015.txt');

>> fileName

fileName =

16×1 cell array

{'Hourly Data Airport 2015.txt' }

{'Hourly Data Eptapurgio 2015.txt' }

{'Hourly Data Martiou 2015.txt' }

{'Hourly Data Lagada 2015.txt' }

{'Hourly Data Malakopi 2015.txt' }

{'Hourly Data Egnatia 2015.txt' }

{'Hourly Data Dimarxeio 2015.txt' }

{'Hourly Data Pedio Arews 2015.txt' }

{'Hourly Data Paparrigopoulou 2015.txt' }

{'Hourly Data Parko 2015.txt' }

{'Hourly Data Taratsa 2015.txt' }

{'Hourly Data Taratsa Babzelis 2015.txt'}

{'Hourly Data Taratsa Zanis 2015.txt' }

{'Hourly Data Kalamaria 2015.txt' }

{'Hourly Data Panorama 2015.txt' }

{'Hourly Data Kordelio 2015.txt' }

Best Answer

Related Solutions

MATLAB: Average of 3d matrix

MATLAB: How to create filename with variable within loop

Related Question