清空筛选条件
清空筛选条件

Working with tables that are within a timetable

1 次查看（过去 30 天）
Lisbon
Lisbon 2020-1-2
评论： J. Alex Lee 2020-1-4
Hi there,
I have a 10x1 timetable. Each row in that timetable is another table with the list of positions (rows), and their properties (columns) for those dates.
I need to work with that data, for example, create another timetable with only the positions for which one of the properties is equal to X.
But I'm not able to tacke the tables.
The code I had was: D = TT.Issue{:,Column10==FIX};
Is not working, nor: D = TT.Issue.Column10=='FIX';
Can someone help please?

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

回答（1 个）

J. Alex Lee
J. Alex Lee 2020-1-3
编辑：J. Alex Lee 2020-1-3
I would first flatten the table, especially if you will be making many queries. Something like
DataCell = cell(height(TT),1);
For i=1:height(TT)
t = TT{i,"Issue"};
T.Time = repmat(TT.Time(i), height(TT),1)
DataCell{i} = t;
end
Data = vertcat(DataCell{:})
Then query as a usual table
RowMask = Data.Column10=='FIX'
NewTable = Data(RowMask,:)
The rowmask line may fail if column10 is not of type categorical
  4 个评论
显示 2更早的评论
Lisbon
Lisbon 2020-1-3
Error on RowMask = Data.Column10=='FIX':
Dot indexing is not supported for variables of this type.
J. Alex Lee
J. Alex Lee 2020-1-4
Yes, you might consider typing your columm10 as a categorical if it makes sense.
Data.Column10 = categorical(Data.Column10)

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by