Delete rows in a table where data in one column is below a value

1 visualizzazione (ultimi 30 giorni)
Hi
I have a table with four columns and multiple rows of data. I want to delet all rows where the value of teh data in the 4th columns is less than 0.1. Can anyone advise how to do this?
I tried this code to keep those rows where the data was >=0.1 but got the below message. Tis the table with all the data and Tmain is the new inteneded table without the those rows where data is <0.1 in 4th column.
T = table(T4, T1, T2, T3)
Tmain = T(T(:,4)>=0.1,:)
Operator '>=' is not supported for operands of type 'table'.
Error in working_file_2 (line 31)
Tmain = T(T(:,4)>=0.1,:)

Risposta accettata

Adam Danz
Adam Danz il 20 Gen 2021
> I want to delet all rows where the value of the data in the 4th columns is less than 0.1.
T(T{:,4}<0.1,:) = [];
  3 Commenti
Adam Danz
Adam Danz il 20 Gen 2021
Modificato: Adam Danz il 20 Gen 2021
You can't use the equal sign twice as in A=B=C.
Instead you've got two options. The second is more efficient.
1
Tmain = T;
Tmain(Tmain{:,4}<0.1,:) = [];
2
Tmain = T(T{:,4}>=0.1,:)
% ^^ Note difference

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Tables in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by