---
layout: post
title: "Using dplyr's join functions in R to filter and merge data frames (CC164)"
blurb: "All the ways to join data with dplyr"
author: "PD Schloss"
date: 2021-11-18
comments: false
youtube: jAl0fRqxK3s
start_hash: 9465d9a42a5666756ce18d8d648bbb03c880f0ad
end_hash: 292867305beb9e0eeeb37202b659c9b55b2b26f2
---

The ability to use `dplyr`'s join functions to merge and filter data frames in R has made life so much easier than trying to do the same thing with base R. In this Code Club, Pat will demonstrate how to use and the difference between `full_join`, `inner_join`, `left_join`, `right_join`, and `anti_join`. He'll demonstrate how to use these functions with a massive data frame that we downloaded from Our World in Data that describes COVID-19 vaccination rates by country and day.

<iframe style="margin: 0 auto;display:block;" width="560" height="315" src="https://www.youtube.com/embed/{{ page.youtube }}" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>


## Code

You can browse the state of the repository at the
* [beginning of the episode](https://github.com/riffomonas/vaccination_attitudes/tree/{{ page.start_hash }})
* [end of the episode](https://github.com/riffomonas/vaccination_attitudes/tree/{{ page.end_hash }})
