MATLAB: Sorting a cell array (text) in the order of a colperm solution

sort

Hello Community! I have a 21×1 cell array containing text in the format 'XYZ'. Its name is nNames. I also have a 1×21 double array from the solution of colperm(). Its name is sortB.

Now I would like to bring the Text array in the order of the colperm order. I tried without success:

namessort=sort(nNames,sortB)

Is there any possibility to do this sorting or at least to print a List or Table where I can bring the text and the order together. Possibly very stupid, but this table could be processed in EXCEL – sorry for this.

Do you have a suggestion?

Best Answer

namessort=nNames(sortB);

Does this gives what you want? If not, sorry but I haven't understood what you want to do.

To display a table with the text of your cell and the order provided by sortB:

sortB = sortB';
myTable = table(nNames,sortB)

Related Solutions

MATLAB: Bucket sort on cell array of vectors

c1 = {[1 2] [10 11];[2 3] [10 11];[1 2] [11 12]; [2 3] [11 12]};
c2 = table2cell(sortrows(cell2table(c1)))

Note that you haven't defined in the question how you order vectors. The above uses lexicographical ordering.

It's unfortunate that sortrows on cell array only work with scalar cell (unless the cells are all of type char), hence the conversion to table and back.

MATLAB: Existing table, populate a column with string (receiving errors)

You are close, but you are trying to assign a character vector to a double variable (NaN = not a number). You can see that if you run the command summary(mytable).

You also do not need to put the text into a cell if you use the string data type.

See if you can get this code to work for your needs.

myArray = nan(5,2)
mytable = array2table(myArray);
mytable.Properties.VariableNames = {'colA', 'colB'};
mytable2 = convertvars(mytable,"colB",'string');
mytable2.colA(:) = 459;
mytable2.colB(:) = "words"

You say you have a lot of data. If the variables already exist, you could do something like this:

colA = nan(5,1);
colB = strings(5,1);
mytable = table(colA,colB);
mytable.colA(:) = 459; % just a random number, proof-of-concept that it works
mytable.colB(:) = "words" % this throws errors

Best Answer

Related Solutions

MATLAB: Bucket sort on cell array of vectors

MATLAB: Existing table, populate a column with string (receiving errors)

Related Question