MATLAB: Reordering variables in a table array

table array

Let's say I have the table below. I want to reorder them by their ages. I tried to use

TSort.Age = sort(TSort.Age)

but it doesn't work because it only sorts the numbers and the corresponding elements remain at the same place.

TSort =

5×6 table

LastName Age Smoker Height Weight BloodPressure

_________ ___ ______ ______ ______ _____________

'Sanchez' 38 true 71 176 124 93

'Johnson' 43 false 69 163 109 77

'Li' 41 true 64 131 125 83

'Diaz' 40 false 67 133 117 75

'Brown' 49 true 64 119 122 80

Best Answer

sortrows() %?

Related Solutions

MATLAB: Sorting a table with strings and numbers

Use readtable() to read in the workbook

T = readtable(fullXlsFileName);

Then use sortrows() to sort the table based on the column with strings in it. Let's say that the column with strings is the first column, like in the example below. Then you'd just do:

LastName = {'Smith';'Johnson';'Williams';'Jones';'Brown'};
Age = [38;43;38;40;49];
Height = [71;69;64;67;64];
Weight = [176;163;131;133;119];
BloodPressure = [124 93; 109 77; 125 83; 117 75; 122 80];
% Create a table, T, as a container for the workspace variables.
T = table(LastName, Age,Height,Weight,BloodPressure)
% Sort rows by last name.
sortedTable = sortrows(T, 1)

In the command window, you'll see the unsorted table first, followed by the sorted table:

T = 
     LastName     Age    Height    Weight    BloodPressure
    __________    ___    ______    ______    _____________
    'Smith'       38     71        176       124     93   
    'Johnson'     43     69        163       109     77   
    'Williams'    38     64        131       125     83   
    'Jones'       40     67        133       117     75   
    'Brown'       49     64        119       122     80   
sortedTable = 
     LastName     Age    Height    Weight    BloodPressure
    __________    ___    ______    ______    _____________
    'Brown'       49     64        119       122     80   
    'Johnson'     43     69        163       109     77   
    'Jones'       40     67        133       117     75   
    'Smith'       38     71        176       124     93   
    'Williams'    38     64        131       125     83

MATLAB: Table row not selecting

You need to define LastName. How should your program know what it is? It's not a built in function or anything.

Best Answer

Related Solutions

MATLAB: Sorting a table with strings and numbers

MATLAB: Table row not selecting

Related Question