Tall table from multiple tables in different .MAT files

3 次查看(过去 30 天)
I have a ton of separate .mat files, each containing a single table. They have the same variables, and same format for each variable. Combined, they do not fit into memory.
Is there a way to create a datastore or a tall table from these? Tried using datastore but, surprisingly, there doesn't seem to be an option for this.
I realize one option would be to loop through these, "convert" them to CSV, and make a datastore from this. This is my backup plan.
Thanks

回答(2 个)

Krishna Bindumadhavan
编辑:Walter Roberson 2017-10-17
The procedure that you have mentioned in the question (converting the files to .csv and then making a datastore) should work. Alternatively, you can also use a FileDatastore (used for custom file formats) as outlined in the documentation here :
The example provided in the documentation shows how you can use FileDatastore with .mat files.
Hope this helps!

Anandan Rangasamy
Anandan Rangasamy 2017-10-17
I would suggest you to set UniformRead to true when creating FileDatastore to get a tall table. Here is an example.

类别

Help CenterFile Exchange 中查找有关 Large Files and Big Data 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by