183. Customers Who Never Order.md

183. Customers Who Never Order

Question Link

Solution

import pandas as pd

def find_customers(customers: pd.DataFrame, orders: pd.DataFrame) -> pd.DataFrame:
    result = customers[~customers['id'].isin(orders['customerId'])]

    result=result[['name']].rename(columns={'name':'Customers'})
    return result