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
2 views (last 30 days)
Show older comments
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)) = [];
0 Comments
Accepted Answer
Ruger28
on 2 Mar 2020
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
Ruger28
on 4 Mar 2020
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.
More Answers (0)
See Also
Categories
Find more on NaNs 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!