Multiply column by a number

12 ビュー (過去 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 ExchangeMatrix Indexing についてさらに検索

タグ

製品


リリース

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by