datetime_diff
Compute the time difference between two datetime columns and add a numeric duration feature. Supports units like days, hours, minutes, seconds for metrics such as age, tenure, or delivery time.
Instructions
Compute time difference between two datetime columns (column_a - column_b). Units: days, hours, minutes, seconds. Creates a new numeric column. Create duration features between two dates (e.g., delivery time, age, tenure). Result is a numeric column ready for modeling. Example: datetime_diff(column_a="end_date", column_b="start_date", new_column="duration_days", unit="days")
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| unit | No | days | |
| df_name | No | ||
| column_a | Yes | ||
| column_b | Yes | ||
| new_column | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |