Text Data Cleaning Project

I have a collection of raw text records that need to be processed so they are accurate, consistent, and ready for downstream use. The task is strictly data processing—specifically text-based data cleaning.

You will work with a spreadsheet (or CSV) containing entries that suffer from extra spaces, inconsistent casing, misspellings, and occasional duplicate rows. Your job is to:

• Remove duplicates without losing any unique information
• Standardize capitalization and spacing
• Correct obvious typos using context (English only)
• Flag any ambiguous or incomplete lines for my review

Please return a cleaned file in the same format plus a short change log summarizing what was fixed. I prefer work done in Excel or Google Sheets, but Python (pandas) scripts are welcome if you include the code for transparency. Accuracy matters more than speed, so take the time to double-check your output before delivery.