TabularStructure
✖
TabularStructure
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:
-
All all columns of the input Tabular data {col1,col2,…} list of columns of the input data spatt string pattern for the column keys of the data crit criterion 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 All list of all the properties above Automatic automatic choice of some of the properties above
Examples
open allclose allBasic Examples (1)Summary of the most common use cases
Build a tabular report about the columns of a Tabular object:
https://wolfram.com/xid/0b0kq490ay6-dub9ml
https://wolfram.com/xid/0b0kq490ay6-6xc7c1
Include only some columns and report only about some properties:
https://wolfram.com/xid/0b0kq490ay6-kdhn12
Scope (3)Survey of the scope of standard use cases
Take tabular data about the Titanic passengers:
https://wolfram.com/xid/0b0kq490ay6-mi1gq
Compute a structural summary of the data:
https://wolfram.com/xid/0b0kq490ay6-qarbk5
Add more properties, including information about possible duplication of entries in each column:
https://wolfram.com/xid/0b0kq490ay6-qvlxc7
Take tabular data about the elements:
https://wolfram.com/xid/0b0kq490ay6-7v3d0w
Find a structural summary for some of the columns:
https://wolfram.com/xid/0b0kq490ay6-l50w0j
https://wolfram.com/xid/0b0kq490ay6-pmu2va
Report only about the original columns that contain "u" in their name:
https://wolfram.com/xid/0b0kq490ay6-shi0dc
Restrict to the columns of "Integer64" type:
https://wolfram.com/xid/0b0kq490ay6-nhdtfp
Take tabular data about the Titanic passengers:
https://wolfram.com/xid/0b0kq490ay6-3q05bc
Find a structural report with the default properties:
https://wolfram.com/xid/0b0kq490ay6-5d9xds
Include all available properties, including some reporting about the possible presence of duplicate entries:
https://wolfram.com/xid/0b0kq490ay6-odxgwd
https://wolfram.com/xid/0b0kq490ay6-fv6i1
https://wolfram.com/xid/0b0kq490ay6-im0qha
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:
https://wolfram.com/xid/0b0kq490ay6-mm2ibe
https://wolfram.com/xid/0b0kq490ay6-n37kw2
Only duplicate-free columns can be key columns, so that rows are uniquely identified by their values:
https://wolfram.com/xid/0b0kq490ay6-8lm28c
Use for example the "state" column, after extracting a subset of the columns:
https://wolfram.com/xid/0b0kq490ay6-7ozr2z
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:
https://wolfram.com/xid/0b0kq490ay6-ca0cot
https://wolfram.com/xid/0b0kq490ay6-nzfcuw
https://wolfram.com/xid/0b0kq490ay6-6jnn08
https://wolfram.com/xid/0b0kq490ay6-451lcy
TabularStructure of an anonymous Tabular object does not have the key column:
https://wolfram.com/xid/0b0kq490ay6-bdypwf
https://wolfram.com/xid/0b0kq490ay6-k19apx
Take a Tabular object:
https://wolfram.com/xid/0b0kq490ay6-oduz4f
A structural summary about zero columns will contain no rows:
https://wolfram.com/xid/0b0kq490ay6-iayzku
A structural summary with zero properties will contain no columns other than the key column:
https://wolfram.com/xid/0b0kq490ay6-1frdhm
https://wolfram.com/xid/0b0kq490ay6-5u1wgw
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
]}
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
]}