Threshold for each column of a mxn matrix

Hi, if say I have a m x n matrix and I want to set a certain threshold for column 1 and certain threshold for column 2, how can I do this please?

For example, if I have

[1 11
 2 12
 3 13
 4 14
 5 15]

and I want to set column1>2 AND at the same time column2<15, which means at the end will left

[3 13
 4 14]

how can i code this please? this is just an example as my data file is actually much bigger. Thank you very much.

Answer 1

[Image Analyst]

Try this:

m = [1 11
 2 12
 3 13
 4 14
 5 15]
rowsToKeep = m(:,1) > 2 & m(:, 2) < 15
out = m(rowsToKeep, :)

[smo]

thank you! i was making a mistake to write rowsToKeep = m(m(:,1) > 2 & m(:, 2) < 15) no wonder i didnt get it! thanks again!

[smo]

May I also ask, if i want m(:,1)>2 and m(:,1)<5, can I do this:

rowsToKeep = m(:,1) > 2 & m(:,1) <5  & m(:, 2) < 15

?

[Image Analyst]

Yes, that will work.

[smo]

but i tried and it doesnt work, it says The input character is not valid in MATLAB statements or expressions.

[Image Analyst]

I just tried it and it worked fine:

m = [1 11
 2 12
 3 13
 4 14
 5 15]
rowsToKeep = m(:,1) > 2 & m(:,1) < 5  & m(:, 2) < 15 
out = m(rowsToKeep, :)

and I see

m =
     1    11
     2    12
     3    13
     4    14
     5    15
rowsToKeep =
     0
     0
     1
     1
     0
out =
     3    13
     4    14

So, what did you do differently? Your script is not called m.m is it?

[smo]

Sorry about that! I made a very stupid mistake. and it is working now. thank you very much! have a nice weekend.