Dropping NaN observations from Matrix
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hey There.
So i have a matrix that has a person ID for the first column, then data in the rows for each. What i need to do is i have identified that there are some observations that are NaN, so i need to write a code that identifies which person ID have NaN observations, so that i can drop those observations from the data.
Any help could be appreciated
0 commentaires
Réponses (2)
Walter Roberson
le 23 Jan 2019
With R2016b or later see https://www.mathworks.com/help/matlab/ref/rmmissing.html
0 commentaires
Kevin Phung
le 23 Jan 2019
Modifié(e) : Kevin Phung
le 23 Jan 2019
if you had a matrix A and wanted to search for NaNs in each row
nanRows =[];
for i = 1:size(A,1)
if any(isnan(A(i,:))) % for each row, if any of the elements contain a NaN
nanRows(i) = i;% store that index
end
end
A(nanRows,:) = []; %remove those IDs from your matrix
if your matrix is of cell arrays, then replace parentheses with {}.
edit: before you run A(nanRows,:) =[] , you can check which IDs had Nans with just A(nanRows,1)
2 commentaires
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!