您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

Matlab fail to read csv data with csvread()

22 次查看（过去 30 天）

显示更早的评论

kairui wang 2019-2-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread

评论： kairui wang 2019-2-1

JumperDataWin_Fixed.csv

在 MATLAB Online 中打开

I tried using csvread() function to read a csv file to get the data, which is in the same folder as the script.

M = csvread('JumperDataWin_Fixed.csv');

But I got these errors

Error using dlmread (line 122)
The file 'JumperDataWin_Fixed.csv' could not be opened because: Invalid argument
Error in csvread (line 48)
    m=dlmread(filename, ',', r, c);
Error in LAB1 (line 8)
M = csvread('JumperDataWin_Fixed.csv');

Could anyone explain what's wrong with my codes?

Thanks!

Updated: attach the file

11 个评论
显示 9更早的评论隐藏 9更早的评论

Geoff Hayes 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666509

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666509

kairui - is JumperDataWin_Fixed.csv a genuine CSV file or is it in some other format with a csv extension? Can you attach the file to this question?

kairui wang 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666516

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666516

Yes. Thanks for reminding.

Geoff Hayes 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666517

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666517

在 MATLAB Online 中打开

I am able to open that file using your line of code

M = csvread('JumperDataWin_Fixed.csv');

although I am using R2014a on a Mac...which version and OS are you using?

kairui wang 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666519

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666519

Mine are R2018a and Windows

Walter Roberson 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666521

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666521

在 MATLAB Online 中打开

Is it possible that there is some hidden character in the filename in your code? Try using

dinfo = dir('Ju*.csv');
filenames = {dinfo.name};

and examine filenames, and if you find one that looks right (say the third),

[fid, message] = fopen(filenames{3})

and see if that works.

If it still fails with invalid argument, try copying and pasting the content into a different file, under the theory that something is corrupted in the metadata of the file.

Question: would you just happen to be trying to read this file from OneDrive with Windows 10 Spring (2018) Update ? Or from a networked drive of some other kind?

Geoff Hayes 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666524

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666524

编辑：Geoff Hayes 2019-2-1

在 MATLAB Online 中打开

Try putting a break point at line 48 of csvread.m and then try your code again. Since the error message is saying something like "invalid argument", what are the filename, r, and c of

m=dlmread(filename, ',', r, c);

kairui wang 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666526

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666526

在 MATLAB Online 中打开

Mr. Roberson, I tried executing

dinfo = dir('JumperDataWin_Fixed.csv');
filenames = {dinfo.name};

But it seems return nothing

I don't read this file from OneDrive, it's in my computer.

BTW, I tried the same syntax in computers of my school. It worked. It seemed to be the issue of my laptop.

kairui wang 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666531

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666531

Mr. Hayes, I set the point in Line48 in csvread, when it halted there, everything is okay, but when it ran through all the codes, the errors appeared.

Geoff Hayes 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666533

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666533

在 MATLAB Online 中打开

kairui - is the file in the MATLAB Search Path? Prepend the full path to the file in your call to csvread, like

M = csvread('C:\somePath\JumperDataWin_Fixed.csv');

Walter Roberson 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666535

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666535

在 MATLAB Online 中打开

What shows up if you use

? Perhaps there is not an exact match for the file name.

kairui wang 2019-2-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666549

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/442584-matlab-fail-to-read-csv-data-with-csvread#comment_666549

I solved it. The reason is that there're some strange symbols in the the name of folder which contains the data. Matlab can't recognize the symbol so it generate a random symbol to replace it. Thank you guys!

请先登录，再进行评论。

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