How to split an array into smaller unequal-sized arrays dependend on array-column values

7 ビュー (過去 30 日間)
I have an array of 2 column and about 31,000 rows. One of the two columns depicts a spatial coordinate on a grid the other one a dependent parameter. What I want to do is the following:
I need to split the array into smaller parts defined by the spatial column; let's say the spatial coordinate are ranging from 0 to 500 - I now want arrays that give me the two column values for spatial coordinate 0-10, then 10-20 and so on. This would result in 50 arrays of unequal size that cover a spatial range from 0 to 500.
Thank you
  3 件のコメント
Adam
Adam 2019 年 8 月 15 日
You'd be better off keeping the data in a single array and just keep another array of row indices into the array, indicating where your splits are. 50 arrays is not good to work with for numerous reasons, especially dynamic naming.
vicsm
vicsm 2019 年 8 月 15 日
1 2
1 5
1 7
1 9
1 10
2 3
2 5
2 7
3 5
3 7
3 10
3 9
3 3
what I want is:
2 3 5
5 5 7
7 7 10
9 9
10 3

サインインしてコメントする。

採用された回答

Joel Handy
Joel Handy 2019 年 8 月 15 日
Histcounts can be used to pin the data the way you want.
[~,~,BIN] = histcounts(mainArray(:,1), 0:10:500)
subArray1 = mainArray(bin==1,2);
subArray2 = mainArray(bin==2,2);
.
.
.
subArray50 = main array(bin==50,2)
  2 件のコメント
Joel Handy
Joel Handy 2019 年 8 月 15 日
I don't think OP should necessarily create individual named variables. I would actually recommend indexing into their main array using the bin indexes as needed rather than actually splitting up the data, but I wanted to show them how they would do the indexing in as simple a manner as possible and to answer their direct question.

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeMatrix Indexing についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by