Grouping the data of two variables by sum

Question

Chinmai Sai 2023-11-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2046005-grouping-the-data-of-two-variables-by-sum

回答： the cyclist 2023-11-11

I have a data with 3 columns R, Z, E. E is a function of R and Z. I would like to add the E coulmn for the same value of R and Z. For example, from the data below, I want to add all the E values for R=1 and Z= 3. Can I get some suggestion?

R Z E

1 3 0.5

3 2 0.4

4 1 0.3

1 3 0.1

1 2 0.5

3 2 0.4

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

Chinmai Sai 2023-11-11

Yes, total. In other words "sum"

Walter Roberson 2023-11-11

findgroups and then groupsummary

请先登录，再进行评论。

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

Answer 1

the cyclist 2023-11-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2046005-grouping-the-data-of-two-variables-by-sum#answer_1351095

在 MATLAB Online 中打开

R = [1; 3; 4; 1; 1; 3];
Z = [3; 2; 1; 3; 2; 2];
E = [0.5; 0.4; 0.3; 0.1; 0.5; 0.4];
tbl = table(R,Z,E)
tbl = 6×3 table
    R    Z     E 
    _    _    ___

    1    3    0.5
    3    2    0.4
    4    1    0.3
    1    3    0.1
    1    2    0.5
    3    2    0.4
groupsummary(tbl,["R","Z"],"sum","E")
ans = 4×4 table
    R    Z    GroupCount    sum_E
    _    _    __________    _____

    1    2        1          0.5 
    1    3        2          0.6 
    3    2        2          0.8 
    4    1        1          0.3 