find function exceeds matrix dimensions?

Question

0 个投票

I'm trying to remove rows that contain Nans in two columns of a dataset. The dataset itself is 9895 x 26, but when I run the following code,

hh1 = hh1(~isnan(hh1(:, 19:20)),:);

it returns 'Index exceeds matrix dimensions' Further investigation revealed that when I run

find(~isnan(hh1(:, 19:20)))

it returns values ranging from 7037 to 19790, which is a problem because, as previously mentioned, the size of the dataset is only 9895 x 26.

Any idea what's going on?

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

Answer 1

Azzi Abdelmalek 2016-7-31

编辑：Azzi Abdelmalek 2016-7-31

0 个投票

Depending on what you want, if the two columns should be equal to nan

hh1 = hh1(~all(isnan(hh1(:,19:20)),2),:)

%or if at least one column is equal to nan

hh1 = hh1(~any(isnan(hh1(:,19:20)),2),:)

Sarah Goldsmith 2016-7-31

Yes, thanks! The second one is what I was looking for!