Data-scraping web pages, PDFs and Google Finance

Skill:

Level:

    • How to extract data from the web and PDFs and flow them into a spreadsheet. You’ll also learn how to scrape real-time and historical stock data into Google Sheets to track specific companies or industries.

    Links and data sets used in this workshopDownload

    More training on Investigative:

    Trans 201

    How to tell holistic stories about trans and gender-diverse individuals. Topics include: Where are all the trans men? Where are the non-white trans folks? Reporting outside the framework of the gender binary. And understanding how your own gendered lens influences story bias.

    Skill:

    Level:

    • Canva 101

    The Florida-Georgia DOT shows some of the best tips and tricks for using Canva, including Background Remover, Positioning, Text Spacing and Text Effects.

    Skill:

    Level:

    • Tools for investigating non-profit organizations

    A look at tools for tracking non-profit finances, what their CEOs earn and much more. We also spend some time looking at Form 990s of charities and give you a chance to pull some on organizations in your area.

    Skill:

    Level:

    • Build your own reporting robot

    How to use the automation function of Github, a tool for programmers, to create a web scraping bot to automatically gather information and data from the web. Our example will be using it to automate a tedious beat check. No prior coding knowledge needed.

    Skill:

    Level: