Using SQLAlchemy ClauseElement and Expression in DataFrame.assign() | teradataml - Using Basic SQLAlchemy ClauseElement and Expression in DataFrame.assign() - 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

With the help of SQLAlchemy, in teradataml, user not only can run SQL functions, but also can run some other features that Vantage offers. Basically, user can use SQLAlchemy ClauseElements, representing select_expression clauses in query.

teradataml can use SQLAlchemy ClauseElements to do following:

  • Build a CASE expression on teradataml DataFrame column and select the using DataFrame.assign().
  • Cast a teradataml DataFrame column.
  • Select distinct values from a teradataml DataFrame Column.
  • Extract values from teradataml column, using EXTRACT function.

Refer to example notebook pkg_install_location\teradataml\data\notebooks\sqlalchemy\teradataml assign() - Using Generic SQLAlchemy ClauseElements (Case, Cast, Extract, Distinct).ipynb to learn about these.