Pandas replace function does not replace value

Question

I am trying to replace values in a column, but for some reason one of the values is not changing. The three values are - 'xxx' , 'aaa' and 0. The problem is with the zero.

This is part of the code I am using:

df['source'] = np.select(conditions, ['xxx', 'aaa'], default=0) df['source'] = df['source'].replace({'xxx': 'xxx', 'aaa': 'aaa', 0: 'test'})

First I am using np.select based on some conditions and since I cant put string value on default, I want to replace the zero with another string. And I can't understand what I am doing wrong.

Just df['source'] = df['source'].replace(0, 'test') or maybe replace 0 with the string '0'? — Quang Hoang
– Quang Hoang, Commented Apr 9, 2020 at 14:24
since I cant put string value on default why is that? default = 'test' doesnot work? — anky
– anky, Commented Apr 9, 2020 at 14:25

zafrin · Accepted Answer · 2020-04-09 14:26:25Z

2

0 may be "0" as a string. check for whitespaces as well. If the series "source" is an "object" then "0" is a string.

In this case:

df['source'] = df['source'].replace({'xxx': 'xxx', 'aaa': 'aaa', '0': 'test'})

answered Apr 9, 2020 at 14:26

zafrin

4644 silver badges11 bronze badges

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

1 Comment

curiosLlama Over a year ago

Don't know why I did not try this before posting here.. Thank you.

Collectives™ on Stack Overflow

Pandas replace function does not replace value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related