How to find the given index values in a array?

1 view (last 30 days)
Manoj
Manoj on 25 Apr 2019
Commented: Manoj on 25 Apr 2019
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

Sign in to answer this question.

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 25 Apr 2019
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);

More Answers (0)

Categories

Find more on Startup and Shutdown in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!