Jan-27-2023, 09:25 PM
(This post was last modified: Jan-27-2023, 09:25 PM by deanhystad.)
import pandas as pd df = pd.DataFrame({"Email": ["[email protected]", "[email protected]", "[email protected]"]}) df["domain"] = df["Email"].apply(lambda a: a.split("@")[1]) df["name"] = df["Email"].map(lambda a: a.split("@")[0]) print(df)
Output: Email domain name
0 [email protected] gmail.com A
1 [email protected] outlook.com B
2 [email protected] aol.com C
Orimport pandas as pd df = pd.DataFrame({"Email": ["[email protected]", "[email protected]", "[email protected]"]}) df[["Name", "Domain"]] = df["Email"].str.split("@", expand=True) print(df)
Output: Email Name Domain
0 [email protected] A gmail.com
1 [email protected] B outlook.com
2 [email protected] C aol.com