Issue when reading csv file using textscan()

7 次查看（过去 30 天）
Ahmad Aseeri
Ahmad Aseeri 2017-4-15
回答： Image Analyst 2017-4-15
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 个评论
显示 2更早的评论
Ahmad Aseeri
Ahmad Aseeri 2017-4-15
Thank you guys for responding. The dataset is in the same directory. I used the full path and got this error:
Error using textscan
Mismatch between file and format character vector.
Trouble reading 'Numeric' field from file (row number 1, field number 1) ==> # Undirected graph: ../../data/output/lj.ungraph.txt\n
Star Strider
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
Image Analyst 2017-4-15
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by