Help me, please. I want a matrix transform averaged and unique in specific col,

I want first 1 and 2 columns unique and 3 coloum make average matrix.
for example
[1,2,11; 1,2,12; 1,2,13; 2,4,10; 2,4,12]
->
[1,2,12; 2,4,10]
How can I get that? I can do that very complex way but I think there is some smart way. Help me people

2 个评论

If you want averaging, then why isn't the second row [2, 4, 11] ?
yes you're right!! it must be [2,4,11].
sorry for my mistake

请先登录,再进行评论。

 采纳的回答

A = [1,2,11; 1,2,12; 1,2,13; 2,4,10; 2,4,12];
[a,b,c] = unique(A(:,1:2),'rows');
out = [a cellfun(@mean,mat2cell(A(:,end),histc(c,1:max(c)),1))];

更多回答(1 个)

may u please elaborate your question? im not getting ur problem...

类别

帮助中心File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by