1683. Invalid Tweets.md

1683. Invalid Tweets

Question Link

Pandas Solution

import pandas as pd

def invalid_tweets(tweets: pd.DataFrame) -> pd.DataFrame:
    result = tweets[tweets['content'].str.len()>15]
    result = result[['tweet_id']]
    return result

SQL Solution

# Write your MySQL query statement below
select tweet_id
from Tweets
where CHAR_LENGTH(content)>15