Topic starter 06/12/2021 8:37 pm
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
Topic starter 06/12/2021 8:39 pm
UseĀ
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.