if variable i = zero then change row j of the same row to 0 - table

1 Ansicht (letzte 30 Tage)
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

Akzeptierte Antwort

David Fletcher
David Fletcher am 21 Mai 2021
Bearbeitet: David Fletcher am 21 Mai 2021
col16zero=(pvdaqdata10{:,16}==0)
pvdaqdata10{col16zero,3}=0

Weitere Antworten (0)

Kategorien

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!

Translated by