i have 50x5 matrix, i want to delete some of the rows but unfortunately the rows which i want to delete are not at equal interval,so i need help

1 view (last 30 days)
i want delete the rows which contains first two rows and last 3 rows of every constant value of 1st column 3 zeros.

Answers (1)

the cyclist
the cyclist on 7 Jun 2016
Edited: the cyclist on 7 Jun 2016
If you have loaded the data into a matrix "M", then you can do this with
deleteRowIndex = ismember(M(:,end-2:end),[0 0 0],'rows');
M(deleteRowIndex,:) = [];
This takes advantage of the fact that the rows you want to delete are of the form
[a b 0 0 0]


Find more on Resizing and Reshaping Matrices 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!