On November 27th, Y-PERN Policy Fellow Dan Olner delivered an engaging webinar for ONS Local, attracting 120 participants interested in learning how to build efficient data pipelines using R.
What Was Covered
The session provided a comprehensive walkthrough of creating an end-to-end data pipeline in R, demonstrating how to:
- Get set up with R and RStudio online
- Use R to extract data directly from web sources
- Create pipelines through to final outputs
- Access and integrate multiple web-based data sources, including online Excel documents, the NOMIS API, and zipped file archives
- Wrangle and transform data for analysis
- Deal with inevitable format changes
Webinar participants learned how to create a report analysing productivity, jobs, and occupations across the UK’s core cities- showcasing R’s capabilities for producing professional content and insights.
Resources Available
The complete step-by-step slides are now available online.
For those seeking a more comprehensive introduction to R, materials the slides and recording from Dan’s last session provide an excellent foundation.
