WOLFRAM

Wolfram 语言与系统参考资料中心

InsertColumns[tab,{col1cval1,…}]

在表格对象 tab 中插入名为 coli 的列 cvali.

InsertColumns[cspec]

表示 InsertColumns 的运算符形式，可以应用于表格数据.

更多信息
Details and Options Details and Options
范例  
基本范例  
范围  
列  
输入数据  
列的放置位置  
应用  
属性和关系  
参见
相关指南
历史
按以下格式引用：

InsertColumns

InsertColumns[tab,{col1cval1,…}]

在表格对象 tab 中插入名为 coli 的列 cvali.

InsertColumns[cspec]

表示 InsertColumns 的运算符形式，可以应用于表格数据.

更多信息

  • InsertColumns 通常用于构建带有附加列的 Tabular 对象.
  • 如果列 coli 已经存在，则用新列替换它. 否则，新列将添加到现有列之后. »
  • 插入的列必须具有与原始表格对象相同的行数.
  • InsertColumns[tab,{acol,colcval}] 在现有名为 acol 的锚点列后添加一个名为 col 的新列，而不是将其附加在末尾. »
  • 对于没有列键的表格数据 atab，InsertColumns[atab,{cval1,…,cvaln}] 会附加 n 个新列. »
  • 可以在 n 行表格对象中插入的可能列规范 cvali 包括：
  • const等价于 ConstantArray[const,n] »
    {v1,…,vn}长度为 n 的向量 »
    TabularColumn[…]长度为 n 的类型一致向量 »
  • 语法 colNothing 可用于删除名为 col 的现有列. »
  • InsertColumns[cspec][tab] 等价于 InsertColumns[tab,cspec]. »
  • InsertColumns 也可以在 TimeSeries 或 EventSeries 对象中插入分量.

范例

打开所有单元 关闭所有单元

基本范例  (2)

在最后插入一个新列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: InsertColumns[tab, "aa" -> {11, 22, 33}]

在第一列后插入新列：

Wolfram Language code: InsertColumns[tab, {"a", "aa" -> {11, 22, 33}}]

使用 InsertColumns 的运算符形式：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: InsertColumns[{"aa" -> {11, 22, 33}, "bb" -> 0}][tab]

范围  (12)

列  (7)

插入一个常数列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: InsertColumns[tab, "c" -> 0]

插入一个向量列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: InsertColumns[tab, "c" -> {.1, .2, .3}]

插入一个类型化的列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: col = TabularColumn[{"cat", "dog", "fox"}, "String"]
Wolfram Language code: InsertColumns[tab, "c" -> col]

删除现有的列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: InsertColumns[tab, "b" -> Nothing]

同时添加多列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: InsertColumns[tab, {"c1" -> {"cat", "dog", "fox"}, "c2" -> {.1, .2, .3}}]

列可以通过将键封装在 Key 或 ExtendedKey 中来插入：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: {InsertColumns[tab, "c" -> {.1, .2, .3}], InsertColumns[tab, Key["c"] -> {.1, .2, .3}], InsertColumns[tab, ExtendedKey["c"] -> {.1, .2, .3}]}

扩展键的深度可以与原始深度不同：

Wolfram Language code: InsertColumns[tab, ExtendedKey["Up", "c"] -> {.1, .2, .3}]

取一个带有扩展键的 Tabular 对象：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {ExtendedKey["Up", "a"], ExtendedKey["Up", "b"]}]

插入一个带有标准键的列：

Wolfram Language code: InsertColumns[tab, "c" -> {.1, .2, .3}]

插入它以匹配扩展键的深度：

Wolfram Language code: InsertColumns[tab, ExtendedKey["Up", "c"] -> {.1, .2, .3}]

输入数据  (2)

向 Tabular 对象追加一列：

Wolfram Language code: Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: InsertColumns[%, "c" -> {.1, .2, .3}]

在 TimeSeries 对象中插入一个数值分量：

Wolfram Language code: ts = TimeSeries[{{1, "dog"}, {2, "cat"}, {3, "fox"}}, {Today}, ComponentKeys -> {"number", "animal"}]
Wolfram Language code: InsertColumns[ts, "city" -> {Entity["City", {"London", "GreaterLondon", "UnitedKingdom"}], Entity["City", {"Tokyo", "Tokyo", "Japan"}], Entity["City", {"BuenosAires", "BuenosAires", "Argentina"}]}]
Wolfram Language code: %//Tabular

在特定位置插入新的分量：

Wolfram Language code: InsertColumns[ts, {"number", "city" -> {Entity["City", {"London", "GreaterLondon", "UnitedKingdom"}], Entity["City", {"Tokyo", "Tokyo", "Japan"}], Entity["City", {"BuenosAires", "BuenosAires", "Argentina"}]}}]
Wolfram Language code: %//Tabular

列的放置位置  (3)

在第一列之前插入一列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: InsertColumns[tab, {"c" -> {11, 12, 13}, "a"}]

在第一列之后插入一列：

Wolfram Language code: InsertColumns[tab, {"a", "c" -> {11, 12, 13}}]

替换现有的列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: InsertColumns[tab, "b" -> 0]

同时添加多个列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: col1 = TabularColumn[{"cat", "dog", "fox"}, "String"]
Wolfram Language code: col2 = TabularColumn[{.1, .2, .3}, "Real64"]
Wolfram Language code: InsertColumns[tab, {"c1" -> col1, "a", "c2" -> col2, "b"}]

应用  (4)

取一个数值 Tabular 对象：

Wolfram Language code: tab = ToTabular[<|"obs" -> RandomReal[{-10, 10}, 5]|>, "Columns"]

从零均值和单位标准差的列 "obs" 创建一个向量：

Wolfram Language code: zscore = Standardize[tab[All, "obs"]]

使用 InsertColumns 将其添加到原始表格对象：

Wolfram Language code: InsertColumns[tab, "z-score" -> zscore]

取一个包含医疗数据的 Tabular 对象：

Wolfram Language code: data = ResourceData["Sample Tabular Data: Cardiac Disease"]

检查列类型：

Wolfram Language code: ColumnTypes[data]

请注意，尽管某些列包含数字，但其数据类型并非数值型：

Wolfram Language code: TabularStructure[data, {"Fluoro", "Thallium"}]

检查数值输入：

Wolfram Language code: {VectorQ[data[All, "Fluoro"], NumericQ], VectorQ[data[All, "Thallium"], NumericQ]}

这两列中的数据可能不可靠，需要标记以指示这一点. 使用 InsertColumns 将所有列项转换为 Missing：

Wolfram Language code: InsertColumns[data, {"Fluoro" -> Missing["Fluoro"], "Thallium" -> Missing["Thallium"]}]
Wolfram Language code: TabularStructure[%, {"Fluoro", "Thallium"}]

取一个包含金融时间序列数据的 Tabular 对象：

Wolfram Language code: ts = Tabular[{...}];

显示数据及其图表：

Wolfram Language code: GraphicsRow@{ts, DateListPlot[ts -> {"Date", "Value"}]}

对数据进行自回归时间序列模型拟合：

Wolfram Language code: tsm = TimeSeriesModelFit[FromTabular[ts, "TimeSeries", <|"TimeColumn" -> "Date", TemporalRegularity -> True|>], "AR"]

模拟这些值：

Wolfram Language code: RandomFunction[Normal[tsm], {1, Length[ts]}]

将模拟列添加到数据中：

Wolfram Language code: InsertColumns[ts, "Simulation" -> %["Values"]]

可视化数据和模拟：

Wolfram Language code: DateListPlot[% -> {{"Date", "Value"}, {"Date", "Simulation"}}, PlotLegends -> {"data", "simulation"}]

取一个 Tabular 对象，其中包含按列给出的月度数据：

Wolfram Language code: data = ResourceData["Sample Tabular Data: Los Angeles Ozone"]

插入空字符串列作为视觉分隔符：

Wolfram Language code: InsertColumns[data, {"Year", "Q1 ->" -> "", "Mar", "Q2 ->" -> "", "Jun", "Q3 ->" -> "", "Sep", "Q4 ->" -> ""}]

属性和关系  (5)

为同一个新键指定不同的列时，将使用最后指定的列：

Wolfram Language code: tab = Tabular[{{1, 3}, {2, 4}, {8, 6}, {5, 7}}, {"a", "b"}]
Wolfram Language code: InsertColumns[tab, {"c" -> {t, x, y, z}, "c" -> {S, P, Q, R}}]

第二个参数为空表示插入零列：

Wolfram Language code: InsertColumns[Tabular[{{1}, {2}}, {"a"}], {}]

使用 TransformColumns 向 Tabular 对象追加一个新列：

Wolfram Language code: tab = Tabular[{{1, 2}, {3, 4}, {5, 6}}, {"a", "b"}]
Wolfram Language code: TransformColumns[tab, "c" -> Function[#a + #b]]

或者，首先计算列，然后使用 InsertColumns 追加：

Wolfram Language code: col = tab[All, "a"] + tab[All, "b"]
Wolfram Language code: InsertColumns[tab, "c" -> col]

取一个以年份和月份为列的 Tabular 对象：

Wolfram Language code: data = {{2024, 10}, {2024, 11}, {2024, 12}};
Wolfram Language code: tab = Tabular[data]

TransformColumns 可以通过为每一行构建一个日期来添加新列：

Wolfram Language code: TransformColumns[tab, DateObject]

或者，首先构建日期列，然后使用 InsertColumns 将其追加：

Wolfram Language code: InsertColumns[tab, Map[DateObject, data]]

向匿名 Tabular 对象追加一列：

Wolfram Language code: mat = {{1, 2}, {3, 4}, {5, 6}}; col = {"cat", "dog", "fox"};
Wolfram Language code: tab = Tabular[mat]
Wolfram Language code: InsertColumns[tab, col]

使用 Join 在第二层连接矩阵可以实现相同的结果：

Wolfram Language code: Join[mat, List /@ col, 2]//MatrixForm

追加多个列：

Wolfram Language code: InsertColumns[tab, {col, col}]

追加原始 Tabular 对象的相同列：

Wolfram Language code: InsertColumns[tab, FromTabular[tab, "Columns"]]

这实际上相当于原始数据的转置：

Wolfram Language code: InsertColumns[tab, Transpose[mat]]
Wolfram Research (2025)，InsertColumns，Wolfram 语言函数，https://reference.wolfram.com/language/ref/InsertColumns.html （更新于 2026 年）.

文本

Wolfram Research (2025)，InsertColumns，Wolfram 语言函数，https://reference.wolfram.com/language/ref/InsertColumns.html （更新于 2026 年）.

CMS

Wolfram 语言. 2025. "InsertColumns." Wolfram 语言与系统参考资料中心. Wolfram Research. 最新版本 2026. https://reference.wolfram.com/language/ref/InsertColumns.html.

APA

Wolfram 语言. (2025). InsertColumns. Wolfram 语言与系统参考资料中心. 追溯自 https://reference.wolfram.com/language/ref/InsertColumns.html 年

BibTeX

@misc{reference.wolfram_2026_insertcolumns, author="Wolfram Research", title="{InsertColumns}", year="2026", howpublished="\url{https://reference.wolfram.com/language/ref/InsertColumns.html}", note=[Accessed: 31-October-2026]}

BibLaTeX

@online{reference.wolfram_2026_insertcolumns, organization={Wolfram Research}, title={InsertColumns}, year={2026}, url={https://reference.wolfram.com/language/ref/InsertColumns.html}, note=[Accessed: 31-October-2026]}