1. What this prompt does

• Function: This AI-driven prompt compares two CSV files to identify and report on added, removed, and changed rows. It highlights the top 10 key column differences and flags suspicious values, offering a comprehensive analysis of data changes and potential anomalies.
• Target:
  • Data Analysts: Streamline data comparison processes for accurate reporting.
  • QA Engineers: Quickly identify discrepancies in data sets during testing phases.
  • Project Managers: Monitor data changes for project accuracy and integrity.
  • Researchers: Ensure data consistency and spot anomalies in research datasets.
• Benefit:
  • Save time by automating CSV comparison and analysis.
  • Get clear insights with detailed reports on data changes.
  • Avoid errors by detecting suspicious values in datasets.
  • Enhance data integrity with reliable analysis of differences.

2. How do you use this prompt?

1. Open ChatGPT
2. Copy the prompt/workflow content
3. Paste into ChatGPT and run
   User Input :

   Compare two versions of a CSV file and generate a report including:
   1. Counts of added, removed, and changed rows.
   2. Samples of added, removed, and changed rows.
   3. Top 10 differences in key columns.
   4. Any suspicious values found in the data.
   
   To execute, provide:
   - The path to both CSV files.
   - The column to use as the key identifier for comparing rows.
   - Any specific columns of interest for detailed comparison.
   

4. Get a detailed report comparing the two CSV versions.

3. When will you need this prompt?

• Data Analysts → When you need to quickly identify what has changed between two data sets for reporting.
• QA Engineers → During testing, to ensure data integrity by comparing test and control data.
• Project Managers → When checking for unauthorized data changes in project databases.
• Researchers → To verify that data remains consistent across different research phases.
• Business Analysts → For regular audits of data integrity and accuracy in business reports.