Lowercase Conversion with lower()

How do we normalize customer email addresses to lowercase to prevent case-sensitive duplicates?

Intermediate⏱ 2 Minutes⭐ 290 XP

🤔 THE QUESTION

How do we normalize customer email addresses to lowercase to prevent case-sensitive duplicates?

💡 WHAT IS IT?

lower() converts all alphabetic characters in a string Column to lowercase.

🎯 WHAT IS IT USED FOR?

Email address deduplication, username normalization, and search query tokenization.

💻 EXAMPLE

from pyspark.sql.functions import col, lower

df = df.withColumn("clean_email", lower(col("email")))

Practice typing production-grade PySpark code for Lowercase Conversion with lower().