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')