Unable to read data with .clv extension
1 次查看(过去 30 天)
显示 更早的评论
Hi,
I am trying to import multiple csv files into Matlab (.csv extension) but I am keep getting an empty structure.
Following online suggestions I used the following line of code:
d = dir('/Users/file_*.clv');
images = arrayfun(@(f) csvread(f.name), dircontent, 'UniformOutput', false);
image = cat(3, images{:});
For some reason seems like Matlab doesn't read the data. I got the following when I checked the size(image). I was expecting a 3D array instead.
ans =
0 0
Below the code I used with the .csv extension:
d = dir('/Users/file_*.csv');
images = arrayfun(@(f) csvread(f.name), dircontent, 'UniformOutput', false);
image = cat(3, images{:});
I got the following error:
>> mult_csv
Error using csvread (line 35)
File not found.
Error in mult_csv>@(f)csvread(f.name)
Error in mult_csv (line 8)
images = arrayfun(@(f) csvread(f.name), dircontent, 'UniformOutput', false);
Any ideas?
P.S. I attached an example of my csv files.
5 个评论
Guillaume
2018-7-26
For some reason, I missed that you commented there (There was a problem yesterday where the activity feed stopped updating for a few hours). I've now updated my answer.
回答(1 个)
KALYAN ACHARJYA
2018-7-26
编辑:KALYAN ACHARJYA
2018-7-30
% Please save all files name in symmetrically before doing the operation
%keep in all one folder, so you avoid the confusion with others files
% names for example f1,f2,f3...
%Save the folder of files in the current directory
path_directory='folder_name_here';
% Pls note the format of files,change it as required
original_files=dir([path_directory '/*.file_extention_format']);
for k=1:length(original_files)
filename=[path_directory '/' original_files(k).csv];
file(k)=csvread (filename);
% Next do your operation and finding
end
3 个评论
Guillaume
2018-7-26
Note that if the files are csv files, xlsread is the slowest possible way to read these files. csvread would be much faster.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!