Mean of mutiple variables

1 view (last 30 days)
ali akbar
ali akbar on 11 Dec 2020
Commented: dpb on 11 Dec 2020
I have 5 '.mat' data files where each datafile contains 1 by 19 cell (each cell size = 512 by 9). I wanted to find the mean of the 4th column of 1st cell from all 5 data files.
Here is a look at the code.
load('data1a.mat');load('data2.mat');load('data3.mat');load('data4.mat');load('data5.mat');...
% Extracting the 4th column
a=data1a{1,1}(:,4);b=data2{1,1}(:,4) and so on...
m=(a+b+c+d+e)/5
Now people in stoneage might used to do this kind of laborious exercise. I am wondering if anyone could give a one/two liner answer for finding mean which is not naive like mine.
  4 Comments
Stephen23
Stephen23 on 11 Dec 2020
Copy and pasting code like this is a sign that you are doing something wrong:
load('data1a.mat');load('data2.mat');load('data3.mat');load('data4.mat');load('data5.mat');...
Learn to use arrays and indexing! For example:
ali akbar
ali akbar on 11 Dec 2020
please see attached.

Sign in to comment.

Accepted Answer

dpb
dpb on 11 Dec 2020
Edited: dpb on 11 Dec 2020
d=dir('data*.mat'); % or similar list. Name files so can use appropriate wildcard expression
total=0;
for i=1:numel(d)
data=load d(i).name;
total=total+structfun(@(x)sum(x{1}(:,4)),data);
end
mn=mean(total);
Above does the summation; same result if were to use mean in the anonymous function as well if same number elements in each cell array.
If the variables were named consistently would be easier to code; above handles whatever they are inside the .mat files as long as just one variable per file.
  2 Comments
ali akbar
ali akbar on 11 Dec 2020
thank you. matlab throwing a syntax error on the second line of the 'for' loop.
dpb
dpb on 11 Dec 2020
so, debug it. (Exercise for Student :) )
Accidentally wrote it as command syntax instead of function form needed.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!