I have a time table with 10 columns and I want to apply same filter to multiple columns.

I want to select only those rows where "data in column 2,3,4,5 > 15 and <20" and "data in column 6,7,8,9 > 2000 and <2500" Any Idea on how to approach this problem? Please help!

Answer 1

[Stephan]

Hi,

this is nearly the same question as you had some weeks before:

https://de.mathworks.com/matlabcentral/answers/409678-i-have-a-table-like-this-and-i-want-to-select-only-the-rows-where-a-14-and-b-1700-how-to-give-both

however, here is an example which selects only rows which meet conditions for 2 rows. You can extend this - use the attached .mat-file which contains date-time vector and temperature-values.

load('date_time_data.mat');
A = table(date, high, low);

>> whos A
  Name          Size              Bytes  Class    Attributes

    A         55237x3             1327014  table

Now make a new table only containing negative values for the column "low":

B = A(A.low<0,:);

>> whos B
  Name         Size             Bytes  Class    Attributes

    B         5014x3             121662  table

now make a new table, where all values (high and low) are <0:

C = A(A.low<0 & A.high <0,:);

>> whos C
  Name        Size            Bytes  Class    Attributes

    C         370x3             10206  table

Best regards

Stephan