FindInconsistencies

This Python script, dated June 5, 2023, is designed to compare two CSV files (listing_1 and listing_2) containing data, specified by the user, and identify new and old entries based on selected columns. The script reads the CSV files into pandas DataFrames, attempts to select specific columns from each DataFrame, and merges them using an outer join, creating an indicator column to show if the entry is new, old, or both. The resulting DataFrame is then written to an Excel file named "NewVals{current_date}.xlsx". Additionally, the script applies formatting to the Excel sheet, including column spacing, coloring, and borders, using a custom formatter class (MyFormatter). Finally, the user is prompted to input the file names and columns to be matched when running the script. The key functionality lies in the comparison and identification of differences between the two datasets and the visualization of the results in the Excel output.

See README.md for a much more detailed description