Data transformation

Although there are a lot of objects returned by the extracted data, we do not need all the items. We will only extract the required fields. Data cleansing is one of the essential steps in the data analysis phase. For our analysis, all we need is data for the following: subject, from, date, to, label, and thread.

Let's look at all the steps involved in data transformation in the following sections.

Data cleansing

Let's create a CSV file with only the required fields. Let's start with the following steps:

1. Import the csv package:

import csv

2. Create a CSV file with only the required attributes:

with open('mailbox.csv', 'w') as outputfile:
 writer = csv.writer(outputfile...