Price data pull and data cleansing

Hi, This project is in 3 parts as follows: 1. Web scraping for pricing information - For 18 car models (contained in the tab called Car List in the attached Excel file), I need the price for car parts as listed on the following websites: o [login to view URL] o [login to view URL] o [login to view URL] o [login to view URL] o [login to view URL] You can start with the first two websites and then we’ll determine whether we need the rest based on data we get from the first two - I only really need one set of price for each car and part. The reason why I have provided multiple websites is as follows: o You might find some sites easier to scrape than others o You might not find enough parts for a particular car from just one website - Something to note about the car list is that most of the cars will have variations to the name. For example, I have included Toyota Camry on the list. When picking cars from the dropdown on the websites, you will find trim/variations like Camry SE, Camry CE and with engine variations. You can choose any trim/variation for a certain make for one year and stick to that trim for that year - Note that each website has different ways of categorizing and naming the parts. In the data summary tab, I have laid out the car parts I am interested in. In reality, the parts on the websites may not have those exact names so you will need to use the names in my list like search keywords to pull parts that are similar to that name. In several instances, this means that you will most likely pull multiple parts from the websites for each item in my list. 2. Data mapping - Ultimately I will need your help to trim the raw data pulled to only show those that are as close as possible in name and description to the ones in my list. 3. Data presentation and summary - After trimming the data/cleansing the data to the best of your ability, I will need you to create a tab for each vehicle and summarize the data using the template called Data Summary in the attached file. You will need to create a separate tab for each car model. Please let us know if this is something you are comfortable working on and let us know how much you will charge for the project. Thanks Bshore