Using udf decorator without arguments | Teradata Package for Python - Using udf Decorator without Arguments - 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
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-23
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage

Create a Python function to_upper to convert values in a column to upper case, then convert the function to UDF using @udf decorator.

Example setup

>>> load_example_data("dataframe", "sales")
>>> df = DataFrame("sales")
>>> df
              Feb    Jan    Mar    Apr    datetime
accounts                                          
Yellow Inc   90.0    NaN    NaN    NaN  04/01/2017
Jones LLC   200.0  150.0  140.0  180.0  04/01/2017
Red Inc     200.0  150.0  140.0    NaN  04/01/2017
Alpha Co    210.0  200.0  215.0  250.0  04/01/2017
Blue Inc     90.0   50.0   95.0  101.0  04/01/2017
Orange Inc  210.0    NaN    NaN  250.0  04/01/2017

Convert a Python function to udf using @udf as decorator

>>> from teradataml.dataframe.functions import udf
>>> @udf
... def to_upper(s):
...     return s.upper()
# Assign the Column Expression returned by udf the DataFrame.
>>> res = df.assign(upper_stats = to_upper('accounts'))
>>> res
            Feb    Jan    Mar    Apr  datetime upper_stats
accounts                                                    
Alpha Co    210.0  200.0  215.0  250.0  17/01/04    ALPHA CO
Blue Inc     90.0   50.0   95.0  101.0  17/01/04    BLUE INC
Yellow Inc   90.0    NaN    NaN    NaN  17/01/04  YELLOW INC
Jones LLC   200.0  150.0  140.0  180.0  17/01/04   JONES LLC
Orange Inc  210.0    NaN    NaN  250.0  17/01/04  ORANGE INC
Red Inc     200.0  150.0  140.0    NaN  17/01/04     RED INC