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