Teradata Package for Python Function Reference | 20.00 - translate - Teradata Package for Python - Look here for syntax, methods and examples for the functions included in the Teradata Package for Python.

Teradata® Package for Python Function Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00.00.03
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-19
dita:id
TeradataPython_FxRef_Enterprise_2000
lifecycle
latest
Product Category
Teradata Vantage
teradataml.dataframe.sql_functions.translate = translate(x, source='UNICODE', target='LATIN')
Returns a TRANSLATE(x USING source_TO_target) expression
 
PARAMETERS:
  x: A ColumnExpression instance coming from the DataFrame
     or output of other functions in sql_functions. A python
     string literal may also be used.
 
  source, target: str with values:
    - 'UNICODE'
    - 'LATIN'
 
REFERENCES:
  Chapter 28: String Operators and Functions
  Teradata® Database SQL Functions, Operators, Expressions, and
  Predicates, Release 16.20
 
EXAMPLES:
  >>> from teradataml.dataframe.sql_functions import translate
 
  >>> df = DataFrame('df')
  >>> tvshow = df['tvshow']
 
  >>> res = df.assign(tvshow = translate(tvshow))