Teradata Package for Python Function Reference on VantageCloud Lake - historic_rows - 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.dataframe.DataFrame.historic_rows = historic_rows(self)
DESCRIPTION:
    Retrieves historical rows from a DataFrame created on a valid-time 
    or bi-temporal table/view. Historical rows are defined as those where the 
    end of the valid-time period precedes the current time.
 
PARAMETERS:
    None.
 
RETURNS:
    teradataml DataFrame.
 
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")
 
    # Retrieve historic rows from the DataFrame.
    >>> df.historic_rows()
    EmployeeID    EmployeeName    Department    Salary          role_validity_period
             1        John Doe            IT     100.0      ('20/01/01', '24/12/31')
             3             Bob         Sales     300.0      ('24/01/01', '24/12/31')