Invalid Tweets — LeetCode 1683 Python Solution

EasyDatabase
Problem
#1683
Reading time
2 min

Table schema

SQL
Table: Tweets +----------------+---------+ | Column Name | Type | +----------------+---------+ | tweet_id | int | | content | varchar | +----------------+---------+ tweet_id is the primary key (column with unique values) for this table. content consists of alphanumeric characters, '!', or ' ' and no other special characters.

Example

SQL
+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| tweet_id       | int     |
| content        | varchar |
+----------------+---------+
tweet_id is the primary key (column with unique values) for this table.
content consists of alphanumeric characters, '!', or ' ' and no other special characters.
This table contains all the tweets in a social media app.

Python solution

Python
import duckdb
import pandas as pd

def solution(tweets: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Tweets", tweets)
    return con.execute("""SELECT
    tweet_id
FROM Tweets
WHERE CHAR_LENGTH(content) > 15;""").df()

Complexity

MeasureComplexity
TimeO(n log n) (typical)
SpaceO(n) auxiliary

Related problems

Frequently asked questions

How hard is LeetCode 1683. Invalid Tweets?
LeetCode 1683. Invalid Tweets is rated Easy on LeetCode.
What topics does LeetCode 1683. Invalid Tweets cover?
LeetCode 1683. Invalid Tweets is tagged Database on LeetCode.

Stuck on problems like this in a live interview?

Stealth Interview is a desktop app for macOS and Windows. It reads the problem off your screen and returns a working solution with a step-by-step explanation and its time and space complexity — invisible to screen sharing.

Get Stealth Interview