How to replace a part string value of a column using another column
data['Product Name'] = data['Product Name'].str.replace('\d+','')


This should get rid of the number if that's what you are looking for. I am not sure what you mean by 'chomped.'