The Centre for Investigative Journalism
The Centre for Investigative Journalism
Menu

Pamela Duncan

Pamela Duncan is the editor of the Guardian’s Data Project team, an occasional award-winning journalist (#humblebrag) and a self-confessed data nerd. She can usually be found at her desk poring over spreadsheets and using her coding skills – usually a combination of scraping, regex and pandas/Python – to build and analyse datasets to produce high quality and exclusive data stories. She has worked on a number of international collaborations including the Pandora Papers, Russian asset tracker and The Uber Files.

Pamela is a very popular data journalism trainer at the #CIJSummer Conference despite being an insufferable data evangelist who forces her love of data upon others. She has taught as a visiting lecturer in data journalism at City, University of London and trained journalists at conferences including DataHarvest, GIJC and NICAR as well as Summer School. She has also written a bespoke data curriculum to teach journalists in developing countries.

Summer Conference Event
 — Class Course

Data Journalism Courses – Hands-On

We will be offering a selection of hands-on data journalism courses for all levels including: - Spreadsheets - R - Python - Mapping - Scraping without Code Taught by some of the best data trainers in the UK and internationally, all current or former data journalists and editors with years of experience between them.
Summer Conference Event
 — Course

Data Journalism – Google Sheets – Hands-On

This three-part hands-on express data journalism course will introduce you to the basics of data analysis in Google Sheets. Suitable for beginners.
Summer Conference Event
 — Talk

Covid-19: A Data Story. UK and Sweden.

Leading data journalists Helena Bengtsson of STV (Sweden), John Burn-Murdoch of the Financial Times (UK), and Pamela Duncan of the Guardian (UK), explain how data analysis plays a crucial part in the coverage of the Covid-19 pandemic.
Summer Conference Event
 — Course

Web Scraping Without Code

How to use the import functions for scraping data into Google Sheets, building a basic scraper with websraper.io and OCR 3 ways.
Summer Conference Event
 — Course

Data Journalism – Google Sheets

Googlesheets 1 Data journalism introduction: an overview of the seven building blocks behind data stories. The basics: using Googlesheets to carry out basic calculations and percentage increases. Googlesheets 2 Finding your top line: sorting and filtering in Googlesheets/Excel.
Data Project Editor at The Guardian
@guardian
@PorcelinaD