I have a matrix A where the first column consists of unique positive whole numbers and zeros. I want to delete the rows where the values are zero.
A = csvread('Truss Data.csv',1,0);
B = sortrows(A(:,1:7)); %I'm sorting them to make sure they are sequential%
A =
1 0 0 0 0 1 1 1 29000 10 1 2
2 30 0 0 -120 0 0 2 29000 10 2 3
3 60 0 0 0 0 0 3 29000 10 3 4
4 90 0 0 0 0 1 4 29000 10 1 5
5 30 40 90 0 0 0 5 29000 10 2 5
6 60 40 0 0 0 0 6 29000 10 3 5
0 0 0 0 0 0 0 7 29000 10 3 6
0 0 0 0 0 0 0 8 29000 10 4 6
0 0 0 0 0 0 0 9 29000 10 5 6
B =
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
1 0 0 0 0 1 1
2 30 0 0 -120 0 0
3 60 0 0 0 0 0
4 90 0 0 0 0 1
5 30 40 90 0 0 0
6 60 40 0 0 0 0
How do I remove the rows in B where the first column of B has zeros? I want:
B =
1 0 0 0 0 1 1
2 30 0 0 -120 0 0
3 60 0 0 0 0 0
4 90 0 0 0 0 1
5 30 40 90 0 0 0
6 60 40 0 0 0 0

댓글 수: 1

Mark
Mark 2013년 3월 28일
*Note - the above matrix A doesn't show correctly on this webpage. There were too many columns to fit.

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

 채택된 답변

Cedric
Cedric 2013년 3월 28일

4 개 추천

B(B(:,1)==0,:) = [] ;

추가 답변 (0개)

카테고리

도움말 센터File Exchange에서 Shifting and Sorting Matrices에 대해 자세히 알아보기

제품

질문:

2013년 3월 28일

편집:

2020년 2월 20일

Community Treasure Hunt

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

Start Hunting!

Translated by