IncludeGroupAggregates

IncludeGroupAggregates

PivotTable 的一个选项,指定是否将含有分组汇总信息的行和列包含在内.

更多信息

  • 采用默认设置 IncludeGroupAggregatesFalse 时,不包括汇总信息.
  • 采用设置 IncludeGroupAggregatesTrue 时,PivotTable 返回一个包含额外的行和列的 Tabular 对象,其键 为 AllExtendedKey[,All],其中包含有关行和列的分组的汇总信息.

范例

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

基本范例  (1)

取含有四个列的表格数据:

"sex""class" 分组计算平均年龄,忽略 "survived" 列:

包括每行和每列的分组汇总信息:

范围  (1)

制作一个数据透视表,显示泰坦尼克号的生存百分比:

默认情况下,PivotTable 不包括分组汇总信息:

显示分组汇总信息,添加键为 All 的行和列:

应用  (1)

The data contains information on kidney transplant patientstime in days to death or on-study time since transplant at the given age:

Use the PivotTable to compute the patients' mean survival time in years split according to alive status versus gender and race, including the summary groups:

Wolfram Research (2025),IncludeGroupAggregates,Wolfram 语言函数,https://reference.wolfram.com/language/ref/IncludeGroupAggregates.html.

文本

Wolfram Research (2025),IncludeGroupAggregates,Wolfram 语言函数,https://reference.wolfram.com/language/ref/IncludeGroupAggregates.html.

CMS

Wolfram 语言. 2025. "IncludeGroupAggregates." Wolfram 语言与系统参考资料中心. Wolfram Research. https://reference.wolfram.com/language/ref/IncludeGroupAggregates.html.

APA

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

BibTeX

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

BibLaTeX

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