Cleaning Invalid Email Characters

Overview

This instance we will clean invalid email characters from our data. This won’t determine if they are valid. However it will give us an idea of who is actually interested in receiving promotional materials.

Procedure:

• Read data from our SQL database.
• Use Pandas to view and sort.
• Check to see if emails contain an “@” symbol.
• Remove invalid email characters such as $%#~ etc.

Tech

• Python
• Pandas
• Sqlite3
• Jupyter Notebook