Sum of elements per hour

6 ビュー (過去 30 日間)
pavlos
pavlos 2017 年 5 月 17 日
コメント済み: Steven Lord 2020 年 12 月 6 日
Hello,
Please help me with the following:
consider a matrix M=
[
1-Oct-13 0 2
1-Oct-13 0 6
1-Oct-13 1 2
1-Oct-13 1 6
1-Oct-13 1 6
1-Oct-13 2 2
1-Oct-13 2 0
1-Oct-13 3 2
2-Oct-13 0 1
2-Oct-13 0 1
2-Oct-13 0 3
2-Oct-13 1 4 ...
];
The first column refers to the dates. The second column refers to the hours. The third column refers to some values that are measured per hour.
Note that the matrix have multiple entries per hour and the number of data entries per hour differs.
I need to find the sum per hour of the third column.
For example, for the first day hour=1 has 3 values, hour=2 has 2 values, etc.
The final matrix should have the following form:
N=[ 1-Oct-13 0 8
1-Oct-13 1 14
1-Oct-13 2 2
1-Oct-13 3 2
...
1-Oct-13 24 ...
2-Oct-13 0 3
2-Oct-13 1 4
... ];
If N cannot contains the dates that`s ok, I need only the sums per hour.
Thank you very much.
Best,
Pavlos
  1 件のコメント
Rik
Rik 2017 年 5 月 17 日
You can use calls to unique and find to fill a loop, but I imagine there are better solutions. You could also try to use diff to find out which rows are from the same date and hour.
Just some thoughts. Good luck.

サインインしてコメントする。

採用された回答

Steven Lord
Steven Lord 2017 年 5 月 17 日
If you're stored this data in a timetable, you can use the retime function to generate hourly sums. See the "Aggregate Timetable Data and Calculate Mean Values" example on the retime documentation page and replace 'mean' with 'sum'.
  2 件のコメント
Nathaniel Parker
Nathaniel Parker 2020 年 12 月 6 日
This is not working when 'sum' is used. could you help?
Steven Lord
Steven Lord 2020 年 12 月 6 日
Please post a small sample of the code that is "not working", describe what "not working" means, and show us at least a few of the rows of the timetable on which you're operating. The head function may help wth that last part.
Does "not working" mean:
  • Do you receive warning and/or error messages? If so the full and exact text of those messages (all the text displayed in orange and/or red in the Command Window) may be useful in determining what's going on and how to avoid the warning and/or error.
  • Does it do something different than what you expected? If so, what did it do and what did you expect it to do?
  • Did MATLAB crash? If so please send the crash log file (with a description of what you were running or doing in MATLAB when the crash occured) to Technical Support using the Contact Support link on the Support section of the MathWorks website so we can investigate.

サインインしてコメントする。

その他の回答 (1 件)

Santhana Raj
Santhana Raj 2017 年 5 月 17 日
try this:
sum(M(find(M(:,1)=='1-Oct-13' & M(:,2)==1),3))
Repeat this in a for loop, and you can generate N.

カテゴリ

Help Center および File ExchangeDates and Time についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by