Split array according to one column values
77 ビュー (過去 30 日間)
古いコメントを表示
I have an array like this:
A = {10 1 1; 10 1 2; 10 1 1; 10 2 1; 10 1 3; 10 2 4; 10 2 5}
I want to split into arrays based on the second column value. The output should look like this:
B = {10 1 1; 10 1 2; 10 1 1; 10 1 3}
C = {10 2 1; 10 2 4; 10 2 5}
How can I do this ?
2 件のコメント
Jack Lavender
2022 年 8 月 22 日
What would you recommend if you have a large array and an unknown number of different values in the indexing column?
回答 (3 件)
Stephen23
2018 年 7 月 25 日
編集済み: Stephen23
2018 年 7 月 25 日
Your life would be much easier if you stored numeric data in numeric arrays:
>> A = [10 1 1; 10 1 2; 10 1 1; 10 2 1; 10 1 3; 10 2 4; 10 2 5]
A =
10 1 1
10 1 2
10 1 1
10 2 1
10 1 3
10 2 4
10 2 5
>> B = A(A(:,2)==1,:)
B =
10 1 1
10 1 2
10 1 1
10 1 3
>> C = A(A(:,2)==2,:)
C =
10 2 1
10 2 4
10 2 5
4 件のコメント
Steven Lord
2022 年 8 月 23 日
You could potentially also use groupsummary and use it to perform whatever operations you'd perform on the matrices stored in the cells of C.
LuKr
2018 年 7 月 25 日
B=A(cellfun(@(x) isequal(1,x),{A{:,2}}),:)
C=A(cellfun(@(x) isequal(2,x),{A{:,2}}),:)
Maybe like this?
0 件のコメント
Hermes Suen
2018 年 7 月 25 日
You should be able to do this through logical indexing, and it may be easier if it was not a cell array but a normal numerical array. Define the matrix as such, without the curly braces:
A = [10 1 1; 10 1 2; 10 1 1; 10 2 1; 10 1 3; 10 2 4; 10 2 5];
Then store the second column into a separate variable:
cols = A(:,2);
This takes the second column of the A matrix and stores it into a column vector called "cols". From there you can use logical indexing as follows:
ones = cols ==1;
twos = cols ==2;
The output of the above two commands should be this:
ones =
7×1 logical array
1
1
1
0
1
0
0
"Ones" will have a "1" whenever the column vector has a "1" and has a "0" whenever the column vector has anything other than a 1. The same logic then applies to the variable "twos"
From here you can then call the following two commands to get what you are looking for:
B = A(ones,:)
C = A(twos,:)
This is logical indexing, a neat feature of MATLAB, let me know if you need further clarification or if you have any questions!
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Data Type Conversion についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!