How to sum up over dates?

3 次查看（过去 30 天）
alpedhuez
alpedhuez 2021-7-29
评论： Cris LaPierre 2021-7-29
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 个评论
alpedhuez
alpedhuez 2021-7-29
https://www.mathworks.com/matlabcentral/answers/406864-how-do-i-sum-over-one-dimension-of-a-multidimensional-array

请先登录，再进行评论。

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

采纳的回答

Cris LaPierre
Cris LaPierre 2021-7-29
编辑：Cris LaPierre 2021-7-29
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.
G = groupsummary(T,groupvars,groupbins,method,datavars)
  13 个评论
显示 11更早的评论
alpedhuez
alpedhuez 2021-7-29
What will be pseudo code?
Cris LaPierre
Cris LaPierre 2021-7-29
See my previous reply. All methods are applied to all datavars.
All your answers can be found by going through the documentation for groupsummary.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB Compiler 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by