MATLAB: Sort table by two columns using column name

column namesmultiplesorttable

Hello!

I can sort a table with: sortrows(tableName, 'columnName1').

I can also sort the same table by 2 columns using: sortrows(tableName,[columnNumber1 columnNumber2])

How can I sort the table by 2 columns using column name?

The following does not work: sortrows(tableName, ['columnName1' 'columnName2']). I get an error saying "unrecognized variable name 'columnName1ColumnName2'.

Thanks in advance!

Best Answer

Use curly braces. From the doc page for sortrows

sortrows(tblA,{'Height','Weight'})

Use square brackets if you want to use indexing to specify the columns

sortrows(tblA,[1 4])

Related Solutions

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

MATLAB: New column to a table with the dynamic name

Yourtable.(expression) = value

The () are part of the syntax.

Best Answer

Related Solutions

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

MATLAB: New column to a table with the dynamic name

Related Question