How to delete all rows of an array that have a specified number in a particular column?
1 view (last 30 days)
Show older comments
How can you delete a row of an array if the number in a particular column doesn't equal a specified number or even multiple numbers? For example, let A = magic(5). How can we delete any row where A(2,:) = 5? B=A(A(:,2)~=5) doesn't quite do it, only gives me the first column. In this case, there's only one row, but I'm looking for a general solution.
0 Comments
Accepted Answer
Walter Roberson
on 30 Mar 2022
A(:, A(2,:) == 5) = [];
2 Comments
Walter Roberson
on 30 Mar 2022
How can we delete any row where A(2,:) = 5
A(2,:) is a query about contents of row 2, not about a particular column. It does not make sense to ask about removing rows for which something is true about row 2.
If you want to deal with columns, then
A = magic(5)
A(A(:,2) == 5, :) = []
More Answers (0)
See Also
Categories
Find more on Matrix Indexing in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!