Teradata Package for Python Function Reference on VantageCloud Lake - end - 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 on VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Package for Python
Release Number
20.00.00.08
Published
November 2025
ft:locale
en-US
ft:lastEdition
2025-12-05
dita:id
TeradataPython_FxRef_Lake_2000
Product Category
Teradata Vantage
teradataml.dataframe.sql.DataFrameColumn.end = end(self)
DESCRIPTION:
    Retrieves the ending date or timestamp from a PERIOD column.
 
PARAMETERS:
    None.
    
RETURNS:
    ColumnExpression.
 
RAISES:
    TeradataMlException.
 
EXAMPLES:
    # Load the data to run the example.
    >>> load_example_data("teradataml", "Employee_roles")
 
    # Create a DataFrame on 'employee_roles' table.
    >>> df = DataFrame("employee_roles")
 
    # Extract the ending date from the period column 'role_validity_period' 
    # and assign it to a new column.
    >>> df = df.assign(end_date_col = df['role_validity_period'].end())
    EmployeeID    EmployeeName   Department      Salary        role_validity_period         end_date_col
             1        John Doe           IT     100.000    ('20/01/01', '24/12/31')             24/12/31
             2      Jane Smith           DA     200.000    ('20/01/01', '99/12/31')             99/12/31
             3             Bob    Marketing     330.000    ('25/01/01', '99/12/31')             99/12/31
             3             Bob        Sales     300.000    ('24/01/01', '24/12/31')             24/12/31