Reading multiple csv files and save in a matrix

2017 10 12
1 个回答
更新时间：2017 10 13
3 次查看（30 天）

0 个投票

Hello, I have multple csv files in a folder, I want to read them and store in a matrix, further, I also check for any duplicate entry in different files and sort the data in according to year and day. I am attaching one of the csv file here.
I tried foll. code:
SL_files = dir(sprintf('%s%s%s',fullfile(dirName),'\','*.csv'));
for idx = 1:size(SL_files,1)
disp(SL_files(idx,1).name)
fid = fopen(sprintf('%s%s%s',fullfile(dirName),'\',SL_files(idx,1).name));
filedata{idx} = textscan(fid, '%f%f%f %f:%f %f %f','Headerlines',16);
fclose(fid);
end
However, I am getting empty values after column 4. Any help? Thanks!

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

Poulomi Ganguli
Poulomi Ganguli 2017-10-13
I solve the problem:
numMat_All = [];
for idx = 1:size(SL_files,1)
disp(SL_files(idx,1).name)
fid = fopen(sprintf('%s%s%s',fullfile(dirName),'\',SL_files(idx,1).name));
data = textscan(fid, '%s %f %f %f %f %f %f', ...
'Delimiter',',', 'MultipleDelimsAsOne',1,'headerlines',16);
fclose(fid);
CharCell = data{1,1};
result = regexprep(CharCell,'[\s;:]+',' ');
numMat = cell2mat(cellfun(@str2num, result(:,1:end), 'UniformOutput', false));
numMat_All = [numMat_All;numMat];
data = []; CharCell = []; result = []; numMat = [];
end
dt = datetime([numMat_All(:,1:5), repmat(0,length(numMat_All),1)]);
T = table(dt,numMat_All(:,[6:7]));
T1 = sortrows(T,'dt');

请先登录，再进行评论。

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

回答（1 个）

KSSV
KSSV 2017-10-12

0 个投票

Use either xlsread or csvread to read the files.

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

Poulomi Ganguli
Poulomi Ganguli 2017-10-12
编辑：KSSV 2017-10-12
xlsread/csvread will not work in this case since the sheet has a combination of numeric and text values. I have attached sample sheet for reference and referred foll. link earlier:
https://www.mathworks.com/matlabcentral/answers/263093-how-to-read-multiple-csv-and-store-all-the-data-into-one-sheet
KSSV
KSSV 2017-10-12
On using xlsread you can extract the numeric data, text data separately.
Poulomi Ganguli
Poulomi Ganguli 2017-10-12
It won't work since year and time are in different format. Textscan will work in this case. I am looking for some other answer/ way to solve it. Thanks!

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by