Clientes que Nunca Ordenan
Tabla: Customers
Tabla: Orders
Escribe una solución para encontrar todos los cliente que nunca ordenan nada.
Devuelve el resultado en cualquier orden.
Ejemplo
Input
Customers table: +----+-------+ | id | name | +----+-------+ | 1 | Joe | | 2 | Henry | | 3 | Sam | | 4 | Max | +----+-------+ Orders table: +----+------------+ | id | customerId | +----+------------+ | 1 | 3 | | 2 | 1 | +----+------------+Output
+-----------+ | Customers | +-----------+ | Henry | | Max | +-----------+Soluciones
Python
def find_customers(customers: pd.DataFrame, orders: pd.DataFrame) -> pd.DataFrame:
customer_ids_with_orders = orders['customerId'].unique()
customers_without_orders = customers[~customers['id'].isin(customer_ids_with_orders)]
return customers_without_orders[['name']].rename(columns={'name': 'Customers'})