Sum of Cells next to a String

Question

tonito 2015-4-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/196020-sum-of-cells-next-to-a-string

回答： Image Analyst 2015-4-4

Hi all,

I imported an excel sheet of numbers next to a string (a category) in an array and having trouble finding a way to get the sum of all the numbers under a category. For example:

Let's say I want the sum of all the numbers to the right of 'VLGMC' and 'DLG'. Is there a way I could do this?

Thanks,

Tony

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

请先登录，再进行评论。

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

Answer 1

Mohammad Abouali 2015-4-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/196020-sum-of-cells-next-to-a-string#answer_173895

编辑：Mohammad Abouali 2015-4-4

在 MATLAB Online 中打开

% creating sample data
data={'VLGMC', 1, 'DLG', 4, 'a', 7; ...
      'VLGMC', 2,   'c', 5, 'a', 8; ...
          'b', 3, 'DLG', 6, 'a', 9};
% summing numbers next to VLGMC
mask=strcmpi(data,'VLGMC');
[row,col]=find(mask);
idx=sub2ind(size(data),row,col+1);
sum_VLGMC=sum(cell2mat(data(idx)))
sum_VLGMC =
       3
% summing numbers next to DLG
mask=strcmpi(data,'DLG');
[row,col]=find(mask);
idx=sub2ind(size(data),row,col+1);
sum_DLG=sum(cell2mat(data(idx)))
sum_DLG =
      10