How to create corresponding equation in a column based on the value of previous column? (Similar to drag in Excel)

2 次查看（过去 30 天）
Wolfgang McCormack
Wolfgang McCormack 2021-5-24
编辑： Stephen23 2021-5-29
Hi all,
Imagine we have a 1000 x 3 matrix named A. I want to have a specific equation such as A(1,1) * by EquationA if the value in A(1,1) is less than 50 and A(1,1) * by EquationB if the value in A(1,1) is greater than or equal to 50. Then, drag this logic for the entire 1000 rows similar to Excel. How should I do this?

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

采纳的回答

Stephen23
Stephen23 2021-5-25
The MATLAB approach would be to use logical indexing:
https://www.mathworks.com/help/matlab/math/array-indexing.html
For example,assuming that your "equations" are actually vectorized functions:
Z = eqB(A(:,1));
X = A(:,1)<50; % logical vector
Z(X) = eqA(A(X,1))
  2 个评论
Wolfgang McCormack
Wolfgang McCormack 2021-5-28
@Stephen Cobeldick thank you. So just a quick question, does the first line multiply the entire A's members by eqB? or just the ones above 50?
Now, in the last line, Z all those mathcing X condition will be multiplied by eqA. but is the final matrix a compiled matrix of all Z mutiplied by eqB and eqA? or should I compile/join it manually?
Stephen23
Stephen23 2021-5-29
编辑：Stephen23 2021-5-29
"So just a quick question, does the first line multiply the entire A's members by eqB? or just the ones above 50?"
All of them.
"but is the final matrix a compiled matrix of all Z mutiplied by eqB and eqA? or should I compile/join it manually?"
You do not need to join anything manually, the indexing already "joins" the data:
Z(X) = eqA...
% ^ this indexing combines the eqA data into the eqB data.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by