Extracting rows from a matrix based on values in columns
1 次查看(过去 30 天)
显示 更早的评论
Following on from this question
I have a large number of conditions lets say i needed 28 different values in the columns to find, how would i do that without finding the indices in 28 different lines, not sure how to do the for loop? :/
0 个评论
回答(1 个)
Stephen23
2016-5-8
编辑:Stephen23
2016-5-8
A = [3, 0.1234;
1, 0.1345;
1, 0.1456;
2, 0.1567;
1, 0.1678;
1, 0.1789];
C = accumarray(A(:,1),A(:,2),[],@(n){n});
Which places each collection into one cell of cell array C:
>> C
C =
[4x1 double]
[ 0.1567]
[ 0.1234]
>> C{1}
ans =
0.1345
0.1456
0.1678
0.1789
This will automatically create as many cells as needed in one output variable C. You need to use cell array indexing to access the contents of the cells of C. Note that you should not attempt to create 28 separate variables and access them dynamically in a loop: this is very poor programming practice (sadly much loved by beginners, who think it is great) that is slow, buggy, and obfuscated:
2 个评论
Maria445
2017-10-8
What if I have more than 1 column? That is, I want A to be a 6-by-4 matrix for example, so to have C{1} = 4-by-3 matrix?
Stephen23
2017-10-16
@Maria445: make the second input to accumarray the row indices, and change the anonymous function to use those indices to extract the required rows:
>> R = 1:size(A,1);
>> C = accumarray(A(:,1),R.',[],@(r){A(r,:)})
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!