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.
Deze oefening maakt deel uit van de cursus
Joining Data with pandas
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
# Merge employees and top_cust
empl_cust = ____.merge(____, on=____,
how=____, indicator=____)