Jul-06-2019, 02:00 AM
(Jul-06-2019, 01:49 AM)scidam Wrote: If you are usinginplace=True
you don't need to assign the result. Removeinplace=True
in your code, orprint(data_pd)
. result variable is None, because wheninplace=true
.fillna
method returnsNone
.
This is minimal working example:
import pandas as pd df = pd.DataFrame({'date': ['2001-09-01', '2001-09-02', '2001-10-01', '2001-10-03', '2001-09-03'], 'value': [1, 2, 0, None, None]}) df.date = pd.to_datetime(df.date) df.fillna(df.groupby([df.date.dt.year, df.date.dt.month]).transform('mean'), inplace=True)
Thank you a lot Mr you have helped me solve my problem