Read multiple CSV files from different folders uing readtable

% Specify the folder where the files live.
myFolder = 'C:\Users\yourUserName\Documents\My CSV Files';
% 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, and its subfolders, with the desired file name pattern.
filePattern = fullfile(myFolder, '**/*.csv'); % Change to whatever pattern you need.
theFiles = dir(filePattern);
for k = 1 : length(theFiles)
    baseFileName = theFiles(k).name;
    fullFileName = fullfile(theFiles(k).folder, baseFileName);
    fprintf(1, 'Now reading %s\n', fullFileName);
    % Now do whatever you want with this file name,
    % such as reading it in as a table.
    thisTable = readtable(fullFileName);
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Image Analyst 2022-9-26

在 MATLAB Online 中打开

Because you left the semicolon off, that should print out the values of B to the command window. Do you not see them?

If you want to store/save them for later, you'll have to make B a matrix and give the column number, like

B(:, k) = data(:, 3); % Store 3rd column of data in k'th column of B.

请先登录，再进行评论。

Answer 2

KSSV 2022-9-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1812050-read-multiple-csv-files-from-different-folders-uing-readtable#answer_1060630

在 MATLAB Online 中打开

thepaths = {p1,p2,p3} ;
for i = 1:3 % loop for ech folder 
    csvFiles = dir([thepaths{i},'\*csv']) ;  % get ll csv files in the folder 
    N = length(csvFiles) ; 
    for j = 1:N  % loop for each csv file 
        csvFile = fullfile(csvFiles(j).folder,csvFiles(j).name) ;
        T = readtable(csvFile) ;
        % do what you want 
    end
end

2 个评论
显示无隐藏无

KSSV 2022-9-26

Check the paths......

Stephen23 2022-9-26

"I am getting only the last iteration"

If you want to store the data from every iteration then you will need to allocate that data to an array, just as the MATLAB documentaton shows:

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

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-cell-array.html

请先登录，再进行评论。

Answer 3

Image Analyst 2022-9-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1812050-read-multiple-csv-files-from-different-folders-uing-readtable#answer_1061765

在 MATLAB Online 中打开

You need to index f. Actually I'd use more descriptive variable names. No one wants to look at code that looks like aphabet soup.

% Get a list of all files in the folder with the desired file name pattern.
filePattern = fullfile(myFolder, '*.CSV'); % Change to whatever pattern you need.
fileList = dir(filePattern);
for k = 1 : length(fileList)
    % Read in this table.
    baseFileName = fileList(k).name;
    fullFileName = fullfile(fileList(k).folder, baseFileName);
    thisTable = readtable(fullFileName); 
    % Extract the third column only.
    column3 = thisTable{:, 3};
    % Append this column to our master vector.
    if k == 1
        allColumn3s = column3;
    else
        allColumn3s = [allColumn3s; column3]
    end
end
numBins = 4;
histogram(allColumn3s, numBins)
grid on;