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

1 次查看（过去 30 天）
Mitul saraiya
Mitul saraiya 2014-12-19
评论： Mitul saraiya 2014-12-20
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

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2014-12-19
编辑：Azzi Abdelmalek 2014-12-19
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 个评论
Mitul saraiya
Mitul saraiya 2014-12-20
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

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by