Use None instead of np.nan for null values in pandas DataFrame

Solution 1:

Use pd.DataFrame.where
Uses df value when condition is met, otherwise uses None

df.where(df.notnull(), None)

enter image description here