Pandas if row name is not a specific string change to desired string name

Question

I am working with a pandas dataframe. I would like to change the name in a column if it DOES NOT equal "false" to the word "NAMED".

df
   hash
0  false
1  false
2  asldkjfl645sd54
3  false
4  65s4d65a3s21d12
5  2s1d53a54d5f1a3

Desired output:

df
   hash
0  false
1  false
2  NAMED
3  false
4  NAMED
5  NAMED

df['hash'].where(df['hash'].eq('false'), 'NAMED')

user3483203
– user3483203

2019-09-18 18:23:58 +00:00
Commented Sep 18, 2019 at 18:23 — user3483203
– user3483203, Commented Sep 18, 2019 at 18:23

Celius Stingher · Accepted Answer · 2019-09-18 18:27:09Z

3

You can try with this:

import pandas as pd

a = {'hash':['false','false','asldkjfl645sd54','34ds','65s4d65a3s21d12','2s1d53a54d5f1a3']}
df = pd.DataFrame(a)
df['hash'] = df['hash'].where(df['hash'] == 'false', 'NAMED')
print(df)

Output:

    hash
0  false
1  false
2  NAMED
3  NAMED
4  false
5  NAMED

answered Sep 18, 2019 at 18:27

Celius Stingher

18.4k6 gold badges26 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Pandas if row name is not a specific string change to desired string name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related