https://www.mathworks.com/matlabcentral/answers/406864-how-do-i-sum-over-one-dimension-of-a-multidimensional-array
How to sum up over dates?
11 views (last 30 days)
Show older comments
alpedhuez
on 29 Jul 2021
Commented: Cris LaPierre
on 29 Jul 2021
I have table with T
date location sales
--------------------
1/1 NY 100
1/2 NY 105
1/1 LA 70
1/2 LA 90
I want to sum up over dates to create T1 with
1/1 170
1/2 195
What is the next step?
Accepted Answer
Cris LaPierre
on 29 Jul 2021
Edited: Cris LaPierre
on 29 Jul 2021
Convert your dates to datetimes and use groupsummary with the groupbins input set to 'day' and your method set to 'sum', and datavars specified as your sales variable. Use the following syntax.
13 Comments
Cris LaPierre
on 29 Jul 2021
See my previous reply. All methods are applied to all datavars.
More Answers (0)
See Also
Categories
Find more on Resizing and Reshaping Matrices 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!