If Statement Using Text in a Table

5 次查看（过去 30 天）

Jay 2019-7-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/472681-if-statement-using-text-in-a-table

评论： Walter Roberson 2019-7-23

What commands can I use in the following if statement to specify blank element overwrite?

% Run throught the table of 10 rows
for i = 1:10
    % The word "REMOVE" has been used in a previous condition subroutine to specify the row removal in this if statment
 if strcmp("REMOVE",table1(i,1)) == 1
    % Emptys rows
table1(i,:) = []
else
end
end

The subroutine is executed and the table rows are not being emptied when true

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

请先登录，再进行评论。

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

采纳的回答

madhan ravi 2019-7-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/472681-if-statement-using-text-in-a-table#answer_384112

在 MATLAB Online 中打开

I have no idea why you need a loop ( https://in.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html ):

T=table({'asdsa';'REMOVE'}); % example
idx=strcmp(T{:,1},"REMOVE");
T(idx,:) = [] % remove those rows

14 个评论
显示 12更早的评论隐藏 12更早的评论

Stephen23 2019-7-22

编辑：Stephen23 2019-7-22

在 MATLAB Online 中打开

"I get the following error ...Unrecognized row name 'REMOVE'."

Get rid of the T=... line.

Using loops like that to generate the table is very complex and inefficient. Simpler:

>> T = array2table(randn(10,3),'VariableNames',{'A','B','C'});
>> T.names = repmat({'Test 1';'Test 2';'REMOVE';'Test 4';'Test 5'},2,1)
T = 
        A           B           C         names  
    _________    ________    ________    ________
     -0.62909     -1.3981     0.88095    'Test 1'
      -1.2038    -0.25506     0.32321    'Test 2'
     -0.25394      0.1644    -0.78415    'REMOVE'
      -1.4286     0.74773     -1.8054    'Test 4'
    -0.020858    -0.27305      1.8586    'Test 5'
     -0.56066      1.5763    -0.60453    'Test 1'
       2.1778    -0.48094     0.10336    'Test 2'
       1.1385     0.32751     0.56317    'REMOVE'
      -2.4969     0.66473      0.1136    'Test 4'
      0.44133    0.085189    -0.90473    'Test 5'
>> X = strcmp(T.names,'REMOVE');
>> T(X,:) = [] % remove those rows
T = 
        A           B           C         names  
    _________    ________    ________    ________
     -0.62909     -1.3981     0.88095    'Test 1'
      -1.2038    -0.25506     0.32321    'Test 2'
      -1.4286     0.74773     -1.8054    'Test 4'
    -0.020858    -0.27305      1.8586    'Test 5'
     -0.56066      1.5763    -0.60453    'Test 1'
       2.1778    -0.48094     0.10336    'Test 2'
      -2.4969     0.66473      0.1136    'Test 4'
      0.44133    0.085189    -0.90473    'Test 5'