How to replace values less than zero in a cell array with NaN?
7 views (last 30 days)
Show older comments
I have a huge cell array and there is a column with a lot of negative values. I want to clean up and replace all those values with NaN. Would appreciate any help. Thanks.
0 Comments
Accepted Answer
Azzi Abdelmalek
on 22 Feb 2013
Edited: Azzi Abdelmalek
on 22 Feb 2013
% for all columns
B=cell2mat(A)
B(B<0)=nan
A=num2cell(B)
%if column 2 for e.g
B=cell2mat(A)
B(B(:,2)<0,2)=nan
A=num2cell(B)
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!