MATLAB: Coneptually question: How to extract certain rows if column conditions are met

beginnercell arrayslogical indexingMATLABtable

This is more of a conceptual question so I do not have an exact table I can share. So I made up a quick one.

State Residence Pets Cars

__________ ______ ______

1 California 0 1

2 California 0 1

3 Texas 1 0

4 Utah 0 0

5 Oregon 1 1

So let's say I have a table with 3 columns. And I want to extract the rows if the column conditions I seek are met. So for example, I want the rows of people who said they have only 1 pet. So the result would be

output:

State Residence Pets Cars

__________ ______ ______

3 Texas 1 0

5 Oregon 1 1

How would I go around doing that? I understand logical indexing would be used of course but I am not sure how to use it here? Which matlab functions would be useful here since I am not quite familar with cell arrays.

Thanks!

Best Answer

Let T be the table you have.

idx = T.Pets==1 ; 
T(idx,:)

Related Solutions

MATLAB: Extract vector parts around index under boolean conditions

One way:

testvector = repmat([0 0 1 0 0 0 1 1 1 1 1 1 1 1 0 0 0 1 0 0 1], 1, 3);  %replicate your demo vector so that there is more than one segment to extract
before = movsum(testvector(1:end-5), [3 0], 'Endpoints', 'discard');  %sum of 3 elements before + current element. Will be 1 if a 1 is preceded by three 0s
after = movsum(testvector(4:end), [0 5], 'Endpoints', 'discard');     %sum of 5 elements after  + current element. Will be 6 if a 1 is followed by five 1s
indices = find(before == 1 & after == 6 & testvector(4:end-5) == 1);  %construct a row vector of indices where the condition is true
segments = testvector(indices + (0:9)')   %extract all segments as column vectors

MATLAB: Make matlab differentiate until the conditions are met

If you want to keep differentiating until only one of the functions has a nonzero limit, simply use:

(limit(f,x,0)==0 || limit(g,x,0)==0)

instead of:

(limit(f,x,0)==0 & limit(g,x,0)==0)

By the way, when somebody resolves one of your questions, please select their answer as accepted. You have now asked 4 questions and left them all unresolved even though people took the time to answer for you...

Best Answer

Related Solutions

MATLAB: Extract vector parts around index under boolean conditions

MATLAB: Make matlab differentiate until the conditions are met

Related Question