Detect NaN from table

92 次查看（过去 30 天）
Daphne PARLIARI
Daphne PARLIARI 2021-5-24
评论： Daphne PARLIARI 2021-5-24
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

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

回答（1 个）

KSSV
KSSV 2021-5-24
A = [1 2 NaN 5 NaN] ;
idx = isnan(A) ;
A(idx)
  5 个评论
显示 3更早的评论
KSSV
KSSV 2021-5-24
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
Daphne PARLIARI 2021-5-24
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by