Reported Posts — LeetCode 1113 Python Solution

Table: Actions +---------------+---------+ | Column Name | Type | +---------------+---------+ | user_id | int | | post_id | int | | action_date | date | | action | enum | | extra | varchar | +---------------+---------+ This table may have duplicate rows. The action column is an ENUM (category) type of ('view', 'like', 'reaction', 'comment', 'report', 'share').

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| user_id       | int     |
| post_id       | int     |
| action_date   | date    | 
| action        | enum    |
| extra         | varchar |
+---------------+---------+
This table may have duplicate rows.
The action column is an ENUM (category) type of ('view', 'like', 'reaction', 'comment', 'report', 'share').
The extra column has optional information about the action, such as a reason for the report or a type of reaction.

import duckdb
import pandas as pd

def solution(actions: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Actions", actions)
    return con.execute("""SELECT extra AS report_reason, COUNT(DISTINCT post_id) AS report_count
FROM Actions
WHERE action_date = '2019-07-04' AND action = 'report'
GROUP BY 1;""").df()