Mean over specific columns

3 次查看（过去 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 中查找有关 Loops and Conditional Statements 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by