필터 지우기
필터 지우기

Detect NaN from table

조회 수: 131 (최근 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
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 CenterFile Exchange에서 Logical에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by