Overwrite table data with 'Yes' or 'No' according to the logical index

load sample1.mat
sampleinputarr = string(sampleinput.Variables) ;
tvIdx = sampleinputarr(:,1) == "TV" ;
sampleinputarr(tvIdx, 2) = "Yes" ;
sampleinputarr(~tvIdx, 2) = "No" ;
newTbl = array2table(sampleinputarr, "VariableNames", sampleinput.Properties.VariableNames )
newTbl = 11×2 table
    TEST_ITEM1    TEST_LOAD1
    __________    __________

       "TV"         "Yes"   
       "TV"         "Yes"   
       "TV"         "Yes"   
       "TT"         "No"    
       "TV"         "Yes"   
       "TV"         "Yes"   
       "TV"         "Yes"   
       "TV"         "Yes"   
       "TL"         "No"    
       "TL"         "No"    
       "TL"         "No"    

Hope this helps

2 个评论
显示无隐藏无

Smithy 2022-9-1

Thank you very mcuh. it works really well.

Abderrahim. B 2022-9-1

My pleasure!

请先登录，再进行评论。

Answer 2

Stephen23 2022-9-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1792285-overwrite-table-data-with-yes-or-no-according-to-the-logical-index#answer_1039380

编辑：Stephen23 2022-9-1

在 MATLAB Online 中打开

sample1.mat

Simpler:

S = load('sample1.mat');
T = S.sampleinput
T = 11×2 table
    TEST_ITEM1    TEST_LOAD1
    __________    __________

      {'TV'}       {'NaN'}  
      {'TV'}       {'NaN'}  
      {'TV'}       {'NaN'}  
      {'TT'}       {'NaN'}  
      {'TV'}       {'NaN'}  
      {'TV'}       {'NaN'}  
      {'TV'}       {'NaN'}  
      {'TV'}       {'NaN'}  
      {'TL'}       {'NaN'}  
      {'TL'}       {'NaN'}  
      {'TL'}       {'NaN'}  
X = strcmpi(T.TEST_ITEM1,'TV');
T.TEST_LOAD1(:) = {'No'};
T.TEST_LOAD1(X) = {'Yes'}
T = 11×2 table
    TEST_ITEM1    TEST_LOAD1
    __________    __________

      {'TV'}       {'Yes'}  
      {'TV'}       {'Yes'}  
      {'TV'}       {'Yes'}  
      {'TT'}       {'No' }  
      {'TV'}       {'Yes'}  
      {'TV'}       {'Yes'}  
      {'TV'}       {'Yes'}  
      {'TV'}       {'Yes'}  
      {'TL'}       {'No' }  
      {'TL'}       {'No' }  
      {'TL'}       {'No' }  