MediumNo. 1934
Confirmation Rate — LeetCode 1934 Python Solution
- Topics
- Database
- Reading time
- 3 min
- Source
- leetcode.com
Table schema
Table: Signups +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp | datetime | +----------------+----------+ user_id is the column of unique values for this table. Each row contains information about the signup time for the user with ID user_id.Example
+----------------+----------+
| Column Name | Type |
+----------------+----------+
| user_id | int |
| time_stamp | datetime |
+----------------+----------+
user_id is the column of unique values for this table.
Each row contains information about the signup time for the user with ID user_id.Python solution
import duckdb
import pandas as pd
def solution(signups: pd.DataFrame, confirmations: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Signups", signups)
con.register("Confirmations", confirmations)
return con.execute("""SELECT
user_id,
ROUND(IFNULL(SUM(action = 'confirmed') / COUNT(1), 0), 2) AS confirmation_rate
FROM
SignUps
LEFT JOIN Confirmations USING (user_id)
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 1934. Confirmation Rate?
LeetCode 1934. Confirmation Rate is rated Medium on LeetCode.
- What topics does LeetCode 1934. Confirmation Rate cover?
LeetCode 1934. Confirmation Rate is tagged Database on LeetCode.