I have a set of voter lists supplied to me in CSV format and need a clean, reliable way to spot and document every duplicate voter record. The key identifier is the EPIC ID, but I also want you to cross-check any supporting fields you feel strengthen the match logic (name spellings, date of birth, address fragments, etc.). Your task is two-fold: 1) Run a duplicate-detection routine and generate a comparative analysis that lays out every matched record in full detail. 2) Merge these findings into my existing booth-wise reports, updating both the spreadsheet versions and the accompanying plain-text summaries so they read seamlessly with the new data. I already have a reporting structure, so please follow the same column order, file naming, and booth codes. Where you add commentary, keep it concise and clearly marked. Deliverables • Cleaned master CSV with duplicates flagged or removed • Booth-wise Excel sheets and their matching TXT summaries reflecting the new counts • A separate “Duplicate_Details” file containing the side-by-side record comparison for each match Accuracy is critical; I will spot-check random booths before releasing final approval. If you work in Python, R, or any tool you prefer, note the scripts and steps so I can rerun the process for future updates.