Cleaning Data with Python and Excel: A Brief Example
I want to show a simple, real world problem and solution I made today with Python. Problem: My data has been corrupted (over 8,000 rows in Excel). Somewhere in my haste, I have scrambled first names and last names in the ‘first name’ and ‘last name’ field. Solution: Find unique words from both fields, which leads […]