get rid of NaNs

2012 6 7
3 个回答
回答已采纳
12 次查看（30 天）

0 个投票

I have two matrix A and B I want to remove all row and columns with all NaNa in matrix A and accordingly delete the same row and column in B:
A( all( isnan( A ), 2 ), : ) = []; % removes all rows with all nans
A( :, all( isnan( A ), 1 ) ) = []; % and columns
this remove all row and column with all NaNs, But I want to remove the exact row and column from B, too, here is an example:
>> A=[1 2 3 NaN NaN 5 6 7];
>> B=[1 2 3 4 5 6 7 8]; I want the B as below:
B=[1 2 3 6 7 8];
Thanks in advances!

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

 采纳的回答

per isakson
per isakson 2012-6-7

1 个投票

rows_to_be_removed = all( isnan( A ), 2 ),
A(rows_to_be_removed,:)=[];
B(rows_to_be_removed,:)=[];
etc.
Given that A and B have the same size.

更多回答（2 个）

Thomas
Thomas 2012-6-7

1 个投票

A=[1 2 3 NaN NaN 5 6 7];
B=[1 2 3 4 5 6 7 8];
check=find(isnan(A));
B(check)=[]
Andrea
Andrea 2012-6-7

0 个投票

actually it was an simple example. But I want to remove rows with all NaNa and then remove the same rows from another matrix accordingly.

类别

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

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by