Finding the position of a cell within a Matrix

Hello Fellow Developer,

i have been given a 100x13 Matrix with Integers in it. But in one cell there is NaN written in it.

I know that the cell with NaN is in column two, so I tried the following code: But my Variable k never changes to one.

for i=1:100
    if Matrix(i, 2) == 'NaN'
        k = 1
    end
end

Answer 1

[KSSV]

Read about isnan.

idx = isnan(Matrix(:,2)) ; 
Matrix(idx,:)
% To get the rows 
rows = find(idx)

[Charnkamal Bhogal]

It works!

Thank you very much Sir!

Answer 2

[Ameer Hamza]

isnan() is used to detect nan. You can write your code without for-loop

k = any(isnan(Matrix(:,2)))

[Charnkamal Bhogal]

The Problem is, that I am trying to find the row in which NaN is written.

I already know that the column is the second

[madhan ravi]

Rows = find(k)

[Ameer Hamza]

If you want to find the row, then something like this will work

idx = find(isnan(Matrix(:,2)))

[Charnkamal Bhogal]

@Ameer Hamza, @madhan ravi, @Jake Bowd

Thanks for your replys

Answer 3

[Jake Bowd]

Hi,

Could you use the following?

m = ; % whatever the matrix is called.

[row, column] = find(m == NaN)

[Charnkamal Bhogal]

I could not use that, because I have loaded the Matrix from a .mat file

[Jake Bowd]

Arrhh I see :).