Compare Csv

What it does

This skill, compare-csv, allows you to compare two CSV files and identify differences between them. It's designed for data validation and quality assurance tasks where discrepancies need to be highlighted. The tool can pinpoint rows that are added, removed, or modified across the compared datasets.

When to use it

• Data Migration Validation: After migrating data from one system to another, verify that all records were transferred correctly.
• A/B Testing Analysis: Compare CSV files representing different versions of a dataset used in A/B tests to assess impact.
• Report Generation Consistency: Ensure consistency between reports generated at different times by comparing their underlying CSV data sources.
• Data Quality Checks: Regularly compare datasets to identify and correct errors or inconsistencies that may have arisen over time.

Key capabilities

• CSV file comparison
• Identification of added rows
• Identification of removed rows
• Identification of modified rows

Example prompts

• "Compare these two CSV files: file1.csv and file2.csv."
• "Show me the differences between sales_data_january.csv and sales_data_february.csv."
• “Can you tell me which rows were added to customer_list_v2.csv compared to customer_list_v1.csv?”

Tips & gotchas

The skill requires access to the CSV files being compared; ensure the AI agent has appropriate permissions and paths to these files. The accuracy of the comparison depends on the structure and consistency of the CSV files (e.g., consistent headers).