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

Question

T4H14 2017-10-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/360657-how-to-add-variables-to-a-table-that-are-products-of-other-variables

评论： Walter Roberson 2017-10-11

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-10-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/360657-how-to-add-variables-to-a-table-that-are-products-of-other-variables#answer_285144

在 MATLAB Online 中打开

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

T4H14 2017-10-10

That's awesome. Thank you!

请先登录，再进行评论。

Answer 2

Andrei Bobrov 2017-10-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/360657-how-to-add-variables-to-a-table-that-are-products-of-other-variables#answer_285149

编辑：Andrei Bobrov 2017-10-10

在 MATLAB Online 中打开

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)];