How to get a subtable out of a large table on conditions

5 次查看（过去 30 天）
JFz
JFz 2015-7-9
评论： JFz 2015-7-9
I have a Matlab table A. I want to extract some rows from the table by certain key words and put the result into another table. The old table has 6 columns, I want to extract the first column to have value 'ATL', and the 3rd column to have value '7/7/2015'. How to do that?
tmpTbl = my_prices('ATL',:,'7/7/2015', :,:, :)
But it keeps saying error. I am totally confused here.
Thanks!

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

采纳的回答

Mohammad Abouali
Mohammad Abouali 2015-7-9
mask=strcmpi(myTable.firstColumn(:),'ATL') & ...
strcmpi(myTable.thirdColumn(:),'7/7/2015');
newTable=myTable(mask,:);
of course change the 'firstColumn', 'thirdColumn', to their appropriate name (also goes for myTable and newTable).
  2 个评论
JFz
JFz 2015-7-9
Hi, Mohammad, Thank you so much! I tested the first part: mask=strcmpi(myTable.firstColumn(:),'ATL') It works. But when I include the 2nd part, it failed. I guess I didn't type it right. Besides, I don't understand the '&...'. Is there a link in mathworks that explain it? Thanks. Jen
JFz
JFz 2015-7-9
This line: mask=strcmpi(myTable.firstColumn(:),'ATL') & ... strcmpi(myTable.thirdColumn(:),'7/7/2015');
| Error: Expression or statement is incomplete or incorrect.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by