Extract specific values from long list of tables contained in a .mat file

2 次查看(过去 30 天)
I have 70 tables, all with the same column headings saved in a .mat file. I would like to be able to loop through the tables to create new arrays of different variables contained in the tables. For instance, one of the column headings is latitude. I would like to be able to loop through all 70 tables, grab the latitude value from each one, and make a new 70 x 1 array with these values. Can someone help me with the best way to accomplish this? I'm attaching the a portion of the .mat file that contains the tables. Thanks!
  2 个评论
John R
John R 2020-7-8
Some of the column variables contain thousands of values, so I'm not sure that would work.
jonas
jonas 2020-7-8
编辑:jonas 2020-7-8
I'm wondering if perhaps it would be easier so work with 70 structs? or alternatively 24 tables?
edit: yes I understand, I deleted my first comment after realizing I was looking at the wrong table :) It would still work, you'd have to learn how to effeciently group data.

请先登录,再进行评论。

回答(1 个)

madhan ravi
madhan ravi 2020-7-8
V = cat(1, TableS{:}); % See how simpler if each table is stored as a cell

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by