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
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
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.