Find Index of Table data satisfying some condition

26 次查看（过去 30 天）
Nikita Agrawal
Nikita Agrawal 2020-4-22
评论： Deepak Gupta 2020-4-22
I have a table in which I want to do conditional formatting dependoing upon conditions certain values in different column follow.

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

回答（1 个）

Deepak Gupta
Deepak Gupta 2020-4-22
Hello Nikita,
You can use conditions as index of the table to do this. For example if you have a table Table1 and the condition is to find a value in table equal to 5 and then replace it with a different number;
Than,
Table1(Table1(:, :)==5) = 6;
will assign 6 to fields which were equal to 5 earlier.
Thanks,
Deepak
  4 个评论
显示 2更早的评论
Nikita Agrawal
Nikita Agrawal 2020-4-22
yes, but I want it for all the elements of the table,
T(T(2:end,2:end)<150)=0
Deepak Gupta
Deepak Gupta 2020-4-22
Then, i guess, it will be better to convert table into array.
Row1 = 200*rand(10, 1);
Row2 = 200*rand(10, 1);
Row3 = 200*rand(10, 1);
T = table(Row1, Row2, Row3);
arrayT = table2array(T);
arrayT(arrayT<150)=0;
T = array2table(arrayT);

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by