TD_CategoricalSummary | CategoricalSummary | Teradata Vantage - TD_CategoricalSummary - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-01
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

TD_CategoricalSummary displays the distinct values and their counts for each specified input table column.

A categorical summary refers to a summary of data that is organized into distinct categories or groups. This type of summary is commonly used when dealing with data that is nominal or categorical in nature, such as demographic information, survey responses, or the type of products purchased by customers.

TD_CategoricalSummary can provide information about the number of observations in each category. This information can be presented in tables, charts, histograms, or pie charts, depending on the type of data and the research question.

Categorical summaries can be useful in several stages of the machine learning process, such as data exploration, feature engineering, and model evaluation. They can help identify patterns, relationships, and outliers in the data, as well as guide the selection and transformation of features for the predictive model. They can also be used to assess the performance of the model and compare it with other models or benchmarks.