Reading multiple csv file from multiple folder

29 Ansichten (letzte 30 Tage)
Nour Ahmed
Nour Ahmed am 13 Jul. 2023
Kommentiert: Nour Ahmed am 15 Jul. 2023
I have a main folder contains 6 sub folder. Each sub folder contains 15 csv file. How to read all this data together?

Akzeptierte Antwort

Stephen23
Stephen23 am 13 Jul. 2023
Bearbeitet: Stephen23 am 14 Jul. 2023
P = 'absolute or relative path to the main folder';
S = dir(fullfile(P,'*','*.csv'));
for k = 1:numel(S)
F = fullfile(S(k).folder,S(k).name);
T = readtable(F); % or READCELL or READMATRIX
% do whatever with your table/cell/matrix
% e.g. store the data from every iteration:
S(k).data = T;
end
  3 Kommentare
Stephen23
Stephen23 am 14 Jul. 2023
"I need to save the data of each subfolder together."
You can easily store the imported file data in the structure S:
P = 'absolute or relative path to the main folder';
S = dir(fullfile(P,'*','*.csv'));
for k = 1:numel(S)
F = fullfile(S(k).folder,S(k).name);
T = readtable(F); % or READCELL or READMATRIX
S(k).data = T;
end
For example, the 2nd file:
S(2).folder % path
S(2).name % filename
S(2).data % imported data
Nour Ahmed
Nour Ahmed am 15 Jul. 2023
It works with me. Thank you for your time.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Tags

Produkte


Version

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by