+ - 0:00:00
Notes for current slide
Notes for next slide



Data Joins

Dr. Mine Dogucu

1 / 13

Image from R for Data Science book licensed under the Creative Commons Attribution-NonCommercial-NoDerivs 3.0 License

2 / 13

Inner Join

Image from R for Data Science book licensed under the Creative Commons Attribution-NonCommercial-NoDerivs 3.0 License

3 / 13

Outer Joins

Image from R for Data Science book licensed under the Creative Commons Attribution-NonCommercial-NoDerivs 3.0 License

4 / 13

Data Joins

Image from R for Data Science book licensed under the Creative Commons Attribution-NonCommercial-NoDerivs 3.0 License

5 / 13
artists
## # A tibble: 4 x 2
##   name          followers
##   <chr>             <dbl>
## 1 Beyoncé        24757958
## 2 Taylor Swift   33098116
## 3 Ariana Grande  51807131
## 4 Drake          50252529
songs
## # A tibble: 5 x 4
##   name       song_name                 album_name                song_popularity
##   <chr>      <chr>                     <chr>                               <dbl>
## 1 Beyoncé    Savage Remix (feat. Beyo… Savage Remix (feat. Beyo…              83
## 2 Taylor Sw… cardigan                  folklore                               85
## 3 Drake      Laugh Now Cry Later (fea… Laugh Now Cry Later (fea…              95
## 4 Beyoncé    Halo                      I AM…SASHA FIERCE                      NA
## 5 Ariana Gr… Stuck with U (with Justi… Stuck with U                           NA
albums
## # A tibble: 4 x 2
##   album_name                           album_release_date
##   <chr>                                <date>            
## 1 Savage Remix (feat. Beyoncé)         2020-04-29        
## 2 I AM…SASHA FIERCE                    2008-11-14        
## 3 Stuck with U                         2020-05-08        
## 4 Laugh Now Cry Later (feat. Lil Durk) 2020-08-14
6 / 13

7 / 13

Join Functions

something_join(x, y) All the join functions in dplyr package are in this fashion where x represents the first data frame and y represents the second data frame.

8 / 13
songs
## # A tibble: 5 x 4
##   name       song_name                 album_name                song_popularity
##   <chr>      <chr>                     <chr>                               <dbl>
## 1 Beyoncé    Savage Remix (feat. Beyo… Savage Remix (feat. Beyo…              83
## 2 Taylor Sw… cardigan                  folklore                               85
## 3 Drake      Laugh Now Cry Later (fea… Laugh Now Cry Later (fea…              95
## 4 Beyoncé    Halo                      I AM…SASHA FIERCE                      NA
## 5 Ariana Gr… Stuck with U (with Justi… Stuck with U                           NA
albums
## # A tibble: 4 x 2
##   album_name                           album_release_date
##   <chr>                                <date>            
## 1 Savage Remix (feat. Beyoncé)         2020-04-29        
## 2 I AM…SASHA FIERCE                    2008-11-14        
## 3 Stuck with U                         2020-05-08        
## 4 Laugh Now Cry Later (feat. Lil Durk) 2020-08-14
left_join(songs, albums, by = "album_name")
## # A tibble: 5 x 5
##   name     song_name          album_name        song_popularity album_release_d…
##   <chr>    <chr>              <chr>                       <dbl> <date>          
## 1 Beyoncé  Savage Remix (fea… Savage Remix (fe…              83 2020-04-29      
## 2 Taylor … cardigan           folklore                       85 NA              
## 3 Drake    Laugh Now Cry Lat… Laugh Now Cry La…              95 2020-08-14      
## 4 Beyoncé  Halo               I AM…SASHA FIERCE              NA 2008-11-14      
## 5 Ariana … Stuck with U (wit… Stuck with U                   NA 2020-05-08

left_join() includes all rows from x

9 / 13
songs
## # A tibble: 5 x 4
##   name       song_name                 album_name                song_popularity
##   <chr>      <chr>                     <chr>                               <dbl>
## 1 Beyoncé    Savage Remix (feat. Beyo… Savage Remix (feat. Beyo…              83
## 2 Taylor Sw… cardigan                  folklore                               85
## 3 Drake      Laugh Now Cry Later (fea… Laugh Now Cry Later (fea…              95
## 4 Beyoncé    Halo                      I AM…SASHA FIERCE                      NA
## 5 Ariana Gr… Stuck with U (with Justi… Stuck with U                           NA
albums
## # A tibble: 4 x 2
##   album_name                           album_release_date
##   <chr>                                <date>            
## 1 Savage Remix (feat. Beyoncé)         2020-04-29        
## 2 I AM…SASHA FIERCE                    2008-11-14        
## 3 Stuck with U                         2020-05-08        
## 4 Laugh Now Cry Later (feat. Lil Durk) 2020-08-14
right_join(songs, albums, by = "album_name")
## # A tibble: 4 x 5
##   name     song_name          album_name        song_popularity album_release_d…
##   <chr>    <chr>              <chr>                       <dbl> <date>          
## 1 Beyoncé  Savage Remix (fea… Savage Remix (fe…              83 2020-04-29      
## 2 Drake    Laugh Now Cry Lat… Laugh Now Cry La…              95 2020-08-14      
## 3 Beyoncé  Halo               I AM…SASHA FIERCE              NA 2008-11-14      
## 4 Ariana … Stuck with U (wit… Stuck with U                   NA 2020-05-08

right_join() includes all rows from y

10 / 13
songs
## # A tibble: 5 x 4
##   name       song_name                 album_name                song_popularity
##   <chr>      <chr>                     <chr>                               <dbl>
## 1 Beyoncé    Savage Remix (feat. Beyo… Savage Remix (feat. Beyo…              83
## 2 Taylor Sw… cardigan                  folklore                               85
## 3 Drake      Laugh Now Cry Later (fea… Laugh Now Cry Later (fea…              95
## 4 Beyoncé    Halo                      I AM…SASHA FIERCE                      NA
## 5 Ariana Gr… Stuck with U (with Justi… Stuck with U                           NA
albums
## # A tibble: 4 x 2
##   album_name                           album_release_date
##   <chr>                                <date>            
## 1 Savage Remix (feat. Beyoncé)         2020-04-29        
## 2 I AM…SASHA FIERCE                    2008-11-14        
## 3 Stuck with U                         2020-05-08        
## 4 Laugh Now Cry Later (feat. Lil Durk) 2020-08-14
inner_join(songs, albums, by = "album_name")
## # A tibble: 4 x 5
##   name     song_name          album_name        song_popularity album_release_d…
##   <chr>    <chr>              <chr>                       <dbl> <date>          
## 1 Beyoncé  Savage Remix (fea… Savage Remix (fe…              83 2020-04-29      
## 2 Drake    Laugh Now Cry Lat… Laugh Now Cry La…              95 2020-08-14      
## 3 Beyoncé  Halo               I AM…SASHA FIERCE              NA 2008-11-14      
## 4 Ariana … Stuck with U (wit… Stuck with U                   NA 2020-05-08

inner_join() includes all rows that are in x and y

11 / 13
songs
## # A tibble: 5 x 4
##   name       song_name                 album_name                song_popularity
##   <chr>      <chr>                     <chr>                               <dbl>
## 1 Beyoncé    Savage Remix (feat. Beyo… Savage Remix (feat. Beyo…              83
## 2 Taylor Sw… cardigan                  folklore                               85
## 3 Drake      Laugh Now Cry Later (fea… Laugh Now Cry Later (fea…              95
## 4 Beyoncé    Halo                      I AM…SASHA FIERCE                      NA
## 5 Ariana Gr… Stuck with U (with Justi… Stuck with U                           NA
albums
## # A tibble: 4 x 2
##   album_name                           album_release_date
##   <chr>                                <date>            
## 1 Savage Remix (feat. Beyoncé)         2020-04-29        
## 2 I AM…SASHA FIERCE                    2008-11-14        
## 3 Stuck with U                         2020-05-08        
## 4 Laugh Now Cry Later (feat. Lil Durk) 2020-08-14
full_join(songs, albums, by = "album_name")
## # A tibble: 5 x 5
##   name     song_name          album_name        song_popularity album_release_d…
##   <chr>    <chr>              <chr>                       <dbl> <date>          
## 1 Beyoncé  Savage Remix (fea… Savage Remix (fe…              83 2020-04-29      
## 2 Taylor … cardigan           folklore                       85 NA              
## 3 Drake    Laugh Now Cry Lat… Laugh Now Cry La…              95 2020-08-14      
## 4 Beyoncé  Halo               I AM…SASHA FIERCE              NA 2008-11-14      
## 5 Ariana … Stuck with U (wit… Stuck with U                   NA 2020-05-08

full_join() includes all rows that are in x or y

12 / 13
artists
## # A tibble: 4 x 2
##   name          followers
##   <chr>             <dbl>
## 1 Beyoncé        24757958
## 2 Taylor Swift   33098116
## 3 Ariana Grande  51807131
## 4 Drake          50252529
songs
## # A tibble: 5 x 4
##   name       song_name                 album_name                song_popularity
##   <chr>      <chr>                     <chr>                               <dbl>
## 1 Beyoncé    Savage Remix (feat. Beyo… Savage Remix (feat. Beyo…              83
## 2 Taylor Sw… cardigan                  folklore                               85
## 3 Drake      Laugh Now Cry Later (fea… Laugh Now Cry Later (fea…              95
## 4 Beyoncé    Halo                      I AM…SASHA FIERCE                      NA
## 5 Ariana Gr… Stuck with U (with Justi… Stuck with U                           NA
albums
## # A tibble: 4 x 2
##   album_name                           album_release_date
##   <chr>                                <date>            
## 1 Savage Remix (feat. Beyoncé)         2020-04-29        
## 2 I AM…SASHA FIERCE                    2008-11-14        
## 3 Stuck with U                         2020-05-08        
## 4 Laugh Now Cry Later (feat. Lil Durk) 2020-08-14
full_join(artists, songs, by = "name") %>% 
  full_join(albums, by = "album_name")
## # A tibble: 5 x 6
##   name    followers song_name     album_name    song_popularity album_release_d…
##   <chr>       <dbl> <chr>         <chr>                   <dbl> <date>          
## 1 Beyoncé  24757958 Savage Remix… Savage Remix…              83 2020-04-29      
## 2 Beyoncé  24757958 Halo          I AM…SASHA F…              NA 2008-11-14      
## 3 Taylor…  33098116 cardigan      folklore                   85 NA              
## 4 Ariana…  51807131 Stuck with U… Stuck with U               NA 2020-05-08      
## 5 Drake    50252529 Laugh Now Cr… Laugh Now Cr…              95 2020-08-14
13 / 13

Image from R for Data Science book licensed under the Creative Commons Attribution-NonCommercial-NoDerivs 3.0 License

2 / 13
Paused

Help

Keyboard shortcuts

↑, ←, Pg Up, k Go to previous slide
↓, →, Pg Dn, Space, j Go to next slide
Home Go to first slide
End Go to last slide
Number + Return Go to specific slide
b / m / f Toggle blackout / mirrored / fullscreen mode
c Clone slideshow
p Toggle presenter mode
t Restart the presentation timer
?, h Toggle this help
Esc Back to slideshow