Extracting data from a table

I have a table with multiple variables most of which are numerical. I have one variable which is categorical, I would like to be able to extract all the data relating to the specific variable.

For example my categories are REST, EXERCISE and RECOVERY. The data is split into 22 different variables (of which the phase is column 20) and I would like to create a table with only the REST data in it.

Currently, the data belongs to 'TestTable' which is a 130x22 table (the number of rows in the table will vary depending on the data set).

Any suggestions would be greatly appreciated, and as simple as possible please!

Answer 1

[Guillaume]

This is basic table filtering:

resttable = TestTable(TestTable.Phase == 'REST', :)  %select only those rows that are REST and all columns

or

resttable = TestTable(TestTable{:, 20} == 'REST', :)

I'd recommend the first syntax.

[Teresa Phillips]

Thank you! This worked a treat :)

[Image Analyst]

Teresa, please click the "Accept this answer" link to give Guillaume credit (reputation points) for it. He'd appreciate it.

[Sudeepkumar Shetty]

what if i wanted to select REST and EXERCISE? I tried resttable = TestTable(TestTable.Phase == 'REST' TestTable.Phase == 'Exercise", :)

[Peter Perkins]

You need to create a logical vector that is true for rows in those two categories. Ignore tables for a moment. How would you create a logical vector based on two conditions?

[Toshikazu Kawagoe]

I did the same thing for my table data but MATLAB said you cannot use '==' for cell data. What should I do?

Answer 2

[Pawel Ladosz]

Hi Teresa, to get the REST Column from the table the command would look something like this:

A = TestTable{:,{'REST'}}

Or

A = TestTable.REST

Let me know if any of those worked for you.

[Guillaume]

If I understood correctly, 'REST' is not a variable of the table, but one of the categories of the 'PHASE' variable.

[Pawel Ladosz]

Yes I think you are correct, I misunderstood the question.