Replace Employee ID With The Unique Identifier — LeetCode 1378 Python Solution

Table: Employees +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | name | varchar | +---------------+---------+ id is the primary key (column with unique values) for this table. Each row of this table contains the id and the name of an employee in a company.

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| id            | int     |
| name          | varchar |
+---------------+---------+
id is the primary key (column with unique values) for this table.
Each row of this table contains the id and the name of an employee in a company.

import duckdb
import pandas as pd

def solution(employees: pd.DataFrame, employee_uni: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Employees", employees)
    con.register("EmployeeUNI", employee_uni)
    return con.execute("""SELECT unique_id, name
FROM
    Employees
    LEFT JOIN EmployeeUNI USING (id);""").df()