Excel Data Deduplication & Report

I have a dataset stored in several Excel/CSV files that needs a thorough scrub. My priority is to spot and remove every duplicate, validate the remaining records, and then document exactly what was changed... (Budget: ₹750 - ₹1250 INR, Jobs: Data Analysis, Data Cleansing, Data Management, Data Processing, Excel, Python, SPSS Statistics, Statistical Analysis)