Sorting a cell array
조회 수: 1 (최근 30일)
이전 댓글 표시
Hello, I have the following cell(data, 1x3):
data = [data{1} data{2} data{3}]
data{1} data{2} data{3}
A 15 1400
A 3 250
B 10 1100
C 13 1350
B 7 600
Now I would like to sort the data and make a new cell as follows:
newcell = [newcell{1} newcell{2} newcell{3}]
newcell{1} newcell{2} newcell{3}
A [15; 3] [1400; 250]
B [10; 7] [1100; 600]
C [13] [1350]
In other words, I want to sort and save the data of a cell with respect to A, B and C. Would you please show me how to do that with or without using for loop etc?
Thanks in advance.
댓글 수: 2
채택된 답변
Guillaume
2015년 6월 17일
data = {'A' 15 1400; 'A' 3 250; 'B' 10 1100; 'C' 13 1350; 'B' 7 600}
[header, ~, row] = unique(data(:, 1));
catcol = @(col) arrayfun(@(r) [data{r == row, col}], 1:numel(header), 'UniformOutput', false)';
newcell = [header, catcol(2), catcol(3)]
would be one way to do it without a loop. It could be made even more generic with an additional arrayfun looping over the columns, but at this point, you'd be better off using a for loop to make it clearer.
댓글 수: 3
Guillaume
2015년 6월 17일
[header, ~, row] = unique(data(:, 1));
newcell = [header, cell(numel(header), size(data, 2)-1)];
for r = 1:numel(header)
for c = 2:size(data, 2)
newcell{r, c} = [data{r == row, c}];
end
end
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Logical에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!