Archive

Posts Tagged ‘Web Scraping’

Scrape Data from Yellow Page


This an example work of data scraping, data mining / data harvesting  from Yellow Pages.

I scraped the UK based yellow pages for search term ‘Car Dealers’ and extracted the Name of the company,address, web URL , phone numbers etc.

First 10 pages’ data has been captured and saved to excel or csv and also be able to run through proxies so that no blockage takes place. Data also inserted into MySql Database , so that I can manipulate whatever the operation need on these as per client requirements.

On that time what I got on yellow page site after searching by ‘Car Dealers’:

http://www.yell.com/ucs/UcsSearchAction.do?startAt=0&keywords=car+dealers&location=london&scrambleSeed=69225616&ssm=1&showOoa=10&ppcStartAt=0&pageNum=1

The snapshot of this:

Item Sets for Scraping on Yellow Page website

 

One example snapshot of spreadsheet report , however I can efficiently deliver the report to  CSV / XML / PDF / MySQL database;

Report after Data Mining / Harvesting

Advertisements
%d bloggers like this: