Clear Filters
Clear Filters

For loop to delete rows from matrix

1 view (last 30 days)
Dimitri Haan
Dimitri Haan on 13 Feb 2023
Edited: Jan on 14 Feb 2023
I have a number of matrices that are thousands of rows long. I am trying to keep rows that have a certain number in the second column, and delete everything else. I am trying to use a for loop with an embedded if statement but I don't know where to start. Any tips would be nice thank you.

Answers (1)

Jan
Jan on 13 Feb 2023
Edited: Jan on 14 Feb 2023
M = randi([0, 5], 10000, 5); % Some test data
P = M(M(:, 2) == 3, :); % Keep only rows, which have a 3 in 2nd column
% [EDITED] Typo fixed, ",:" inserted. Thanks, Voss.
  2 Comments
Dimitri Haan
Dimitri Haan on 13 Feb 2023
This was very helpful but i was hoping to keep more rows of the matrix not just the one column. Basically it would be "if the value of column 2 equals 1, keep the entire row. If the value of column 2 doesnt equal 1, delete the entire row
Voss
Voss on 13 Feb 2023
P = M(M(:, 2) == 3, :); % Keep only rows, which have a 3 in 2nd column

Sign in to comment.

Categories

Find more on Loops and Conditional Statements 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!