pandas determine percentage of nans in column code example

Example 1: pandas determine percentage of nans in column

>>> flights.isna().mean().round(4) * 100

Example 2: sql not null

SELECT column_name FROM table_name 
WHERE column_name IS NOT NULL;