MATLAB: Sorting columns of cell Array

cell arraysMATLABsort

Hello,

I have a Cell Array of Data that is 144×12; it looks like this:

Now I would like to sort the columns by the value in row 7. At the end, what I would like is a Cell Array with the first column that has in row 7 'p1' and so on…

I will try to be more specific because maybe there's a clever way to obtain what I need…

In my data there are, for example, six columns that have the same value in row 7, but different values in row 6. Given that, I need to do some analysis on all the ones that have the same value in row 7, but taking as reference the one between them that have a certain value in row 6.

Can somebody help me please?

Thank you very much and best regards,

Manuel

Best Answer

Either download my FEX submission natsort:

https://www.mathworks.com/matlabcentral/fileexchange/34464-customizable-natural-order-sort

and then use it like this, where C is your cell array:

[~,idx] = natsort(C(7,:))
D = C(:,idx)

Or use sscanf to get the numeric values and then sort them:

[~,idx] = sort(sscanf([C{7,:}],'p%f'))
D = C(:,idx)

Related Solutions

MATLAB: Sorting 256*2 cell

Although the question is not very clear, I suspect that you might like to download and try my FEX submission natsortrows, which performs an alphanumeric sort on the rows of a cell array (of character vectors):

https://www.mathworks.com/matlabcentral/fileexchange/47433-natural-order-row-sort

Alternatively you can simply convert the first column to double and sort that, e.g. where |C| is your cell array:

V = str2double(C(:,1));
[~,X] = sort(V);
D = C(X,:)

Note that this method only sorts by the values in the first column, the values in the second column are not taken into account.

MATLAB: How to filter rows of a cell based on an empty column

Similarly to your previous question, the code will be like:

% 100x100 sample cell array with randomly located empty cells 
C = num2cell(randi(10,100,100));
idx = cellfun(@(x) isequal(x,3), C);
C(idx) = {''};
% Rows where the 8th column is empty
idx = cellfun(@isempty, C(:,8));
% Extract the target rows
C1 = C(idx,:);
% Others
C2 = C(~idx,:);

Best Answer

Related Solutions

MATLAB: Sorting 256*2 cell

MATLAB: How to filter rows of a cell based on an empty column

Related Question