How can I merge tables of csv files into one file?

I obtained data which are stored in 2000 csv files and I need to make(append) them one file. They have same headers for their columns. I attached two of the files. So, data from "log_table_1.csv" is to become the continuation of "log_table_0.csv" and so on until the 2000th one.

Answer 1

[Jake Gonzalez]

Try something like this;

 d = table();
 fileNames = dir('*.csv');
 for ii = 1:numel(fileNames)
     d0 = readtable(fileNames(ii).name);
     d = [d; d0];
 end

See if that works.

[Jake Gonzalez]

It's not the most elegant solution, as it will copy the contents of d over again everytime you need to concatenate. Thus, if you know the length of each file (seems to be 798 datapoints per file) then you should pre-allocate d in some way to try and save speed.

[Peter Perkins]

Another (faster) possibility is to read each table into a cell of a 2000x1 cell array

cellContainingTables{i} = readtable(...);

and then do this:

t = vertcat(cellContainingTables{:});