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

Product
Teradata Package for Python
Release Number
17.10
Published
May 2022
Language
English (United States)
Last Update
2022-08-18
dita:mapPath
rsu1641592952675.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
B700-4006
lifecycle
previous
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 should match.