How to sum values of two cell arrays based on another array?.

Question

lucksBi 2018-1-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/376065-how-to-sum-values-of-two-cell-arrays-based-on-another-array

评论： Birdman 2018-1-8

采纳的回答： Birdman

在 MATLAB Online 中打开

Hey all

How to sum values of Add1 with all elements of Add2 based on ConditionArray.

    Add1 = {1,1,1,0.6,0.6,0.3; 1.6,1,1,1,0.6,0.6}
    Add2{1,1} = {0,0.8,-1,0.2,-0.5}
    Add2{1,2} = {0,0,0.8,1,0}
    conditionArray = {[2,3,4,5];[1,3,4,5]}

Result will be based on ConditionArray. Like As ConditionArray{1,1} contains [2,3,4,5] which means that we have to take 2nd,3rd,4th and 5th value from Add1 and add up these values with Add2{1,1}. Similarly ConditionArray{2,1} contains [1,3,4,5] which means that we have to take 1st,3rd,4th and 5th value from Add1 and add up these values with Add2{1,2}. Result may look like this:

    ResultantArray{1,1} = {1,1.8,-0.4,0.8,-0.2} % {(1+0),(1+0.8),(0.6+(-1)),(0.6+0.2),(0.3+(-0.5))}
    ResultantArray{1,2} = {1.6,1,1.8,1.6,0.6}     % {(1.6+0),(1+0),(1+0.8),(0.6+1),(0.6+0)}

Thanks in advance

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

请先登录，再进行评论。

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

Answer 1

Birdman 2018-1-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/376065-how-to-sum-values-of-two-cell-arrays-based-on-another-array#answer_299094

在 MATLAB Online 中打开

%conversion
row1Add1=cell2mat(Add1(1,:));
row2Add1=cell2mat(Add1(2,:));
%taking necessary values
row1Add1=row1Add1(cell2mat(conditionArray(1,:)));
row2Add1=row2Add1(cell2mat(conditionArray(2,:)));
%resultant array
ResultantArray{1,1}=[zeros(1,numel(cell2mat(Add2{1,1}))-numel(row1Add1)) row1Add1]+cell2mat(Add2{1,1})
ResultantArray{1,2}=[zeros(1,numel(cell2mat(Add2{1,2}))-numel(row2Add1)) row2Add1]+cell2mat(Add2{1,2})

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

lucksBi 2018-1-8

Ok but Add1 needs to be 1 index ahead to Add2 as we have to remove 1 values from Add1 based on conditionalArray. So that indexes left behind are equal in number