Agenda

Week 1

Day 1

Welcome, create objects, vectors, tidy data, filter

  1. Welcome to open source
  2. Tour RStudio
  3. Start a new R project
    • Create an R script
  4. Create, update and remove data
  5. Make a tidy data tables
  6. Add new R packages
    • The tidyverse
  7. Read data
    • read_csv for text files
  8. Save files
  9. Explore data
    • Column names, rows, observations, value types
    • Missing values
    • Mean, max, min, quantile
  10. Filter data

Packages: tidyverse

Day 2

Excel files, arrange, select, group, summarize and add columns

  1. Read Excel files: readxl and read_excel( )
  2. Your data toolbox:
    • Arrange, sort, and filter data
    • Comparing data: >, ==, %in%
  3. Adding and calculating new columns
  4. New columns based on an if condition
    • If age > 10 then “Eligible for vaccine”
  5. Use the pipe %>% to chain functions together
  6. Summarize data
    • Functions: mean, median, max, min, quantile
  7. group_by
    • Summarize by group or category
    • By location: city, county, ZIP

Packages: readxl

Week 2

Day 3

Plots, grammar of graphics, geoms, labels, colors, facets

  1. Get visual with ggplot2
    • Grammar of graphics
    • aesthetics and geoms
  2. Make ggplot sandwiches
    • Scatterplots, text, and boxplots
    • Add titles, colors, and labels
    • Facets
    • Reference lines
    • Themes
  3. Save charts to a variety of formats

Packages: ggplot2

Day 4

All things maps, spatial functions, interactive

  1. Intro to Maps
    • Coordinates and coordinate reference systems
  2. Spatial functions
    • Distances, buffers, intersections
  3. Interactive maps
    • Leaflet
    • Layers, labels, legends
    • Points, polygons, markers

Packages: sf, leaflet

Week 3

Day 5

Table joins, clean_names, date formats, date parts, time series

  1. Join tables
    • left_join
  2. library(janitor)
    • clean_names()
  3. Working with Dates
    • Format conversion
    • Date/time parts: year, day, hour
    • Time zones
    • Time series plots

Packages: lubridate

Day 6

Review, reading code, wide data, databases, markdown

  1. Connect to databases
    • ODBC
    • keyring: Keep your passwords secret
  2. Wide format data <–> Long data
  3. R markdown reports
  4. Choose your own adventure!

Packages: DBI, RODBC, keyring



🐈🐈 Concatulations!! 🐱🐱


agenda