How to make NaN data an empty entry
2 views (last 30 days)
Show older comments
Opeyemi Kehinde
on 5 Dec 2021
Commented: Opeyemi Kehinde
on 10 Dec 2021
I have a 2160 by 4320 data that has lots of NaN. How do I make matlab ignore the NaNs (i.e making them an empty entry, not zero) and still maintain the same size of the data size
0 Comments
Accepted Answer
Walter Roberson
on 5 Dec 2021
A=randi(500,5,5);
A(A<100)=nan
Ac = num2cell(A)
Ac(isnan(A)) = {[]}
Ac is now the same size as A, but the nan entries have been made empty.
0 Comments
More Answers (1)
Matt J
on 5 Dec 2021
It depends on the operation. If you are taking the maximum of each data colum, for example, the NaNs are already ignored, e.g.,
A=randi(500,5,5);
A(A<100)=nan
maximum = max(A)
6 Comments
Walter Roberson
on 8 Dec 2021
Suppose that somehow you were able to create a numeric-like matrix that you could do mathematics with, and yet displayed some elements as blanks/nothing. What mathematical properties should be blank/nothing have? For example should [blank*2,5] have the blank be treated as the empty vector, and empty times 2 is empty, and horzcat([], 5) is the scalar 5 ??
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!