Outputting cumulative sum for Cell array with strings and numbers

Question

Eli Dim 2015-7-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/226349-outputting-cumulative-sum-for-cell-array-with-strings-and-numbers

评论： Eli Dim 2015-7-2

Cell1={
'A1'  5
'A2'  1
'A3'  2
'A4'  4
'A5'  1
'B1'  2
'B2'  6
'B3'  17
'B4'  8
'B5'  3
'C1'  7
'C2'  8
'D1'  1
.
.
.
};
I have a cell Cell1 which has varying row length. How can I say for example; for all As Bs Cs Ds Es etc .... count the values in column two. In the end, I would like to have an output like this 
'A'  13 
'B'  36 
'C'  15
'D'  1
etc...

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2015-7-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/226349-outputting-cumulative-sum-for-cell-array-with-strings-and-numbers#answer_184664

编辑：Andrei Bobrov 2015-7-1

在 MATLAB Online 中打开

Cell1={
'A1'  5
'A2'  1
'A3'  2
'A4'  4
'A5'  1
'B1'  2
'B2'  6
'B3'  17
'B4'  8
'B5'  3
'C1'  7
'C2'  8
'D1'  1};
S = regexp(Cell1(:,1),'^[A-Za-z]+','match');
S = [S{:}]';
[a,~,c] = unique(S);
out = [a num2cell(accumarray(c,cell2mat(Cell1(:,2))))];