Combining many variables into one table

Question

erin wootton 2022-3-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1668634-combining-many-variables-into-one-table

评论： Benjamin Thompson 2022-3-11

I have 100 variables from simulink output all stored in a huge .mat file (after being collated from seperated .mat files). I just want a specific variable from each one in a table. The examples of making a table have a few variables in that you type the names manually to create the table.

T = table (results(1, 1).Collision1.signals.values, results(2, 1).Collision1.signals.values,results(3, 1).Collision1.signals.values, results(4, 1).Collision1.signals.values

I will have 300 so this isnt an option.

How can I get the specific variable out I want :

results(1, 1).Collision1.signals.values

results(2, 1).Collision1.signals.values

results(3, 1).Collision1.signals.values

******

results(99, 1).Collision1.signals.values

results(100, 1).Collision1.signals.values

and plot them all in one table?

(figure 1, variables from .mat resullts workspace)

Many thanks

Erin

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Benjamin Thompson 2022-3-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1668634-combining-many-variables-into-one-table#answer_914814

You can use addvars in a for loop to successively add columns to a table. Note all table columns will need to have the same number of entries. I am guessing at variable names here but if you have further questions post sample data.

T = table();

for i = 1:N

T = addvars(T, results(i, 1).Collision1.signals.values,['results(' num2str(i) ', 1).Collision1.signals.values']);

end

4 个评论
显示 2更早的评论隐藏 2更早的评论

Peter Perkins 2022-3-11

This will probably work, but will create some pretty awkward variable names. I suggest something more like ['X' num2str(i)]. Also, addvars is fine, but

T.(['X' num2str(i)]) = results(i, 1).Collision1.signals.values

might be easier to read.

Benjamin Thompson 2022-3-11