Skip to main content
DatabricksPySparkSnowflakeApache Airflow
Code Keys/PySpark Academy/Module 07/Lesson 52
PYSPARK • LESSON 52

Left Trimming with ltrim()

How do we strip leading whitespace padding from inventory SKU codes?

Intermediate⏱ 2 Minutes⭐ 310 XP
🤔 THE QUESTION

How do we strip leading whitespace padding from inventory SKU codes?

💡 WHAT IS IT?

ltrim() strips whitespace from only the left (beginning) side of string Column values.

🎯 WHAT IS IT USED FOR?

Cleaning fixed-width formatted mainframe extracts with leading space padding.

💻 EXAMPLE
from pyspark.sql.functions import col, ltrim

df = df.withColumn("sanitized_code", ltrim(col("sku")))

🎯 Mission Objectives

Practice typing production-grade PySpark code for Left Trimming with ltrim().

  • ✓ Import ltrim function
  • ✓ Strip left-side whitespace padding
  • ✓ Sanitize inventory SKU strings
🚀 Start Mission
← Prev (Trimming Whitespace with trim())Next Lesson (Right Trimming with rtrim()) →