How to find the given index values in a array?
1 回表示 (過去 30 日間)
古いコメントを表示
I have a matrix having 17 rows and 41 colums (find the attachment)
How to find the values at the top from 2nd column to last column with respect to the first column corresponing values
0 件のコメント
採用された回答
Andrei Bobrov
2019 年 4 月 25 日
in R2016b
T = readtable('Sheet2.xls','ReadVariableNames',0);
lo = T{:,2:end} ~= 0 & ~isnan(T{:,2:end});
[ii,~] = find(lo);
out = sortrows([T{:,2:end}(lo),T{:,1}(ii)],2);
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Startup and Shutdown についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!