Pandas: replace empty cell to 0

Question

I have a data frame results that contains empty cells and I would like to replace all empty cells with 0.

So far I have tried using pandas' fillna:

result.fillna(0)

and replace:

result.replace(r'\s+', np.nan, regex=True)

However, both with no success.

Answer 1

You are creating a copy of the dataframe but the original one is not keeping the changes, you need to specify "inplace=True" if you want the dataframe to persist the changes

result.fillna(0, inplace=True)