historic_rows() | Teradata Package for Python - historic_rows() - Teradata Package for Python

Use the historic_rows() function to retrieve 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.

There are no parameters for this function.

Example setup

Load the data.

>>> load_example_data("teradataml", "Employee_roles")

Create a DataFrame on 'Employee_roles' table.

>>> df = DataFrame("Employee_roles")

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