erasing all the rows that begin with NaN

1 次查看（过去 30 天）

显示更早的评论

Sabbas 2012-7-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/43118-erasing-all-the-rows-that-begin-with-nan

采纳的回答： Andrei Bobrov

在 MATLAB Online 中打开

I have a cell matric.

The first two columns of this matrix are

           [1x28 char]    [          NaN]
    [             NaN]    [          NaN]
    'MART'              'TOTATRIA'
    'PREGORY'             'TOSTE'   
    [             NaN]    [          NaN]

My goal is to erase these rows which have as a first element NaN

In the above example I want to erase row2 and the last one

thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov 2012-7-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/43118-erasing-all-the-rows-that-begin-with-nan#answer_53017

在 MATLAB Online 中打开

just

out = A(~cellfun(@(x)all(isnan(x)),A(:,1)),:)

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

Sabbas 2012-7-9

it works!thnx

请先登录，再进行评论。

更多回答（2 个）

Thomas 2012-7-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/43118-erasing-all-the-rows-that-begin-with-nan#answer_53002

在 MATLAB Online 中打开

If A is your input cell matrix

out=cellfun(@isnan,A(:,1),'UniformOutput',false)
count=cellfun(@(x)any(x==1),out);
A(~count,:)

10 个评论
显示 8更早的评论隐藏 8更早的评论

Sabbas 2012-7-9

编辑：Sabbas 2012-7-9

it works for me when I choose the first two columns. But not when I use the whole matrix

Sabbas 2012-7-9

编辑：Sabbas 2012-7-9

I used

count=cellfun(@(x)any(x==1),out);

A(count==1,:)=[]

and it seems to work

could you plese verify that the code is equivalent to the one you provided?

thanks

请先登录，再进行评论。

Jan 2012-7-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/43118-erasing-all-the-rows-that-begin-with-nan#answer_53035

编辑：Jan 2012-7-9

在 MATLAB Online 中打开

A(cellfun(@(x) isequalwithequalnans(x, NaN), C), :)