if variable i = zero then change row j of the same row to 0 - table
    5 views (last 30 days)
  
       Show older comments
    
    Mathieu St-AMour
 on 21 May 2021
  
    
    
    
    
    Edited: David Fletcher
      
 on 21 May 2021
            So I have a 5007717 x 16 Table and I changed all negative value of column 16 to zero. But now if column 16 is zero  I want to change columne 3 of the same row to zero. 
SO I tried things like 
for i = 1:5007717
    if pvdaqdata10(i,16) == 0
       pvdaqdata10(i,3) = 0 ; 
    end
 end 
but it does'nt seem to work with table 
Error: Incorrect use of '=' operator. To assign a value to a variable, use '='. To compare values for equality, use '=='.
Operator '==' is not supported for operands of type 'table'.
So my question is, how in a table do you change the value of a cell with respect to the value of a other cell of the same row and do that for each row ?
Thanks for your help
Regards
0 Comments
Accepted Answer
  David Fletcher
      
 on 21 May 2021
        
      Edited: David Fletcher
      
 on 21 May 2021
  
      col16zero=(pvdaqdata10{:,16}==0)
pvdaqdata10{col16zero,3}=0
0 Comments
More Answers (0)
See Also
Categories
				Find more on Tables in Help Center and File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!