merge multiple excel file data
10 次查看(过去 30 天)
显示 更早的评论
hello..
i store image data into excel file with the size of 786432x1
first file name is 1.csv second file is save as 2.csv upto 500 hundred files each file contain 786432x1 record
know a want to merge all these files in such a way that if first file end an 786432 row then second file record start at 786433 to 1572864
3rd image recored start at 1572865 and upto soo on
all 500 picture are in store in single file with one column
0 个评论
回答(1 个)
Mathieu NOE
2023-3-20
编辑:Mathieu NOE
2023-3-20
hello
try this
to make sure to get the files in the right ordre please download first this submission
(dir is not 100% reliable)
P = pwd; % get working directory (or specify it)
S = dir(fullfile(P, '*.csv'));
S = natsortfiles(S); % sort folders / file names into order
% https://fr.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort
data_all = [];
for k = 1:numel(S)
F = fullfile(S(k).folder, S(k).name);
data = readmatrix(F); % or READTABLE or csvimport or whatever.
data_all = [data_all; data(:)];
end
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!