Not looping over all the files

Hi,

I am reading the column_13 from 79 csv files in a folder then taking the mean of each column from each file and want to save 79 values of means in a separate file but struggling to do that. Below is the code. Please see the picture attached shows the workspace and error.

Code:

close all; clear all; clc;

P = 'F:\3-PIV_Experimental_Data\Calculations_TurbulentIntensity\line_Data\Elliptical_Side\Length\DesignPoint\110_outlet';
Q = 'F:\3-PIV_Experimental_Data\Calculations_TurbulentIntensity\line_Data\Elliptical_Side\Length\DesignPoint';
S = dir(fullfile(P,'*.csv'));
N = natsortfiles({S.name});
% Pre-allocate output vector
TurbulentFluctuationArray_Mean=zeros(numel(N), 1); % matrix of results that you will fill later in your "for cycle"
% loop over the file names
for idx = 1:numel(N,1);
    data = readtable( fullfile(P, N{idx}) ); % read the csv files
    col_13 = data(:,13);     % Get the 13th column
    TurbulentFluctuation_array(idx) = table2array(col_13)  %convert the table to arrays
    TurbulentFluctuationArray_Mean(idx) = mean(TurbulentFluctuation_array); 
end
csvwrite(fullfile(Q, 'TF_mean.csv'), TurbulentFluctuationArray_Mean(idx)); % its only saving first term value TurbulentFluctuationSquare_Mean

Answer 1

[KSSV]

close all; clear all; clc;

P = 'F:\3-PIV_Experimental_Data\Calculations_TurbulentIntensity\line_Data\Elliptical_Side\Length\DesignPoint\110_outlet';
Q = 'F:\3-PIV_Experimental_Data\Calculations_TurbulentIntensity\line_Data\Elliptical_Side\Length\DesignPoint';
S = dir(fullfile(P,'*.csv'));
N = natsortfiles({S.name});
% Pre-allocate output vector
TurbulentFluctuationArray_Mean=zeros(numel(N), 1); % matrix of results that you will fill later in your "for cycle"
% loop over the file names
for i = 1:numel(N);
    data = readtable( fullfile(P, N{i}) ); % read the csv files
    col_13 = data.(13) ;     % Get the 13th column   
    TurbulentFluctuationArray_Mean(i) = mean(col_13); 
end
csvwrite(fullfile(Q, 'TF_mean.csv'), TurbulentFluctuationArray_Mean); % its only saving first term value TurbulentFluctuationSquare_Mean

[muhammad choudhry]

Hi, it is still calculating the value from first csv file and giving the 0 values for the rest of the files. it seems to me that line

data = readtable( fullfile(P, N{idx}) ); % read the csv files

only reading the first csv file rather then all of them, as you can see in the image attached in the post above

0.331476141698658

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

[KSSV]

Edited the code....

[muhammad choudhry]

Super Dooper Star!!!!! if you can resolve the problem I am having in the link below that be great as well

https://uk.mathworks.com/matlabcentral/answers/1737820-want-to-see-the-results-from-the-79-csv-files-but-only-getting-one-result?s_tid=mlc_ans_email_view#comment_2207580