Page 20 sur 25
Extract a specific string
[code]# Delete what is before SpecificString
df['NewField'] = df['OldField'].replace({'.*(?=SpecificString)': ''}, regex=True)
# Delete what is after SpecificString
df['NewField'] = df['NewField'].replace({'(?<=SpecificString).*': ''}, regex=True)[/code]
Extract names from email
[code]from email_decomposer.EmailDecomposer import EmailDecomposer
email_decomposer = EmailDecomposer()
df[['first_name', 'last_name', 'host']] = df['email'].apply(
lambda x: pd.Series(email_decomposer.decompose(data=x, get_host=True)))[/code]