How to find corresponding indices?

8 views (last 30 days)
Kendal
Kendal on 9 Nov 2022
Answered: Voss on 9 Nov 2022
Good Day,
I have a dataset I am working (891 rows,12 columns) with and have already sorted one column with zeros and ones (Logical). I would now like to pull data from 2 other columns (number and text) where the ones are located (neglecting the zeros). How can I write this in matlab?
TIA!

Answers (1)

Voss
Voss on 9 Nov 2022
% some data
data = [0 10]+(1:10).'
data = 10×2
1 11 2 12 3 13 4 14 5 15 6 16 7 17 8 18 9 19 10 20
% whether to get each row:
rows_to_get = [false; false; true; true; false; false; false; true; true; false]
rows_to_get = 10×1 logical array
0 0 1 1 0 0 0 1 1 0
% final result:
result = data(rows_to_get,:)
result = 4×2
3 13 4 14 8 18 9 19

Categories

Find more on Shifting and Sorting Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!