calculation mean as index for columns

5 views (last 30 days)
expert
expert on 23 Nov 2019
Commented: Image Analyst on 24 Nov 2019
Hi,
I want o calculation mean for 12850x22 matrix. First of all I calculated some values with for loop, after normalized data. But I could not calculate true means for colums.
I m trying this:
%import table from same directory
T = readtable("T.xlsx", "UseExcel", false);
%convert table to matrix except first column
T = T{:,2:23};
cols = size(T,2);
for i = 2:cols
res(:,i-1) = T(:,i)./T(:,1);
res_norm = normalize(res,'norm',Inf);
res_mean = mean(res); %but these are not true means, I need index number but how?
end

Answers (1)

Image Analyst
Image Analyst on 23 Nov 2019
Why not
meanOfThisColumn = mean(T{:,i}); % Braces for T, not parentheses.
You forgot to attach T.xlsx. I'll check back later.
  2 Comments
expert
expert on 24 Nov 2019
Hi
Thank you for your response. But there is an error with this command:
Brace indexing is not supported for variables of this type.
Error in Untitled4 (line 10)
res_m = mean(res{:,i});
I attached file.
Image Analyst
Image Analyst on 24 Nov 2019
See how important it is to include relevant data in advance?
Try this:
T = readtable('T.xlsx', 'UseExcel', false);
% Convert table to matrix except first column and first row.
numbers = T{2 : end, 2 : end};
columnMeans = mean(numbers, 1)

Sign in to comment.

Categories

Find more on Cell Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!