convert string into number in table

Question

Tomasz Kaczmarski 2020-3-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509639-convert-string-into-number-in-table

回答： Star Strider 2020-3-7

采纳的回答： Star Strider

TargetSet.mat

在 MATLAB Online 中打开

Hi

attached file is a table with

'STANDING','SITTING','LAYING','WALKING','WALKING_DOWNSTAIRS','WALKING_UPSTAIRS'

could you please help how to convert them into numers

i tired

targetSet1 = table2array(TargetSet)
z = cellfun(@(x){x(1),x(2),x(3:end)},targetSet1,'un',0);
TargetSet = str2double([z{:}]);

but its converting all into Nan plus output is in columns not rows

i need output as single column in double format where the values are numeric only

Thank you in advance

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2020-3-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509639-convert-string-into-number-in-table#answer_419056

在 MATLAB Online 中打开

I am not certain what you intend by ‘numbers’, so guessing:

D = load('TargetSet.mat');
TargetSet = D.TargetSet;
ActivityCode = table(findgroups(TargetSet.Activity), 'VariableNames',{'ActivityCode'});
TargetSet = [TargetSet, ActivityCode];
First15Rows = TargetSet(1:15,:)

producing:

First15Rows =
     Activity      ActivityCode
    ___________    ____________
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'SITTING'}         2      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1      
    {'LAYING' }         1 