How to extract rows given multiple ranges

10 ビュー (過去 30 日間)
Jacob Ebilane
Jacob Ebilane 2022 年 5 月 30 日
編集済み: KSSV 2022 年 5 月 30 日
So i have a dataset and I'm trying to downsize it, I have data sorted and have extracted the row indeces required to downsize the dataset while maintaining an almost equal amount of samples per class.
Here are the the specified rows. The dataset has 500,000 samples, using these rows downsizes it to about 120,000. I just want to know what I can to extract these from the original dataset keeping all the columns.
[0:5000,34586:39586,72961:77961,107165:112165,142309:147309,175845:180845,207262:212262,241495:246495,277250:282250,311197:316197,345045:350045,351453:354453,355332:359332,359895:362895,363048:365048,365517:370517,373755:378755,398739:403739,408560:413560,421163:425163,425859:427859,428631:433631,438809:443809,447548:452548,462867:467867,474286:476286,477036:479036,480031:485031,498294:500294]

採用された回答

KSSV
KSSV 2022 年 5 月 30 日
編集済み: KSSV 2022 年 5 月 30 日
If you have the indices of rows idx, you can just use
iwant = A(idx,:) ; % where A is your matrix and idx are the row indices
to extract the rows from A wih all the columns.
Note: MATLAB indexing start from 1 and indices should be positive integers or logicals.
In your case, the first number: 0:5000 should be 1:5000.
% EXample
A = magic(10) % dummy data for demo
A = 10×10
92 99 1 8 15 67 74 51 58 40 98 80 7 14 16 73 55 57 64 41 4 81 88 20 22 54 56 63 70 47 85 87 19 21 3 60 62 69 71 28 86 93 25 2 9 61 68 75 52 34 17 24 76 83 90 42 49 26 33 65 23 5 82 89 91 48 30 32 39 66 79 6 13 95 97 29 31 38 45 72 10 12 94 96 78 35 37 44 46 53 11 18 100 77 84 36 43 50 27 59
idx = [1 3 5 7] ; % extrcat these rows from A
iwant = A(idx,:)
iwant = 4×10
92 99 1 8 15 67 74 51 58 40 4 81 88 20 22 54 56 63 70 47 86 93 25 2 9 61 68 75 52 34 23 5 82 89 91 48 30 32 39 66

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeMatrices and Arrays についてさらに検索

タグ

製品


リリース

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by