Removing all-NaN Rows/Columns from Cell Matrix?

1 次查看（过去 30 天）
John R.
John R. 2014-8-26
评论： John R. 2014-8-26
Let's say I have the following cell matrix that contains NaN's, numbers, and strings...
A = {...
0 2 'All' NaN NaN 2
NaN NaN NaN NaN NaN NaN
NaN NaN 'Yes' NaN NaN 1};
Is there an easy way to identify the rows and columns that contain all NaN's? In this example, I would like to remove row 2, and then columns 4 and 5. The result would be...
B = {...
0 2 'All' 2
NaN NaN 'Yes' 1};
I have brute-forced it by checking every value, but I'm sure there is a more methodical approach using cellfun perhaps. My method took 30 lines but I'm guessing there it can be done in just a few lines.
Thanks!

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2014-8-26
A = { 0 2 'All' NaN NaN 2
NaN NaN NaN NaN NaN NaN
NaN NaN 'Yes' NaN NaN 1}
idx=cellfun(@(x) all(isnan(x)),A)
ii=all(idx,2)
jj=all(idx)
A(ii,:)=[]
A(:,jj)=[]

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by