How to delete rows that contain NaN in a table

Hello all,

So how do you delete all the rows that contain NaNs in a table (not a matrix or a cell array)? I have tried various versions of

 tableA(~any(~isnan(tableA), 2),:)=[];

but none work.

Thank you

[Image Analyst]

Make it easy for us to help you by suppling code to generate a table with nans in it. Then I can try some things. And do any of your columns contain anything other than numbers? Like strings or something?

Answer 1

[dpb]

If the table uses default missing values for the various types (see documentation for the various types; NaN is for numeric) then

tableA=tableA(~any(ismissing(tableA),2),:);

should do the trick. This will eliminate other variables that are missing besides numeric, too, of course, leaving only a complete table.

[sensation]

Hi,

I have tried this but got an error: Error using any Not enough input arguments.

I have first column as string and second is numeric with nan values sometimes inside. I want to get riw of those rows with nans.

thank you

[dpb]

Missing parens... ismissing(tableA) returns 2D logical, need any applied to it in 2d dimension to return the rows with missing value, then keep the complement.

Answer 2

[Peter Perkins]

If you have access to R2016b, you can use rmmissing .