Home > Scrape - Yellow Page > Scrape Data from Yellow Page

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
  1. May 7, 2013 at 5:22 pm

    Great website you have here but I was curious if you knew of any user discussion forums that cover the same topics talked about in this article?

    I’d really like to be a part of online community where I can get comments from other knowledgeable individuals that share the same interest. If you have any recommendations, please let me know. Kudos!

  2. May 7, 2013 at 6:01 pm

    Thanks for your comment.

    I have started a new website and blog very recently: http://www.wscraper.com/blog/2013/is-web-scraping-lawful/

    I/we need to bring this to other knowledgeable individuals who are interested to make comments on this data scraping fields. Or I may make it open for blogging on the same IT related topics.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: