Pandas: Extract email from a specified column of string type of a given DataFrame

Last update on May 02 2025 12:52:23 (UTC/GMT +8 hours)

24. Extract Email from Column

Write a Pandas program to extract email from a specified column of string type of a given DataFrame.

Sample Solution:

Python Code :

import pandas as pd
import re as re
pd.set_option('display.max_columns', 10)
df = pd.DataFrame({
    'name_email': ['Alberto Franco [email protected]','Gino Mcneill [email protected]','Ryan Parkes [email protected]', 'Eesha Hinton', 'Gino Mcneill [email protected]']
    })
print("Original DataFrame:")
print(df)
def find_email(text):
    email = re.findall(r'[\w\.-]+@[\w\.-]+',str(text))
    return ",".join(email)
df['email']=df['name_email'].apply(lambda x: find_email(x))
print("\Extracting email from dataframe columns:")
print(df)

Sample Output:

Original DataFrame:
                    name_email
0  Alberto Franco [email protected]
1    Gino Mcneill [email protected]
2        Ryan Parkes [email protected]
3                 Eesha Hinton
4   Gino Mcneill [email protected]
\Extracting email from dataframe columns:
                    name_email          email
0  Alberto Franco [email protected]   [email protected]
1    Gino Mcneill [email protected]   [email protected]
2        Ryan Parkes [email protected]      [email protected]
3                 Eesha Hinton               
4   Gino Mcneill [email protected]  [email protected]

For more Practice: Solve these Related Problems:

Write a Pandas program to extract email addresses from a string column using regex and then output a new column with the emails.
Write a Pandas program to filter and extract valid email addresses from a DataFrame column and then count their occurrences.
Write a Pandas program to capture emails embedded in text of a column using regex and then verify by listing unique emails.
Write a Pandas program to extract email addresses from messy text in a column and then standardize them to lower case.

Go to:

Previous: Write a Pandas program to split a string of a column of a given DataFrame into multiple columns.
Next: Write a Pandas program to extract hash attached word from twitter text from the specified column of a given DataFrame.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.