easy5 pts · first answer countspythonpandasdata-cleaning

Duplicates hiding behind spaces and case

"Anil@Mail.com " and "anil@mail.com" are the same customer, but drop_duplicates keeps both. What should you do first?

A.df["email"] = df["email"].str.strip().str.lower()B.df["email"] = df["email"].astype("category")C.df["email"] = df["email"].str.title()D.df["email"] = df["email"].replace(" ", None)

Discussion 0

Join free to post in the discussion.

Duplicates hiding behind spaces and case

Discussion 0

Related questions