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

on YouTube ↗15m

" summary

Shows concrete steps to move Excel and PowerPoint work into R using openxlsx and officer plus rvg::dml to export editable ggplots and fully automate hundreds of tables and slides, then describes a pragmatic hack: a ProUCL mouse-macro pipeline that chunks data so ProUCL won't crash at ~10,000 rows, drives the GUI, parses its Excel outputs into formatted tables, saves 6–8 hours on large runs, and "pays for itself" in reduced manual copying.

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 2019
• 46mElegant R: Tips from a Software DeveloperThales De Mello · The Conf 2018
• 20m15 Years of R in Quantitative FinanceBrandon Farr · rstudio::conf 2019
• 17mModel Migration: from Excel to RJohnny Breen · rstudio::conf 2019
• 23mGrowth Hacking - Product Analytics at Scale using R and RStudioAndrew Mangano · rstudio::conf 2019
• 24mHow to Write Reproducible ManuscriptsFrancisco Rodríguez-Sánchez · LatinR 2020
• 21mOur colour of magic The open sourcery of fantastic R packagesMiles McBain · rstudio::conf 2019
• 58mPractical Tips for Using Generative AI in Data Science WorkflowsMelissa Van Bussel · posit::conf(2024)