Mean over specific columns

27 vues (au cours des 30 derniers jours)
Antonio Melieni
Antonio Melieni le 31 Mar 2019
Hi :)
I have a 450x42 table.
I would like to calculate the mean over cloumns 2:5 7:10 12:15 and so
mean([2:5],2) mean([7:10],2).....
anybody an idea :)
  3 commentaires
Antonio Melieni
Antonio Melieni le 31 Mar 2019
no idea how to usw that.... can u maybe explain it :)
Walter Roberson
Walter Roberson le 31 Mar 2019
In the above, Tab would be your table object. All of the variables (columns) in the table would have to be numeric for it to work properly. The code I posted could have problems your variables are not all the same numeric type, such as if columns 2:5 were double but columns 7:10 were uint8.

Connectez-vous pour commenter.

Réponses (1)

John D'Errico
John D'Errico le 31 Mar 2019
Modifié(e) : John D'Errico le 1 Avr 2019
Easy peasy? Convert to an array first of course. Or, if some of those columns are non-numeric, then convert only the indicated columns to an array.
But it is pretty easy to generate that list of columns.
T = rand(450,42);
M = mean(T(:,[2:5]' + (0:5:35)),1);
So the list of column indices is:
ind = reshape([2:5]' + (0:5:35),1,[]);

Catégories

En savoir plus sur Matrices and 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!

Translated by