Working with CSV in Python Part 2 - Normalizing the Name Column

In this tutorial, we continue with the problem setting described in Part 1. In order to make the data user-friendly, we need to perform a series of cleaning activities. The most outstanding is the name column which contains a mixture of full names and emails. Our goal is to work on the files so that records having emails as names will be replaced with their corresponding full names from a reference file.

Stay tuned and watch as I demonstrate how to use Python list comprehension, dictionary comprehension, and pandas map function to filter and replace incorrect data in a CSV.

If you haven’t seen the previous videos, you can it below to get a fuller understanding.

Source Code
Visit the following GitHub repository to follow along with the code used in this tutorial