Borrar filtros
Borrar filtros

Removing rows with identical column value

2 visualizaciones (últimos 30 días)
Miguel L
Miguel L el 27 de Dic. de 2015
Comentada: Miguel L el 27 de Dic. de 2015
Hello. I have a 2 x 3 matrix.
I want to delete all rows which have the same elements in column 3.
For instance: a = [2,7; 3,4; 3,7] => [3,4]
In this case, as number 7 was repeated in row 1 and row 3, both rows are removed.
Thanks in advance.

Respuesta aceptada

harjeet singh
harjeet singh el 27 de Dic. de 2015
hello miguel use this code
clear all
close all
clc
a = [2,7; 3,4; 3,7];
b=[];
for i=1:size(a,1)
[r,c]=find(a(:,1)==a(i,1));
if(length(r)==1)
b=[b;a(i,:)];
end
end
b

Más respuestas (1)

Star Strider
Star Strider el 27 de Dic. de 2015
a = [2,7; 3,4; 3,7];
[Au,ia,ic] = unique(a(:,2), 'stable');
rep = accumarray(ic, 1);
rows = find(ic == ic(rep<2));
Result = a(rows,:)
Result =
3 4

Categorías

Más información sobre Creating and Concatenating Matrices en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by