Mean over specific columns

22 次查看（过去 30 天）
Antonio Melieni
Antonio Melieni 2019-3-31
编辑： John D'Errico 2019-4-1
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 个评论
显示 1更早的评论
Antonio Melieni
Antonio Melieni 2019-3-31
no idea how to usw that.... can u maybe explain it :)
Walter Roberson
Walter Roberson 2019-3-31
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.

请先登录，再进行评论。

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

回答（1 个）

John D'Errico
John D'Errico 2019-3-31
编辑：John D'Errico 2019-4-1
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,[]);

类别

在 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