Deleting duplicate values in matrix

1 view (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)

Categories

Find more on MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!