How to update value of column B if column A contains some specific string or set of words out of sentence in column A

Question

If column A has sentence: hb_mumbai refinery data. So i need to check if column A contains hb_mumbai then update the value of column B to : hb_mumbai

I have tried to implement it using contains function but it did not produced desired output.

if df['A'].str.contains('hb_mumbai'): df['B']=='hb_mumbai'

Actual result: Value of column B is not getting updated Desired result: Value of column B should get updated.

u can use numpy.where for this which is more efficient , df.A = np.where(df.B.str.contains('hb_mumbai'),'hb_mumbai', df.A). Do import numpy as np also. — Shijith
– Shijith, Commented Jul 8, 2019 at 5:17
Possible duplicate of How to conditionally update DataFrame column in Pandas — user11563547
– user11563547, Commented Jul 8, 2019 at 5:18
while using where() can we give more than one condition in contains() function? — Manjinder Singh
– Manjinder Singh, Commented Jul 8, 2019 at 10:24

Thinh Phung · Accepted Answer · 2019-07-08 05:01:55Z

2

'=='is equality operator, not assigning values, use '=' instead

answered Jul 8, 2019 at 5:01

Thinh Phung

996 bronze badges

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

Comments

l'L'l · Accepted Answer · 2019-07-08 05:05:13Z

If df is a dictionary then you could do:

if 'hb_mumbai' in df['A']: df['B']='hb_mumbai'

As mentioned == is used for checking equality; = would assign a value.

Daniel Fischer · Accepted Answer · 2019-07-08 05:09:30Z

import pandas as pd df = pd.DataFrame({"A":['hb_mumbai in here','asd','qwe'], "B":['123','456','789'] }) print(df) df['B'] = ['hb_mumbai' if 'hb_mumbai' in a else b for a,b in zip(df['A'],df['A'])] print(df)

Collectives™ on Stack Overflow

How to update value of column B if column A contains some specific string or set of words out of sentence in column A

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related