How can I put the output of each iteration into one table to find averages of each row later?

Question

Kathryn Baker 2019-6-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/467711-how-can-i-put-the-output-of-each-iteration-into-one-table-to-find-averages-of-each-row-later

编辑： Kathryn Baker 2019-6-21

Here is the code I have used to loop through and process all files within a directory. It produces a graph of all of the iterations, but outputs each iteration as a separate command in the command window. Instead, I would like to add the results of each iteration into a table so that I can collate the data and find the average of each row later on. I have tried using zeros() but this distorts the data in the graph so it only shows one iteration output.

%%import folder location

path='file path';

fil=fullfile(path,'area*.txt');

d=dir(fil);

for k=1:numel(d)

filename=fullfile(path,d(k).name);

delim=';';

headings=6;

A=importdata(filename, delim, headings);

data=A.data;

variable1=data(:,1);

variable2=data(:,2);

%find minimum and maximum

%minimum

%isolate bottom 0.5 percentile

minimum=prctile(variable1, 0.5);

%maximum

maximum=prctile(variable1, 99.5);

%normalise data

normalised(k)=(variable1(k)-minimum)/(maximum-minimum);

%smooth graph

a=linspace(0,1,100);

b=spline(normalised, variable2, x);

%plot distribution figure 1

figure(1)

plot(a,b,'.-');

hold on

end

hold off

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

请先登录，再进行评论。

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

Answer 1

Bob Thompson 2019-6-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/467711-how-can-i-put-the-output-of-each-iteration-into-one-table-to-find-averages-of-each-row-later#answer_379753

The simplest way to do this is to index b.

b(:,k) = spline(normalised_IQ, number_count, x);
% and then down in the plot section
plot(a,b(:,k),'.-')

I think that should take care of what you are looking for with regards to the storage.

Taking the averages of each column should be done outside the loop. Just add the following after the loop.

aves = mean(b,1);

2 个评论
显示无隐藏无

Kathryn Baker 2019-6-18

编辑：Kathryn Baker 2019-6-21

Thank you for your quick response!

How would this work if I was not using the spline feature? As I would like to produce a table of 12 columns and 20 rows, with each iteration (6 in total) filling two columns, the first with variable 2 and the second with variable1, rather than the spline information. I am only using the spline to smooth the graph.

Bob Thompson 2019-6-18

编辑：Bob Thompson 2019-6-18

The key part of what I did is on the left side of the equal sign, so the basic concept is the same. If you are looking to put two columns in at once then I would expect it to look something like the following:

% Single command format
b(:,2*k-1:2*k) = [number_count, normalised_IQ];
% Double command format; Choose only the above single or the below double
b(:,2*k-1) = number_count;
b(:,2*k) = normalized_IQ;

This may not be exactly what you're looking for, but it should be a rough idea.

For a more detailed description of indexing, check out this.

请先登录，再进行评论。