How to use logical indexing on multiple criteria

Question

I have a table that has a column containing values between 1 and 20. I want to filter the table such that I can show only certain discrete values, i.e. 3, 10, 12, and 19. The problem is writing this is cumbersome, especially since I want to write other criteria for filtering too.:

i = tb.subn==3 | tb.subn==10 | tb.subn==12 | tb.subn==19

If I use i = tb.subn==[3 10 12 19] then I get a :x4 boolean matrix. How can I get that into just one column?

If it were &, I suppose I could use prod(tb.subn==[3 10 12 19],2) but I can't figure out or.

Thanks.

score 1 · Answer 1 · answered Jun 05 '17 at 22:22

1

i = all(tb.subn==[3 10 12 19], 2);

Note that this works only for very late matlab, while you solution will work better for all versions.

answered Jun 05 '17 at 22:22

Xiangrui Li

2,386
2
13
17

Thanks for helping. This works for `AND` but what about `OR`? – teepee Jun 05 '17 at 22:23
For OR, you will use any instead of all. – Xiangrui Li Jun 06 '17 at 02:45

G.J · Accepted Answer · 2017-06-05T22:57:16.097

1

You can use ismember(tb.subn, [3, 10, 12, 19])

edited Jun 05 '17 at 22:57

answered Jun 05 '17 at 22:29

G.J

795
1
6
12

That's it! Thanks for your help. I forgot about this function. – teepee Jun 05 '17 at 22:32

How to use logical indexing on multiple criteria

2 Answers2