Extract specific table columns of table variable from a .mat file

24 次查看（过去 30 天）
Malik
Malik 2022-2-16
评论： Malik 2022-2-22
Hello there, Support would be very much apprecaited with the following:
Background: I have append a large number of .mat files that contain tables. These files are very large and I would like to load only specific table columns e.g. a, d, f of the 96 columns, without opening the entire file, to reduce the memory hit. Each .mat file has the same variable 'data_unstacked', of different time periods, that I would later like to append. So,
  • I have a filename.mat file that contains a table unstacked_data
  • table data_unstacked has a number of colums with 96 variable names a, b, c and so on...
  • when I load('filename.mat'), it reveals a 1x1 struct in my workspace that on opening contains the data_unstacked 1123456x96 table
  • I would like to only load columns Timestamp, a, d, f etc. of table data_unstacked when I load the file
  • Later, once I have loaded, say, twelve of these mat files I would like to append the downselected tables, since they are part of the same timeseries.
Inside the .mat file:
Many thanks!

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

采纳的回答

Malik
Malik 2022-2-20
编辑：Malik 2022-2-20
I have found a similar request from user in the past. See:
https://uk.mathworks.com/matlabcentral/answers/344709-is-there-any-way-to-load-parts-of-a-large-table-from-a-mat-file
It seems my request, which is very similar to above, is a Matlab limitation.
Would be great if someone could confirm, or provide a workaround.
Thank you!

更多回答（1 个）

Walter Roberson
Walter Roberson 2022-2-16
编辑：Walter Roberson 2022-2-20
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2022-2-20
I guess because the table has the header information about variable types and descriptions and so on, that this is just something that is not possible at this time.

请先登录，再进行评论。

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by