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.
Questo esercizio fa parte del corso
Joining Data with pandas
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
# Merge employees and top_cust
empl_cust = ____.merge(____, on=____,
how=____, indicator=____)