How do I replace all NaNs in a pandas dataframe with the string "None"

Question

I have a dataframe and some of them are empty. I want to make it a None string so I can parse it easier than a NaN value.

None a python object, NaN is a float type which is better suited to represent missing data. Can you explain what you're trying to do? — cs95
– cs95, Commented Mar 5, 2019 at 19:46

kninjaboi · Accepted Answer · 2019-03-05 19:46:26Z

1

df = df.replace(np.nan, 'None', regex=True)

Use the code above.

answered Mar 5, 2019 at 19:46

kninjaboi

2011 silver badge13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

regex=True this is not going to work especially since you are not replacing strings (np.nan is not a string)