WOLFRAM

gives structural information about the Tabular tab for each column.

TabularStructure[tab,cols]

gives structural information for the columns cols.

TabularStructure[tab,cols,props]

selects the properties props to report.

Details

  • TabularStructure is typically used to get structural information for each column.
  • TabularStructure[tab,cols,props] returns another Tabular object in which the properties props are column keys and the columns cols are entries in a key column called "ColumnKey". Each row contains information for one of the original columns.
  • Possible forms cols of column specification include:
  • Allall columns of the input Tabular data
    {col1,col2,}list of columns of the input data
    spattstring pattern for the column keys of the data
    critcriterion function to select columns keys
  • Possible string patterns spatt include strings with wild characters, such as "col*" and StringExpression objects such as "col"~~__.
  • The criterion function crit takes named variables #ColumnKey, providing the column key, and #ElementType, providing the type of the elements of the column.
  • Possible properties props include:
  • "ColumnType"type of the column
    "MissingCount"number of missing elements in the column
    "NonMissingCount"number of non-missing elements in the column
    "ByteCount"byte count of the column
    "DuplicateFreeQ"whether the column has unique entries
    "CountDistinct"number of unique entries
    {prop1,prop2,}list of properties propi above
    Alllist of all the properties above
    Automaticautomatic choice of some of the properties above

Examples

open allclose all

Basic Examples  (1)Summary of the most common use cases

Build a tabular report about the columns of a Tabular object:

Out[1]=1
Out[2]=2

Include only some columns and report only about some properties:

Out[3]=3

Scope  (3)Survey of the scope of standard use cases

Take tabular data about the Titanic passengers:

Out[1]=1

Compute a structural summary of the data:

Out[2]=2

Add more properties, including information about possible duplication of entries in each column:

Out[3]=3

Take tabular data about the elements:

Out[1]=1

Find a structural summary for some of the columns:

Out[2]=2

Restrict to only one column:

Out[3]=3

Report only about the original columns that contain "u" in their name:

Out[4]=4

Restrict to the columns of "Integer64" type:

Out[5]=5

Take tabular data about the Titanic passengers:

Out[1]=1

Find a structural report with the default properties:

Out[2]=2

Include all available properties, including some reporting about the possible presence of duplicate entries:

Out[3]=3

Select only one property:

Out[4]=4

Select several properties:

Out[5]=5

Applications  (1)Sample problems that can be solved with this function

Find out which columns of a Tabular object could be used as key columns for indexing it:

Out[1]=1
Out[2]=2

Only duplicate-free columns can be key columns, so that rows are uniquely identified by their values:

Out[3]=3

Use for example the "state" column, after extracting a subset of the columns:

Out[4]=4

Properties & Relations  (3)Properties of the function, and connections to other functions

TabularStructure[tab] returns a Tabular object whose key column contains the column keys of tab:

Out[2]=2
Out[3]=3
Out[4]=4

TabularStructure of an anonymous Tabular object does not have the key column:

Out[1]=1
Out[2]=2

Take a Tabular object:

Out[1]=1

A structural summary about zero columns will contain no rows:

Out[2]=2

A structural summary with zero properties will contain no columns other than the key column:

Out[3]=3
Out[4]=4
Wolfram Research (2025), TabularStructure, Wolfram Language function, https://reference.wolfram.com/language/ref/TabularStructure.html.
Wolfram Research (2025), TabularStructure, Wolfram Language function, https://reference.wolfram.com/language/ref/TabularStructure.html.

Text

Wolfram Research (2025), TabularStructure, Wolfram Language function, https://reference.wolfram.com/language/ref/TabularStructure.html.

Wolfram Research (2025), TabularStructure, Wolfram Language function, https://reference.wolfram.com/language/ref/TabularStructure.html.

CMS

Wolfram Language. 2025. "TabularStructure." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/ref/TabularStructure.html.

Wolfram Language. 2025. "TabularStructure." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/ref/TabularStructure.html.

APA

Wolfram Language. (2025). TabularStructure. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/TabularStructure.html

Wolfram Language. (2025). TabularStructure. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/TabularStructure.html

BibTeX

@misc{reference.wolfram_2024_tabularstructure, author="Wolfram Research", title="{TabularStructure}", year="2025", howpublished="\url{https://reference.wolfram.com/language/ref/TabularStructure.html}", note=[Accessed: 23-January-2025 ]}

@misc{reference.wolfram_2024_tabularstructure, author="Wolfram Research", title="{TabularStructure}", year="2025", howpublished="\url{https://reference.wolfram.com/language/ref/TabularStructure.html}", note=[Accessed: 23-January-2025 ]}

BibLaTeX

@online{reference.wolfram_2024_tabularstructure, organization={Wolfram Research}, title={TabularStructure}, year={2025}, url={https://reference.wolfram.com/language/ref/TabularStructure.html}, note=[Accessed: 23-January-2025 ]}

@online{reference.wolfram_2024_tabularstructure, organization={Wolfram Research}, title={TabularStructure}, year={2025}, url={https://reference.wolfram.com/language/ref/TabularStructure.html}, note=[Accessed: 23-January-2025 ]}