Apply SET Operations on teradataml DataFrames | Teradata Package for Python - Apply SET Operations on teradataml DataFrames - Teradata Package for Python

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-23
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
lifecycle
latest
Product Category
Teradata Vantage

teradataml offers various API's that allow users to perform set operations which internally uses Teradata SET operators, to combine similar data sets or find difference of a list of teradataml DataFrames or GeoDataFrames.

The SET operators are similar to the JOINs, the only difference is that JOIN combines the columns from different DataFrames or GeoDataFrames, whereas SET operators combine rows from different DataFrames or GeoDataFrames.

Supported SET operators include:
The data types of the columns which are being used in the SET operators must match.