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

조회 수: 1(최근 30일)
Sangjae
Sangjae 2011년 10월 20일
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
Sangjae
Sangjae 2011년 10월 20일
yes you're right!! it must be [2,4,11].
sorry for my mistake

댓글을 달려면 로그인하십시오.

채택된 답변

Andrei Bobrov
Andrei Bobrov 2011년 10월 20일
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개)

Pramod Bhat
Pramod Bhat 2011년 10월 20일
may u please elaborate your question? im not getting ur problem...

Community Treasure Hunt

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

Start Hunting!

Translated by