Indices of the values for which two conditions are true

Question

Emiliya Taskova 2020-5-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524655-indices-of-the-values-for-which-two-conditions-are-true

评论： Emiliya Taskova 2020-5-11

I have a table of data where the first column is an abbreviated name (abbrev), second column is the first word of the full name (firstword) and the third is a particular number corresponding to that name. I would like to clean my data from duplicates that have the same 'abbrev' and 'firstword' and sum up the numbers for these duplicates. Some entries may have the same abbreviated name but a different first word- e.g. 'rr' and 'Roger' and 'Dodger' and vice versa, that's why I want to introduce this condition that both the first name and the first word have to match for an entry to be considered a duplicate.

Or in other words from this data:

abbrev =

{'yw' }

{'rr' }

{'yw' }

{'rr' }

firstword =

{'yellow'}

{'Roger' }

{'yellow'}

{'Dodger' }

number =

5

10

1

3

I want to get this:

abbrev =

{'yw' }

{'rr' }

firstword =

{'yellow'}

{'Roger' }

{'Dodger' }

number =

6

10

3

Thank you in advance!

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

请先登录，再进行评论。

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

Answer 1

Peng Li 2020-5-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524655-indices-of-the-values-for-which-two-conditions-are-true#answer_431795

在 MATLAB Online 中打开

tbl = table(abbrev(:), firstword(:), number(:));
[gp, outTbl] = findgroups(tbl(:, 1:2));
outTbl.sum = splitapply(@sum, tbl.(3), gp)
outTbl =
  3×3 table
     Var1        Var2       sum
    ______    __________    ___
    {'rr'}    {'Dodger'}     3 
    {'rr'}    {'Roger' }    10 
    {'yw'}    {'yellow'}     6 