Formatting more than 600 table

Question

Ahmed 2015-1-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/169392-formatting-more-than-600-table

评论： Ahmed 2015-1-21

I have more than 600 tables each one has a different data. I want To put all the data in the same table (one table). I wonder how can I do that in Matlab. Any help would be greatly appreciated. I will be grateful to you.

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

Guillaume 2015-1-9

Are your tables actual matlab tables or just plain text files?

Your naming does not appear to be very consistent. I would have expected the first table to be named either table1 or table001. How is the 10th table named? table010 or table10?

You've not answered whether or not the tables all have the same columns

Ahmed 2015-1-9

The Table is plain text files. It has the same columns. The first table named table01…..tabe10…table11….table600

请先登录，再进行评论。

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

Answer 1

Guillaume 2015-1-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/169392-formatting-more-than-600-table#answer_164417

编辑：Guillaume 2015-1-9

在 MATLAB Online 中打开

A simple code (which does not preserve completely the table header):

tabledir = 'C:\wherever\the\files\are\on your\drive';
tablecount = 600; %how however many there are
tableout = 'alltables.txt' %or however you want to name it
tables = cell(tablecount, 1);
%read tables one by one into cell array
for tableidx = 1:tablecount
   tablefile = sprintf('table%02d.txt', tableidx);
   if ~exist(fullfile(tabledir, tablefile), 'file')
      warning('skipping table %s. file does not exist', tablefile);
   else
      tables{tableidx} = readtable(fullfile(tabledir, tablefile)); %read table
   end
end
alltables = vertcat(tables{:}); %concatenate all tables
writetable(alltables, fullfile(tabledir, tableout));