0 个投票

Hi,
I have a code which finds the daily average from the hourly values and stores them in a variable. I want to store this values in a matrix so I can use them elsewhere later. Please let me know.
for column = 2:width(cooling_load)
x = table2array(cooling_load(:,column));
for i = 0:364
for j=1:24
sumof =sumof + x(i*24+j+2,1);
end
avgg = sumof/24;
sumof=0;
daily(i+1)=avgg;
end
coolingload = daily'
end

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Rik
Rik 2022-3-9
There is an end statement missing. If you use the smart-allign, you should be able to see whether everything is indeed in the loop you intended.
You already have indexing into daily, so what exactly is your question?
Mohammed Rabani
Mohammed Rabani 2022-3-9
编辑：Mohammed Rabani 2022-3-9
(Edit-fixed)The end statement wasn't copied in the snippet, but my question is to store the daily values in a table or matrix to access all the values later.
Rik
Rik 2022-3-9
You already know how to index, so what is your question? You already know how to store values in an array based on the loop variable.
Mohammed Rabani
Mohammed Rabani 2022-3-9
Sorry for the confusion. Idk if this makes more sense but I want to store all the array values into one matrix(or table) instead of individual arrays so I can use them later.

请先登录，再进行评论。

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

 采纳的回答

Rik
Rik 2022-3-9

0 个投票

You're already there:
for column = 2:width(cooling_load)
x = table2array(cooling_load(:,column));
for i = 0:364
sumof=0;
for j=1:24
sumof =sumof + x(i*24+j+2,1);
end
avgg = sumof/24;
daily(i+1,column-1)=avgg;
% ^^^^^^^^
% just this simple change
end
end

更多回答（1 个）

Peter Perkins
Peter Perkins 2022-3-9

1 个投票

This will be MUCH easier using a timetable. It's a one-liner:
>> tt = timetable(rand(100,1),'RowTimes',datetime(2022,3,9,1:100,0,0))
tt =
100×1 timetable
Time Var1
____________________ ________
09-Mar-2022 01:00:00 0.697
09-Mar-2022 02:00:00 0.40754
[snip]
13-Mar-2022 03:00:00 0.089853
13-Mar-2022 04:00:00 0.16103
>> ttDaily = retime(tt,'daily','mean')
ttDaily =
5×1 timetable
Time Var1
___________ _______
09-Mar-2022 0.56102
10-Mar-2022 0.43778
11-Mar-2022 0.49814
12-Mar-2022 0.57098
13-Mar-2022 0.43989
At this point, you can get the means from that daily timetable ...
>> dailyMeans = ttDaily.Var1
dailyMeans =
0.56102
0.43778
0.49814
0.57098
0.43989
... but I doubt you need to. Just leave them there, along with their dates.

类别

在 帮助中心 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by