Find Index of Table data satisfying some condition

31 次查看（过去 30 天）

Nikita Agrawal 2020-4-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/519786-find-index-of-table-data-satisfying-some-condition

评论： 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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

Deepak Gupta 2020-4-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/519786-find-index-of-table-data-satisfying-some-condition#answer_427545

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更早的评论隐藏 2更早的评论

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 2020-4-22

在 MATLAB Online 中打开

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);