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.
Bu egzersiz
Joining Data with pandas
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
# Merge employees and top_cust
empl_cust = ____.merge(____, on=____,
how=____, indicator=____)