This script compares values of two Excel files and creates a new file with different values. It uses pandas to read in and manipulate data, compares values using equals() function, and writes different rows to a new file using ExcelWriter(). Ideal for comparing large sets of data and identifying discrepancies quickly.
Clone the repository Install the dependencies using pip:
pip install pandas
Place the two Excel files in the same directory as the script Update the file names in the script Run the script using Python
pandas
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.
This project is licensed under the MIT License - see the LICENSE file for details.