1. Learn
  2. /
  3. Courses
  4. /
  5. Joining Data with pandas

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.