to read multiple csv files

3 次查看（过去 30 天）
sarfudeen
sarfudeen 2014-10-15
回答： Ken Atwell 2014-10-15
I used the following code for reading the multiple csv files but for the execution it takes too much of time.
My code is as follows:
[files,path] = uigetfile('*.csv', 'MultiSelect','on');
FileName = fullfile(path,file);
fmt = '%s%s%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%';
num = length(FileName);
data = cell(1,num);
for i = 1 : num
fid = fopen(FileName{i},'r');
data(i) = textscan(fid,fmt,'Delimiter',',',CollectOutput',1);
end
Hence sort out this and help me in this bug at the earliest...
Regards, M. Sarfudeen

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

回答（1 个）

Ken Atwell
Ken Atwell 2014-10-15
How many files are we talking about, and how big is each file?
If you have R2014b, you may want to check out the new datastore capability as a more elegant approach to what you're doing. It may not help with your performance issue, though.
PS: Don't forget to fclose your files, especially if you have lots of them.

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by