how to retrieve a table from a cell array?

19 次查看（过去 30 天）

MA 2021-9-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1456704-how-to-retrieve-a-table-from-a-cell-array

评论： MA 2021-9-20

In the following hierarchy structure of the cell array 'results', assuming that this is a huge set of data tables where we don't know where the table we want for a specific date is located. How can I retrive a certain table from the cell array 'results' that is shown below, using the values in the first column (data file name) of 'results' and the value of the 'Date' variable in the desired table? any idea...

for example:

the cell array results would look like this:

and when expanding a cell from the second column it would look like the image below, where these are the tables that I would like to retrive based on the 'Date' variable (8th column) inside them

and the tables are having the following formats

2 个评论
显示无隐藏无

Stephen23 2021-9-20

编辑：Stephen23 2021-9-20

Background: https://www.mathworks.com/matlabcentral/answers/1456284-how-i-can-modify-this-code-to-read-files-in-a-folder-into-tables

In general, keeping data together makes it easier to work with.

Although you have spent considerable effort splitting your data up into lots of separate tables, that rather defeats the purpose of using tables (which ultimately is to efficiently group and process data within one array). Most likely this task would be simpler if you just had one table, not hundreds of tables nested in a cell array.

MA 2021-9-20

thanks for your commnet, I agree with you, but this is for the purpose of sorting some data out and it will later on be applied to a huge number of data files. there might be a better way of implementing such thing for sure, but I am a begginer here and I am trying to learn.

请先登录，再进行评论。

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

采纳的回答

Kevin Holly 2021-9-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1456704-how-to-retrieve-a-table-from-a-cell-array#answer_791394

在 MATLAB Online 中打开

The answer is actually written on your tabs.

To view the whole table in the last screenshot, type the following:

results{1,2}{1}

8 个评论
显示 6更早的评论隐藏 6更早的评论

Kevin Holly 2021-9-20

在 MATLAB Online 中打开

Alternatively, you could try this if your Date is in datetime format within your table:

Array_of_Tables(i,:) = any(ismember(str2num(char(results{1,2}{i}.Date)),196612010520))

MA 2021-9-20

Both of them worked peerfectly as needed. Thank you for your time and your effort.

请先登录，再进行评论。

更多回答（1 个）

Sargondjani 2021-9-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1456704-how-to-retrieve-a-table-from-a-cell-array#answer_791399

NEver used table but i think this will work:

X = results{1,2}{1,1};

MyDates = X.Date;

Might even work directly:

MyDates = results{1,2}{1,1}.Date

2 个评论
显示无隐藏无

MA 2021-9-20

thank you for your reply, but the aim is to retrieve the whole table given a specific Date value, not the Date values. and assuming that this is a huge set of data where we don't know where the table we want for a specific date is located.

Sargondjani 2021-9-20