Delete rows with NaN for a cell array

2013 6 26
2 个回答
回答已采纳
更新时间：2021 4 21
6 次查看（30 天）

0 个投票

I want to remove the rows that have NaN and still keep the dimension of the array intact.
[ NaN] [ NaN] [ NaN] [ NaN]
[ NaN] [ NaN] [ NaN] [ NaN]
'Total RADIO Drops' 'Total Drops' 'CC DCR (%)' 'RADIO DCR (%)'
Above is just an example, I have over a thousand rows.
The only problem I have now is removing rows which have NaN and string together
Thank you

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

Rooy
Rooy 2013-6-26
Is there a way to delete the rows which have strings and Nan mixed together ?
[ 'A'] [ NaN] [ NaN] [ NaN]
'Total RADIO Drops' 'Total Drops' 'CC DCR (%)' 'RADIO DCR (%)'

请先登录，再进行评论。

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

 采纳的回答

更多回答（1 个）

Andrei Bobrov
Andrei Bobrov 2013-6-26
编辑：Andrei Bobrov 2013-6-26

2 个投票

A - your cell array
out = A(any(cellfun(@(x)any(~isnan(x)),A),2),:);
ADD
out = A(all(cellfun(@(x)any(~isnan(x)),A),2),:);

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Rooy
Rooy 2013-6-26
That works thank you, is there a way to delete the rows which have strings and Nan mixed together ?
Andrei Bobrov
Andrei Bobrov 2013-6-26
see ADD part in my answer
Rooy
Rooy 2013-6-26
Thank you for your great help
YING CONG XIAO
YING CONG XIAO 2021-4-21
hi Andrei,
how to specify the range in this fun:
out = A(any(cellfun(@(x)any(~isnan(x)),A),2),:);

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by