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

1 次查看（过去 30 天）
Ali Nouri
Ali Nouri 2020-2-11
评论： Steven Lord 2020-2-14
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??

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

采纳的回答

Stephen23
Stephen23 2020-2-11
>> 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
  5 个评论
显示 3更早的评论
Steven Lord
Steven Lord 2020-2-14
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by