By the end of this week, students should be able to

  • Translate data wrangling problems into clean and expressive code
  • Explain and describe the difference of logical operators:
    • !
    • &
    • |
    • &&
    • ||
  • Explain primary and foreign keys for relational data
  • Write {dplyr} code to solve a wide range of data manipulation problems:
    • one table verbs
    • two table verbs
    • conditional element selections
  • Write {dplyr} code to translate R code to SQL to manipulate database