Concatenate the Name and the Profession — LeetCode 2504 Python Solution

Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | person_id | int | | name | varchar | | profession | ENUM | +-------------+---------+ person_id is the primary key (column with a unique value) for this table. Each row in this table contains a person's ID, name, and profession.

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| person_id   | int     |
| name        | varchar |
| profession  | ENUM    |
+-------------+---------+
person_id is the primary key (column with a unique value) for this table.
Each row in this table contains a person's ID, name, and profession.
The profession column in an enum of the type ('Doctor', 'Singer', 'Actor', 'Player', 'Engineer', or 'Lawyer')

import duckdb
import pandas as pd

def solution(person: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Person", person)
    return con.execute("""SELECT person_id, CONCAT(name, "(", SUBSTRING(profession, 1, 1), ")") AS name
FROM Person
ORDER BY person_id DESC;""").df()