I want to read all the text files from a folder deleting headers and some string columns and calculate the median of some selected rows

I am able to do it for single file(.min). Here is the code. Each file contains 1440 rows and have to take median of 60 rows of last 4 columns.

   M=dlmread('myfile.min','',23,2);
for i=1:24;
     mat=(M((i*60)-59:i*60,2:5));  
    X(i,2:5)=median(M((i*60)-59:i*60,2:5));
   end
  X(:,1)=[];

how I can do it for all the files in the folder? attached are 2 sample files.

Answer 1

[KSSV]

F = dir('*.txt');
N = length(F) ; % total files 
for ii = 1:N  % loop for each file 
   file = F(ii).name ;
 %%do what you want
end

[Mahrukh Farooq]

Yes i used a similar technique it does read all the files but the problem is it gives median 'X' of only 1st file. how can i resolve this? because apparently the following code does not hive any errors. here is the code

clc;
clear all;
fnames = dir('\\Swmop02\swmop02\Mahrukh\IAGAFormat\same lat\2015\HONdata20161111075825\*.min');
 tradataa = cell(1,length(fnames));
 for k=1:length(fnames);
   fname = fnames(k).name;
   tradataa{k} = dlmread(fname,'',23,2);
   for i=1:24;
     mat=(tradataa{k}((i*60)-59:i*60,2:5));  
    X(i,2:5)=median(tradataa{k}((i*60)-59:i*60,2:5));
   end
X(:,1)=[];%to delete all rows of 1st column
end

[KSSV]

Try this:

for k=1:length(fnames);
   fname = fnames(k).name;
   tradataa{k} = dlmread(fname,'',23,2);
   for i=1:24;
     mat=(tradataa{k}((i*60)-59:i*60,2:5));  
    XX(i,2:5)=median(tradataa{k}((i*60)-59:i*60,2:5));
   end
X(k,:)=XX;%to delete all rows of 1st column
end

I can initialize XX and X if I know size of XX.

[Mahrukh Farooq]

there are 366 files in a folder each having 1440 rows, X should take median of 60 rows of last 4 columns making 24 rows for each file