calculation mean as index for columns
8 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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
0 commentaires
Réponses (1)
Image Analyst
le 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 commentaires
Image Analyst
le 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)
Voir également
Catégories
En savoir plus sur Cell Arrays dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!