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")
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"column_a": "<column_a>",
"column_b": "<column_b>",
"new_column": "<new_column>"
},
"name": "datetime_diff"
}
}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 |