Finding which rows in table contain NaN, save those as new table
95 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
new2matlab
am 6 Feb. 2020
Kommentiert: David Ebert
am 3 Okt. 2022
Im looking to find a way to figure our which rows contain a 'NaN' in column 5, and then save all of those that do as a new table
1 Kommentar
Akzeptierte Antwort
Guillaume
am 6 Feb. 2020
Assuming your input is a table:
nantable = yourtable(isnan(yourtable{:, 5}), :) %keep all rows whose 5th column is nan
0 Kommentare
Weitere Antworten (1)
Adam Danz
am 6 Feb. 2020
Bearbeitet: Adam Danz
am 7 Feb. 2020
If the tables all contain the same variable names (headers), use the variable names to index columns rather than column number. This is one of the strengths of tables over matrices and cell arrays. If the variable names are different, then you'll have to use numeric indexing.
Suppose column 5 is named "MyData" and the table is named "T".
nanIdx = isnan(T.MyData);
% If you must use numeric indexing,
% nanIdx = isnan(T{:,5});
Create the new table
Tnew = T(nanIdx,:);
2 Kommentare
Siehe auch
Kategorien
Mehr zu Tables 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!