Borrar filtros
Borrar filtros

How can I delete the rows of a matrix in matlab under a given condition

8 visualizaciones (últimos 30 días)
Hello everybody,
I have a matrix which has 10118 rows and 14 columns. I would like to delete the number of rows having values greater than 100. How can I do this?
Thanks in advance!

Respuesta aceptada

madhan ravi
madhan ravi el 14 de Nov. de 2018
Editada: madhan ravi el 23 de Nov. de 2018
EDITED
%Numbers greater than 100
idx = matrix > 100;
matrix ( ~ ( sum ( idx , 2) == 0 ) , : ) = []
%__________________________
%Numbers lesser than 100
idx = matrix < 100;
matrix ( sum ( idx , 2 ) ~= 0 , : ) = []
  21 comentarios
Stephen23
Stephen23 el 23 de Nov. de 2018
Editada: Stephen23 el 23 de Nov. de 2018
This code, although convoluted, will remove rows with any value greater than 100:
idx = matrix < 100;
matrix ( ~ ( sum ( idx , 2) == 0 ) , : ) = []
But what is this going to do?:
idx = matrix < 100;
matrix ( sum ( idx , 2 ) == size ( matrix , 2 ) , : ) = []
madhan ravi
madhan ravi el 23 de Nov. de 2018
Editada: madhan ravi el 23 de Nov. de 2018
@Skyscraper: yes because if any of the numbers in a matrix is less than 100 the whole row is removed, the matrix which you gave contains numbers less than 100 in each row.

Iniciar sesión para comentar.

Más respuestas (1)

Stephen23
Stephen23 el 23 de Nov. de 2018
Editada: Stephen23 el 23 de Nov. de 2018
@Sky Scrapper: the standard MATLAB practice is to use any:
>> A = [110,0,10,70,15;100,30,50,20,9;50,-150,95,65,7]
A =
110 0 10 70 15
100 30 50 20 9
50 -150 95 65 7
>> B = A(~any(abs(A)>100,2),:) % create a new array B,
B =
100 30 50 20 9
>> A(any(abs(A)>100,2),:) = [] % or delete rows from A.
A =
100 30 50 20 9

Categorías

Más información sobre Matrices and Arrays 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!

Translated by