find_duplicates
Identify and handle duplicate rows in Excel/CSV files using configurable strategies including highlighting, removal, or exporting duplicates.
Instructions
Find and manage duplicate rows in Excel/CSV files with multiple strategies
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filePath | Yes | Path to the CSV or Excel file | |
| columns | No | Columns to check for duplicates (empty = all columns) | |
| action | No | What to do with duplicates (default: report_only) | |
| keepFirst | No | Keep first occurrence when removing (default: true) | |
| sheet | No | Sheet name for Excel files (optional) |