Week 9: Code along 8

R for Data Science: Chapter 13

Introduction

nycflights13

##Keys

Mutating joins

x <- tribble(
    ~key, ~val_x,
    1, "x1",
    2, "x2",
    3, "x3",
)
y <- tribble(
    ~key, ~val_y,
    1, "y1",
    2, "y2",
    4, "y3"
)

inner_join(x,y)

## Joining with `by = join_by(key)`

## # A tibble: 2 × 3
##     key val_x val_y
##   <dbl> <chr> <chr>
## 1     1 x1    y1   
## 2     2 x2    y2

Outer joins

left_join(x,y)

## Joining with `by = join_by(key)`

## # A tibble: 3 × 3
##     key val_x val_y
##   <dbl> <chr> <chr>
## 1     1 x1    y1   
## 2     2 x2    y2   
## 3     3 x3    <NA>

Filtering joins

Join problems

Set operations