importing csv file into matlab

Question

sri satya ravi 2017-1-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/319892-importing-csv-file-into-matlab

编辑： per isakson 2017-1-11

采纳的回答： Walter Roberson

matlab_upload.csv

在 MATLAB Online 中打开

Hi,

I am having error while using csv read for the following file.

num = csvread (FileName,2,0);
Error using dlmread (line 143)
Mismatch between file and format string.
Trouble reading 'Numeric' field from file (row number 1, field number 57) ==>
N,N,N,N,N,N,N,Y,N,N\n

Is there a way to read the following sheet into matlab.

Thanks...!!!!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-1-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/319892-importing-csv-file-into-matlab#answer_250156

在 MATLAB Online 中打开

csvread() is unable to read files with text, with the possible exception of header rows and maybe leading columns of text -- definitely not text at the end of lines.

If you have R2013b or later, I suggest you use

datatab = readtable('matlab_upload.csv', 'headerlines', 1);

2 个评论
显示无隐藏无

sri satya ravi 2017-1-11

编辑：per isakson 2017-1-11

在 MATLAB Online 中打开

Hi Walter; That worked for me if i am giving the file name directly into the command readtable.

I am not getting it when i ask it select the file. Didn't understand what the difference is.

[FileName,PathName] = uigetfile('C:\Users\Yashwanth\Desktop\workbased_window\*.CSV;*.mdl;*.mat','Select the CSV code file');
 datatab = readtable('FileName', 'headerlines', 1);

I get error "Unable to open file 'FileName'."

per isakson 2017-1-11

编辑：per isakson 2017-1-11

在 MATLAB Online 中打开

Replace

datatab = readtable('FileName', 'headerlines', 1);

by

datatab = readtable( FileName, 'headerlines', 1);

FileName is the name of a string variable. The value of the variable, FileName, is the name of the file.

请先登录，再进行评论。

Answer 2

halleyhit 2017-1-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/319892-importing-csv-file-into-matlab#answer_250151

I think it is because the csv file contains too many strings. csvread is to load data not string. You can use "Improt data" on your "Home" label. Also you can generate script or function in this tool.