How to iterate (validate_email) through a dataframe column

Question

How to iterate through the email column(x) with the lines below

validate_email(x, check_mx=True)
validate_email(x, verify=True)

#pip install pyDNS
#pip install validate_email

import pandas as pd 
from validate_email import validate_email

# initialize list of lists
data = [['[email protected]','True','True'], ['[email protected]','True','False'], ['[email protected]','False','False']]
 
# Create the pandas DataFrame
df = pd.DataFrame(data, columns=['email', 'check_mx', 'verify'])
 
# print dataframe.
df

Output should look like the image below:

gtomer · Accepted Answer · 2022-06-15 15:17:13Z

1

There is a package for that:

from validate_email import validate_email
df['is_valid_email'] = df['email'].apply(lambda x:validate_email(x))

This will create a column with a value if the email address is valid

answered Jun 15, 2022 at 15:17

gtomer

6,5941 gold badge14 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to iterate (validate_email) through a dataframe column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related