Making data on the web useful: scraping

Introduction

Many times data is not easily accessible – although it does exist. As much as we wish everything was available in CSV or the format of our choice – most data is published in different forms on the web. What if you want to use the data to combine it with other datasets and explore it independently?

Scraping to the rescue!

Scraping describes the method to extract data hidden in documents – such as Web Pages and PDFs and make it useable for further processing. It is among the most useful skills if you set out to investigate data – and most of the time it’s not especially challenging. For the most simple ways of scraping you don’t even need to know how to write code.

This example relies heavily on Google Chrome for the first part. Some things work well with other browsers, however we will be using one specific browser extension only available on Chrome. If you can’t install Chrome, don’t worry the principles remain similar.

Code-free Scraping in 5 minutes using Google Spreadsheets & Google Chrome

Knowing the structure of a website is the first step towards extracting and using the data. Let’s get our data into a spreadsheet – so we can use it further. An easy way to do this is provided by a special formula in Google Spreadsheets.

Save yourselves hours of time in copy-paste agony with the ImportHTML command in Google Spreadsheets. It really is magic!

Recipes

In order to complete the next challenge, take a look in the Handbook at one of the following recipes:

  1. Extracting data from HTML tables.
  2. Scraping using the Scraper Extension for Chrome

http://farm9.staticflickr.com/8303/7850933084_b188c02992_o_d.jpg

Both methods are useful for:

  • Extracting individual lists or tables from single webpages

The latter can do slightly more complex tasks, such as extracting nested information. Take a look at the recipe for more details.

Neither will work for:

  • Extracting data spread across multiple webpages

Challenge

Task: Find a website with a table and scrape the information from it. Share your result on datahub.io (make sure to tag your dataset with schoolofdata.org)

Tip

Once you’ve got your table into the spreadsheet, you may want to move it around, or put it in another sheet. Right click the top left cell and select “paste special” – “paste values only”.

Scraping more than one webpage: Scraperwiki

Note: Before proceeding into full scraping mode, it’s helpful to understand the flesh and bones of what makes up a webpage. Read the Introduction to HTML recipe in the handbook.

Until now we’ve only scraped data from a single webpage. What if there are more? Or you want to scrape complex databases? You’ll need to learn how to program – at least a bit.

It’s beyond the scope of this course to teach how to scrape, our aim here is to help you understand whether it is worth investing your time to learn, and to point you at some useful resources to help you on your way!

Structure of a scraper

Scrapers are comprised of three core parts:

  1. A queue of pages to scrape
  2. An area for structured data to be stored, such as a database
  3. A downloader and parser that adds URLs to the queue and/or structured information to the database.

Fortunately for you there is a good website for programming scrapers: ScraperWiki.com

http://farm9.staticflickr.com/8112/8660176200_2dd5aa8d0b_z.jpg

ScraperWiki has two main functions: You can write scrapers – which are optionally run regularly and the data is available to everyone visiting – or you can request them to write scrapers for you. The latter costs some money – however it helps to contact the Scraperwiki community (Google Group) someone might get excited about your project and help you!.

If you are interested in writing scrapers with Scraperwiki, check out this sample scraper – scraping some data about Parliament. Click View source to see the details. Also check out the Scraperwiki documentation: https://scraperwiki.com/docs/python/

When should I make the investment to learn how to scrape?

A few reasons (non-exhaustive list!):

  1. If you regularly have to extract data where there are numerous tables in one page.
  2. If your information is spread across numerous pages.
  3. If you want to run the scraper regularly (e.g. if information is released every week or month).
  4. If you want things like email alerts if information on a particular webpage changes.

…And you don’t want to pay someone else to do it for you!

Summary:

In this course we’ve covered Web scraping and how to extract data from websites. The main function of scraping is to convert data that is semi-structured into structured data and make it easily useable for further processing. While this is a relatively simple task with a bit of programming – for single webpages it is also feasible without any programming at all. We’ve introduced =importHTML and the Scraper extension for your scraping needs.

Further Reading

Any questions? Got stuck? Ask School of Data!

Last updated on Sep 02, 2013.

  • http://www.facebook.com/jonathan.b.bechtel Jonathan Bechtel

    This is very helpful, but I was caught up with the following step:

    Once you’ve done this, filter the constituency field for “(blank)” values – this will give you all the letter headings (If you’re not sure how to do this – check out this course (link to spreadsheets intro sort&filter)

    Did you mean to link to something here?

  • Andrew Omondi

    DataMiner is an extension for scraping data out of web pages and into Microsoft Excel .You can get it from Chrome Web store.

  • Peter Neubauer

    Isn’t there also import.io for scraping?

  • dhamu

    hi, Am a webdatascraper ,I will scrap any kind of data from any website and give any format like csv,excel,database.Any one need help contact me

    If you need my help contact me. Website : http://www.webrippertools.com email : webdatascraper@gmail.com

    Regards, Dhamu

  • Jack Smith

    Scraping is a technique that is best used by experts. http://www.website-datascrapingexperts.com

  • Jack Smith

    Scraping is a technique that is best used by experts.

    http://www.website-datascraping-experts.com