How to separate a data in this way?

Question

Yunseo Choi 2018-8-7

评论： KSSV 2018-8-7

For example, if I have a data like this

what I want is - if I look at the first column,

since 0<(1,1)=0.9370 = print a=1, b=1 and 2<(2,1),(3,1)<3 = >print a=2, b=3

....

like this so that I can get a matrix of

A= coordinate(a:b,:)

How can I do this?

Answer 1

KSSV 2018-8-7

Let C be you column in which you want to seek the indices.

idx = C<1 ;   % this is logical indesing, this gives numbers in C less than 1
idx = find(C) ; % this gives you the location you want.

Yunseo Choi 2018-8-7

Then How can I get a A = coordinate(a:b,:) of every data as using for and if statement same as above condition?

KSSV 2018-8-7

[A,txt,raw] = xlsread('coordinate.xlsx') ;   % read file 
iwant = A(A(:,1)<12,:)            % This gives the data for first column less then 12