Teradata Package for Python Function Reference | 20.00 - reverse - 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.02
- Published
- September 2024
- Language
- English (United States)
- Last Update
- 2024-10-17
- dita:id
- TeradataPython_FxRef_Enterprise_2000
- Product Category
- Teradata Vantage
- teradataml.dataframe.sql.DataFrameColumn.reverse = reverse()
- DESCRIPTION:
Function reverses the string value in column.
RAISES:
TypeError, ValueError, TeradataMlException
RETURNS:
DataFrameColumn
EXAMPLES:
# Load the data to run the example.
>>> load_example_data("dataframe", "admissions_train")
# Create a DataFrame on 'admissions_train' table.
>>> df = DataFrame("admissions_train").iloc[:4]
>>> print(df)
masters gpa stats programming admitted
id
3 no 3.70 Novice Beginner 1
4 yes 3.50 Beginner Novice 1
2 yes 3.76 Beginner Beginner 0
1 yes 3.95 Beginner Beginner 0
# Example 1: Reverses strings in "stats" column and pass it as input to
# DataFrame.assign().
>>> res = df.assign(col= df.stats.reverse())
>>> print(res)
masters gpa stats programming admitted col
id
3 no 3.70 Novice Beginner 1 ecivoN
4 yes 3.50 Beginner Novice 1 rennigeB
2 yes 3.76 Beginner Beginner 0 rennigeB
1 yes 3.95 Beginner Beginner 0 rennigeB
# Example 2: Executed reverse() function on "stats" column and filtered computed
# values which are equal to 'rennigeB'.
>>> print(df[df.stats.reverse() == "rennigeB"])
masters gpa stats programming admitted
id
4 yes 3.50 Beginner Novice 1
2 yes 3.76 Beginner Beginner 0
1 yes 3.95 Beginner Beginner 0