How to Extract an Email Address From Text in a Dataframe

Python

 1|  import re
 2|  
 3|  #Create dataframe from dictionary
 4|  data = {'id':[112,312,34,654],
 5|            'text': ['Email Address: akilest@gmail.com',
 6|                   'Email Address: mjikn789@gmail.com',
 7|                   'Email Address: fourtest@hotmail.com',
 8|                   'Email Address: notfor789@hotmail.com']}
 9|  df = pd.DataFrame(data)
10|  
11|  #Use regex to extract the email address from the text column
12|  df['email'] = df['text'].apply(lambda x: re.findall(r"([\w.-]+@[\w.-]+)",x)[0])
13|  
14|  >>
15|  	id	text					email
16|  0	112	Email Address: akilest@gmail.com	akilest@gmail.com
17|  1	312	Email Address: mjikn789@gmail.com	mjikn789@gmail.com
18|  2	34	Email Address: fourtest@hotmail.com	fourtest@hotmail.com
19|  3	654	Email Address: notfor789@hotmail.com	notfor789@hotmail.com
detro
Nlp | Re | Email
Did you find this snippet useful?

Sign up for free to to add this to your code library

Remove Stop Words from Text in DataFrame Column
Python

Pandas | Nltk | Nlp

133
LightGBM Custom Loss Function
Python

LightGBM | Loss function

121
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

117
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

109
How to Scale Data Using Standard Scaler But Keep Column Names
Python

Scaler | Standard

79
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

77
Calculating Root Mean Squared Error (RMSE) with Sklearn and Python
Python

Rmse

77
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

61
How to Train a Catboost Classifier with GridSearch Hyperparameter Tuning
Python

Catboost | Hyperparameter tuning

60
Overwriting a Python Logging File Instead of Appending
Python

Logging

55