Pandas → T-SQL › fillna

Pandas fillna to ISNULL / COALESCE

A constant fill is ISNULL. Filling from another column is COALESCE(a, b).

ISNULL(phone, '')
COALESCE(region, country)

ffill is LAST_VALUE with IGNORE NULLS on 2022+, or a messy self-join on older boxes.

Canonical translation

ISNULL(phone, '')
COALESCE(region, country)

Then write it on a ticket

Monday is free. A colleague asks, you type, we mark it.

Clock in free