How to combine te same elements in table
Afficher commentaires plus anciens
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
2 commentaires
madhan ravi
le 25 Jan 2019
Which version are you using?
Andrzej Marciniak
le 25 Jan 2019
Réponse acceptée
Plus de réponses (1)
madhan ravi
le 25 Jan 2019
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])
Catégories
En savoir plus sur Tables dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!