How to delete rows that contain NaN in a table

Question

012786534 2017-2-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/323274-how-to-delete-rows-that-contain-nan-in-a-table

评论： dpb 2017-6-12

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Image Analyst 2017-2-3

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 2017-2-3

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/323274-how-to-delete-rows-that-contain-nan-in-a-table#answer_253273

编辑：dpb 2017-6-12

在 MATLAB Online 中打开

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.

2 个评论
显示无隐藏无

sensation 2017-6-12

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 2017-6-12

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.

请先登录，再进行评论。