Web Scraping: Find carrying capacity of vehicle with hitches
We would like to obtain data on the carrying capacity of vehicles.
Attached is an excel sheet containing data for 2016, 2018, 2020 vehicles,
We require the following datapoints:
* Gross Vehicle Weight Rating (GVWR) (lbs)
* Payload (lbs)
* Curb Weight (lbs)
* Vehicle Length (in)
* Wheel Base (in)
* Source of data (example: [login to view URL], [login to view URL], or [login to view URL])
Gross Weight, GVWR, Gross Vehicle Weight Rating (GVWR) (lbs) are different names for the same thing.
Typically, Gross Weight or is equal to the sum of Payload and Curb Weight, so for GVWR, Payload and Curb Weight, it is acceptable if only 2 of them are available.
The excel workbook attached contains 3 sheets, one for each year, 2016, 2018, 2020.
4,700 vehicles in total. 3,580 are completed. 1,120 are unfinished.
The names are all listed, we only need the missing data completed.
Most will be found easily on www.edmunds.com. The names of the cars and trim levels match perfectly.
[login to view URL] might not list Gross Weight and Payload for some smaller cars.
However, Gross Weight and Payload can usually be found on [login to view URL] or [login to view URL] or the manufacture's site.
We have a lot of cars due to listing every trim style, Many of the cars have the same wheelbases and overall lengths for every trim style. However, Trucks and Vans lengths and wheelbases can vary with trim style.
The point is, There are not so many unique data points. Many can be entered once and populated down the sheet. As a result this project should take less than 20 hrs to do completely manual.
I'm going to post and then give freelancers time to understand the project before awarding.
37 freelancers are bidding on average $375 for this job
Hello, Please review my profile as I have the relevant skills and experience required for this project Kindly send me a message to discuss further Thanks, Faiza