Merge multiple .csv files of different dimensions into one data

Question

Curious Mind 2018-2-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/383754-merge-multiple-csv-files-of-different-dimensions-into-one-data

评论： Curious Mind 2018-2-20

Hi all: Say I have about 200 .csv files of different dimensions (e.g 6662*2 double and 6634*2 double) and I would like to merge them into one dataset. I have a code that can merge multiple .csv files of same dimensions but not of varying dimensions like one described above. Is there a code that can help me do that? Thank you.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bob Thompson 2018-2-20

在 MATLAB Online 中打开

Do they all share the same second dimension? If so you should just be able to concatenate them.

data = [];
for i=1:numberoffiles
    data = [data,csvread(file(i))];
end

You might have to finesse things a little bit to make sure the right dimensions are being joined, but that's the general idea.

请先登录，再进行评论。

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

Answer 1

Guillaume 2018-2-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/383754-merge-multiple-csv-files-of-different-dimensions-into-one-data#answer_306125

在 MATLAB Online 中打开

Assuming all the files have the same number of columns (otherwise you need to explain what to do with the files with less columns):

filepath = 'C:\somewhere';
filelist = {'file.csv', 'file2.csv', ..., 'filen.csv'};  %obtained any which way you want. Maybe with dir
filecontents = cell(numel(filelist), 1);
for fileidx = 1:numel(filelist);
   filecontents{fileidx} = csvread(fullfile(filepath, filelist{fileidx}));  %or use dlmread
end
concatenatedcontent = vertcat(filecontents{:});
csvwrite('c:\somewhere\somefile.csv', concatenatedcontent);