to read multiple csv files

1 次查看（过去 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 中查找有关 Data Import and Export 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by