Invalid Tweets — LeetCode 1683 Python Solution
EasyDatabase
- Problem
- #1683
- Reading time
- 2 min
- Source
- leetcode.com
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
| Measure | Complexity |
|---|---|
| Time | O(n log n) (typical) |
| Space | O(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.