have two columns that are the same size but one of them has NAN on the first and last row, how would i delete those rows for both columns

code is this:
[rows, cols] = find(isnan(Fe));
Fe(:,unique(rows)) = [];
WAT(:,unique(rows)) = [];
error message is:
Matrix index is out of range for deletion.
Error in Comparison (line 204)
Fe(:,unique(rows)) = [];

 Accepted Answer

a = 1:10;
b = 1:10;
b(1) = NaN;
b(end) = NaN;
NaN_Vals = find(isnan(b));
a(NaN_Vals) = [];
b(NaN_Vals) = [];

2 Comments

No problem! The issue is usually that you remove a row, and then the index is off. Easiest way is to create a list of values (like NaN_Vals) and remove them after the fact, all at once.

Sign in to comment.

More Answers (0)

Asked:

on 2 Mar 2020

Commented:

on 4 Mar 2020

Community Treasure Hunt

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

Start Hunting!