Pandas Dataframe slice fillna value not being assigned (not working)

Question

I tried this

values = {'BsmtQual':'None','BsmtCond':'None', 'BsmtExposure':'None', 'BsmtFinType1':'None', 'BsmtFinType2':'None'}
df_test.loc[:, ('BsmtQual','BsmtCond', 'BsmtExposure', 'BsmtFinType1', 'BsmtFinType2')].fillna(value=values, inplace=True)

and this

values = {'BsmtQual':'None','BsmtCond':'None', 'BsmtExposure':'None', 'BsmtFinType1':'None', 'BsmtFinType2':'None'}
df_test.loc[:, ['BsmtQual','BsmtCond', 'BsmtExposure', 'BsmtFinType1', 'BsmtFinType2']].fillna(value=values, inplace=True)

and this

values = {'BsmtQual':'None','BsmtCond':'None', 'BsmtExposure':'None', 'BsmtFinType1':'None', 'BsmtFinType2':'None'}
df_test[['BsmtQual','BsmtCond', 'BsmtExposure', 'BsmtFinType1', 'BsmtFinType2']].fillna(value=values, inplace=True)

just this

df_test[['BsmtQual','BsmtCond', 'BsmtExposure', 'BsmtFinType1', 'BsmtFinType2']].fillna('None', inplace=True)

one line with .loc

df_test.loc[:, ['BsmtQual','BsmtCond', 'BsmtExposure', 'BsmtFinType1', 'BsmtFinType2']].fillna('None', inplace=True)

and nothing worked! Please help me out

score 2 · Answer 1 · answered Jul 12 '20 at 07:42

2

You need to assign it. For example:

df_test.loc[:, ('BsmtQual','BsmtCond', 'BsmtExposure', 'BsmtFinType1', 'BsmtFinType2')] = df_test.loc[:, ('BsmtQual','BsmtCond', 'BsmtExposure', 'BsmtFinType1', 'BsmtFinType2')].fillna(value=values)

answered Jul 12 '20 at 07:42

Always Right Never Left

1,441
7
13

but I used inplace=True – Ameer Ul Islam Jul 12 '20 at 11:11
it worked though.. but why didn't 'inplace=True' didn't work :/ – Ameer Ul Islam Jul 12 '20 at 11:16
When you are using `.loc`, you are generating a new object, which is a slice of the original dataframe. `inplace=True` is applied to this new object, not the original dataframe, hence you see no changes in the original dataframe. – Always Right Never Left Jul 12 '20 at 15:49

Pandas Dataframe slice fillna value not being assigned (not working)

1 Answers1