Multiply column by a number

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

Answer 1

[the cyclist]

Here is one way:

varList = ["Var7","Var8","Var9"];
tbl{:,varList} = tbl{:,varList}*15;

[the cyclist]

@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]

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.

Answer 2

[Walter Roberson]

YourTable{:,[7 8 9]} = YourTable{:, [7 8 9]} * 15;