Deleting Entries in an Array

4 views (last 30 days)
Hans123
Hans123 on 29 Jan 2019
Commented: Hans123 on 30 Jan 2019
I am working with a 1627x11 array, labelled A, and I want to delete the entries that have 0 in the 9th column (i.e delete the whole row).
V = A(:,9);
vals=find(V==0);
A(vals)=[ ];
after running that code, the array converts to an 1x16617 double - which is not wat I anticipated nor want.
To reiterate, the 9th column which has a sort of counter is used to keep track of which point I am working with, and I do not want to include the rows which are in the 0th point.
Rows 0 to 1280 contains 0 in the 9th column (this was done by observing the array), so I should have a 347x11 array after running the code.
What am I doing wrong

Accepted Answer

Brian Hart
Brian Hart on 29 Jan 2019
Hi Ramitha,
You almost got it. For your last line of code, try
A(vals,:)=[];
The way you tried it at first uses linear lindexing (see sub2ind)
  3 Comments
Stephen23
Stephen23 on 30 Jan 2019
Simpler and more efficient to use logical indexing (without find):
A(A(:,9)==0,:) = [];
Hans123
Hans123 on 30 Jan 2019
that's great! Thanks Stephen

Sign in to comment.

More Answers (1)

madhan ravi
madhan ravi on 29 Jan 2019
Edited: madhan ravi on 30 Jan 2019
A(~any(A(:,9),2),:)=[]

Products


Release

R2017b

Community Treasure Hunt

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

Start Hunting!