Journalism with RStudio, R, and the tidyverse
summary
Uses dbplyr on a 380 million ARCO S opioid table to run SQL-backed tidyverse queries and flag likely “pill mills,” combines Google Forms/Sheets for human-labeled collections, and calls APIs with httr for bespoke datasets. Publishes with R Markdown and an aptheme ggplot theme plus SVG export (SVG Light caveat for artists). Plans include automated recurring pulls, scripted data-validation checks, reticulate bridges to Python, and distributing reproducible SQL and code to members via data.world for relabeling and local stories.
AI-written summary · about
chapters (6)
related talks
25mScope of data journalism for developers
44mData Journalism 1
21mTracking COVID 19 with Ruby
22mElection Night Reporting Using R & Quarto
43mKeynote
20mBuilding a Flexible, Scaleable Self-Serve Reporting System with Shiny
01h 01m50 ways to show your data
09mPublishing Customer Facing Products with RStudio Connect