Issue when reading csv file using textscan()
显示 更早的评论
I want to read dataset.csv in my program. I have the following code:
filename = 'dataset.csv';
delimiter = '\t';
formatSpec = '%f%f%[^\n\r]';
fileID = fopen(filename,'r');
dataArray = textscan(fileID, formatSpec, 'Delimiter', delimiter, 'ReturnOnError', false);
fclose(fileID);
However, I get this error:
Error using textscan
Invalid file identifier. Use fopen to generate a valid file identifier.
Can someone tell me the issue? I couldn't spot it!!
4 个评论
Nick
2017-4-15
Is the .csv file you are trying to open in your current matlab directory?
per isakson
2017-4-15
Try to use the fully qualified file name; something like
filename = 'c:\folder\of\the\file\dataset.csv';
Ahmad Aseeri
2017-4-15
Star Strider
2017-4-15
You need to look at the file in a text editor to see what it contains. Using textscan with the 'HeaderLines' name-value pair seems an attractive option.
采纳的回答
Image Analyst
2017-4-15
0 个投票
You forgot to include the csv file so we're all going to be guessing here until you do. If you want a fast answer, you should attach the csv file so we can see what's wrong with it.
If the delimiter is a tab, then it's not a csv file despite the extension of csv that you incorrectly gave it. So you can't use csvread(). I suggest you try dlmread(). If you have headerlines, dlmread() now lets you specify how many header lines to skip by specifying the proper starting row and column.
更多回答（0 个）
类别
在 帮助中心 和 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 
