EntityAugmentColumns
EntityAugmentColumns[tab,col,"prop"]
adds a new column with name "prop" whose values are computed as EntityValue[ei,"prop"] for the entities ei of the column col of the tabular data tab.
EntityAugmentColumns[tab,col,ncol"prop"]
adds a new column with name ncol.
EntityAugmentColumns[tab,col,{"prop1","prop2",…}]
adds several new columns for the properties "propi", with name also "propi".
EntityAugmentColumns[tab,col,{ncol1"prop1",ncol2"prop2",…}]
adds several new columns with names ncoli.
EntityAugmentColumns[tab,col,ncol{"prop1","prop2",…}]
adds several columns with names ExtendedKey[ncol,"propi"].
Details
- EntityAugmentColumns is typically used to extend tabular data with additional data obtained as properties of existing entity columns.
- EntityAugmentColumns[tab,col,ncol"prop"] is equivalent to TransformColumns[tab,ncolFunction[EntityValue[#col,"prop"]]].
Examples
open all close allBasic Examples (1)
Take a Tabular object with a second column of entities:
tab = Tabular[{{1, Entity["Country", "France"]}, {2, Entity["Country", "Italy"]}}, {"number", "country"}]
| |
| |
Add a new column of population values, using by default the property name as column header:
EntityAugmentColumns[tab, "country", "Population"]Specify the name of the new column:
EntityAugmentColumns[tab, "country", "population" -> "Population"]EntityAugmentColumns[tab, "country", {"Population", "Area"}]Scope (1)
Take a Tabular object the four Galilean moons in a column:
tab = ToTabular[{"moon" -> EntityList[EntityClass["PlanetaryMoon", "GalileanMoon"]]}, "Columns"]Add a new column with the radius of each moon:
EntityAugmentColumns[tab, "moon", "Radius"]Specify the name of the new column:
EntityAugmentColumns[tab, "moon", "radius" -> "Radius"]EntityAugmentColumns[tab, "moon", {"Radius", "Mass"}]Specify the names of one or more of those new columns:
EntityAugmentColumns[tab, "moon", {"radius" -> "Radius", "Mass"}]EntityAugmentColumns[tab, "moon", {"radius" -> "Radius", "mass" -> "Mass"}]Group several new properties with extended column keys:
EntityAugmentColumns[tab, "moon", "radii" -> {"EquatorialRadius", "PolarRadius"}]Mix the various possibilities:
EntityAugmentColumns[tab, "moon", {"radii" -> {"EquatorialRadius", "PolarRadius"}, "mass" -> "Mass"}]Applications (1)
Construct a Tabular object with a column of the countries in the ISO 3166 list:
ToTabular[{"country" -> EntityList["Country"]}, "Columns"]Augment it with new columns containing their populations and capital cities:
EntityAugmentColumns[%, "country", {"Population", "capital" -> "CapitalCity"}]Plot the locations of those capital cities:
GeoGraphics[{Red, Point[% -> "capital"]}, GeoRange -> "World"]Text
Wolfram Research (2026), EntityAugmentColumns, Wolfram Language function, https://reference.wolfram.com/language/ref/EntityAugmentColumns.html.
CMS
Wolfram Language. 2026. "EntityAugmentColumns." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/ref/EntityAugmentColumns.html.
APA
Wolfram Language. (2026). EntityAugmentColumns. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/EntityAugmentColumns.html