Remove rows with NaN from a table
347 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I have a table T. T has some rows with NaN. I would like to remove any rows with NaN in any entry. Please advise.
0 Commenti
Risposta accettata
Paolo
il 13 Giu 2018
T = table([38;43;38;40;49],[71;NaN;64;67;64],[176;163;131;NaN;119])
T =
Var1 Var2 Var3
____ ____ ____
38 71 176
43 NaN 163
38 64 131
40 67 NaN
49 64 119
rmmissing(T) =
Var1 Var2 Var3
____ ____ ____
38 71 176
38 64 131
49 64 119
2 Commenti
Jonathan Beard
il 26 Apr 2019
This treats empty and nan equivalently. If you know the column that contains nans for which you want to remove the corresponding rows of you can use something like this.
T = T(find(~isnan(T.ColumnWithSomeNans)), :);
Walter Roberson
il 26 Apr 2019
Only numeric values can be nan (or not), and numeric values in a table cannot be empty: the table-reading process fills them in with a definite value (typically nan.)
You would need to go back to the original file (if it is text) or use activex or .NET talking to Excel in order to determine whether a location is empty rather than nan.
Più risposte (1)
Walter Roberson
il 13 Giu 2018
T( any(ismissing(T),2), :) = [];
4 Commenti
Walter Roberson
il 13 Giu 2018
rmmissing is good, and I did not know about it. I voted for Paolo's answer, but I left mine as an alternative solution.
Blake
il 19 Set 2019
Walter thanks:
For some reason, Pablo's answer didn't work on my data which had mixed data types, but yours did.
Vedere anche
Categorie
Scopri di più su Text Files in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!