Confirmation Rate — LeetCode 1934 Python Solution

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.

+----------------+----------+
| 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.

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()