Find column where one value is NaN
35 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
更多回答(1 个)
KALYAN ACHARJYA
2019-11-19
编辑:KALYAN ACHARJYA
2019-11-19
"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 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!