发布"合并"结果

使用 dplyr 编程

Dr. Chester Ismay

Educator, Data Scientist, and R/Python Consultant

union 示意图

为乌拉圭做 union 前的准备

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")

新的 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 示意图

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

让我们练习！

使用 dplyr 编程