How to find the lowest and highest rows in a column vector which contain a value.
1 回表示 (過去 30 日間)
古いコメントを表示
So, I have a 20x1 vector (A) shown below. How would I find the row number for the lowest and highest row that contain a value? In the vector below the lowest would be row 6, and the highest would be row 17. Thanks.
A =
NaN
NaN
NaN
NaN
NaN
1
1
1
NaN
NaN
NaN
1
1
1
NaN
NaN
1
NaN
NaN
NaN
0 件のコメント
採用された回答
Akira Agata
2018 年 1 月 31 日
idx = ~isnan(A);
lowestRow = min(find(idx));
highestRow = max(find(idx));
5 件のコメント
Jos (10584)
2018 年 1 月 31 日
You also forgot the for-loop counter
for K = lowestRow:highestRow
if ~isnan(A(K))
disp(K)
end
end
However,
tf = ~isnan(A)
disp( A(tf) )
would almost do the same and is much more efficient
その他の回答 (1 件)
Jos (10584)
2018 年 1 月 31 日
idx = ~isnan(A);
lowestRow = find(idx, 1, 'first')
highestRow = find(idx, 1, 'last')
参考
カテゴリ
Help Center および File Exchange で Logical についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!