How do I load only part of a table saved to a .mat file?

6 views (last 30 days)
Kyle Padilla
Kyle Padilla on 23 Mar 2022
Answered: Kyle Padilla on 30 Mar 2022
I have some large tables stored in .mat files and was wondering if there is a way I could load only some of the data into MATLAB (for example, a subset of rows or columns in a table). I read about the matfile function, but it doesn't seem to work with tables. Whenever I try to load part of a table, I get an error telling me to load the whole table. Is there some way to load partial data that works for tables?

Accepted Answer

Kyle Padilla
Kyle Padilla on 30 Mar 2022
I found out you can make your table a tall table, which provides a way to work with large amounts of data. You use the tall function and pass in your table. You can write your table to a folder of .mat files using the write function. You then create a datastore and convert it to a tall table. Finally, you can get a subset of the tall table and use the gather function to get the results.

More Answers (2)

Walter Roberson
Walter Roberson on 23 Mar 2022
No, there is no method provided for that.

Peter Perkins
Peter Perkins on 24 Mar 2022
You might look into using datastores, which would, in effect, allow you to load pieces.
  3 Comments
Kyle Padilla
Kyle Padilla on 30 Mar 2022
That might work yeah. I think I figured it how I can do this with .mat files though. Gonna post an answer to my question so others can use it for future reference.

Sign in to comment.

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by