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

2 vues (au cours des 30 derniers jours)
Mathieu St-AMour
Mathieu St-AMour le 21 Mai 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

Réponse acceptée

David Fletcher
David Fletcher le 21 Mai 2021
Modifié(e) : David Fletcher le 21 Mai 2021
col16zero=(pvdaqdata10{:,16}==0)
pvdaqdata10{col16zero,3}=0

Plus de réponses (0)

Catégories

En savoir plus sur Logical dans Help Center et File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by