Remove rows in a matrix where there isn't a change larger than 3 in either column
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I have a 225x2 matrix where the first 200 rows or so (it varies by data set) does not change by more than 3 in either column. I need a function to delete all of the rows where there isn't a change greater than 3 and then condense the matrix.
0 comentarios
Respuestas (1)
Image Analyst
el 6 de Abr. de 2023
Do you mean a change between the first column and second column in each row?
Try this
changes = m(:, 2) - m(:, 1); % Change from col 1 to col 2.
rowsToDelete = changes > 3;
m = m(~rowsToDelete, :);
3 comentarios
Dyuman Joshi
el 6 de Abr. de 2023
In the example you mentioned, both columns in the 2nd row don't change by more than 3 from the 1st row.
Now, do you want to remove the 2nd row, and compare the 3rd row to the first? Or do you want to compare the 3rd row to the 2nd one?
Image Analyst
el 6 de Abr. de 2023
You forgot to give the output. Is the first row to be deleted too? Or just the second and third row?
m = [...
1000 520
1000 521
1001 519
800 250
324 104];
changes = diff(m, 1) % Change from one row to the next
rowsToDelete = [0; any(changes >= 0 & changes < 3, 2)]
m = m(~rowsToDelete, :)
Ver también
Categorías
Más información sobre Resizing and Reshaping 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!