In our previous examples, there were always matching values when we were performing our joins. What happens when that isn’t true?
Let’s imagine that our
products table is out of date and is missing the newest product: Product 5. What happens when someone orders it?
We’ve just released a new product with
product_id equal to
5. People are ordering this product, but we haven’t updated the
In notebook.Rmd, you’ll find two data frames:
products. Inspect these data frames using
Notice that the third order in
orders is for the mysterious new product, but that there is no
product_id 5 in
products data frames with
inner_join() and save the resulting data frame to the variable
What happened to