Finding Continuous missing values (NaN) from a matrix

1 次查看（过去 30 天）
vedesh Mohit
vedesh Mohit 2018-2-12
回答： Jos (10584) 2018-2-12
Hey,
I have a matrix (133656x1) that contains hourly wind speeds for fifteen years with random and continuous missing points. I am only focused on the continuous section of the data and would like to know if there is a way to search through the matrix and count the amount of continuous NaN's in the matrix. can you help me?

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

回答（2 个）

Andrei Bobrov
Andrei Bobrov 2018-2-12
Let A - your vector with nan's
out = sum(diff([0;isnsn(A(:))]) == 1)
Jos (10584)
Jos (10584) 2018-2-12
I am not sure what you mean by " count the amount of continuous NaN's". Do you want know total number of NaN values in X? The number of sections with consecutive NaNs?
X = [1 2 3 NaN NaN 6 7 NaN 9 NaN NaN 12 13]
Q = isnan(X)
N_NaNs = sum(Q) % total number of NaNs in X (=5)
N_NaNsections = sum(diff([false Q])>0) % number of sections with consecutive NaNs (=3)

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by