Dropping NaN observations from Matrix
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (2)
Walter Roberson
am 23 Jan. 2019
With R2016b or later see https://www.mathworks.com/help/matlab/ref/rmmissing.html
0 Kommentare
Kevin Phung
am 23 Jan. 2019
Bearbeitet: Kevin Phung
am 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 Kommentare
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!