Replace None with NaN in pandas dataframe

Question

I have table x           website 0   http   www google com  1   http   www yahoo com 2   None   I want to replace python None with pandas NaN  I tried   x replace to replace None  value np nan    But I got   TypeError   regex  must be a string or a compiled regular expression or a list or dict of strings or regular expressions  you passed a  bool    How should I go about it

User · Accepted Answer

You can use DataFrame fillna or Series fillna which will replace the Python object None  not the string  None   import pandas as pd import numpy as np  For dataframe  df   df fillna value np nan   For column or series  df mycol fillna value np nan  inplace True

User · Answer

Here s another option   df replace to replace  None   value np nan  inplace True

User · Answer

DataFrame  Col name   replace  None   np nan  inplace True

User · Answer

If you use df replace  None   np nan  inplace True   this changed all datetime objects with missing data to object dtypes  So now you may have broken queries unless you change them back to datetime which can be taxing depending on the size of your data    If you want to use this method  you can first identify the object dtype fields in your df and then replace the None   obj columns   list df select dtypes include   object    columns values  df obj columns    df obj columns  replace  None   np nan

User · Answer

The following line replaces None with NaN   df  column   replace  None   np nan  inplace True

[pandas] Replace None with NaN in pandas dataframe

Examples related to pandas

Examples related to dataframe

Examples related to replace

Examples related to nan

Examples related to nonetype