How to store two tables resulting from a for loop

59 次查看（过去 30 天）
Konstantinos Tsitsilonis
评论： Daisy 2022-3-25
Hi guys,
I have a for loop with two iterations, and each iteration results into a table.
I would like to know whether it is possible to store the two tables coming out of the for loop such that I do not get the table from the first iteration overwritten from the second one.
Thanks for your help in advance.

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

采纳的回答

per isakson
per isakson 2017-7-13
编辑：per isakson 2017-7-13
Yes, with something like this
for jj = 1 : 2
T = something;
filename = sprintf( 'myfile_%d', jj );
writetable( T, filename )
end
if I understand your question correctly
  1 个评论
Konstantinos Tsitsilonis
Konstantinos Tsitsilonis 2017-7-13
Yes, that essentially what I want. Is there a way to 'save' the results without actually saving a .txt file? Like the same way you would do it in a vector:
for i=1:2
y(i)=i+2
end

请先登录，再进行评论。

更多回答（3 个）

Elias Gule
Elias Gule 2017-7-13
Ok, I now understand what you want.
numIters = 3;
tables = cell(numIters,1); % A cell array to store the tables
for index = 1 : numIters
t0 = table();
tables{index} = t0;
end
Elias Gule
Elias Gule 2017-7-13
Try this.
t1 = table();
t1.Name = 'My Name';
t1.Age = 89;
data = table();
data.Name = 'Your Name';
data.Age = 15;
% Append data contained in the t1 table to the data table
data = vertcat(data,t1);
  2 个评论
Konstantinos Tsitsilonis
Konstantinos Tsitsilonis 2017-7-13
编辑：Konstantinos Tsitsilonis 2017-7-13
Thanks for your answer Elias.
This approach shows how to store results from a for loop in one table if I understand correctly.
However, my problem is that I want each iteration to store its results in separate tables. I.e. if the for loop has 3 iterations, there should be three output tables, etc.
Pappu Murthy
Pappu Murthy 2018-5-18
the statement "data = vertcat(data,t1); produced and error. Could not concatenate the table variable 'Name' using VERTCAT.
Caused by: Error using vertcat Dimensions of arrays being concatenated are not consistent.

请先登录，再进行评论。

Jose Rego Terol
Jose Rego Terol 2019-10-19
Hi!
This thread is being very useful but I cannot find the way to save my tables in a excel file.
Here is the code
for jj = 1 : length(theFiles)
Table_parameters_spike = table(T,Q_spike,I_max,AT_HW,AT_RT)
filename = sprintf( 'Spike_%d', jj );
writetable(Table_parameters_spike, filename)
end
I got 5 .txt files but my objective is to get 1 .xls file with all the tables (2x5) concatenate vertically
Thanks!

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by