Deleting duplicate values in matrix

11 views (last 30 days)
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

Accepted Answer

Oleg Komarov
Oleg Komarov on 27 Aug 2012
[trash,idx] = unique(S(:,1),'stable');
S(idx,:)
Note that only the first column is considered to be the key.
  6 Comments
Andrei Bobrov
Andrei Bobrov on 27 Aug 2012
[trash,idx] = unique(S(:,1),'first');
out = S(sort(idx),:);
kash
kash on 29 Aug 2012
Thanks andrei and Jan by mistake i clicked Accepy the answer button

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!