parse_date_column
Parse inconsistent date formats in an Excel column and write normalized dates to a specified output column, with options for day-first parsing and custom output format.
Instructions
Parse varying date formats in a column and write normalized results to an output column.
Args:
file_path: Workbook path.
sheet_name: Worksheet name.
column: Column to parse.
output_column: Optional target column; if omitted, overwrites column.
output_format: Strftime format for normalized output.
dayfirst: Whether to parse day-first dates.
header_row: 1-based header index.
Returns: dict: Summary including number of parsed rows and parse errors.
Notes:
- Destructive by default when output_column targets existing column.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | ||
| dayfirst | No | ||
| file_path | Yes | ||
| header_row | No | ||
| sheet_name | Yes | ||
| output_column | No | ||
| output_format | No | %Y-%m-%d |