How to add variables to a table that are products of other variables

If I have a table of 46 variables and I want to add on new variables to this table which are the squares and cubes of some of these variables (columns 10 and 12-18) how can I accomplish this? I would be adding on 16 new variables (columns) in all to the original table.

Answer 1

[Walter Roberson]

cur_varnames = YourTable.Properties.VariableNames;
for K = [10, 12:18]
  thisvarname = cur_varnames{K};
  thisval = YourTable.(thisvarname);
  sq_varname = [thisvarname '_squared'];
  cu_varname = [thisvarname '_cubed'];
  YourTable.(sq_varname) = thisval .^ 2;
  YourTable.(cu_varname) = thisval .^ 3;
end

[T4H14]

That's awesome. Thank you!

Answer 2

[Andrei Bobrov]

Let T - your table.

ts = reshape(T{:,[10,12:18]}.^reshape(2:3,1,1,[]),size(T,1),[]);
newname = cellstr(reshape(string(T(:,[10,12:18]).Properties.VariableNames)'...
                                                  +'_'+["squares","cube"],1,[]));
Tout = [T,array2table(ts,'VariableNames',newname)];

[Walter Roberson]

(Note: the above code requires R2017a or later as it uses some properties of the new string data type)