How to replace matching rows

[SriMekala]

Hi,
I have below DataFrame, I want to replace if row value contains 'pass' with '0'.

1 2 3 4

import pandas as pd   df=pd.DataFrame({'Name':['NHAY', 'HAY','UTY','UIK', 'JUI','YTH'],'Status':['Pass','Running','pass(warning 0)','pass','fail','passed']}) df.loc[df['Status'].str.contains('pass', case=False), 'Status'] = 0

but if in case I want to column number (like here in this case 1), how to do it.

[scidam]

You can do this e.g., as follows:

1	df.iloc[:, 1][df.iloc[:, 1].str.contains('pass', case=False)] = 0

[SriMekala]

I want to add a column and apply the above condition, I use below code but all rows fill with zeros.

1	df['Add']=df.loc[df['Status'].str.contains('pass', case=False), 'Status'] = 0