How to extract Email column from Excel file and find out the type of mail using Pandas?

In this article, Let’s see how to Extract Email column from an Excel file and find out the type of mail using Pandas. Suppose our Excel file looks like below given image, and then we have to store different type of emails in different columns of Dataframe. 

For viewing the Excel file Click Here

Approach:

• Import required module.
• Import data from Excel file.
• Make an extra column for each different Email.
• Set Each required Index for searching.
• Define the Pattern of the Email.
• Search the Email and assigning to the respective column in Dataframe.

Let’s see Step-By-Step-Implementation:

Step 1: Import the required module and read data from Excel file.

Output:

Step 2: Make an extra column for each different Email.

Output:

Output :

Step 3: Set Each required Index for searching.

Output:

1 2 3

Step 4: Defining the Pattern of the Email.

Step 5: Searching the Email and assigning into respective column in Dataframe.

Output:

Complete Code:

Output :

Note: Before running this program, make sure you have already installed xlrd library in your Python environment.