Scraping for Journalists (2nd edition)
Scraping for Journalists (2nd edition)
How to grab information from hundreds of sources, put it in data you can interrogate - and still hit deadlines
About the Book
Scraping - getting a computer to capture information from online sources - is one of the most powerful techniques for data-savvy journalists who want to get to the story first, or find exclusives that no one else has spotted. Faster than FOI and more detailed than advanced search techniques, scraping also allows you to grab data that organisations would rather you didn’t have - and put it into a form that allows you to get answers.
Scraping for Journalists introduces you to a range of scraping techniques - from very simple scraping techniques which are no more complicated than a spreadsheet formula, to more complex challenges such as scraping databases or hundreds of documents. At every stage you'll see results - but you'll also be building towards more ambitious and powerful tools.
You’ll be scraping within 5 minutes of reading the first chapter - but more importantly you'll be learning key principles and techniques for dealing with scraping problems.
Unlike general books about programming languages, everything in this book has a direct application for journalism, and each principle of programming is related to their application in scraping for newsgathering. And unlike standalone guides and blog posts that cover particular tools or techniques, this book aims to give you skills that you can apply in new situations and with new tools.
- Your own robot
- A book about not reading books
- I’m not a programmer
- PS: This isn’t a book
2. Scraper #1: Start scraping in 5 minutes
- How it works: functions and parameters
- What are the parameters? Strings and indexes
- Tables and lists?
3. Scraper #2: What happens when the data isn’t in a table?
- Strong structure: XML
- Scraping XML
4. Scraper #3: Looking for structure in HTML
- Detour: Introduction to HTML and the LIFO rule
- Attributes and values
- Classifying sections of content: div, span, classes and ids
- Back to Scraper #3: Scraping a <div> in a HTML webpage
5. Scraper #4: Finding more structure in webpages: Xpath
6. Scraper #5: Scraping multiple pages with Google Drive
7. Scraper #6: Structure in URLs - using Open Refine
- Looking for structure in URLs
- Assembling the ingredients
- Grabbing ID codes or URLs from a website
- Using Open Refine as a scraper
- Grabbing the HTML for each page
Extracting data from the raw HTML with
- Using CSS selectors in scraping
- Understanding the results
8. Scraper #7: Scraping multiple pages with ‘next’ links using Outwit Hub
- Creating a basic scraper in OutWit Hub
- Scraping a series of pages
- Customised scrapers in OutWit
- Trying it out on a search for questions about health
9. Scraper #8: Poorly formatted webpages - solving problems with OutWit
- Identifying what structure there is
- Repeating a heading or other piece of data for each part within it
- Splitting a larger piece of data into bits: using separators
10. Scraper #9: Scraping uglier HTML and ‘regular expressions’ in an OutWit scraper
- Introducing Regex
- Using regex to specify a range of possible matches
- Catching the regular expression too
- I want any character: the wildcard and quantifiers
- Matching zero, one or more characters - quantifiers
- 3 questions: What characters, how many, where?
- Using regex on an ugly page
- What’s the pattern?
- Matching non-textual characters
- What if my data contains full stops, forward slashes or other special characters?
- ‘Anything but that!’ - negative matches
- This or that - looking for more than one regular expression at the same time
- Only here - specifying location
- Back to the scraper: grabbing the rest of the data
- Which dash? Negative matches in practice.
11. Scrapers #10 and #11: Scraping hidden and ‘invisible’ data on a webpage: icons and ‘reveals’
- Scraping accessibility data on Olympic venues
- Hidden HTML
12. Scraper #12: An introduction to Python: adapting scraper code
- Python - you already know some of it
- The ScraperWiki Classic Archive
- Forking a scraper
- Introducing Morph.io
- Finding a scraper to clone
- How to copy a scraper into Morph.io
- Adapting the code
13. Scraper #13: Tracing the code - libraries and functions, and documentation in Scraperwiki
- Parent/child relationships
- Parameters (again)
- Detour: Variables
- Back to Scraper #9
14. Scraper #13 continued: Scraperwiki’s tutorial scraper 2
- What are those variables?
- Detour: loops (for and while)
- Back to scraper #13: Storing the data
- Detour: Unique keys, primary keys, and databases
- A unique key can’t be empty: fixing the error
- Summing up the scraper
15. Scraper #14: Adapting the code to scrape a different webpage
- Dealing with errors
16. Scraper #15: Scraping multiple cells and pages
Creating your own functions:
- If statements - asking a question
- Numbers in square brackets? Indexes again!
- Creating your own functions:
17. Scraper #16: Adapting your third scraper: creating more than one column of data
18. Scraper #17: Scraping a list of pages
Tip: creating a list of items using the
JOINfunction in a spreadsheet
19. Scraper #18: Scraping a page - and the pages linked (badly) from it
- Using ranges to avoid errors
lento test lists
- Other workarounds
- Scraper tip: a checklist for understanding someone else’s code
20. Scraper #19: Scraping scattered data from multiple websites that share the same CMS
- Finding websites using the same content management system (CMS)
- Writing the scraper: looking at HTML structure
21. Scraper #20: Automating database searches (forms)
- Understanding URLs: queries and parameters
- When the URL doesn’t change
- Solving the cookie problem: Mechanize
22. Scraper #21: Storing the results of a search
Scraper tip: using
23. Scraper #22: Scraping PDFs part 1
- Detour: indexes and slicing shortcuts
- Back to the scraper
- Detour: operators
- Back to the scraper (again)
- Detour: the % sign explained
- Back to the scraper (again) (again)
- Running the code on a working URL
- Borrowing some code
- The first test run
- Fixing a unicode error
- Where’s the ‘view source’ on a PDF?
24. Scraper 23: Scraping PDFs part 2
- Scraping speed camera PDFs - welcome back to XPath
- Ifs and buts: measuring and matching data
25. Scraper 24: Scraping multiple PDFs
- The code
- Tasks 1 and 2: Find a pattern in the HTML and grab the links within
- XPath contains…
- The code: scraping more than one PDF
- The wrong kind of data: calculations with strings
- Putting square pegs in square holes: saving data based on properties
26. Scraper 25: Text, not tables, in PDFs - regex
- Starting the code: importing a regex library
- Scraping each PDF
- The UnicodeDecodeError and the AttributeError
- Storing the first pieces of information
- Why it’s a good idea to store line numbers
Re: Python’s regex library
Other functions from the
- Back to the code
- Joining lists of items into a single string
- Finding all the links to PDF reports on a particular webpage
- Finding the PDF link on a page
- Detour: global variables and local variables
- The code in full
27. Scraper 26: Scraping CSV files
- The CSV library
- Process of elimination 1: putting blind spots in the code
- Process of elimination 2: amending the source data
- Encoding, decoding, extracting
- Removing the header row
- Ready to scrape multiple sheets
- Combining CSV files on your computer
28. Scraper 27: Scraping Excel spreadsheets part 1
- A library for scraping spreadsheets
- What can you learn from a broken scraper?
- Applying the scraper to a different spreadsheet
- But what is the scraper doing?
29. Scraper 28: Scraping Excel spreadsheets part 2: scraping one sheet
- Testing on one sheet of a spreadsheet
30. Scraper 28 continued: Scraping Excel spreadsheets part 3: scraping multiple sheets
- One dataset, or multiple ones
- Using header row values as keys
31. Scraper 28 continued: Scraping Excel spreadsheets part 4: Dealing with dates in spreadsheets
- Scraping multiple spreadsheets
- Loops within loops
- Scraper tip: creating a sandbox
32. Scraper 29: writing scrapers for JSON and APIs
- If you’re API and you know it
- Dealing with JSON
- Adding our own code
- Storing the results
- Querying your own API
33. The final chapter: where do you go from here?
- The map is not the territory
- Recommended reading and viewing
- End != End
- 34. Acknowledgements
- 35. Glossary
The Leanpub 45-day 100% Happiness Guarantee
Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers), EPUB (for phones and tablets) and MOBI (for Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
El Manual del ManagerKeyvan Akbary, Félix López, and Álvaro Salazar
¿Has deseado alguna vez el haber tenido una buena introducción al rol del Engineering Manager? En este libro aprenderás lo necesario para ejercer el rol de una manera efectiva: Expectativas y Responsabilidades del Rol, 1-1s, Ayudar a Crecer, Objetivos, Planes de Carrera, Cultura, Feedback, Contratación, Cultura de Producto y mucho más.
Ansible for KubernetesJeff Geerling
Ansible is a powerful infrastructure automation tool. Kubernetes is a powerful application deployment platform. Learn how to use these tools to automate massively-scalable, highly-available infrastructure.
Functional Design and ArchitectureAlexander Granin
Software Design in Functional Programming, Design Patterns and Practices, Methodologies and Application Architectures. How to build real software in Haskell with less efforts and low risks. The first complete source of knowledge.
CCIE Service Provider Version 4 Written and Lab Exam Comprehensive GuideNicholas Russo
The service provider landscape has changed rapidly over the past several years. Networking vendors are continuing to propose new standards, techniques, and procedures for overcoming new challenges while concurrently reducing costs and delivering new services. Cisco has recently updated the CCIE Service Provider track to reflect these changes; this book represents the author's personal journey in achieving that certification.
CCIE SP v4.1 - WorkbookŁukasz Bromirski, Piotr Jablonski, and Nicholas Russo
Are you striving to prepare to and pass CCIE SP lab exam? Take the opportunity and get this workbook! With the attached initial cfg files you will prepare yourself for the CCIE SP exam as well as learn SP technologies applicable to all kinds of today modern networks! This workbook covers blueprint topics and provides challenging examples.
Ansible for DevOpsJeff Geerling
Ansible is a simple, but powerful, server and configuration management tool. Learn to use Ansible effectively, whether you manage one server—or thousands.
Code Faster in DelphiAlister Christie
This book will make you a faster Delphi developer, it doesn't matter if you are just starting out, or have been using Delphi since version 1, you will find all sorts of tips, tricks and hacks to boost your productivity.
R Programming for Data ScienceRoger D. Peng
This book brings the fundamentals of R programming to you, using the same material developed as part of the industry-leading Johns Hopkins Data Science Specialization. The skills taught in this book will lay the foundation for you to begin your journey learning data science. Printed copies of this book are available through Lulu.
Practical FP in Scala: A hands-on approachGabriel Volpe
A practical book aimed for those familiar with functional programming in Scala who are yet not confident about architecting an application from scratch.
Together, we will develop a purely functional application using the best libraries in the Cats ecosystem, while learning about design patterns and best practices.
Cloud StrategyGregor Hohpe
“Strategy is the difference between making a wish and making it come true.” A successful migration to the cloud shouldn’t be driven by wishes, but guided by a sound strategy, frameworks, and decision models. This book tells you how—without becoming superficial nor getting lost in technology and product details.
11 BooksThe Quality Software Bundle is for managers, would-be managers, and any of us who find themselves being managed and confused. This comprehensive bundle covers the entire span of software development approaches, from hacking through waterfall, cascade, prototyping, Iterative enhancement, reusable code, off-the-shelf, to Agile teams. The bundle...
11 BooksIn this bundle, you will find 10 different agile books. They are about different aspects of being agile. - finding a job - doing coding dojo's - Retrospectives - Personal kanban - a non-typical coaching book and even a book that gives you an insight in the lives of some agile people.
WTFlop 6M + HU - Beta Bundle
Fifty Quick Ideas
3 BooksGet all three books for the price of two! Fifty Quick Ideas books are full of practical, real-world techniques that you can use to improve teamwork, build better products and build them in a better way.
Growing Agile: Coach's Guide Series
4 BooksThis bundle provides a collection of training and workshop plans for a variety of agile topics. The series is aimed at agile coaches, trainers and ScrumMasters who often find themselves needing to help teams understand agile concepts. Each book in the series provides the plans, slides, handouts and activity instructions to run a number of...
Marionette.js A to Z
Complete Scala Bundle
3 BooksScala is a general-purpose programming language and it's getting extremely popular these days. Some say that learning Scala could be a challenging task. My experience, however, suggests that this is actually a myth that has very little to do with reality. With the right approach, learning Scala can be easy, fun and rewarding.The first book from...
Build A Better Backbone App
3 BooksThe best way to learn new development skills is through experience, but that takes time you don't have.Get the best of both worlds with this bundle: you'll learn how to produce modern web applications by learning from experienced developers like Derick Bailey and David Sulc. BackboneJS is one of the favorite tools on the web today, but it...
People Skills—Soft but Difficult
7 BooksPerhaps you've been told that "lack of people skills" has been holding you back. No wonder: you may have had hundreds of hours of technical training, but little or no "people skills" guidance.You've heard it said that people skills are "soft," whereas technical skills are "hard." For you, though, technical skills are "easy," but people skills...