Sum loop inside a large vector

Question

Miguel L 2016-9-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/304002-sum-loop-inside-a-large-vector

编辑： Miguel L 2016-9-22

Hi everyone!

I have 5 years with hourly data from a meteorological station (24 hours x 365 days x 5 years= 43800 data in total of wind speed).

I would like to do a 24 hours summation loop during the five years, in order to get the sum of wind speed by each day.

For example, look at the next data:

1  1  0  0.17592594
1  1  1  0.07407408
1  1  2  0
1  1  3  0.16203705
1  1  4  0.07407408
1  1  5  0.25000002
1  1  6  0
1  1  7  0.14814816
1  1  8  0
1  1  9  0.07407408
1  1  10  0
1  1  11  0
1  1  12  0.14814816
1  1  13  0.68518524
1  1  14  3.43981509
1  1  15  5.06944485
1  1  16  5.42129673
1  1  17  4.82407446
1  1  18  5.23611153
1  1  19  5.24074116
1  1  20  3.74074104
1  1  21  3.8888892
1  1  22  2.76388911
1  1  23  2.78240763
1  2  0  2.39351871
1  2  1  2.29629648
1  2  2  2.02314831
1  2  3  2.00000016
1  2  4  2.70833355
1  2  5  2.53703724
1  2  6  2.43518538
1  2  7  2.16666684
1  2  8  3.55555584
1  2  9  3.77777808
1  2  10  3.46296324
1  2  11  3.11111136
1  2  12  2.98611135
1  2  13  2.68981503
1  2  14  2.43055575
1  2  15  2.12037054
1  2  16  3.36574101
1  2  17  3.15740766
1  2  18  2.22685203
1  2  19  3.37037064
1  2  20  3.6111114
1  2  21  3.18981507
1  2  22  3.31944471
1  2  23  2.51851872
1  3  0  1.98148164
1  3  1  1.26388899
1  3  2  0.57870375
1  3  3  0.6018519
1  3  4  0.95833341
1  3  5  0.69907413
1  3  6  0.86574081
1  3  7  0.77314821
1  3  8  1.21759269
1  3  9  1.52314827
1  3  10  1.78703718
1  3  11  2.17129647
1  3  12  2.25462981
1  3  13  2.27777796
1  3  14  2.37500019
1  3  15  2.13425943
1  3  16  2.12500017
1  3  17  2.13888906
1  3  18  2.2222224
1  3  19  2.06944461
1  3  20  1.96296312
1  3  21  2.21296314
1  3  22  1.29166677
1  3  23  1.98148164
1  4  0  2.42129649
1  4  1  1.46759271
1  4  2  1.24537047
1  4  3  1.60648161
1  4  4  1.43981493
1  4  5  0.47222226
1  4  6  0.28240743
1  4  7  0
1  4  8  0
1  4  9  0.27314817
1  4  10  0.79166673
1  4  11  1.34722233
1  4  12  1.07407416
1  4  13  2.75462985
1  4  14  2.93518542
1  4  15  3.07870395
1  4  16  3.07870395
1  4  17  2.81944467
1  4  18  2.49537057
1  4  19  2.61574095
1  4  20  2.99074098
1  4  21  3.10648173
1  4  22  3.04629654
1  4  23  3.3796299

In the table of above, the fourth column corresponds to the hour and the fifth corresponds to the wind speed measurement. At the end, is necessary generate the next output (daily wind speed sum).

1  1  44.19907761
1  2  67.4537091
1  3  39.46759575
1  4  44.7222258

Thanks in advance for your support!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2016-9-22

I've formatted the data as code to make it readable.

请先登录，再进行评论。

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

Answer 1

Jan 2016-9-22

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/304002-sum-loop-inside-a-large-vector#answer_235659

在 MATLAB Online 中打开

WindPerDay = sum(reshape(Data(:, 5), 24, []), 1);
Result     = cat(2, Data(:, 1:3), WindPerDay(:));

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Miguel L 2016-9-22

编辑：Miguel L 2016-9-22

I add the next script before "Result=..."

Days=unique(Data(:, 1:3),'rows');

And after I edited "Result=" as follow:

Result = cat(2, Days, WindPerDay(:));

Thanks for your support!

请先登录，再进行评论。

Answer 2

KSSV 2016-9-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/304002-sum-loop-inside-a-large-vector#answer_235630

编辑：KSSV 2016-9-22

在 MATLAB Online 中打开

k = rand(24,365,5) ;
iwant = sum(k,1) ;

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Sum loop inside a large vector

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

采纳的回答

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

更多回答（1 个）

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

产品

Community Treasure Hunt

Sum loop inside a large vector

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

采纳的回答

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

更多回答（1 个）

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

产品

Community Treasure Hunt

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

0 个评论
显示 -2更早的评论隐藏 -2更早的评论