sql replace null values code example
Example 1: replace null with 0 in sql
SELECT IFNULL(Price, 0) FROM Products;
SELECT COALESCE(Price, 0) FROM Products;
-- Oracle (extra):
SELECT NVL(Price, 0) FROM Products;
Example 2: Replace null values
# Replace null values
df4.na.fill(50).show()
# +---+------+-----+
# |age|height| name|
# +---+------+-----+
# | 10| 80|Alice|
# | 5| 50| Bob|
# | 50| 50| Tom|
# | 50| 50| null|
# +---+------+-----+
df5.na.fill(False).show()
# +----+-------+-----+
# | age| name| spy|
# +----+-------+-----+
# | 10| Alice|false|
# | 5| Bob|false|
# |null|Mallory| true|
# +----+-------+-----+
df4.na.fill({'age': 50, 'name': 'unknown'}).show()
# +---+------+-------+
# |age|height| name|
# +---+------+-------+
# | 10| 80| Alice|
# | 5| null| Bob|
# | 50| null| Tom|
# | 50| null|unknown|
# +---+------+-------+