finding consecutive NaN in matrix
16 views (last 30 days)
Show older comments
i have a vector like [1,2,3,4,NaN,NaN,NaN,7,8,9]. I want to find if there is 3 consecutive NaN present in the vector. i can go for loop but is there more direct and easy way to do that.
0 Comments
Accepted Answer
Cedric
on 9 Oct 2017
Edited: Cedric
on 9 Oct 2017
>> x = [1,2,3,4,NaN,NaN,NaN,7,8,9] ;
>> strfind( isnan(x), true(1,3) )
ans =
5
if you just need a "flag found", do it as follows:
>> found = ~isempty(strfind( isnan(x), true(1,3) ))
found =
logical
1
2 Comments
Tumelo Maja
on 17 Oct 2018
How would i apply this method to matrix? I want to find consecutive NaNs in columns of a matrix.
Image Analyst
on 18 Oct 2018
Apply it one column at a time
for k = 1 : size(m, 2)
thisColumn = m(:, k);
nanRows = isnan(thisColumn));
% Now do whatever you want to do with nanRows.
end
More Answers (1)
Image Analyst
on 9 Oct 2017
For a more general purpose function, use isnan() and regionprops() (in the Image Processing Toolbox). It will find all groupings of Nans no matter how long or short they are. You can also specify a size range for the groups if you want, like ignore nans that are only one element long or whatever. If you want this general purpose code, let me know. Otherwise Cedric's code using the handy but little known strfind() trick is great for your given example of 3 nans in a row.
2 Comments
Cedric
on 9 Oct 2017
To be honest, I would not have thought about using STRFIND on numbers had I not seen it first on Loren's blog back then.
Image Analyst
on 10 Oct 2017
Right, I mean who would have thought that a string function could work on numbers? It's not intuitive (that's why I called it a trick).
Anyway, in case anyone is interested, here is the general case that finds lengths and indexes for all the NaN regions in the vector:
m = [1,2,3,4,NaN,NaN,NaN,7,8,9,NaN,NaN,0,NaN,9,NaN,NaN,NaN,NaN] % Sample data
nanLocations = isnan(m) % Get logical array of whether element is NaN or not.
props = regionprops(nanLocations, 'Area', 'PixelIdxList'); % Find all the regions.
% DONE! Now let's print them out
for k = 1 : length(props)
fprintf('Region #%d has length %d and starts at element %d and ends at element %d\n',...
k, props(k).Area, props(k).PixelIdxList(1), props(k).PixelIdxList(end));
end
Here's what shows up in the command window:
m =
1 2 3 4 NaN NaN NaN 7 8 9 NaN NaN 0 NaN 9 NaN NaN NaN NaN
nanLocations =
1×19 logical array
0 0 0 0 1 1 1 0 0 0 1 1 0 1 0 1 1 1 1
Region #1 has length 3 and starts at element 5 and ends at element 7
Region #2 has length 2 and starts at element 11 and ends at element 12
Region #3 has length 1 and starts at element 14 and ends at element 14
Region #4 has length 4 and starts at element 16 and ends at element 19
See Also
Categories
Find more on Matrix Indexing 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!