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

2 次查看（过去 30 天）
Mathieu St-AMour
Mathieu St-AMour 2021-5-21
编辑： David Fletcher 2021-5-21
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

请先登录，再回答此问题。

采纳的回答

David Fletcher
David Fletcher 2021-5-21
编辑：David Fletcher 2021-5-21
col16zero=(pvdaqdata10{:,16}==0)
pvdaqdata10{col16zero,3}=0

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by