sum all successive values in matrix row

3 次查看（过去 30 天）
summyia qamar
summyia qamar 2018-8-13
评论： summyia qamar 2018-8-13
I have a vector A which represents 10 machines defect rate. Matrix B shows a process plan in each row in which the elements show process time of one part on corresponding machine for example; row 1 col 4 shows that this part takes 9 minutes to process on machine 4.I want to multiply each row of B with A such that every non zero element of B is multiplies by the sum of corresponding non zero elements of A. for example;
A=[0.1, 0.2, 0.2, 0.4, 0.2, 0.3, 0.1, 0.1, 0.1, 0.2]
B=[0 0 0 9 0 0 10 0 8 8;
8 0 0 0 7 9 0 0 0 10]
C=[0 0 0 (9+9*(0.4+0.1+0.1+0.2)) 0 0 (10+10*(0.1+0.1+0.2) 0 (8+8*(0.1+0.2)) 8+8*0.2;
(8+8*(0.1+0.2+0.3+0.2) 0 0 0 (7+7*(0.2+0.3+0.2) (9+9*(0.3+0.2)) 0 0 0 (10+10*(0.2))]
I tried cumsum and move sum but they are not giving the right answer.
  3 个评论
显示 1更早的评论
summyia qamar
summyia qamar 2018-8-13
A is 1x10 and B is 2x10 so each row of B is compared with A. starting from row 1, 4th element of B is non zero so it is multiplied with A 4th element of A in such a way that all the successive elements of A corresponding to non zero elements of B are added and then multiplied with B.
summyia qamar
summyia qamar 2018-8-13
non zero elements of B are 4th, 7th 9th and 10th so these elements of A are added and multiplied with 4th element of B. then for 7th element; 7 9 and 10th elements of A are added and them multiplied with 7th element of B

请先登录，再进行评论。

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

采纳的回答

Matt J
Matt J 2018-8-13
编辑：Matt J 2018-8-13
map=(B~=0);
C=cumsum(map.*A,2,'reverse').*B+B

更多回答（1 个）

Geoff Hayes
Geoff Hayes 2018-8-13
summiya - for the seventh element, you seem to have
(10+10*(0.3+0.1+0.2)
Is the 0.3 a mistake and so should be 0.1 instead?
Regardless, if we assume that B has integers only, then we can determine the indices of the non-zero elements of the first row of B with
nonZeroElementsInB = B(1,:) ~= 0;
We can then determine the sum (from A) of these non-zero elements as
sumNonZeroElementsInA = sum(A(nonZeroElementsInB));
So this will be the sum of all the elements of A corresponding to non-zero elements in the first row of B
(0.4+0.1+0.1+0.2)
You will need to adjust this sum for those elements where you don't want to include all of these values.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by