split_column
Split a single text column into multiple columns using a delimiter, simplifying data parsing and enabling structured analysis.
Instructions
Split a single text column into multiple columns using a delimiter.
Args: file_path: Path to workbook. sheet_name: Worksheet name. column: Column letter or header name to split. delimiter: Delimiter string (default ","). new_columns: Optional list of new column names. drop_original: If True, remove the original column after split. output_file: Optional path to write results instead of overwriting input. header_row: 1-based header row index.
Returns: dict: Summary of created columns and row counts.
Notes:
- Destructive unless output_file is provided.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | ||
| delimiter | No | , | |
| file_path | Yes | ||
| header_row | No | ||
| sheet_name | Yes | ||
| new_columns | No | ||
| output_file | No | ||
| drop_original | No |