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.