0

Hi is it possible to do something like this?

 np.where(COMBINED_HOUSELIST[PCT] in COMBINED_HOUSELIST[Site_Name]
,COMBINED_HOUSELIST["Site"] == COMBINED_HOUSELIST[Site_Name].replace(COMBINED_HOUSELIST[PCT], "")
, COMBINED_HOUSELIST["Site"] == COMBINED_HOUSELIST[Site_Name]
)

I'm trying to replace the town name with "" if present in the site_name e.g turn "Black Horse Birmingham" into just "Black Horse".

Thanks

Michael Amos
  • 37
  • 4
  • seems need replace one column to another, if not working pleas add sample data and expected ouput. – jezrael Nov 25 '22 at 10:43

0 Answers0