Jan-30-2023, 01:19 PM
(Jan-27-2023, 09:25 PM)deanhystad Wrote: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)Or
Output:Email domain name 0 [email protected] gmail.com A 1 [email protected] outlook.com B 2 [email protected] aol.com C
import 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
deanhystad - Thank kindly for the help. - Both versions worked very well.