Clear Filters
Clear Filters

Making loop for a function 'xlsread'

3 views (last 30 days)
Hi,
I have many files
1.csv, 2.csv, 3.csv.................................39.csv
How can I make a simple loop to convert them all together.
I simply want to obtain
data1=xlsread('1.csv');
data2=xlsread('2.csv');
data3=xlsread('3.csv');
.
.
.
.
data39=xlsread('39.csv');
I have tried to make its loop but I am getting stuck.
q = dir('Data/*.csv');
filenames = {q.name};
nfiles = length(filenames);
for i=1:nfiles
thisfile=filenames{i};
end
Kindly if someone can assist.
regards
  1 Comment
Stephen23
Stephen23 on 5 Mar 2024
Edited: Stephen23 on 5 Mar 2024
Use a DataStore:
"I simply want to obtain"
Numbering lots of variable names like that is one way that beginners force themselves into writing slow, complex, inefficient, obfuscated, buggy code that is hard to debug. Best avoided.
The MATLAB approach is to use indexing. Indexing is simple and efficient, unlike what you are trying to do.

Sign in to comment.

Accepted Answer

Dyuman Joshi
Dyuman Joshi on 5 Mar 2024
Edited: Dyuman Joshi on 5 Mar 2024
Use readmatrix instead of the deprecated xlsread().
q = dir('Data/*.csv');
nfiles = numel(filenames);
for k=1:nfiles
%file name
str = fullfile(q(k).folder, q(k).name)
%read the data
arr=readmatrix(str);
%perform necessary/required operations on the data
end
You can also preallocate a numeric array or a cell array to store the data - Preallocation
Also, since you have files named sequentially, you can read them accordingly as in the 1st example here -https://in.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html
(Note that the method you have used is also mentioned in the documentation linked)
  4 Comments
Stephen23
Stephen23 on 5 Mar 2024
"How can I import each file as seperate."
They already are: every cell of MYDATA contains a separate array imported from your files. You can trivially process those arrays using e.g. a loop and indexing. For example, the 2nd file's data: MYDATA{2}. So easy.
In contrast your approach of having lots and lots and lots of numbered variables is going to force you into writing slow, complex, inefficient code (either by doing lots of copy-and-pasting or by dynamically accessing the variable names... either way is a waste of time). Best avoided.

Sign in to comment.

More Answers (1)

Chuguang Pan
Chuguang Pan on 5 Mar 2024
Edited: Chuguang Pan on 5 Mar 2024
xlsread is not recommended, you can use readtable/readmatrix/readcell depend on what type of data you want to read.
The following code may be helpful:
q = dir('Data/*.csv');
filenames = {q.name};
Datas=cell(numel(filenames),1);
for i=1:length(filenames)
Datas{i}=readtable(filenames(i));
end
  1 Comment
Dyuman Joshi
Dyuman Joshi on 5 Mar 2024
Datas=cell(39,1);
Hard coding values is not optimal.
Use numel() or size().

Sign in to comment.

Categories

Find more on MATLAB in Help Center and File Exchange

Products


Release

R2023b

Community Treasure Hunt

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

Start Hunting!