Extracting data from a table

Question

Teresa Phillips 2016-8-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/299600-extracting-data-from-a-table

评论： Toshikazu Kawagoe 2018-6-26

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!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Guillaume 2016-8-15

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/299600-extracting-data-from-a-table#answer_231764

在 MATLAB Online 中打开

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.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Peter Perkins 2018-3-28

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 2018-6-26