Deliver the state of the union

Programming with dplyr

Dr. Chester Ismay

Educator, Data Scientist, and R/Python Consultant

union diagram

Prepping for union with Uruguay

uruguay_imf_filtered <- imf_data %>%
  select(iso, country, year) %>%
  filter(country == "Uruguay", between(year, 2010, 2014))

uruguay_wb_filtered <- world_bank_data %>%
  select(iso, country, year) %>%
  filter(country == "Uruguay")

The new tibbles

uruguay_imf_filtered

# A tibble: 5 x 3
  iso   country  year
  <chr> <chr>   <int>
1 URY   Uruguay  2010
2 URY   Uruguay  2011
3 URY   Uruguay  2012
4 URY   Uruguay  2013
5 URY   Uruguay  2014

uruguay_wb_filtered

# A tibble: 4 x 3
  iso   country  year
  <chr> <chr>   <dbl>
1 URY   Uruguay  2013
2 URY   Uruguay  2014
3 URY   Uruguay  2015
4 URY   Uruguay  2016

union()

union(uruguay_imf_filtered, 
      uruguay_wb_filtered)

# A tibble: 7 x 3
  iso   country  year
  <chr> <chr>   <dbl>
1 URY   Uruguay  2010
2 URY   Uruguay  2011
3 URY   Uruguay  2012
4 URY   Uruguay  2013
5 URY   Uruguay  2014
6 URY   Uruguay  2015
7 URY   Uruguay  2016

union(uruguay_wb_filtered, 
      uruguay_imf_filtered)

# A tibble: 7 x 3
  iso   country  year
  <chr> <chr>   <dbl>
1 URY   Uruguay  2013
2 URY   Uruguay  2014
3 URY   Uruguay  2015
4 URY   Uruguay  2016
5 URY   Uruguay  2010
6 URY   Uruguay  2011
7 URY   Uruguay  2012

union_all diagram

union_all(uruguay_imf_filtered, 
          uruguay_wb_filtered)

# A tibble: 9 x 3
  iso   country  year
  <chr> <chr>   <dbl>
1 URY   Uruguay  2010
2 URY   Uruguay  2011
3 URY   Uruguay  2012
4 URY   Uruguay  2013
5 URY   Uruguay  2014
6 URY   Uruguay  2013
7 URY   Uruguay  2014
8 URY   Uruguay  2015
9 URY   Uruguay  2016

union_all(uruguay_wb_filtered, 
          uruguay_imf_filtered)

# A tibble: 9 x 3
  iso   country  year
  <chr> <chr>   <dbl>
1 URY   Uruguay  2013
2 URY   Uruguay  2014
3 URY   Uruguay  2015
4 URY   Uruguay  2016
5 URY   Uruguay  2010
6 URY   Uruguay  2011
7 URY   Uruguay  2012
8 URY   Uruguay  2013
9 URY   Uruguay  2014

Let's practice!

Programming with dplyr