# copying matrix values based on a specific value in another column

2 views (last 30 days)
okoth ochola on 20 Jan 2023
Commented: Jiri Hajek on 20 Jan 2023
Hello, suppose we have A=[1 1 1 1 2 2 2 2 3 3 3 3]' and B=[3 4 6 7 8 9 0 12 4 5 6 8]', so that C=[A B]. Is there a way I can copy all element values in column 2 corresponding to say all 1 in column 1 then put them in another matrix? The actual matrices am dealing are much much larger than what have given above there. Basically I want to extraxt values from column 2 corresponding to specific values in column 1 for larger matrix.
##### 0 CommentsShow -1 older commentsHide -1 older comments

Sign in to comment.

### Accepted Answer

Jiri Hajek on 20 Jan 2023
Hi, for this, se use logical indices in MATLAB:
A=[1 1 1 1 2 2 2 2 3 3 3 3]'; B=[3 4 6 7 8 9 0 12 4 5 6 8]'; C=[A B];
selectedRowsLogicalIndices = A == 1;
subsetBdata = B(selectedRowsLogicalIndices)
subsetBdata = 4×1
3 4 6 7
##### 2 CommentsShow 1 older commentHide 1 older comment
Jiri Hajek on 20 Jan 2023
You can use all logical operators in the expression, where you define logical indices. Also, note that dates (datetime class) can be compared using <, > operators, so it should be straightforward. So there is no need to convert dates to a different class (e.g. double).

Sign in to comment.

### Categories

Find more on Logical in Help Center and File Exchange

R2016a

### Community Treasure Hunt

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

Start Hunting!