table2array

Convert table to homogeneous array

Syntax

A = table2array(T)

Description

A = table2array(T) converts the table or timetable, T, to a homogeneous array, A. The variables in T become columns in A.

The output A does not include the table properties in T.Properties.

• If T is a table with row names, then A does not include the row names.

• If T is a timetable, then A does not include the row times.

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(["Y";"Y";"N";"N";"F"]),[38;43;38;40;49],...
    [71;69;64;67;64],[176;163;131;133;119],...
    'VariableNames',["Smoker" "Age" "Height" "Weight"])

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

      Y       38       71       176  
      Y       43       69       163  
      N       38       64       131  
      N       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 Smoker.

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 | timetable

Input table, specified as a table or timetable. 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 or timetable 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.

C/C++ Code Generation

Generate C and C++ code using MATLAB® Coder™.

Usage notes and limitations:

• In generated code, the names of the table variables must be constant when using this function. For more information, see Code Generation for Tables (MATLAB Coder) and Table Limitations for Code Generation (MATLAB Coder).

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).

Version History

Introduced in R2013b