TidyX 74: Joins in SQL vs Local R Environment

This week, Ellis Hughes and I continue our SQL in R series by discussing an important database task, joining two tables. Some of the things we cover:

  • The different types of joins (LEFT JOIN, RIGHT JOIN, FULL JOIN, INNER JOIN, and ANTI JOIN)
  • Doing a JOIN using SQL versus the local R environment and when you might choose one over the other
  • Using the {microbenchmark} package to test which query is faster and performing optimally
  • Finally, if you’d like more explicit info on creating JOINS in R, I wrote a blog post a little over a year ago that covers this topic in more detail, CLICK HERE.

To watch our screen cast, CLICK HERE.

To access our code, CLICK HERE.