#0210

Left Join Customers and Orders in R

MediumR25 min20 XP

Problem

Use a left join so customers without orders are still present with missing order values.

Left joins are essential for analytics tables where the entity table must stay complete.

Example 1

Inputcustomers Ada and Ben; only Ada has an order

OutputAda has 50; Ben has NA

The customer table is preserved, and missing order values become NA.

CodeR

library(dplyr)

customers <- tibble(id = c(1, 2), name = c("Ada", "Ben"))
orders <- tibble(id = c(1), amount = c(50))

# write your code here

library(dplyr)

customers <- tibble(id = c(1, 2), name = c("Ada", "Ben"))
orders <- tibble(id = c(1), amount = c(50))

# write your code here

Visible browser tests run here when available.

Testcases1 visible / 3 hidden categories

Core example

Inputcustomers Ada and Ben; only Ada has an order

ExpectedAda has 50; Ben has NA

The customer table is preserved, and missing order values become NA.

Hidden Test Categories

empty or minimal inputrepeated valueslarger realistic input