Replace specific dataframe columns values with blank

Question

I have dataframe column (df) which I am trying to replace 999 values with blank. The head of the unadjusted column looks like:

Name: IntValue, dtype: int32
0    999
1     50
2     50
3     55
4     58

I would like the adjusted column to be adjusted to look like:

Name: IntValue, dtype: int32
0    
1     50
2     50
3     55
4     58

I am using:

rawDatabase[newFieldTrunc].replace(999, "")

But it's not changing the columns data at all.

iDrwish · Accepted Answer · 2018-04-30 11:37:28Z

1

Because you are replacing over a copy of the Series, not the actual Series.

rawDatabase[newFieldTrunc].replace(999, "", inplace=True)

Or

rawDatabase[newFieldTrunc] = rawDatabase[newFieldTrunc].replace(999, "")

PS: It is advised to use Python native None or np.nan as a placeholder for blanks instead of a blank text "".

answered Apr 30, 2018 at 11:37

iDrwish

3,1131 gold badge18 silver badges24 bronze badges

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

Comments

sjw · Accepted Answer · 2018-04-30 11:37:20Z

0

To alter the DataFrame inplace, you need to set the inplace argument to True:

rawDatabase[newFieldTrunc].replace(999, "", inplace=True)

answered Apr 30, 2018 at 11:37

sjw

6,5512 gold badges30 silver badges41 bronze badges

Joe · Accepted Answer · 2018-04-30 11:38:16Z

0

As alternative to the previous answers:

 rawDatabase[newFieldTrunc] = rawDatabase[newFieldTrunc].replace(999, "")

answered Apr 30, 2018 at 11:38

Joe

12.4k7 gold badges44 silver badges58 bronze badges