CLEAN BRAND VALUES FROM FILE (using Python 3)

FIRST CHECK THIS -> No interested in freelancers that bid at one price without understanding the project, and raise the price later. Please take the time to understand the project carefully before bidding bc I took the time to explain it with details and price changes won't be allowed. Please submit a sample with your bid. Write a logic in python that will clean the values under the brandName Column. To clean the values should (at the row level) use all the words under the following columns (gmdnPTName, productCodeName, PT UNIQUE VALUES, GENERIC UNQUE VALUES, KPTS UNIQUE VALUES, BODY PART VALUES, MATERIAL VALUES) and remove those if they are under brandName string and publish 2 last columns: one called "brandName cleaned" which is the brandName string wo the words in other columns and the other called "remnant" which should have the words removed in the order they appeared in brandName Be carefull to remove singular and plural versions Please check the first rows In the file attached as an example Deliver the data in the excel format using the specified columns. The data should be in csv/txt or excel with the data in txt (meaning even numeric values must be in txt to not miss leading zeros) Deliver the code in python 3