Multiply column by a number

10 次查看（过去 30 天）
Dung Tran
Dung Tran 2023-5-23
评论： Walter Roberson 2023-5-23
hi , I have a table above, I want to scale up Column 7,8,9 ( Var 7, Var8, Var9) by multiply to 15
somebody please help me to make it. Thank you very much

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

回答（2 个）

the cyclist
the cyclist 2023-5-23
Here is one way:
varList = ["Var7","Var8","Var9"];
tbl{:,varList} = tbl{:,varList}*15;
  2 个评论
the cyclist
the cyclist 2023-5-23
@Dung Tran, note that @Walter Roberson's and my solutions are largely equivalent; he indexes into the table using the column numbers, and I index into the table using the variable names. It's good to understand both ways.
Walter Roberson
Walter Roberson 2023-5-23
Using the column numbers should be slightly faster -- but if the columns got moved around, then the mapping of which column you wanted to column number could fail, so using the variable names from the columns is more robust when the names are available.

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2023-5-23
YourTable{:,[7 8 9]} = YourTable{:, [7 8 9]} * 15;

类别

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

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by