opening different folders with different name and read CSV files

Question

Roozbeh Yousefnejad 2018-5-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/402933-opening-different-folders-with-different-name-and-read-csv-files

评论： Ameer Hamza 2018-5-29

Hi, I want to open different folders with Matlab and then open different CSV files in each folder and read some specific sheets and columns. I can read the files from specific columns or sheet; however, my problem is that I cannot open different folders.

The first problem I have is that the files' name are in this form: F21802010055 or F21802010058 so they are not in row.
Also, each folder may have a different number of CSV files. For example folder F21802010055 has two CSV files with the names of F21802010055-201801-21_00-17 and F21802010055-201801-22_00-12 and folder F21802010058 has one csv file with the name of *F21802010058-201801-21_00-17*Can you please advise what would be the best approach to open these files?

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

请先登录，再进行评论。

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

Answer 1

Ameer Hamza 2018-5-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/402933-opening-different-folders-with-different-name-and-read-csv-files#answer_322286

在 MATLAB Online 中打开

Use FEX::subdir to find all the files in the subfolders. Download this package, extract it and place it on MATLAB path. Here is a general template of what to do

files = subdir('C:\path_to_csv_folders\*.csv'); % here specify the path to top folder which contain all the other csv files
for i=1:numel(files) . % for loop will iterate over all file names
  filename = files(i).name;
  data = csvread(filename); % or readtable() or whatever function you are using to read csv file
  % do you processing
end

Note that in subdir() all the CSV files doe not need to be present in the top folder. You can have several subfolders under the top folders and subfolder can contain several CSV files. subdir() can handle all the recursive file paths.

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

Ameer Hamza 2018-5-28

Alternatively you can use, set path button on the top bar in MATLAB window to add a folder to MATLAB path.

Roozbeh Yousefnejad 2018-5-28

for example the csv file is F21802010055-201801-21_00-17.csv I also want to cut F21802010055-201801-21_00-17 and put it in front of the average numbers to know, which row is for which excel file.

请先登录，再进行评论。

Answer 2

Roozbeh Yousefnejad 2018-5-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/402933-opening-different-folders-with-different-name-and-read-csv-files#answer_322293

在 MATLAB Online 中打开

Thank you so much. It works perfectly. Can you just add, how I can have the excel number separately? currently, this is my code

clc
clear
files = subdir('C:\Users\roozm\Desktop\New folder\*.csv'); % here specify the path to top folder which contain all the other csv files
N=zeros(numel(files),9);
for i=1:numel(files)  % for loop will iterate over all file names
  filename = files(i).name;
  sheet = 1;
subset = xlsread(filename,sheet,'A:C');
subset2 = xlsread(filename,sheet,'F:G');
subset3 = xlsread(filename,sheet,'K:N');
subset_merged=[subset,subset2,subset3];
subset_tot=subset_merged([end-6:end-2],:);
M=mean(subset_tot); % or readtable() or whatever function you are using to read csv file
N(i,:)=M;
end

so actually I take an average and I have an average for all the excel files and put in in the matrix name N. Now, I want to have the number of the excel file to know which row is for which excel file. How can I do it?

2 个评论
显示无隐藏无

Roozbeh Yousefnejad 2018-5-28

for example the csv file is F21802010055-201801-21_00-17.csv I also want to cut F21802010055-201801-21_00-17 and put it in front of the average numbers to know, which row is for which excel file.