Delete rows in a matrix that contain ONLY a negative number

4 次查看（过去 30 天）
Christina
Christina 2013-1-14
Hello
I've got a really large matrix (say 2000 x 3000) and I want to delete the rows that contain ONLY the negative number -999.
For example, I've got A = [5 3 -999 ; -999 -999 -999; 4 1 7 ; -999 -999 -999]
and I want my new matrix to be A = [5 3 -999 ; 4 1 7]
How can I do that?
Thanks!

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2013-1-14
idx = all(A == -999, 2);
A(idx, :) = [];

更多回答（3 个）

Kye Taylor
Kye Taylor 2013-1-14
编辑：Kye Taylor 2013-1-14
Try
isNegRow = all( A==-999, 2 );
A(isNegRow,:) = [];
Shashank Prasanna
Shashank Prasanna 2013-1-14
编辑：Shashank Prasanna 2013-1-14
If you don't want to use loops and keep it simple in a single line, I suggest logical indexing as follows:
A(all(A==-999,2),:)=[]
This should do the trick.
Amith Kamath
Amith Kamath 2013-1-14
编辑：Amith Kamath 2013-1-14
I'm quite positive that this does the trick. There would probably be more optimal ways to do it!
X = 100.*rand(12,5); %for example.
X([2 5],:) = -999; % artificially create rows to remove.
i = 1;
while i <= size(X,1)
if(sum(X(i,:) == -999) == size(X,2))
X(i,:) = [];
else
i = i+1;
end
end
  3 个评论
显示 1更早的评论
Amith Kamath
Amith Kamath 2013-1-14
Edited: Thanks Walter! Didn't catch that case earlier! Your answer is much more elegant anyways.
James Tursa
James Tursa 2013-1-15
编辑：James Tursa 2013-1-15
Using a loop in this manner is very bad for performance. At each row that is deleted, potentially huge amounts of data will need to be copied. The same data can end up being copied many, many times. For a large matrix with many rows being deleted, this can easily result in a performance hit that is one or more orders of magnitude slower than the other answers shown above. (This is basically the same problem as increasing the size of an array in a loop). Best to get the indices of everything to be deleted first and then delete it all at once as shown above.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by