Pandas Replace NaN with blank/empty string

Question

I have a Pandas Dataframe as shown below:

    1    2       3  0  a  NaN    read  1  b    l  unread  2  c  NaN    read 

I want to remove the NaN values with an empty string so that it looks like so:

    1    2       3  0  a   ""    read  1  b    l  unread  2  c   ""    read 

Answer 1

df = df.fillna('') 

or just

df.fillna('', inplace=True) 

This will fill na's (e.g. NaN's) with ''.

If you want to fill a single column, you can use:

df.column1 = df.column1.fillna('') 

One can use df['column1'] instead of df.column1.