Converting multiple table variables from string to categorical data

Question

Jared 2014-3-28

2
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/123458-converting-multiple-table-variables-from-string-to-categorical-data

评论： Guillaume 2015-12-18

I've figured out how to use the categorical function to convert a single table variable (i.e., a single column of table data) to categorical data using the table.variable=categorical(table.variable) method but is there not a way to convert multiple variables/columns from string to categorical with a single command?

Thanks,

JK

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

请先登录，再进行评论。

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

Answer 1

Tim leonard 2015-2-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/123458-converting-multiple-table-variables-from-string-to-categorical-data#answer_167822

在 MATLAB Online 中打开

I'd love to know if this is possible as well. This is the best I can figure out, but still not really at all elegant.

%make table
  tblIn= table({'cat';'dog';'bird'},{'bat';'rat';'sat'},(1:3)')
%which cols to convert
  cellOfColumnNames = {'Var1','Var2'}
    tblOut = [tblIn(:,~ismember(tblIn.Properties.VariableNames,cellOfColumnNames))...
               varfun(@categorical,tblIn,'inputvariables',cellOfColumnNames)];
% or, unpacked a little bit:
    newTable = varfun(@categorical,tblIn,'inputvariables',cellOfColumnNames);
    tblOut = [tblIn(:,~ismember(tblIn.Properties.VariableNames,cellOfColumnNames))...
               newTable];

2 个评论
显示无隐藏无

Dhruv Ghulati 2015-12-18

在 MATLAB Online 中打开

This is a great answer. I tried to use the same thing for the function str2double, but I got an error

Error using table (line 253) All variables must have the same number of rows.

Error in table/varfun (line 220) b = table(b{:},'VariableNames',b_varnames);

continousVars = {'artists_paying_for', 'bookmarks','connected_ga','connected_fb',...
    'connected_itunes','free_artists','subscribed_artists','usersincompany',...
    'companyartistspaidfor','sincelastcontacted','sincelastheardfrom','sincefirstseen',...
    'sincesignedup','sincecompanylastseen','sincecompletedsetup','sinceusercreated',...
    'sinceaccountcreated','sincecompanycreated'};
newTable = varfun(@str2double,cleanNBS,'inputvariables',continousVars);
T = [cleanNBS(:,~ismember(cleanNBS.Properties.VariableNames,catVars))...
    newTable];