Do It For Yourself: Creating a data input platform using R
summary
Lab migrates from Microsoft Access to a Google Sheets + R workflow that supports simultaneous entry, strict validation, and relational records; prototype uses googlesheets4 and googledrive with functions like drive_mkdir() and sheet_copy() to create per-day folders and per-observer forms; automated pipeline turns template spreadsheets into validated long-format inputs, reduces bottlenecks so teams enter data concurrently, and eventually collapses setup to one line of code for creating a new expedition folder and sheets.
AI-written summary · about
chapters (4)
related talks
16mEXCELsioR!
15mSave an ocean of time: streamline data wrangling with R
31mBeginning your own data engineering projects
19mData Engineering for Social Good
20mMaking Data Pipelines in R: A Story From A “Self-Taught” Perspective
53mThe Pain and Glory of Data Preparation
17mBuilding a data science pipeline for the FT with RStudio Connect
24mSecuring Executive Buy-In for Data Strategies