Find if a value in a column is greater than a number and exclude the entire row
21 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
R2
el 27 de Abr. de 2015
I have a numerical array that consists of 9 columns, where I want to consider the values in one of these columns and determine if it is greater than 0.00001. If this condition is met for a particular value I want to exclude all of the other values in the other columns for that row. I have included an example of the data, where in this case I want to specifically look at the values in the 7th column.
Thanks!
0 comentarios
Respuesta aceptada
Stephen23
el 27 de Abr. de 2015
Editada: Stephen23
el 27 de Abr. de 2015
If A is that matrix of data, first we can check the seventh column:
A = [...];
idx = A(:,7) > 1e-5;
A(idx,: ) = [];
Or it is likely to be better to keep the original data matrix intact and simply use the index vector idx when you need to extract that particular subset of data. Note you can also invert the index to get the remaining rows:
A = [...];
B = A(~idx,:);
Creating and using indices to access subsets of data is often simpler and faster than actually altering the original data matrices, as it simplifies the memory management that MATLAB has to perform when you change the matrices.
Más respuestas (0)
Ver también
Categorías
Más información sobre Matrix Indexing 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!