Save data from subfolders into a cell array

Question

Johanna Popp 2022-2-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1642995-save-data-from-subfolders-into-a-cell-array

评论： Johanna Popp 2022-2-4

Hi all,

I am trying to access several matrices from my directiry and store them in a cell array.

They are stored in a way where I have 1062 subfolders in my directory that are named with the subject ID. Each of that subfolder contains 4 individual .csv files that are all named the exact same across all subjects.

What I would like to do now is go into each of the subfolder, extract one of the 4 csv.files and save it as a matrix in a cell array. Optimally, the information to which subfolder (aka subject) the matrix belongs would also be included in the cell array.

Any help would be appreciated!

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2022-2-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1642995-save-data-from-subfolders-into-a-cell-array#answer_888805

编辑：Stephen23 2022-2-4

在 MATLAB Online 中打开

P = 'absolute or relative path to where the subfolders are';
N = 'the name of the file that you want.CSV';
S = dir(fullfile(P,'*'));
S = S([S.isdir]); % remove files
S(ismember({S.name},{'.','..'})) = []; % remove dot directories
for k = 1:numel(S) % loop over the subfolders
    F = fullfile(P,S(k).name,N);
    S(k).data = readmatrix(F);
end

The imported data are simply stored in the structure S. For example the second file:

S(2).name % subject ID
S(2).data % imported file data

You can trivially loop over the structure and use indexing to process all of the file data.

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

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

Stephen23 2022-2-4

编辑：Stephen23 2022-2-4

在 MATLAB Online 中打开

"The structure is still empty..."

If you mean that

numel(S)

is zero then no subfolders exist on the path that you gave. Check the path carefully.

"I forgot to include in my question that the subject specific folder contains ANOTHER subfolder (named the same exact same for all subjects) that then contains my 4 csv files.. It would be great if you could show a way to include this in the solution, thanks!!"

You wll need to include the name of the subsubfolder inside the FULLFILE inside the loop, e.g.:

D = 'the name of the subsubfolder';
..
for k = ..
    F = fullfile(P,S(k).name,D,N);
    %                        ^
end

Look at the order I used inside FULLFILE:

the path to where the subfolders are (constant)
the subfolder name (subject ID)
the subsubfolder name (constant)
the filename (constant)

This is exactly the same as if you were writing the filepath down yourself. Have a look at the output of FULLFIlE (i.e. variable F), it should match what you would see in your explorer address bar or similar tool. You can adjust the folder/file names and order to suit your folder structure.

Stephen23 2022-2-4

在 MATLAB Online 中打开

"Is the a way to skip subjects? "

You can test if a particular folder of file exists:

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

and add an IF condition inside the loop when the file data is imported, e.g.:

if isfile(F)
    S(k).data = readmatrix(F);
end

You can do something similar for the subsubfolders too, if required.

Johanna Popp 2022-2-4

awesome, thanks!

请先登录，再进行评论。

Save data from subfolders into a cell array

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

Save data from subfolders into a cell array

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

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