Collect data from directories

Question

civil tech 2023-4-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1951168-collect-data-from-directories

评论： Image Analyst 2023-4-22

I have a series of folders (for example, 50 folders), each with its unique name (completely different names). I want to extract a set of information from each of these folders (from an Excel file). The final output should be an Excel file, that contain all the information extracted from the 50 folders. The data are not numbers. They are E-mails of stuffs. Finally, it should remove duplicate data.

The only common aspect among these 50 folders is that they all contain a folder named "A", and inside this folder, all the necessary information (Excell file with the Emails I want to collect) is placed.

Can anyone help me with this? Thanks in advance.

2 个评论
显示无隐藏无

Walter Roberson 2023-4-21

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Image Analyst 2023-4-21

You posted so soon I really doubt you even had time to run my demos below..

请先登录，再进行评论。

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

Answer 1

Image Analyst 2023-4-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1951168-collect-data-from-directories#answer_1220693

See some file and folder demos, attached. Adapt as needed.

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

Image Analyst 2023-4-21

在 MATLAB Online 中打开

Try this. Adapt as needed to do whatever you want with the data read in from the Excel files.

% Optional initialization steps
clc;    % Clear the command window.
close all;  % Close all figures (except those of imtool.)
clear;  % Erase all existing variables. Or clearvars if you want.
workspace;  % Make sure the workspace panel is showing.
format long g;
format compact;
% Specify the folder where the files live.
myFolder = fullfile(pwd, 'MainFolder'); % or 'C:\Users\whatever\';
% Check to make sure that folder actually exists.  Warn user if it doesn't.
if ~isfolder(myFolder)
    errorMessage = sprintf('Error: The following folder does not exist:\n%s\nPlease specify a new folder.', myFolder);
    uiwait(warndlg(errorMessage));
    myFolder = uigetdir(); % Ask for a new one.
    if myFolder == 0
        % User clicked Cancel
        return;
    end
end
% Get a list of all files in the folder with the desired file name pattern.
filePattern = fullfile(myFolder, '**\*.xlsx'); % Change to whatever pattern you need.
theFiles = dir(filePattern);
allFileNames = fullfile({theFiles.folder}, {theFiles.name})
for k = 1 : length(theFiles)
    baseFileName = theFiles(k).name;
    fullFileName = fullfile(theFiles(k).folder, baseFileName);
    % Read in the next image.
    fprintf(1, 'Now reading #%d of %d : "%s"\n', k, length(theFiles), fullFileName);
    data = readmatrix(fullFileName);
    % Now do something with data.
end

civil tech 2023-4-22

Thank you so much for your kind help.

Image Analyst 2023-4-22

If this Answer solves your original question, then could you please click the "Accept this answer" link to award the answerer with "reputation points" for their efforts in helping you? They'd appreciate it. Thanks in advance. 🙂 Note: you can only accept one answer (so pick the best one) but you can click the "Vote" icon for as many Answers as you want. Voting for an answer will also award reputation points.

请先登录，再进行评论。