Error on loop on multiple ASCII files

Question

Roxane 2022-2-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1650210-error-on-loop-on-multiple-ascii-files

评论： Roxane 2022-2-15

Hello,

I have 100s of ASCII files with the same name in subfolders, I want to import them and perform the same operations on all of them.

I have managed to import the files but I have a problem with the importdata function. I get different ASCII files as I want but when I import the data, I get the same data from the first file. Therefore, all the further operations are done on the first file.

files=dir('F:\Teamdrive\TEST\**\*.ascii');
numfiles=length(files);
mydata=cell(1,numfiles);
  for k = 1:numfiles 
       mydata{k} = importdata(files(k).name); 
       A{k}=size(mydata{k});
       SelData{k}=mydata{k}(mydata{k}(:,4)>1,:); % extract matrix with only events>1
       
       Area{k}=SelData{k}(:,1);
       Diameter{k}=SelData{k}(:,2);
       Eccentricity{k}=SelData{k}(:,3);
       Events{k}=SelData{k}(:,4);
       Density{k}=SelData{k}(:,5);
       Clusternumber{k}=size(SelData{k});
       MeanArea{k}=mean(Area{k});
end

I am not an expert in MATLAB and I am pretty sure it is a small mistake and I really appreciate your help in this matter.

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2022-2-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1650210-error-on-loop-on-multiple-ascii-files#answer_896525

编辑：Stephen23 2022-2-15

在 MATLAB Online 中打开

You should specify the path when importing the file data, for example:

P = 'F:\Teamdrive\TEST';
S = dir(fullfile(P,'**','*.ascii'));
for k = 1:numel(S)
    F = fullfile(S(k).folder,S(k).name);
    M = readmatrix(F);
    X = M(:,4)>1;
    M = M(X,:); % extract matrix with only events>1
    S(k).EventData = array2table(M(:,1:5),'VariableNames',{'Area','Diameter','Eccentricity','Events','Density'});
    S(k).ClusterNumber = size(M);
    S(k).MeanArea = mean(M(:,1));
end

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

Roxane 2022-2-15

great thank you and also for the help in the matrix writing.

请先登录，再进行评论。

Answer 2

Yongjian Feng 2022-2-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1650210-error-on-loop-on-multiple-ascii-files#answer_896530

在 MATLAB Online 中打开

File.name only gives you the name of the file, not the path. Try:

files=dir('F:\Teamdrive\TEST\**\*.ascii');
numfiles=length(files);
mydata=cell(1,numfiles);
  for k = 1:numfiles 
       fname = fullfile(files(k).folder, files(k).name);
       mydata{k} = importdata(fname); 
       A{k}=size(mydata{k});
       SelData{k}=mydata{k}(mydata{k}(:,4)>1,:); % extract matrix with only events>1
       
       Area{k}=SelData{k}(:,1);
       Diameter{k}=SelData{k}(:,2);
       Eccentricity{k}=SelData{k}(:,3);
       Events{k}=SelData{k}(:,4);
       Density{k}=SelData{k}(:,5);
       Clusternumber{k}=size(SelData{k});
       MeanArea{k}=mean(Area{k});
end