Import files from two folders

12 次查看(过去 30 天)
Hi,
I am trying to import files from two different folders, including each file name. I manage to import the files from the first folder but I have problems when I come to the second folder.I get the error: "Undefined function 'Importing' for input arguments of type 'cell'.My code looks as follows:
path1 = 'files1';
subfolderInfo = dir(path1);
subfolderNames = {subfolderInfo.name};
subfolderNames(ismember(subfolderNames,{'.','..'}))=[];
Num1=numel(subfolderNames);
for b = 1: Num1
[X1,X2] = PImport(b,subfolderNames);
end
%in this folder I get the problem...
path2 = 'files2';
subfolderInfo = dir(path2);
subfolderNames = {subfolderInfo.name};
subfolderNames(ismember(subfolderNames,{'.','..'}))=[];
Num2=numel(subfolderNames);
for c = 1: Num2
[Z1] = ImportingEl(c,subfolderNames);
end
I don't know if it the connected to the use of "subfolderNames" twice. However, I have tried changing it to "SubfolderNames2" but that does not work either. Furthermore, the code within each for loop is as follows:
cd 'files1';
fileInfo = dir(subfolderNames{v});
fileNames = {fileInfo.name};
fileNames(ismember(fileNames,{'.','..'}))=[];
ImportedData = readtable(char(fullfile(fileInfo(1).folder,fileNames(1))));
Data = table2array(ImportedData(:,2));
Data(1:4,:)=[];
Thank you in advance!
  1 个评论
Jan
Jan 2021-12-7
A simplification: If you access a cell string with curly braces, you can omit the conversion by CHAR():
% ImportedData = readtable(char(fullfile(fileInfo(1).folder,fileNames(1))));
ImportedData = readtable(fullfile(fileInfo(1).folder, fileNames{1}));

请先登录,再进行评论。

采纳的回答

Jan
Jan 2021-12-7
The error message is clear:
Undefined function 'Importing'
This means, that this function is not visible. If it was working before, I guess it is stored in a folder, which was the current folder, but then the current folder was changed by a cd() command.
Store functions in folders, which are included in Matlab's path. See:
doc addpath
doc savepath
doc pathtool
Do not change the current directory. Remember than callbacks of timers of GUIs might call CD also at unexpected situations. Prefer working with absolute paths in every case. Replace
cd 'files1';
fileInfo = dir(subfolderNames{v});
by
fileInfo = dir(fullfile('files1', subfolderNames{v}));
But even here 'files1' is a relative path. Better: 'D:\Your\Folder\files1'.
  5 个评论
Vlatko Milic
Vlatko Milic 2021-12-8
The code is as appended above (with modification according to you). See below.
Main script:
path2 = 'files2';
subfolderInfo = dir(path2);
subfolderNames = {subfolderInfo.name};
subfolderNames(ismember(subfolderNames,{'.','..'}))=[];
Num2=numel(subfolderNames);
for c = 1: Num2
[Z1] = Importing(c,subfolderNames);
end
And the code in the functions is:
function [Output]=Importing(v,subfolderNames)
fileInfo = dir(fullfile('files1', subfolderNames{v}));
fileNames = {fileInfo.name};
fileNames(ismember(fileNames,{'.','..'}))=[];
ImportedData = readtable(char(fullfile(fileInfo(1).folder,fileNames(1))));
Data = table2array(ImportedData(:,1));%Data-column
As an example, I'm appending two examples of the files that I want to read. Please see attached excel-files. To clarify, I want the file names (i.e. Mat.. and Mat..2) as new row names for the Data-columns(see comment in the code above) which I get from running the script (output=Z1 in the main script). Hence, according to the example above it should be two columns containing the data given in the appended excel-files with Mat_question.xlsx and Mat_question2.xlsx as the row names, respectively.
Vlatko Milic
Vlatko Milic 2021-12-8
I solved it by myself, thank you Jan!

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by