MATLAB Answers

0

Find column where one value is NaN

Asked by Martin Holding on 19 Nov 2019 at 15:59
Latest activity Answered by Stephan
on 19 Nov 2019 at 16:09
Hi,
I have a long matrix containing 2 rows and many thousands of columns. The values are either 0.5 or NaN. I want to be able to locate any columns where only the second row is equal to NaN and the first row is equal to 0.5. For example the matrix:
a = [0.5, NaN, 0.5, 0.5, 0.5;
0.5, NaN, 0.5, NaN, NaN]
should return the indices [4, 5].
Is this possible using some variation of the find function? I can use find to locate the columns where both rows are equal to either 0.5 or NaN but I can't figure out how to do it where one row is 0.5 and one row isn't. If it isn't possible using find what is the most succint way of achieving this?
Thanks,
Martin

  0 Comments

Sign in to comment.

Products


Release

R2019b

2 Answers

Answer by Stephan
on 19 Nov 2019 at 16:09
 Accepted Answer

res = find(~isnan(a(1,:)) & isnan(a(2,:))==1)

  0 Comments

Sign in to comment.


Answer by KALYAN ACHARJYA on 19 Nov 2019 at 16:07
Edited by KALYAN ACHARJYA on 19 Nov 2019 at 16:07

"Find column where one value is NaN"
a=[0.5, NaN, 0.5, 0.5, 0.5;
0.5, NaN, 0.5, NaN, NaN];
[r,c]=find(isnan(a));
col_data=setdiff(c,r)

  0 Comments

Sign in to comment.