Using SQLAlchemy ClauseElement and Expression in DataFrame.assign() | teradataml - 17.00 - Using Basic SQLAlchemy ClauseElement and Expression in DataFrame.assign() - Teradata Package for Python

Teradata® Package for Python User Guide

Product
Teradata Package for Python
Release Number
17.00
Release Date
November 2021
Content Type
User Guide
Publication ID
B700-4006-070K
Language
English (United States)

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 ClauseElments, 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.