if variable i = zero then change row j of the same row to 0 - table
2 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 Logical 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!