pandas replace boolean value with string or integer

Question

This is snipett of my code with column values comparison:

import pandas as pd
df =pd.DataFrame({'coname1':['Apple','Yahoo','Gap Inc'],'coname2':['Apple', 'Google', 'Apple']})
df['eq'] =df.apply(lambda row: row['coname1'] == row['coname2'],axis=1)

The problem is that I am interested with Character (True='Y' or False = 'N') or Integer (True= 1 or False = 0) values.

Option df.replace(['True', 'False'],[1,0]) doesn't work Thank you

Answer 1

When assigning the 'eq' column, use atype(int). The int conversion turns True into 1 and False into 0

df = pd.DataFrame({'coname1': ['Apple','Yahoo','Gap Inc'], 'coname2':['Apple', 'Google', 'Apple']})
df['eq'] = df.apply(lambda row: row['coname1'] == row['coname2'], axis=1).astype(int)

---

For characters

df['eq'] = np.where(df['eq'], 'Y', 'N')
df