Fill Null Values — Solution & ExplanationProblems / Fill Null Values / EditorialApproachCOALESCE(value, default) is the standard SQL function for replacing NULLs. It evaluates its arguments left-to-right and returns the first non-NULL value.SQL```sqlSELECTproduct_id, name,COALESCE(category, 'Uncategorized') AS category,COALESCE(price, 0) AS price,COALESCE(discount, 0) AS discountFROM products```In PySpark, F.coalesce() works the same way. Use F.lit() to wrap literal default values.Hints

The COALESCE function returns the first non-NULL argument.

COALESCE(column, default) replaces NULLs in column with the default value.

In PySpark, F.coalesce() works similarly — combine it with F.lit() for literal default values.

Solve Fill Null Values yourself →