Deleting duplicate values in matrix

I have a dataset in which i have duplicate vaues(same values),i want to delete it as
S={
'' 'c1' 'c2' 'c3'
'p-a' 'pso' 'mpso' 'pso'
'p-a' 'pso' 'mpso' 'pso'
'p-a' 'pso' 'mpso' 'pso'
'k' 'spsp' 'pso' 'mpso'
'y-b' 'pso' 'pso' 'spso'
'y-b' 'pso' 'pso' 'spso'}
i need output as
out={
'p-a' 'pso' 'mpso' 'pso'
'k' 'spsp' 'pso' 'mpso'
'y-b' 'pso' 'pso' 'spso'}
please help

 채택된 답변

Oleg Komarov
Oleg Komarov 2012년 8월 27일

1 개 추천

[trash,idx] = unique(S(:,1),'stable');
S(idx,:)
Note that only the first column is considered to be the key.

댓글 수: 6

kash
kash 2012년 8월 27일
am getting error
Error using cell/unique (line 28) Unrecognized option.
Honglei Chen
Honglei Chen 2012년 8월 27일
편집: Honglei Chen 2012년 8월 27일
If it does not solve your issue, please do not accept an answer. The error you see could be due to you are using an older version of MATLAB that does not support 'stable' option.
kash
kash 2012년 8월 27일
ok can u tell how to solve it please am using 2010a
Jan
Jan 2012년 8월 27일
편집: Jan 2012년 8월 27일
Omit the "stable", kash. And please be so kind to answer my question: Why does the first row disappear in the output? It is a unique line, so it should be kept according to your explanations.
If using the first row is not enough for your problem, take the time to explain such details. Try unique(S, 'rows') instead.
You've asked 220 questions now and still accept an answer, which does not solve your problem? Surprising. Again I suggest to read, consider and respect the forum rules, which are explained e.g. here: http://www.mathworks.com/matlabcentral/about/answers/
[trash,idx] = unique(S(:,1),'first');
out = S(sort(idx),:);
kash
kash 2012년 8월 29일
Thanks andrei and Jan by mistake i clicked Accepy the answer button

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

추가 답변 (0개)

카테고리

태그

질문:

2012년 8월 27일

Community Treasure Hunt

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

Start Hunting!

Translated by