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


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.)




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: zip car, web page spreadsheet, web form to google spreadsheet, spreadsheet web page, spreadsheet web form, spreadsheet on web page, spreadsheet on web, spreadsheet on the web, spreadsheet in web page, scraping tools web, scraping com, reset link, program used to create websites, google web search address, google com search web, data web scraping, data scraping search engine, data link me, city year, car website usa, data scraping tools, web scraping tools, google web search by name and address, create new web address, car codes

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

Proje NO: #735180

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


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

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(65 Değerlendirme)

Hello,Please refer your [login to view URL] you.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(115 Değerlendirme)

Hi, I am ready to start working on your [login to view URL] check your [login to view URL]!

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)

check pmb.....

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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 Fazla

in %bids___i_period_sub_35% gün içinde229%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)


in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I can do this job.

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)