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

Skills: Engineering, Python, Software Architecture, Software Testing

See more: python delete file, how to clear data in file in python, python write variable to file, python write to file, python read and delete line from file, external file python, python read and write to same file, python import data from text file, read csv file using python script, modify csv file using python, modifying csv file using python, conversion plist pdf file using python, code using python 3 on ubuntu for computer security, code using python 3, diffiehellman key exchange code using python 3 on ubuntu, practical programming an introduction to computer science using python 3, how to scrape data from linkedin using python, plotting real time data from arduino using python, extract data from linkedin using python, building ai chatbot using python 3 & tensorflow

About the Employer:
( 77 reviews ) Palmetto, United States

Project ID: #19293397

19 freelancers are bidding on average $153 for this job


Hi there,I am Python expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agre More

$183 USD in 3 days
(34 Reviews)

Hello there, This is a default bid made. we'll discuss the price later in the chat after reading your project i can do this for you perfectly.I still have a few questions. please leave a message on my chat so we can di More

$500 USD in 3 days
(31 Reviews)

Hi there, I am interested in your project. I would approach your project by using . I have 4+ years’ experience at Web scraping. If you'd like to view my previous work, take a look at my profile [login to view URL] More

$197 USD in 3 days
(86 Reviews)

Dear sir. Your project attracted my attention at first glance, because I've extensive experience in Python & CSV Programming. I'm really confident about your project, and very eager to join your project. If we have More

$200 USD in 3 days
(55 Reviews)

Hi This is a simple task. Less than a day to deliver. Output in csv files would be the best option, but I will write a script for you that you give it the input file as a param and it will create the relevant output More

$166 USD in 1 day
(10 Reviews)

hi, i worked here for a long time. I delivered quality and satisfaction. Hope to work with you. Good day

$100 USD in 2 days
(61 Reviews)

Hi there, I have read through the project description. I can help you complete the project. I will be looking forward to hear from you. Please contact me on PM for details.

$200 USD in 3 days
(35 Reviews)

Hello, how are you? I just read your requirements. I checked your project carefully, so that i feel very confident in your project because I am talented C/C++, Python developer with 8+ years. I'm going to wait your More

$150 USD in 3 days
(22 Reviews)

Hi, I can help you with this script; I've already written some lines of code and obtained the following results: [login to view URL] Still, I have a More

$111 USD in 2 days
(28 Reviews)

Dear Hiring Manager, Thank you for this wonderful opportunity. Today your job posting has caught my attention and I’m keenly considering your job post including these skills. I have excellent experience in Websit More

$155 USD in 3 days
(3 Reviews)

Hi, I am a Data Analyst at the University of Oxford, specializing in web scraping, data parsing / curation for the maintenance and update of our uni databases. I'm scripting in Python 3 and I heavily rely on regular More

$100 USD in 3 days
(2 Reviews)

Hi! I checked the attached Excel file and I can use Python for automating this task in only 2 days. My bid is only $80. Please let me know any other details you didn't mention in the description. You can check the revi More

$80 USD in 2 days
(7 Reviews)

Salutations, I have been developing scripts in the python environment for many years. I can intern your tasks at the given bid. I have experience with all of the following: Python 3 / DataProcessing / NLP SciKi More

$100 USD in 3 days
(11 Reviews)

Hi! I work with the pandas library everyday and I can clean up your table really quickly. I've thoroughly read your project and understand the task. I will not raise the price. Please let me know if you're interested i More

$111 USD in 2 days
(1 Review)

After reading your description, I noticed you needed a python to clean your .xlsx file values and insert them into a csv/.txt file. Hi, I'm Abubakar and I'm a python programmer with 2+ years experience. I can develop t More

$60 USD in 2 days
(1 Review)

I have professional experience working with large volumes of data. I know to code in python. I will provide a complete solution with all the test cases cover and tested. During development, if I get any new & interest More

$111 USD in 5 days
(0 Reviews)

I can do this work for you in given time n budget

$111 USD in 2 days
(0 Reviews)

I'm a developer with 10 years of experience in various technologies. Test Automation (Developer): ----------------------------- * Test Automation Framework * Programming Languages: TCL, Python 3.6, Expect I More

$155 USD in 3 days
(0 Reviews)

I can deliver the code as expected in the time frame mentioned with high quality. Relevant Skills and Experience I have good experience with Python

$122 USD in 3 days
(0 Reviews)