Data scraping with Google Sheets and Tabula

Skill:

Level:

    • Data scraping — pulling tables of stats and other information from web pages, .PDFs and other documents — is a valuable skill for journalists. In this training video and hands-on exercises, you’ll learn how to scrape data tables out of web pages. We’ll use a formula and a browser plug-in to scrape web pages, then we’ll cover how to scrape native .PDFs with a fantastic tool called Tabula. Before starting the video, install Tabula.technology on your computer, and open the exercises page link. You’ll be a data-scraping ninja in no time!
    Download the presentationDownload

    Link to exercises: Click here

    Scraping formula: =IMPORTHTML(“URL”,“table”, 0)

    Download free Tabula .PDF scraping software here: Click here
    More data scraping resources on Journalist’s Toolbox: Click here

    More training on Reporting & Writing:

    Converting criminal justice coverage to social justice coverage

    A conversation around how social justice storytelling can help humanize even the most tragic of stories and how we can ensure our reporting serves both our communities and our readership goals.

    Skill:

    Level:

    • Covering retail and inflation

    Learn how to use tools like Google Shopping, Keepa and CamelCamelCamel to track prices. Also: How to use the Consumer Price Index, use inflation calculators and other tools for tracking prices and fraudulent online sellers/reviewers.

    Skill:

    Level:

    • Data visualization: InfoGram 201

    Students will use datasets to build more advanced maps and single chart graphics.

    Skill:

    Level:

    • Don’t count words. Make your words count.

    Writing concise, to the point stories isn’t about cutting until you’re under the limit. It’s about writing the story with the right words and nothing more. We’ll talk about finding the one thing that will drive your story, how a zero draft can start you in the right place, the magic of reading aloud and the secret sauce of short yet authoritative writing (that one, as they say, may shock you).

    Skill:

    Level: