table2array

Convert table to homogeneous array

Syntax

A = table2array(T)

Description

A = table2array(T) converts the table, T, to a homogeneous array, A.

Examples

Convert Table of Numeric Data to Array

Create a table, T, consisting of numeric data.

T = table([1;2;3],[2 8; 4 10; 6 12],[3 12 21; 6 15 24; 9 18 27],...
    'VariableNames',{'One' 'Two' 'Three'})

T=3×3 table
    One      Two          Three    
    ___    _______    _____________

     1     2     8    3    12    21
     2     4    10    6    15    24
     3     6    12    9    18    27

Convert table, T, to an array.

A = table2array(T)

A = 3×6

     1     2     8     3    12    21
     2     4    10     6    15    24
     3     6    12     9    18    27

A contains two columns from variable Two and three columns from variable Three.

Convert Numeric Subset of Table to Array

Define the numeric subset of a table to convert to an array.

Create a table with nonnumeric data in the first variable.

T = table(categorical({'M';'M';'F';'F';'F'}),[38;43;38;40;49],...
    [71;69;64;67;64],[176;163;131;133;119],...
    'VariableNames',{'Gender' 'Age' 'Height' 'Weight'})

T=5×4 table
    Gender    Age    Height    Weight
    ______    ___    ______    ______

      M       38       71       176  
      M       43       69       163  
      F       38       64       131  
      F       40       67       133  
      F       49       64       119  

Convert T(:,2:4) to an array.

A = table2array(T(:,2:4))

A = 5×3

    38    71   176
    43    69   163
    38    64   131
    40    67   133
    49    64   119

A does not include data from the variable Gender.

Convert Table with Three-Dimensional Variables to Array

Create a table, T, with two rows and three variables where each variable has three dimensions.

T = table(ones(2,1,3),2*ones(2,2,3),3*ones(2,3,3),...
    'VariableNames',{'One' 'Two' 'Three'})

T=2×3 table
         One               Two              Three     
    ______________    ______________    ______________

    [1x1x3 double]    [1x2x3 double]    [1x3x3 double]
    [1x1x3 double]    [1x2x3 double]    [1x3x3 double]

The size of the table is 2-by-3.

Convert table T to an array.

A = table2array(T)

A = 
A(:,:,1) =

     1     2     2     3     3     3
     1     2     2     3     3     3


A(:,:,2) =

     1     2     2     3     3     3
     1     2     2     3     3     3


A(:,:,3) =

     1     2     2     3     3     3
     1     2     2     3     3     3

The size of A is 2-by-6-by-3.

Input Arguments

T — Input table

table

Input table, specified as a table. All variables in T must have sizes and data types that are compatible for horizontal concatenation. Specifically, the size of all variable dimensions greater than 2 must match.

• If T is an m-byn table with variables that each have one column, then each variable becomes one column in A, and A is an m-by-n array.

• If T contains variables that consist of more than one column, those variables become multiple columns in A, and the size of A is greater than the size of T.

• If T contains variables with more than two dimensions, the number of dimensions of A is the same as the number of variable dimensions.

Tips

• table2array horizontally concatenates the variables in T to create A. If the variables in T are cell arrays, table2array does not concatenate their contents, and A is a cell array, equivalent to table2cell(T). To create an array containing the contents of variables that are all cell arrays, use cell2mat(table2cell(T)).

• table2array(T) is equivalent to T{:,:}.

Algorithms

If T contains variables with different data types that are compatible for horizontal concatenation, table2array creates a homogeneous array, A, of the dominant data type. For example, if T contains double and single numeric data, table2array(T) returns an array with data type single.

Extended Capabilities

Tall Arrays

Calculate with arrays that have more rows than fit in memory.

This function fully supports tall arrays. For more information, see Tall Arrays.

Distributed Arrays

Partition large arrays across the combined memory of your cluster using Parallel Computing Toolbox™.

This function fully supports distributed arrays. For more information, see Run MATLAB Functions with Distributed Arrays (Parallel Computing Toolbox).