I have "teste1" cell array column with values from 0 to 5. I want to separate the rows by number (0, 1, 2, 3, 4, 5) into the respective new cell array. How can I proceed?
1 次查看(过去 30 天)
显示 更早的评论
A new cell with 0's, another one with 1's, and so on..
However, it would be even better if the rows would not change position in the new cells. Like, if the first 0 is in row 1567, in the new cell this value should appear on the same row positio and not in the first row. How can I do this?
4 个评论
Walter Roberson
2016-11-1
You wrote,
"Like, if the first 0 is in row 1567, in the new cell this value should appear on the same row positio and not in the first row"
So row 1567 needs to appear in row 1567 of the cell that is devoted to containing the values with 0. In that cell, what should appear in rows 1 to 1566, since those corresponded to rows with a different value? What should appear in row 1567 of the cells devoted to 1, to 2, to 3, and so on?
采纳的回答
Walter Roberson
2016-11-1
colvals = cell2mat(YourCellArray(:,TheAppropriateColumnNumber));
EmptyCellArray = cell(size(YourCellArray));
NewCell = cell(1,6);
for K = 0 : 5
temp = EmptyCellArray;
mask = colvals == K;
temp(mask) = YourCellArray(mask, :);
NewCell{K+1} = temp;
end
Now, NewCell{J} corresponds to column value J-1, and will be a cell array in which the row entries are all empty for the rows where the column value was not J-1 and will copy the row if the column value for the row is J-1 .
This is necessary in order to keep each row at its same location in the destination array.
I suspect this is not what you actually want. I suspect that you want to do the equivalent of sorting by the column value, with all the entries for the same value kept in the same relative order. If that is what you want then,
colvals = cell2mat(YourCellArray(:,TheAppropriateColumnNumber));
[~, sortidx] = sort(colvals, 'stable');
NewCell = YourCellArray(sortidx, :);
6 个评论
Walter Roberson
2016-11-2
>> 0
ans =
0
>> '0'
ans =
0
Notice the difference in spacing.
You can also use class()
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!