Organize Data & Docs

Learning Objectives

After completing this material, an individual will be able to organize data tasks in a variety of ways.

• document ongoing work with R Markdown
• create functions to collapse repeated steps into one-line “verbs”
• use git and github to keep track of code and document changes with version control
• organize documentation and data tasks into packages (R libraries) to share
• create and manage external database with R objects
  • see databases
  • understand use and limitations of CSV and XLS file formats
  • understand and use SQLite in R; learn about DBI, dbplyr
  • understand and use RDS and fst formats

Contents

• R Markdown for Reproducible Reports
• Function Examples
• SQLite & dplyr
• R Packages
• Organizing data in R (Doug Bates)

References

• Database basics - dplyr and DBI
  • Intro to dbplyr
  • dplyr and pool
• Why learn about databases (UC Berkeley)
• SQLite, feather, and fst
• R Packages

---

Table of contents

• R Markdown for Reproducible Reports
• R Functions
• SQLite and dplyr
• R Packages
• Organizing data in R