Find Index of Table data satisfying some condition
31 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I have a table in which I want to do conditional formatting dependoing upon conditions certain values in different column follow.
0 Commenti
Risposte (1)
Deepak Gupta
il 22 Apr 2020
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 Commenti
Deepak Gupta
il 22 Apr 2020
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);
Vedere anche
Categorie
Scopri di più su Tables in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!