Merging multiples csv files in Matlab-R2014b
4 ビュー (過去 30 日間)
古いコメントを表示
I have 50 csv files without header. Size of each file is 11320x2 with one common column in all files. I would like to merge all of these files in matlab and would like to create a matrix of size (11320x51). Any suggestion is highly appreciated. Thank you!
0 件のコメント
採用された回答
Ken Atwell
2015 年 3 月 11 日
Assuming the files are all in the same folder and you have 'cd'ed to there, trying something like:
files = dir('*.csv'); % Get list of files
out = csvread(files(1).name); % First file
for ii = 2:numel(files)
new = csvread(files{ii}.name); % Read the nth file
out = horzcat(out, new[:,2]); % Concatenate "out" with the 2nd column from new file
end
This is from memory and may not be exactly right.
5 件のコメント
Renjith V Ravi
2018 年 1 月 28 日
I am also getting the same error message "Unbalanced or unexpected parenthesis or bracket". Tried a lot to correct but couldn't.Please help me
Brendan Hamm
2018 年 2 月 9 日
In MATLAB you cannot index with [] as is done in the last line of the for loop. Change this to () and all will work fine.
files = dir('*.csv'); % Get list of files
out = csvread(files(1).name); % First file
for ii = 2:numel(files)
new = csvread(files{ii}.name); % Read the nth file
out = horzcat(out, new(:,2)); % Concatenate "out" with the 2nd column from new file
end
その他の回答 (2 件)
Brendan Hamm
2015 年 3 月 11 日
Presumably you would want to use the csvread function. If all of the files are in the same directory, then set that as your working directory. This can be accomplished with
cd [directory]
where [directory] is the full path to your directory.
You can get a list of all of the files in the directory with the dir command.
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で File Operations についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!