Kapalı

Web Data Mining Scraping

Task 1

I need to compile a spreadsheet of every Honda Certified Used Car dealer located in the USA which are located in the zip codes in the attached spreadsheet. See attachment. You can locate all the dealers here: [url removed, login to view] by entering the zip codes from the attached spreadsheet. You will enter the data for the dealers into the spreadsheet I have started called HondaProject.

Use google maps or some other program to calculate miles from zip code 10552 and minutes from 10552 to each dealer: [url removed, login to view]

To locate the miles and minutes, an example from row 1 in the excel file is, put 10552 into box A on the google maps page and copy & paste the address, city, state & zip from the excel file into box B

In the website column of the excel file, the website address needs to be in the form of a link so I can click on it and it will take me to the website.

To locate the website for each dealer, google the store name and typically you should have an exact match in one of the first few hits in google.

Task 2

Summary

To compile a spreadsheet in Excel of all the cars matching the following search criteria from the websites gathered in Task 1.

Make: Honda

Model: Accord

I am only looking to gather the information below for Certified Used or Certified Pre-Owned vehicles. Different websites have it listed as different phrases, but the word Certified will always be in the phrase in their website or search engine used to search for the vehicles.

I want the program to gather the following information from the websites and input it into the Excel Spreadsheet from Task 1 and create a new worksheet:

Make (always going to be Honda)

Model (always going to contain Accord, but may have a suffix, like Sedan , or Sedan SE, or Sedan EX, etc.)

Year

Mileage

VIN

Price (if no price is listed, indicate that in spreadsheet)

Link to the car on their website

Miles to the dealer’s location from zip code 10552

Ratio of Price divided by Mileage

I should be able to run this program at anytime and the program will compile the data for Task 2 into a new Worksheet.

I am looking to spend less than $50 for this project.

Beceriler: C++ Programlama, Veri İşleme, Perl, Visual Basic, Web Scraping

Daha fazlasını görün: zip car, web page spreadsheet, web form google spreadsheet, spreadsheet web form, spreadsheet web page, reset link, program used create websites, google web search address, city year, car website usa, create new web address, car codes, used car dealer, word pre, web year, web se, web model, web contain, usa b, row b, mining web, honda, excel ex, enter data website spreadsheet, data visual

İşveren Hakkında:
( 0 değerlendirme ) Mamaroneck, United States

Proje NO: #735180

8 freelancer bu iş için ortalamada 167$ teklif veriyor

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

in 5 gün içinde200$ USD
(65 Değerlendirme)
6.7
MAnkita

Hello,Please refer your PMB.Thank you.

in 5 gün içinde250$ USD
(115 Değerlendirme)
6.5
bggashnik

Hi, I am ready to start working on your project.Please check your PM.Thanks!

in 3 gün içinde50$ USD
(11 Değerlendirme)
3.6
Ventura123

check pmb.....

in 3 gün içinde250$ USD
(2 Değerlendirme)
2.6
bhogal67

Hi Iam very much interested in your project and can deliver it on and before time.

in 2 gün içinde30$ USD
(1 Değerlendirme)
1.0
Asoke321

Dear Project Creator: I can surely do your project very successfully but cannot be done below $229 in North America, if you want to get it done here by a registered and professional developer just like we want to ce Daha fazlası

in 7 gün içinde229$ USD
(0 Değerlendirme)
0.0
webscrapingpro

ALMOST SOLVED. KINDLY CHECK YOUR INBOX.

in 3 gün içinde30$ USD
(0 Değerlendirme)
0.0
habibgholizadeh

I can do this job.

in 5 gün içinde300$ USD
(0 Değerlendirme)
0.0