Sum the component of a matrix till a certain value

2 次查看（过去 30 天）

显示更早的评论

luca 2019-9-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/478562-sum-the-component-of-a-matrix-till-a-certain-value

评论： luca 2019-9-2

采纳的回答： madhan ravi

Hi,

given the vector matrix M= [2 4 4 5 6 16 8 9 21 3 5 8 12 34 5 6 8;

2 4 2 5 7 8 8 9 1 12 5 8 12 3 8 6 8]

I want to obtain a new matrix S with the same component but cutted at the column X when the sum repeated for each single column exceed a specific value Y.

So if in our case Y=80. the new matrix S would be

S = [2 4 4 5 6 16; 2 4 2 5 7 8 ], in this case the sum of the elements in the column reach 65. (2+2+4+4+4+2+5+5+6+7+16+8)

Adding the 7th column we obtain 81, exceeding our limit. That's why we cut at the column X=6, obtaining S.

Does someone know hot to implement this?

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

请先登录，再进行评论。

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

采纳的回答

madhan ravi 2019-9-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/478562-sum-the-component-of-a-matrix-till-a-certain-value#answer_390062

编辑：madhan ravi 2019-9-2

在 MATLAB Online 中打开

ix = cumsum(M(:))<80;
v = mod(nnz(ix),size(M,1));
[~,c] = ind2sub(size(M),nnz(ix));
Wanted = M(:,1:c-(v~=0))

4 个评论
显示 2更早的评论隐藏 2更早的评论

madhan ravi 2019-9-2

Done , see the edited answer.

luca 2019-9-2

thanks

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Matrices and Arrays Matrix Indexing

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by