how to select and change data in python pandas dataframe

Question

Using the following as a simple example in pandas:

dataframe

        height  animal
1       33      dog
2       22      cat
3       1000    elephant
4       35      dog
.
.
1000    45      dog

how can i select all dog strings and set them to 0?

iv tried:

df['name'][df['name'] == 'dog'] = 0

but unfortunately is did not work

`df.loc[df.animal == 'dog','animal'] = 0` – DJK Sep 28 '17 at 19:17 — DJK, Sep 28 '17 at 19:17

BENY · Answer 1 · 2017-09-28T19:21:21.770

1

Just using replace

df.replace({'dog':0})

EDIT

df['animal'].replace('dog', 0)

edited Sep 28 '17 at 19:21

answered Sep 28 '17 at 19:19

BENY

That alters other columns, use `df['animal'].replace('dog', 0)` – Zero Sep 28 '17 at 19:20

score 0 · Answer 2 · answered Sep 28 '17 at 19:17

0

Try this

df['animal'][df['animal'] == 'dog'] = 0

answered Sep 28 '17 at 19:17

prudhvi Indana

2 Answers2