How do I find the number of occurrences of NaN and the corresponding subscripts in an array

Question

Ms. Mat 2013-1-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/58359-how-do-i-find-the-number-of-occurrences-of-nan-and-the-corresponding-subscripts-in-an-array

A = NaN 100 101 102 103 104
2   7   3   2   2 
NaN 8   4   5   6
NaN NaN 2   3   5
3   4   2   6   4

I have a matrix with the first row and first column being headers. I would like to know the no. occurences and subscripts on NaN.

To find no. of occurences, I did

number_of_nan = sum(sum(isnan(A(2:end,2:end))))

Also,

    logical_array = isnan(A(2:end,2:end));
    numel(logical_array(logical_array == 1));

Is there a simpler/better way. Also how do I find the subscripts of the NaN elements in the array ?

2 个评论
显示无隐藏无

José-Luis 2013-1-9

What do you mean by subscripts? The linear indexes or the row and column position? The indices relative to what? To the entire array or to the array without column and headers?

Ms. Mat 2013-1-9

编辑：Ms. Mat 2013-1-9

在 MATLAB Online 中打开

I would like to know the row and column position. For the given example matrix A,

202, 100
203, 100
203, 101

or

3, 2
4, 2
4, 3

Thank You

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

José-Luis 2013-1-9

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/58359-how-do-i-find-the-number-of-occurrences-of-nan-and-the-corresponding-subscripts-in-an-array#answer_70612

编辑：José-Luis 2013-1-9

在 MATLAB Online 中打开

Another option:

 logical_array = A(2:end,2:end) ~= A(2:end,2:end)
 num_NaN = sum(logical_array(:));
 idx = find(logical_array); %I am not sure this is what you want, please see my comment to your question

EDIT so that was not what your wanted after all. For that:

To get row and column position, according to the header:

 logical_array = A(2:end,2:end) ~= A(2:end,2:end)
 idx = find(logical_array); 
 [dim(1) dim(2)] = size(A);
 [ii,jj] = ind2sub(dim-1,idx);
 your_position = [A(ii+1,1) A(1,jj+1)'];