Exercise

Performing an anti join

In our music streaming company dataset, each customer is assigned an employee representative to assist them. In this exercise, filter the employee table by a table of top customers, returning only those employees who are not assigned to a customer. The results should resemble the results of an anti join. The company's leadership will assign these employees additional training so that they can work with high valued customers.

The top_cust and employees tables have been provided for you.

Instructions 1/3

undefined XP
    1
    2
    3
  • Merge employees and top_cust with a left join, setting indicator argument to True. Save the result to empl_cust.