google refine

Paul Bradshaw Data Journalism Massive -- scattered notes

Submitted by Ændrew Rininsland on Wed, 10/19/2011 - 15:47

Scraping

  • Tools:
    • OutWit Hub
    • Needlebase
    • Scraperwiki
    • Google Spreadsheets
    • Formulae
  • Walkthru using Google Docs (=import)
    1. Open a spreadsheet
    2. In A1, type the URL of a page with a table.
    3. In cell A2, type: =ImportHTML(A1, "table", 1)
    4. Function importHTML($source, $element, $index)
      • Source = Where you're getting data from. Can be a spreadsheet cell.
Tags: 
notes
lectures
data
scraping
google refine
google spreadsheet
Subscribe to RSS - google refine
© copyright 2011 Ændrew Rininsland. Most content CC-licensed.. Drupal theme by Kiwi Themes.