Filtering Columns by Contents of Rows

1 次查看（过去 30 天）
Justin Delano
Justin Delano 2020-3-30
评论： Justin Delano 2020-3-30
I have arrays that look like this:
A =
1 NaN NaN
2 3 4
2 5 NaN
I want to remove columns that contain rows with less than n non-NaN entries. In this case, with n=2, the first column of A would be removed, since the first row contains only 1 non-NaN value. The resulting array would be:
A =
NaN NaN
3 4
5 NaN
Is there a compact way to do this? I hope this explanation makes sense!

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

回答（1 个）

Birdman
Birdman 2020-3-30
n=2;
A(:,(sum(~isnan(A),2)<n).')=[]
  3 个评论
显示 1更早的评论
Birdman
Birdman 2020-3-30
Try the following line for both cases:
n=2;
A(:,any(~isnan(A) & A<n,1))=[]
Justin Delano
Justin Delano 2020-3-30
For this new case, it removed the first column, as opposed to the third column, unfortunately.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Filter Banks 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by