table2struct

Convert table to structure array

Syntax

S = table2struct(T)

S = table2struct(T,"ToScalar",true)

Description

S = table2struct(T) converts the table or timetable, T, to a structure array, S. Each variable in T becomes a field in S. If T is an m-by-n table or timetable, then S is a m-by-1 structure array with n fields.

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

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

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

S = table2struct(T,"ToScalar",true) converts the table, T, to a scalar structure S. Each variable of T becomes a field in S. If T is a m-by-n table, then S has n fields, each of which has m rows.

Examples

Convert Table to Structure Array

Create a table, T, with five rows and three variables.

T = table(categorical(["Y";"N";"Y";"N";"N"]),[38;43;38;40;49], ...
[124 93;109 77; 125 83; 117 75; 122 80], ...
VariableNames=["Smoker" "Age" "BloodPressure"])

T=5×3 table
    Smoker    Age    BloodPressure
    ______    ___    _____________

      Y       38      124     93  
      N       43      109     77  
      Y       38      125     83  
      N       40      117     75  
      N       49      122     80  

Convert T to a structure array.

S = table2struct(T)

S=5×1 struct array with fields:
    Smoker
    Age
    BloodPressure

Display the field data for the first element of S.

S(1)

ans = struct with fields:
           Smoker: Y
              Age: 38
    BloodPressure: [124 93]

The information corresponds to the first row of the table.

Convert Table to Scalar Structure

Create a table, T, with five rows and three variables.

T = table(categorical(["Y";"N";"Y";"N";"N"]),[38;43;38;40;49], ...
[124 93;109 77; 125 83; 117 75; 122 80], ...
VariableNames=["Smoker" "Age" "BloodPressure"])

T=5×3 table
    Smoker    Age    BloodPressure
    ______    ___    _____________

      Y       38      124     93  
      N       43      109     77  
      Y       38      125     83  
      N       40      117     75  
      N       49      122     80  

Convert T to a scalar structure.

S = table2struct(T,ToScalar=true)

S = struct with fields:
           Smoker: [5×1 categorical]
              Age: [5×1 double]
    BloodPressure: [5×2 double]

The data arrays in the fields of the scalar structure all have five rows, corresponding to the five rows in the table T.

Display the data for the field BloodPressure.

S.BloodPressure

ans = 5×2

   124    93
   109    77
   125    83
   117    75
   122    80

The structure field BloodPressure contains all of the data that was in the variable of the same name from table T.

Convert Table with Row Names to Structure

Create a table, T, that includes row names.

T = table(categorical(["Y";"N";"Y";"N";"N"]),[38;43;38;40;49], ...
[124 93;109 77; 125 83; 117 75; 122 80], ...
VariableNames=["Smoker" "Age" "BloodPressure"], ...
RowNames=["Chang" "Brown" "Ruiz" "Lee" "Smith"])

T=5×3 table
             Smoker    Age    BloodPressure
             ______    ___    _____________

    Chang      Y       38      124     93  
    Brown      N       43      109     77  
    Ruiz       Y       38      125     83  
    Lee        N       40      117     75  
    Smith      N       49      122     80  

Convert T to a scalar structure.

S = table2struct(T,ToScalar=true)

S = struct with fields:
           Smoker: [5×1 categorical]
              Age: [5×1 double]
    BloodPressure: [5×2 double]

Add a field for the row names from the table.

S.RowNames = T.Properties.RowNames

S = struct with fields:
           Smoker: [5×1 categorical]
              Age: [5×1 double]
    BloodPressure: [5×2 double]
         RowNames: {5×1 cell}

If S is a nonscalar structure, use [S.RowNames] = T.Properties.RowNames{:} to include a field with the row names from the table.

Input Arguments

T — Input table

table | timetable

Input table, specified as a table or timetable.

If T has variables whose names are not valid MATLAB^® identifiers, then table2struct modifies them to create valid field names, primarily by removing spaces and replacing non-ASCII characters with underscores.

Output Arguments

S — Output structure array

structure array

Output structure array.

Extended Capabilities

C/C++ Code Generation

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

Usage notes and limitations:

• In generated code, the input table 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).

GPU Code Generation

Generate CUDA® code for NVIDIA® GPUs using GPU Coder™.

Refer to the usage notes and limitations in the C/C++ Code Generation section. The same usage notes and limitations apply to GPU code generation.

Thread-Based Environment
Run code in the background using MATLAB® backgroundPool or accelerate code with Parallel Computing Toolbox™ ThreadPool.

Version History

Introduced in R2013b