MATLAB: Merging multiple csv files into one mat file

csvmatMATLAB

I have multiple csv files (37 files). Every csv file has a column and it want to merge it into one mat file so that I get a mat file with 37 columns. How can I do that?

Best Answer

csvfiles = dir('*.csv') ; 
N = length(csvfiles) ; 
A = cell(N,1) ;
for i = 1:N
    A{i} = csvread(csvfiles(i).name)
end

Related Solutions

MATLAB: How to combine multiple .dat files.

Just call csvread or dlmread 5 times, then concatenate, then call csvwrite

m1 = csvread(filename1);
m2 = csvread(filename2);
m3 = csvread(filename3);
m4 = csvread(filename4);
m5 = csvread(filename5);
mOut = [m1;m2;m3;m4;m5];
csvwrite(fileNameOut, mOut);

MATLAB: Reading data from csv files

%your original code, slightly modified
csvfiles = dir('*.csv'); 
filescontent = cell(numel(csvfiles), 1);
for i = 1:numel(csvfiles)
    filescontent{i} = csvread(csvfiles(i).name);
end
%write rows of matrices into mat file
destfolder = 'C:\somewhere\somefolder';
allcontent = cat(3, filescontent{:});  %concatenate all matrices into a 3D matrix
%save rows of each matrix into a mat file (as variable rows)
for rowidx = 1:size(allcontent, 1)
    rows = permute(allcontent(rowidx, :, :), [3 2 1]);  %extract rows.Permute so each matrix is a row of rows
    save(fullfile(destfolder, sprintf('row%d.mat', rowidx)), rows);
end

Best Answer

Related Solutions

MATLAB: How to combine multiple .dat files.

MATLAB: Reading data from csv files

Related Question