Finding Continuous missing values (NaN) from a matrix
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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?
0 Commenti
Risposte (2)
Andrei Bobrov
il 12 Feb 2018
Let A - your vector with nan's
out = sum(diff([0;isnsn(A(:))]) == 1)
0 Commenti
Jos (10584)
il 12 Feb 2018
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)
0 Commenti
Vedere anche
Categorie
Scopri di più su NaNs in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!