How to add values in matrix if in a conditions is met?

Question

Danny Helwegen 2020-12-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/687103-how-to-add-values-in-matrix-if-in-a-conditions-is-met

编辑： dpb 2020-12-8

Hey everybody,

I'm processing some data and i'm stuck at the moment. I have a matrix consisting of 2 columns and about 4000 rows. A simplified example is given below:

data =  0       1.5
        0.2     0.3
        0.4     4 
        0.6     0.2 
        0.8     0.9 
        1       1.5
        0       2
        0.2     1.2
        0.4     0.8
        0.6     2.3
        0.8     4.5
        1       1.3

And what I need is that when values in column 1 are the same, then values of the second column are added to get one answer for one value in column 1. For the data above this would give:

For 0: 1.5 + 2 = 3.5

0.2: 0.3 + 1.2 = 1.5

0.4: 4 + 0.8 = 4.8

etc.

Could anyone help me with how to do this? Cause at the moment, I really don't know how. I tried a if loop but it didn't work.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

dpb 2020-12-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/687103-how-to-add-values-in-matrix-if-in-a-conditions-is-met#answer_569083

编辑：dpb 2020-12-8

在 MATLAB Online 中打开

 >> accumarray(findgroups(data(:,1)),data(:,2))
ans =
    3.5000
    1.5000
    4.8000
    2.5000
    5.4000
    2.8000
>> 

or, more completely

>> [ig,g]=findgroups(data(:,1));
>> [g accumarray(ig,data(:,2))]
ans =
         0    3.5000
    0.2000    1.5000
    0.4000    4.8000
    0.6000    2.5000
    0.8000    5.4000
    1.0000    2.8000
>> 

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Zezheng Wu 2020-12-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/687103-how-to-add-values-in-matrix-if-in-a-conditions-is-met#answer_569078

在 MATLAB Online 中打开

splitapply(@(x) [x(1, 1), sum(x(:, 2))], data, findgroups(data(:, 1)));

2 个评论
显示无隐藏无

Danny Helwegen 2020-12-8

Thanks for the reply, if I run this I get als negative values whilst I don't have them in my data set. Any idea how I can solve that?

Zezheng Wu 2020-12-8

在 MATLAB Online 中打开

This piece of code works just fine with your example data:

data =  [0       1.5;
2     0.3;
4     4 ;
6     0.2;
8     0.9 ;
     1.5;
     2;
2     1.2;
4     0.8;
6     2.3;
8     4.5;
     1.3];
splitapply(@(x) [x(1, 1), sum(x(:, 2))], data, findgroups(data(:, 1)))
ans =
         0    3.5000
2000    1.5000
4000    4.8000
6000    2.5000
8000    5.4000
0000    2.8000
    