How to combine te same elements in table
Mostrar comentarios más antiguos
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 comentarios
madhan ravi
el 25 de En. de 2019
Which version are you using?
Andrzej Marciniak
el 25 de En. de 2019
Respuesta aceptada
Más respuestas (1)
madhan ravi
el 25 de En. de 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])
Categorías
Más información sobre Tables en Centro de ayuda y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!