How to combine te same elements in table

2019 1 25
2 个回答
回答已采纳
更新时间：2019 1 25
11 次查看（30 天）

0 个投票

I have table like this:
1 1
24 1
52 1
53 4 % element 53 occurs 4 times
53 3 % the same element 53 occurs 3 times
77 1
78 1 % element 78 occurs 1 time
78 5 % the same element 78 occurs 5 times
I have to combine the same elements of first column and count the occurencies from second column - the final table should be:
1 1
24 1
52 1
53 7 %
77 1
78 6 %
Any idea - I'm beginner.
Thanx in advance

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

 采纳的回答

Walter Roberson
Walter Roberson 2019-1-25

0 个投票

[uu,~,gg]=unique(YourArray(:,1));
tt = accumarray(gg, YourArray(:,2));
output = [uu, tt];

更多回答（1 个）

madhan ravi
madhan ravi 2019-1-25

1 个投票

Requires 2018a or later:
a=[ 1 1
24 1
52 1
53 4 % element 53 occurs 4 times
53 3 % the same element 53 occurs 3 times
77 1
78 1 % element 78 occurs 1 time
78 5] % the same element 78 occurs 5 times]
T=table;
T.Group=a(:,1);
T.Times=a(:,2);
G=findgroups(T.Group);
T=groupsummary(T,'Group','sum');
T(:,[1 3])

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by