Retain IDs of rows kept by the Unique function
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Alessandro
el 1 de Mzo. de 2017
Editada: Alessandro
el 1 de Mzo. de 2017
I have a matrix composed in the following way: [ID_1 ID_2 Resisting_Area]
ID_1 and ID_2 are integer values, Resisting_Area is float.
I need to perform the unique operation on the first 2 columns of the matrix, but also I need to carry the third column value for the kept rows. Is there a simple way to do this?
MWE:
A = [1 2 3.0001; 1 2 3.0002; 2 4 5.12];
I would like to select only the first and third rows but
B = unique(A,'rows')
won't do it, since the resisting area value is not integer and it is not correctly detected as duplicate. Also uniquetol does not have a 'rows' option.
0 comentarios
Respuesta aceptada
Roger Stafford
el 1 de Mzo. de 2017
Editada: Roger Stafford
el 1 de Mzo. de 2017
[U,m] = unique(A(:,1:2),’rows’);
B = [U,m];
I'm not sure which you want to keep, the indices of the "kept" rows or those kept third column values themselves. If the latter, change the second line of code to:
B = [U,A(m,3)];
Note that the rows that are "kept" depends on the 'first' or 'last' option, though that doesn't affect the contents of U, only that of m.
1 comentario
Más respuestas (0)
Ver también
Categorías
Más información sobre Creating and Concatenating Matrices en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!