How to get sum of all the order values for a given id of a column in matrix

1 visualización (últimos 30 días)
i have 2 columns and 10 rows
1 10
2 29
2 34
2 79
3 11
3 20
3 11
4 9
4 1
5 10
i want the add numbers having same value in first column The answer i want is using loop or any other operation
1 10
2 142
3 42
4 10
5 10

Respuesta aceptada

Azzi Abdelmalek
Azzi Abdelmalek el 19 de Dic. de 2014
Editada: Azzi Abdelmalek el 19 de Dic. de 2014
A=[1 10;2 29;2 34;2 79;3 11;3 20;3 11;4 9;4 1;5 10]
out=[unique(A(:,1)) accumarray(A(:,1),A(:,2))]
  1 comentario
Mitul saraiya
Mitul saraiya el 20 de Dic. de 2014
Actually i have to work on a matrix with 2 columns but more than 100 rows when i tried using accumarray it gives error as Error using horzcat Dimensions of matrices being concatenated are not consistent.
Error in mm (line 26) out=[unique(mannu(:,1)) accumarray(mannu(:,1),mannu(:,2))];
mannu is the matrix with 2 columns and 100 rows

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Creating and Concatenating Matrices en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by