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

Hello everybody,

I would like to overwrite the table data if the logical index of row is true.

Logical index will be True if sampleinput.TEST_ITEM1 is'TV'

In case of True, the sampleinput.TEST_LOAD1 need to be changed with 'Yes'.

and False, the sampleinput.TEST_LOAD1 need to be changed with 'No'.

Please give me some help.

load sample1

idx = sampleinput.TEST_ITEM1 == "TV";

sampleinput.TEST_LOAD1(idx) = 'Yes';

idx = sampleinput.TEST_ITEM1 ~= "TV";

sampleinput.TEST_LOAD1(idx) = 'No';

Answer 1

[Abderrahim. B]

Hi!

Maybe this:

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

[Smithy]

Thank you very mcuh. it works really well.

[Abderrahim. B]

My pleasure!

Answer 2

[Stephen23]

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' }  

[Smithy]

Thank you very much for your answer. It is really good

[Stephen23]

@Smithy: remember that you can vote for my answer if you liked it!