Receiving error "Unable to open csv file". What could be causing this issue?

127 次查看（过去 30 天）

Norma 2024-9-9，12:54

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2151314-receiving-error-unable-to-open-csv-file-what-could-be-causing-this-issue

编辑： Govind KM 2024-9-9，18:30

Hello, I'm trying to convert my .csv file into a table. I'm receiving the error above. It also says "Error: readtable(filename)" when converting the .csv file to a table. I've tried changing the name of the file or editing the file path but, I'm still getting the error. What could be the cause of this error?

%Opens file explorer to select .csv file
[filename, ~] = uigetfile("*.*");
%The data variable is just an example variable name
data = readtable(filename);
%Convert the table to a times table
T = table2timetable(data);
%Display summary of data so I can start manipulating the headers
summary(T);

6 个评论
显示 4更早的评论隐藏 4更早的评论

Star Strider 2024-9-9，13:32

Use the which function to see if it is on your MATLAB search path. It may be necessary to use fullfile.

If it is, or once you have located it, use type, readlines or fileread to see what its contents are.

Stephen23 2024-9-9，17:35

Do NOT change folders just to read/write data files. This is slow and makes debugging harder.

Do NOT add folders to the MATLAB Search Path just to read/write data files. This pointlessly pollutes the search path with files, which slows down MATLAB. Similarly, do not keep your data files on the search path!

The reliable and efficient approach is to use absolute/relative filenames. FULLFILE helps with that.

请先登录，再进行评论。

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

采纳的回答

Govind KM 2024-9-9，13:31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2151314-receiving-error-unable-to-open-csv-file-what-could-be-causing-this-issue#answer_1513344

编辑：Govind KM 2024-9-9，13:41

在 MATLAB Online 中打开

Hi Norma,

This error message indicates that the selected .csv file is not in the MATLAB path and is hence not accessible by the “readtable” function. To be able to read the file, you can either

Change the present working directory to the location of the selected file through the “cd” function
Add the folder containing the selected file to your MATLAB path through the “addpath” function
Provide the full location of the file to the "readtable" function

Sample code for these approaches is as follows:

Select the required file and get its filename and location:

%Opens file explorer to select .csv file
[filename, loc] = uigetfile("*.*");

Approach 1: Change directory:

%Change current working directory to file location
cd(loc);
data = readtable(filename);

Approach 2: Add to path:

%Add folder contatining selected file to MATLAB path
addpath(loc);
data = readtable(filename);

Approach 3; Provide full path to "readtable" function:

%Provide the full location of the file
data = readtable(fullfile(loc,filename));

You can refer to the documentation to understand more about the MATLAB path:

https://www.mathworks.com/help/matlab/matlab_env/what-is-the-matlab-search-path.html

Hope this resolves the issue.

8 个评论
显示 6更早的评论隐藏 6更早的评论

Govind KM 2024-9-9，18:25

@Stephen23,

I hadn't used AI for the answer, I was just listing out the possible approaches for the goal that I knew of and had verified at my end. I agree that I should have recommended the "fullfile" approach in my answer instead of simply listing the possible solutions. Will keep this in mind.

Govind KM 2024-9-9，18:28

编辑：Govind KM 2024-9-9，18:30

@Norma,

It would be difficult to understand why the header names are not showing up without any knowledge of the data being converted to a table. If your .csv file cannot be shared, perhaps you could share a small .csv file with mock data that has the same issue?

请先登录，再进行评论。