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

Finding Range Extremes with min() and max()

How do we find the lowest and highest product unit prices in a catalog in a single query?

Intermediate⏱ 2 Minutes⭐ 380 XP
🤔 THE QUESTION

How do we find the lowest and highest product unit prices in a catalog in a single query?

💡 WHAT IS IT?

min() and max() identify the minimum and maximum values in a Column across distributed partitions.

🎯 WHAT IS IT USED FOR?

Detecting pricing boundaries, identifying latency spikes, and tracking date ranges in event logs.

💻 EXAMPLE
from pyspark.sql.functions import col, max, min

df.select(
    min(col("unit_price")).alias("min_price"),
    max(col("unit_price")).alias("max_price")
).show()

🎯 Mission Objectives

Practice typing production-grade PySpark code for Finding Range Extremes with min() and max().

  • ✓ Import min and max functions
  • ✓ Compute pricing boundaries in single pass
  • ✓ Alias minimum and maximum metrics
🚀 Start Mission
← Prev (Calculating Averages with avg())Next Lesson (Unique Cardinality with countDistinct()) →