calculation mean as index for columns

9 次查看（过去 30 天）
expert
expert 2019-11-23
评论： Image Analyst 2019-11-24
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

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

回答（1 个）

Image Analyst
Image Analyst 2019-11-23
Why not
meanOfThisColumn = mean(T{:,i}); % Braces for T, not parentheses.
You forgot to attach T.xlsx. I'll check back later.
  2 个评论
expert
expert 2019-11-24
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 2019-11-24
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)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by