cumulative sum table over group

Question

Frederick Awuah-Gyasi 2022-5-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1723750-cumulative-sum-table-over-group

评论： Frederick Awuah-Gyasi 2022-5-23

tableA
Name Day Color Quantity 
A    1    0        3 
A    1    2        3 
A    1    3        3 
A    2    0        2
A    2    2        4 
A    2    3        5
B    1    0        3 
B    1    1        3 
B    1    3        3 
B    2    0        4 
B    2    2        1
B    2    3        0
C    1    0        2 
C    1    1        1 
C    1    2        3 
C    2    0        1
C    2    1        2
C    2    2        3

Results : Cumulative sum for each color over the days.

tableA_cumsum
Name Day Color Quantity 
A    1    0        3 
A    1    2        3 
A    1    3        3 
A    2    0        5
A    2    2        7 
A    2    3        8
B    1    0        3 
B    1    1        3 
B    1    3        3 
B    2    0       12
B    2    2        1
B    2    3        3
C    1    0        2 
C    1    1        1 
C    1    2        3 
C    2    0        4
C    2    1        3
C    2    2        6

Was trying cumsum but not sure how to get the groupings done.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Frederick Awuah-Gyasi 2022-5-20

编辑：Frederick Awuah-Gyasi 2022-5-23

check @Bruno Luong solution below (middle) . @Steven Lord and @_ yours is the 3rd one

请先登录，再进行评论。

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

Answer 1

Bruno Luong 2022-5-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1723750-cumulative-sum-table-over-group#answer_968275

编辑：Bruno Luong 2022-5-20

在 MATLAB Online 中打开

tableA = {"A"    1    0        3 ;
"A"    1    2        3 ;
"A"    1    3        3 ;
"A"    2    0        2;
"A"    2    2        4 ;
"A"    2    3        5;
"B"    1    0        3 ;
"B"    1    1        3 ;
"B"    1    3        3 ;
"B"    2    0        4 ;
"B"    2    2        1;
"C"    1    0        2 ;
"C"    1    1        1 ;
"C"    1    2        3 ;
"C"    2    0        1;
"C"    2    1        2;
"C"    2    2        3};
tableA = cell2table(tableA, "VariableNames",["Name" "Day" "Color" "Quantity"])
tableA = 17×4 table
NameDayColorQuantity____________________

    "A"      1       0         3    
    "A"      1       2         3    
    "A"      1       3         3    
    "A"      2       0         2    
    "A"      2       2         4    
    "A"      2       3         5    
    "B"      1       0         3    
    "B"      1       1         3    
    "B"      1       3         3    
    "B"      2       0         4    
    "B"      2       2         1    
    "C"      1       0         2    
    "C"      1       1         1    
    "C"      1       2         3    
    "C"      2       0         1    
    "C"      2       1         2    
[~,~,G]=unique([tableA.Name tableA.Color],"rows");
b = zeros(1,max(G));
tableA_cumsum = tableA;
for k=1:length(G)
    Gk = G(k);
    s = b(Gk) + tableA.Quantity(k);
    tableA_cumsum.Quantity(k) = s;
    b(Gk) = s;
end
tableA_cumsum
tableA_cumsum = 17×4 table
NameDayColorQuantity____________________

    "A"      1       0         3    
    "A"      1       2         3    
    "A"      1       3         3    
    "A"      2       0         5    
    "A"      2       2         7    
    "A"      2       3         8    
    "B"      1       0         3    
    "B"      1       1         3    
    "B"      1       3         3    
    "B"      2       0         7    
    "B"      2       2         1    
    "C"      1       0         2    
    "C"      1       1         1    
    "C"      1       2         3    
    "C"      2       0         3    
    "C"      2       1         3    

2 个评论
显示无隐藏无

Frederick Awuah-Gyasi 2022-5-20

Thank you @Bruno Luong. I will test this out.

Frederick Awuah-Gyasi 2022-5-23

Tested further and this solution proved rather right. Thank you @Bruno Luong

请先登录，再进行评论。

Answer 2

Steven Lord 2022-5-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1723750-cumulative-sum-table-over-group#answer_968210

Take a look at the grouptransform function.

6 个评论
显示 4更早的评论隐藏 4更早的评论

Voss 2022-5-20

在 MATLAB Online 中打开

"I wish there is a way to take it out do the groupTransform and join to have it back in place."

Try this:

Name = char('A' + randi([0 2], 18, 1));
Day = randi(2, 18, 1);
Color = randi([0 3], 18, 1);
Quantity = randi([0 5], 18, 1);
T = table(Name, Day, Color, Quantity)
T = 18×4 table
NameDayColorQuantity____________________

     C       2       0         1    
     C       2       2         2    
     C       2       3         3    
     A       1       0         3    
     C       2       0         2    
     C       2       2         0    
     A       2       1         2    
     B       2       2         1    
     C       2       1         5    
     C       1       1         0    
     B       2       2         1    
     C       1       0         4    
     A       2       3         4    
     C       1       1         2    
     A       2       1         4    
     C       1       1         0    
T(:,{'Color' 'Quantity'}) = grouptransform(T(:,{'Color' 'Quantity'}), 'Color', @cumsum)
T = 18×4 table
NameDayColorQuantity____________________

     C       2       0          1   
     C       2       2          2   
     C       2       3          3   
     A       1       0          4   
     C       2       0          6   
     C       2       2          2   
     A       2       1          2   
     B       2       2          3   
     C       2       1          7   
     C       1       1          7   
     B       2       2          4   
     C       1       0         10   
     A       2       3          7   
     C       1       1          9   
     A       2       1         13   
     C       1       1         13   