How to convert a 8760X30matrix to a 365X30 matrix?

I have a 8760X30 matrix and I want to convert this matrix to 365X30 matrix.

Every values in the row indicates a value in hour and now by take average of every 24 values, I want to have the day matrix.

Can anybody help me with it??

Answer 1

[Stephen23]

>> inp = rand(8760,30); % fake data matrix
>> out = mean(permute(reshape(inp,24,[],30),[2,3,1]),3);

And checking:

>> size(out)
ans =
   365    30
>> isequal(mean(inp(1:24,:),1),out(1,:))
ans = 1

[Ali Nouri]

thanks

[Ali Nouri]

what if i want to take the hourly average of whole year? like the average of all those value at 12 clock. how can I do it??

[Stephen23]

>> out = mean(permute(reshape(inp,24,[],30),[1,3,2]),3);

checking:

>> size(out)
ans =
   24   30
>> isequal(mean(inp(1:24:end,:),1),out(1,:))
ans = 1

It might be clearer to use a table:

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

[Ali Nouri]

Thanks.

[Steven Lord]

Since this is time-based data, I'd recommend a timetable instead of a table as that would let you do things like retime the timetable to a daily basis with one function call.