MATLAB Answers

How to sum up over dates?

3 views (last 30 days)
alpedhuez
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?
  1 Comment
alpedhuez
alpedhuez on 29 Jul 2021
https://www.mathworks.com/matlabcentral/answers/406864-how-do-i-sum-over-one-dimension-of-a-multidimensional-array

Sign in to comment.

Accepted Answer

Cris LaPierre
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
Cris LaPierre on 29 Jul 2021
See my previous reply. All methods are applied to all datavars.
All your answers can be found by going through the documentation for groupsummary.

Sign in to comment.

More Answers (0)

Tags

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!