# How to get the delete rows with conditions and get the corresponding row number?

조회 수: 2(최근 30일)
MCC 2021년 3월 23일
댓글: MCC 2021년 3월 23일
I have a matrix A, which is 1764 by 1023. But I need delete rows that meet this condition: the ratio between the 1 column and 2 column less than or equal to 1. Then I need to know all row numbers that I have deleted from the A. I get the new matrix B but I cannot get the row number. Can anybody please help me? Here is the code I wrote:
A = [1 2 3
11 1 46
45 45 12
47 24 5
25 14 3];
col_1 = 1;
col_2 = 2;
for i=size(A,1):-1:1
Ratio(i) = A(i,col_1)/A(i,col_2);
if Ratio(i) <= 1
A(i,:)=[];
[rows,cols] = find(Ratio(i) <= 1);
end
end

댓글을 달려면 로그인하십시오.

### 채택된 답변

Cris LaPierre 2021년 3월 23일
Use a logical array (Ch 12 MATLAB Onramp) instead of a for loop.
A = [1 2 3
11 1 46
45 45 12
47 24 5
25 14 3];
% determine rows to delete
ind = A(:,1)./A(:,2) <= 1;
rows = 1:size(A,1);
rows = rows(ind)
rows = 1×2
1 3
A(ind,:)=[]
A = 3×3
11 1 46 47 24 5 25 14 3
##### 댓글 수: 1표시숨기기 없음
MCC 2021년 3월 23일
Thank you, it works fine for this problem.

댓글을 달려면 로그인하십시오.

### Community Treasure Hunt

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

Start Hunting!

Translated by