data_cleaner
Clean Excel sheets by running operations like trimming, deduplication, filling missing values, and normalizing data. Preview changes before applying them.
Instructions
Run a pipeline of cleaning operations (trim, dedupe, fill missing, normalize, etc.) on a sheet.
Args: file_path: Workbook path. sheet_name: Worksheet to operate on. operations: Ordered list of operations to run (see tool docs for allowed names). columns: Optional subset of columns to target. preview: If True, return a preview without persisting changes. output_file: Optional path to write cleaned results. header_row: 1-based header index. fill_missing_strategy: Strategy name for filling missing values. fill_value: Literal value to use if strategy is "value".
Returns: dict: Summary including rows modified and operations applied.
Notes:
- Document allowed operations strings in the route or underlying tool docs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columns | No | ||
| preview | No | ||
| file_path | Yes | ||
| fill_value | No | ||
| header_row | No | ||
| operations | No | ||
| sheet_name | No | Sheet1 | |
| output_file | No | ||
| fill_missing_strategy | No | value |