DeleteColumns[tab,cspec]
从表格数据 tab 中删除由 cspec 指定的列.
DeleteColumns[cspec]
表示可应用于表格数据的 DeleteColumns 的算符形式.
DeleteColumns
DeleteColumns[tab,cspec]
从表格数据 tab 中删除由 cspec 指定的列.
DeleteColumns[cspec]
表示可应用于表格数据的 DeleteColumns 的算符形式.
更多信息
- DeleteColumns 亦称为删除列.
- DeleteColumns 通常用于从表格数据中删除列以简化后续处理.
- 表格数据 tab 可取的形式包括:
-
Tabular[…] 类型一致的表格数据 Dataset[…] 普通的分层数据 {assoc1,assoc2,…} 共有键构成的关联的列表 matrix 矩阵 TimeSeries[…] 含有多个分量的时间序列 EventSeries[…] 含有多个分量的事件序列 - 可能的列指定 cspec 包括:
-
name or Key[name] or ExtendedKey[…] 已命名列 ind 用整数索引的列 {col1,…} 几个列 cmin;;cmax;;step 列的 Span
范例
打开所有单元 关闭所有单元基本范例 (1)
从 Tabular 对象中删除一个列:
tab = Tabular[{{1, 2, 3}, {4, 5, 6}}, {"a", "b", "c"}]DeleteColumns[tab, "a"]DeleteColumns[tab, {"a", "c"}]范围 (10)
从 Tabular 对象中删除一个列:
tab = Tabular[{{"a", "A", "α"}, {"b", "B", "β"}}, {"lower", "upper", "greek"}]DeleteColumns[tab, "upper"]DeleteColumns[tab, {"upper", "lower"}]DeleteColumns[tab, {1, 2}]或指定 Span 的范围:
DeleteColumns[tab, 1 ;; 2]可以从 Tabular 对象中删除所有列:
Tabular[{{1, 2}, {3, 4}, {5, 6}}]DeleteColumns[%, {1, 2}]Dimensions[%]从 Dataset 对象中删除一个列:
ds = Dataset[{<|"c1" -> 1, "c2" -> 7.3, "c3" -> True|>, <|"c1" -> 5, "c2" -> 2.8, "c3" -> False|>}]DeleteColumns[ds, "c2"]DeleteColumns[ds, {"c2", "c1"}]data = {<|"a" -> 1, "b" -> 2, "c" -> 3|>, <|"a" -> 4, "b" -> 5, "c" -> 6|>};DeleteColumns[data, "a"]DeleteColumns[data, {"a", "c"}]mat = {{1, 2, 3}, {4, 5, 6}, {7, 8, 9}};DeleteColumns[mat, {2}]DeleteColumns[mat, {1, -1}]DeleteColumns[mat, 2 ;; 3]删除 TimeSeries 对象的一个分量:
ts = TimeSeries[{{1, "dog"}, {2, "cat"}, {3, "fox"}}, {Today}, ComponentKeys -> {"number", "animal"}]Tabular[ts]DeleteColumns[ts, "number"]Tabular[%]DeleteColumns[ts, {"number", "animal"}]Tabular[%]获取一个含有已命名分量的 EventSeries 对象:
es = EventSeries[{"foo", "bar", "baz"}, {{.2, .6, 1.7}}, {"a"}]Tabular[es]删除时间序列或事件序列中的 "Timestamp" 分量,系统将自动添加时间戳:
DeleteColumns[es, "Timestamp"]Tabular[%]使用 DeleteColumns 的算符形式:
ToTabular[{{1, 2}, {3, 4}, {5, 6}}, "Columns", <|"ColumnKeys" -> {"a", "b", "c"}|>]%//DeleteColumns["b"]取一个 Tabular 对象:
tab = Tabular[{{"a", "A", "α"}, {"b", "B", "β"}}, {"lower", "upper", "greek"}]DeleteColumns[tab, "greek"]列的键也可以封装在 Key 或 ExtendedKey 中:
DeleteColumns[tab, {Key["lower"], ExtendedKey["upper"]}]取一个含有扩展键的 Tabular 对象:
tab = Tabular[{{"a", "A", "α"}, {"b", "B", "β"}}, {ExtendedKey["latin", "lower"], ExtendedKey["latin", "upper"], ExtendedKey["greek", "lower"]}]DeleteColumns[tab, ExtendedKey["latin", "upper"]]如果扩展键的最后一个子键可以唯一标识该列,则可以用它来进行指定:
DeleteColumns[tab, "upper"]应用 (1)
取一个包含帕尔默企鹅信息的 Tabular 对象:
data = ResourceData["Sample Tabular Data: Palmer Penguins"]DeleteColumns[data, "index"]属性和关系 (5)
DeleteColumns 操作与将剩下的列用 Part 提取出来是一样的:
tab = Tabular[RandomReal[10, {3, 5}]]DeleteColumns[tab, {1, 3, 4}]% === Part[tab, All, {2, 5}]mat = RandomColor[RGBColor[_, _, _], {3, 4}]DeleteColumns[mat, {}] === matDeleteColumns 是 TransformColumns 的特殊版本:
tab = Tabular[{{1, 2, 3}, {3, 4, 7}}, {"a", "b", "c"}]用 DeleteColumns 删除选中的列:
DeleteColumns[tab, "b"]用 TransformColumns 将选中的列设为 Nothing:
TransformColumns[tab, "b" -> Nothing]DeleteColumns 是 ConstructColumns 的互补运算:
tab = Tabular[{{1, 2, 3}, {3, 4, 7}, {5, 6, 11}}, {"a", "b", "c"}]DeleteColumns[tab, {"a", "c"}]ConstructColumns[tab, {"b"}]取一个 Tabular 对象,并提取一个列:
tab = Tabular[{{1, 2, 5}, {3, 4, 7}}, {"a", "b", "c"}]colb = tab[[All, "b"]]从 Tabular 对象中删除该列:
DeleteColumns[tab, "b"]用 InsertColumns 将一个列插入到 "a" 列的后面,并使用键 "B":
InsertColumns[%, {"a", "B" -> colb}]相关指南
-
▪
- 表格数据清理
文本
Wolfram Research (2025),DeleteColumns,Wolfram 语言函数,https://reference.wolfram.com/language/ref/DeleteColumns.html (更新于 2026 年).
CMS
Wolfram 语言. 2025. "DeleteColumns." Wolfram 语言与系统参考资料中心. Wolfram Research. 最新版本 2026. https://reference.wolfram.com/language/ref/DeleteColumns.html.
APA
Wolfram 语言. (2025). DeleteColumns. Wolfram 语言与系统参考资料中心. 追溯自 https://reference.wolfram.com/language/ref/DeleteColumns.html 年
BibTeX
@misc{reference.wolfram_2026_deletecolumns, author="Wolfram Research", title="{DeleteColumns}", year="2026", howpublished="\url{https://reference.wolfram.com/language/ref/DeleteColumns.html}", note=[Accessed: 07-September-2026]}
BibLaTeX
@online{reference.wolfram_2026_deletecolumns, organization={Wolfram Research}, title={DeleteColumns}, year={2026}, url={https://reference.wolfram.com/language/ref/DeleteColumns.html}, note=[Accessed: 07-September-2026]}