MATLAB: How concatenate two tables in MATLAB

concatenate tables

I have two tables with no variables in common, with the same number of rows and with different number of columns. For example:

      Age    Height    
      ___    ______    
       38      71        
       43      69

and the table:

 Weight    Blood
 ______    ______
  176       124     
  163       109

How can I get:

 Age    Height    Weight    Blood
 ___    ______    ______    _____
  38     71        176       124    
  43     69        163       109

Thanks!

Best Answer

Adriano, to horizontally concatenate anything in MATLAB, you would probably just use square brackets, right? Such as AB = [A B]. Same for tables. cat and horzcat provide a functional form of that, but the standard MATLAB way is brackets.

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: Reordering variables in a table array

sortrows() %?

Best Answer

Related Solutions

MATLAB: Sorting a table with strings and numbers

MATLAB: Reordering variables in a table array

Related Question