How hard is LeetCode 1113. Reported Posts?

LeetCode 1113. Reported Posts is rated Easy on LeetCode.

What topics does LeetCode 1113. Reported Posts cover?

LeetCode 1113. Reported Posts is tagged Database on LeetCode.

Is LeetCode 1113. Reported Posts a premium problem?

Yes. LeetCode 1113. Reported Posts is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.

Reported Posts — LeetCode 1113 Python Solution

EasyLeetCode PremiumDatabase

Problem: #1113
Reading time: 2 min
Source: leetcode.com

Table schema

SQL

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').

Example

SQL

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

Python solution

Python

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

Complexity

Measure	Complexity
Time	O(n log n) (typical)
Space	O(n) auxiliary

Frequently asked questions

How hard is LeetCode 1113. Reported Posts?: LeetCode 1113. Reported Posts is rated Easy on LeetCode.
What topics does LeetCode 1113. Reported Posts cover?: LeetCode 1113. Reported Posts is tagged Database on LeetCode.
Is LeetCode 1113. Reported Posts a premium problem?: Yes. LeetCode 1113. Reported Posts is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.