EasyNo. 1581
Customer Who Visited but Did Not Make Any Transactions — LeetCode 1581 Python Solution
- Topics
- Database
- Reading time
- 2 min
- Source
- leetcode.com
Table schema
Table: Visits +-------------+---------+ | Column Name | Type | +-------------+---------+ | visit_id | int | | customer_id | int | +-------------+---------+ visit_id is the column with unique values for this table. This table contains information about the customers who visited the mall.Example
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| visit_id | int |
| customer_id | int |
+-------------+---------+
visit_id is the column with unique values for this table.
This table contains information about the customers who visited the mall.Python solution
import duckdb
import pandas as pd
def solution(visits: pd.DataFrame, transactions: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Visits", visits)
con.register("Transactions", transactions)
return con.execute("""SELECT customer_id, COUNT(1) AS count_no_trans
FROM Visits
WHERE visit_id NOT IN (SELECT visit_id FROM Transactions)
GROUP BY 1;""").df()Complexity
- Time
- O(n log n)(typical)
- Space · auxiliary
- O(n)
Related problems
| No. | Problem | Difficulty |
|---|---|---|
| 0175 | Combine Two Tables | Easy |
| 0176 | Second Highest Salary | Medium |
| 0177 | Nth Highest Salary | Medium |
| 0178 | Rank Scores | Medium |
| 0180 | Consecutive Numbers | Medium |
| 0181 | Employees Earning More Than Their Managers | Easy |
Frequently asked questions
- How hard is LeetCode 1581. Customer Who Visited but Did Not Make Any Transactions?
LeetCode 1581. Customer Who Visited but Did Not Make Any Transactions is rated Easy on LeetCode.
- What topics does LeetCode 1581. Customer Who Visited but Did Not Make Any Transactions cover?
LeetCode 1581. Customer Who Visited but Did Not Make Any Transactions is tagged Database on LeetCode.