csv-excel-merger

Intelligently merge multiple CSV or Excel files with automatic column matching and data deduplication. When a user needs to merge CSV or Excel files: Analyze Input Files : Inspect File Structures : Create Merge Strategy : Column Matching : Conflict Resolution (when same record appears in multiple files): Deduplication : Perform Merge : Format Output : Handle Special Cases : Multiple Primary Keys : Different Data Types : Missing Columns : Large Files : Generate Code : Provide Python/pandas script that: Export Options : Column Matching : Data Quality : Performance : Transparency : Ensure merges: Generate clean, deduplicated merged files with full transparency and data quality checks. - Analyze Input Files : - How many files need to be merged? - What format (CSV, Excel, TSV)? - Are the files provided or need to be read from disk? - Do columns have the same names across files? - What is the primary key (unique identifier)? - Inspect File Structures : - Read headers from each file - Identify column names and data types - Detect encoding (UTF-8, Latin-1, etc.) - Check for missing columns - Look for duplicate column names - Create Merge Strategy : Column Matching : - Exact name match: "email" = "email" - Case-insensitive: "Email" = "email" - Fuzzy match: "E-mail" ≈ "email" - Common patterns: - "first_name", "firstname", "First Name" → "first_name" - "phone", "phone_number", "tel" →...