Data-comparison-tool-csv-file

This Python-based GUI application compares and analyzes data between two Excel or CSV files, highlighting differences and matches.

The program is a Python-based GUI application that allows users to compare and analyze data between two files (Excel or CSV). The user can load an "old" and a "new" file, select specific columns to compare, and identify differences or matches based on a chosen primary key column. The application highlights the discrepancies and allows the user to save the results, along with statistical summaries such as the number and percentage of changes/matches. The results can be exported to an Excel file, which includes detailed data and visual representations like bar graphs for easy analysis.

Features

• Compare data between two files.
• Identify changes, matches, and differences.
• Export results to Excel with visual summaries.

Installation

1. Clone the repository:

   git clone https://github.com/yourusername/Data-comparison-tool-csv-file.git

2. Navigate to the project directory:

   cd Data-comparison-tool-csv-file

3. Install dependencies:

   pip install -r requirements.txt

4. Run the application:

   python main.py

Usage

1. Load the old and new files.
2. Select the primary key and columns to compare.
3. View the differences and save the results.

License

This project is licensed under the MIT License.