Hands-On Exploratory Data Analysis with Python

Data refactoring

We noticed that the from field contains more information than we need. We just need to extract an email address from that field. Let's do some refactoring:

1. First of all, import the regular expression package:

import re

2. Next, let's create a function that takes an entire string from any column and extracts an email address:

def extract_email_ID(string):  email = re.findall(r'<(.+?)>', string)  if not email:    email = list(filter(lambda y: '@' in y, string.split()))  return email[0] if email else np.nan

The preceding function is pretty straightforward, right? We have used a regular expression to find an email address. If there is no email address, we populate the field with NaN. Well, if you are not sure about regular expressions, ...