Replacing values in pandas data frame with None

Question

This thread here shows replace with inplace=True to change values in pandas data frame.

I want to apply the same technique, but replacing with None

mydf = pd.DataFrame({"col1":[5, 5, 8, 4, 5], "col2":[2, 5, 6, 7, 5]})
mydf.replace([5], None, inplace=True)

mydf changes like this and there is an additional output

   col1  col2
0     5     2
1     5     2
2     8     6
3     4     7
4     4     7

col1    None
col2    None
dtype: object

How to replace values with None?

Corralien · Accepted Answer · 2021-06-17 19:52:51Z

1

Prefer use pd.NA rather than None. Read this

mydf.replace([5], pd.NA, inplace=True)
# mydf.replace([5], [None], inplace=True)

>>> mydf
   col1  col2
0  <NA>     2
1  <NA>  <NA>
2     8     6
3     4     7
4  <NA>  <NA>

edited Jun 17, 2021 at 19:52

answered Jun 17, 2021 at 19:46

Corralien

121k8 gold badges44 silver badges69 bronze badges

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

Comments

Mustafa Aydın · Accepted Answer · 2021-06-17 19:50:38Z

1

None also happens to be the default value for value argument so if you need to use it, you can place it in a 1-element list to distinguish that you're not passing the default:

mydf = mydf.replace([5], [None])

also: inplace=True is not so good, opt for assigning back

answered Jun 17, 2021 at 19:50

Mustafa Aydın

18.4k4 gold badges21 silver badges43 bronze badges

Collectives™ on Stack Overflow

Replacing values in pandas data frame with None

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related