Perform mathematical operation on matching values

Question

ea 2017-1-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/319206-perform-mathematical-operation-on-matching-values

编辑： Mohammad Abouali 2017-1-5

采纳的回答： Mohammad Abouali

在 MATLAB Online 中打开

I know how to extract the value of column 3 when column 2 matches a specified integer (in this case 21).

A(A(:,2)==21,3;

How do I alter this expression to not only extract the value of column 3 (when column 2 equals 21) but also perform a mathematical operation on the extracted value.

For example, I'd like to extract the value from column 3 and subtract it from 186.

Any suggestions?

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

请先登录，再进行评论。

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

Answer 1

Mohammad Abouali 2017-1-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/319206-perform-mathematical-operation-on-matching-values#answer_249499

编辑：Mohammad Abouali 2017-1-5

在 MATLAB Online 中打开

One way is this:

mask = (A(:,2)==21);
% performing the operation and storing it back in A:
% mask is used twice, so I compute it once and use it two times.
A(mask,3) = 186 - A(mask,3);
% Performing the operation but storing it in a separate variable:
% Here since mask is used once you don't need to store it in a separate variable. 
newVariable = 186 - A(mask,3);