Find Index of Table data satisfying some condition
31 ビュー (過去 30 日間)
古いコメントを表示
I have a table in which I want to do conditional formatting dependoing upon conditions certain values in different column follow.
0 件のコメント
回答 (1 件)
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 件のコメント
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!