Remove rows with NaN from a table

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.

Answer 1

[Paolo]

Use rmmissing :

 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

[Jonathan Beard]

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]

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.

Answer 2

[Walter Roberson]

T( any(ismissing(T),2), :) = [];

[alpedhuez]

rmmissing

[Paolo]

What does your comment mean? Both solutions work fine and solved your problem. Please mark any answer as accepted.

[Walter Roberson]

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]

Walter thanks:

For some reason, Pablo's answer didn't work on my data which had mixed data types, but yours did.