Detect NaN from table

Hello! I would like your help on my issue.

I have an excel file (see attached) that contains daily pollution data from 2006-2016. For the columns B to H I would like to find NaN values for each column, sum them, and in the end, store all these in a new table.

So far I have done this for column B:

[ii jj] = find(isnan(MoT20062016S1.SO2gm3));
outij = sortrows([ii jj]);
length(outij)

How can I expand outij to include columns C to H?

Thanks in advance!

PS. I'm on R2019a

Answer 1

[KSSV]

A = [1 2 NaN 5 NaN] ; 
idx = isnan(A) ;
A(idx)

[Daphne PARLIARI]

Thank you KSSV.

Your answer could only work for one column. I am interested in assessing all 7 columns (B to H) and store the results in the new table outij.

[KSSV]

Run a loop for each column.

for i = 2:7
    t = T.(i)
end

[Daphne PARLIARI]

Could you please explain what those 3 lines do?

[KSSV]

It is a loop, which picks each column of table depedning on the loop index.

Are you looking for nansum? Read about it.

[Daphne PARLIARI]

Let me explain it this way:

Ideally, I want a table (see outij.xlsx attached) that will contain the 7 columns I want to assess, and each column will have saved the positions where a NaN was detected.

E.g. For SO2, the first NaN was detected at place 201 of the original table, the second NaN at position 202 etc.