selecting unique rows

20 visualizzazioni (ultimi 30 giorni)
kash
kash il 18 Gen 2012
I have an matrix of 6 columns,all columns have repeated numbers,now i want to select only unique values of that matrix ,please help

Risposta accettata

Andrei Bobrov
Andrei Bobrov il 18 Gen 2012
EDIT [23:27(UTC+4) 18.01.2012]
a = [1 2 7 8 9 0
2 2 71 2 4 1];
out0 = a(all(diff(sort(a,2),1,2) > 1e4*eps,2),:)
out1 = sortrows(out0);
loc = [true;all(diff(out1,1,1),2)];
out = out1(loc,:);
  1 Commento
kash
kash il 18 Gen 2012
andrei am not gtting exact result plz look at my file and result
http://www.sendspace.com/file/knqbjv
every column has same values,,i nees only unique values in every column

Accedi per commentare.

Più risposte (2)

TAB
TAB il 18 Gen 2012
Type
>> doc unique
on your command window

Wayne King
Wayne King il 18 Gen 2012
C = unique(A,'rows');
Selects the unique rows of the matrix A in sorted order. Is that what you mean?
  6 Commenti
kash
kash il 18 Gen 2012
i my matrix my first column has repeated values
so
1 2 7 8 9 0
2 2 71 2 4 1
now 2nd column has repeating values
si i need as
1 2 7 8 9 0
like this i have 32000 rows and 6 columns
Andrei Bobrov
Andrei Bobrov il 18 Gen 2012
a = [1 2 7 8 9 0
2 2 71 2 4 1];
out = a(all(diff(sort(a,2),1,2) > 1e4*eps,2),:)

Accedi per commentare.

Categorie

Scopri di più su Shifting and Sorting Matrices in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by