i want to delete a specific number of NaN in a matrix
1 view (last 30 days)
Show older comments
Marco Callado
on 13 Feb 2019
Commented: Marco Callado
on 13 Feb 2019
i have a matrix A, and i would like to delete the columns with all cells NaN and the ones with just one valid number
A =
1 3 5 1 NaN
2 3 4 NaN NaN
NaN 4 2 NaN NaN
NaN NaN NaN NaN NaN
NaN NaN NaN NaN NaN
NaN NaN NaN NaN NaN
and i manage to delete some with
A(:,all(isnan(A)))=[] %to al column with all cells as NaN
A(:,any(isnan(A)))=[] %to whatever nan i find
0 Comments
Accepted Answer
madhan ravi
on 13 Feb 2019
A(:,all(isnan(A)))=[]; % delete columns with only NaNs
A(:,sum(~isnan(A))==1)=[] % deletes column filled with one number
More Answers (0)
See Also
Categories
Find more on Logical 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!