SQL Expressions with selectExpr()

How can we apply inline SQL calculations and column renaming directly inside a select operation?

Beginner⏱ 2 Minutes⭐ 170 XP

🤔 THE QUESTION

How can we apply inline SQL calculations and column renaming directly inside a select operation?

💡 WHAT IS IT?

selectExpr() accepts standard SQL expression strings, allowing simultaneous calculation and alias projection.

🎯 WHAT IS IT USED FOR?

Quick column arithmetic, conditional SQL expressions, and column aliasing without importing functions.

💻 EXAMPLE

df.selectExpr("name", "salary * 1.10 AS revised_salary").show()

Practice typing production-grade PySpark code for SQL Expressions with selectExpr().