Advocating for Automation: Adapting Current Tools in Environmental Science with R

on YouTube ↗15m

" summary

Shows concrete automation steps using openxlsx and officer to produce editable Excel and PowerPoint outputs from R, plus a scripted mouse macro to control EPA software ProUCL so it can process >10,000 records without manual repeats. Builds an R pipeline that chunks data, launches the macro, parses ProUCL’s formatted Excel output, and writes cleaned tables. Runs that shrink project runtimes from 15–30 minutes up to 6–8 hours per full run and eliminates manual copy‑paste errors.

AI-written summary · about

" chapters (4)

1. 0:00Introduction
2. 1:57What is Automation
3. 4:16Work Products
4. 11:47Final Thoughts

" related talks

• 15mAdvocating for Automation: Adapting Current Tools in Environmental Science with RHannah Podzorski · rstudio::conf(2022)
• 22m. Cultivating Your Own R Ecosystem as a Solo ContributorMeghan Hall · rstudio::conf(2022)
• 46mElegant R: Tips from a Software DeveloperThales De Mello · The Conf 2018
• 24mHow to Write Reproducible ManuscriptsFrancisco Rodríguez-Sánchez · LatinR 2020
• 22mUsing Python & R in HarmonyMatthew Brower, Krista Readout · PyOhio 2019
• 05mTemplated Analyses within R Packages for Collaborative, Reproducible ResearchChristopher T. Kenny · posit::conf(2024)
• 57mGood Practices for Applied Machine LearningJulia Silge, Max Kuhn · rstudio::conf(2022)
• 20mUsing R, Python, and Cloud Infrastructure to Battle Aquatic Invasive SpeciesUli Muellner, Nicholas Snellgrove · posit::conf(2023)