Sum of elements per hour
5 views (last 30 days)
Show older comments
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 Comment
Rik
on 17 May 2017
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.
Accepted Answer
Steven Lord
on 17 May 2017
2 Comments
Steven Lord
on 6 Dec 2020
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.
More Answers (1)
Santhana Raj
on 17 May 2017
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.
0 Comments
See Also
Categories
Find more on Timetables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!