How to find NaN values in a cell array.
196 views (last 30 days)
Show older comments
Thirunavukkarasu Yadav
on 30 Dec 2016
Commented: Image Analyst
on 8 Jul 2017
This is my data:
a = {'raja' 'I' 76 56 NaN;'bala' 'R' 12 7 56;'kavi' NaN 56 5 12}
X = find(isnan(a));
I got
??? undefined function or method 'isnan'
for input arguments of type 'cell'.
0 Comments
Accepted Answer
Image Analyst
on 30 Dec 2016
Try this to examine columns 2 onwards:
a = {'raja' 'I' 76 56 NaN;'bala' 'R' 12 7 56;'kavi' NaN 56 5 12}
b = cell2mat(cellfun(@isnan, a(:, 2:end), 'UniformOutput', false))
You'll see:
a =
3×5 cell array
'raja' 'I' [76] [56] [NaN]
'bala' 'R' [12] [ 7] [ 56]
'kavi' [NaN] [56] [ 5] [ 12]
b =
3×4 logical array
0 0 0 1
0 0 0 0
1 0 0 0
3 Comments
Image Analyst
on 8 Jul 2017
Well, you can start from the first column (not line as you said), if you want to check the names for nans.
More Answers (1)
the cyclist
on 30 Dec 2016
Edited: the cyclist
on 30 Dec 2016
Here is one way:
find(cell2mat(cellfun(@(x)any(isnan(x)),a,'UniformOutput',false)))
I had to stick the "any" command in there to deal with the strings, but I think this still does what you intend.
0 Comments
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!