How can I import multiple .CSV files in MATLAB with no sequential filename?

I need to import 175 “.csv” files where each file contains 100 measurements from 400 items (Columns and Rows respectively). I have to write a script to import the data. The .csv files are named as D059546, D067966, D077936 etc.

Please HELP!

[Stephen23]

Use the dir method shown in the documentation:

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

[Farhan K]

Thanks a lot. But before writing the script using dir method, it mentions to use function syntax to pass the name of the file to the import or export function. How to do that? Also how can I mention the file address folder?

[Stephen23]

"...it mentions to use function syntax to pass the name of the file to the import or export function. How to do that?"

The examples on that page use function syntax, so just follow those examples. If you want to know more:

https://www.mathworks.com/help/matlab/matlab_prog/command-vs-function-syntax.html

"Also how can I mention the file address folder?"

Use fullfile to create an absolute/relative filename:

https://www.mathworks.com/help/matlab/ref/fullfile.html

Answer 1

[Stephen23]

P = 'relative/absolute path to the folder where the files are saved';
S = dir(fullfile(P,'*.csv')); 
for k = 1:numel(S)
    F = fullfile(P,S(k).name);
    S(k).data = csvread(F);
end

https://www.mathworks.com/help/matlab/matlab_prog/access-multiple-elements-of-a-nonscalar-struct-array.html

[Farhan K]

Thanks a lot! But it only imported the last .csv file in the folder. The rest of the 174 files still needs to be imported. Do I need to import all the files seperately? Because I have to calculate the average of the values in each file.

[Stephen23]

"But it only imported the last .csv file in the folder."

I doubt that.

"The rest of the 174 files still needs to be imported."

All of the files have already been imported. Their data is stored in the non-scalar structure S.

"Do I need to import all the files seperately?"

No.

That is what loops are for, like the one in my answer that imports all of your files.

[Farhan K]

Thanks a lot! :D

[Sara Nasir]

How should I skip the first line when attaempting to read the file by csvread command?

I know that fopen can be used but its giving that identifier error.

[Stephen23]

"How should I skip the first line when attaempting to read the file by csvread command?"

Specify the row option: csvread(filename,1,0)

"I know that fopen can be used but its giving that identifier error."

CSVREAD does not use FOPEN.