Find trending hashtags ii

# Table: Tweets
# 
# +-------------+---------+
# | Column Name | Type    |
# +-------------+---------+
# | user_id     | int     |
# | tweet_id    | int     |
# | tweet_date  | date    |
# | tweet       | varchar |
# +-------------+---------+
# tweet_id is the primary key (column with unique values) for this table.
# Each row of this table contains user_id, tweet_id, tweet_date and tweet.
# It is guaranteed that all tweet_date are valid dates in February 2024.
# 
# Write a solution to find the top 3 trending hashtags in February 2024. Every tweet may contain several hashtags.
# 
# Return the result table ordered by count of hashtag, hashtag in descending order.
# 
# The result format is in the following example.
#
# Example 1:
# Input:
# Tweets table:
# +---------+----------+------------------------------------------------------------+------------+
# | user_id | tweet_id | tweet                                                      | tweet_date |
# +---------+----------+------------------------------------------------------------+------------+
# | 135     | 13       | Enjoying a great start to the day. #HappyDay #MorningVibes | 2024-02-01 |
# | 136     | 14       | Another #HappyDay with good vibes! #FeelGood               | 2024-02-03 |
# | 137     | 15       | Productivity peaks! #WorkLife #ProductiveDay               | 2024-02-04 |
# | 138     | 16       | Exploring new tech frontiers. #TechLife #Innovation        | 2024-02-04 |
# | 139     | 17       | Gratitude for today's moments. #HappyDay #Thankful         | 2024-02-05 |
# | 140     | 18       | Innovation drives us. #TechLife #FutureTech                | 2024-02-07 |
# | 141     | 19       | Connecting with nature's serenity. #Nature #Peaceful       | 2024-02-09 |
# +---------+----------+------------------------------------------------------------+------------+
# Output:
# +-----------+-------+
# | hashtag   | count |
# +-----------+-------+
# | #HappyDay | 3     |
# | #TechLife | 2     |
# | #WorkLife | 1     |
# +-----------+-------+
# Explanation:
# #HappyDay: Appeared in tweet IDs 13, 14, and 17, with a total count of 3 mentions.
# #TechLife: Appeared in tweet IDs 16 and 18, with a total count of 2 mentions.
# #WorkLife: Appeared in tweet ID 15, with a total count of 1 mention.
# Note: Output table is sorted in descending order by count and hashtag respectively.

import pandas as pd

def find_trending_hashtags(tweets: pd.DataFrame) -> pd.DataFrame:
  import re
  tweets['tweet_date'] = pd.to_datetime(tweets['tweet_date'])
  feb = tweets[(tweets['tweet_date'].dt.year == 2024) & (tweets['tweet_date'].dt.month == 2)].copy()
  hashtags = feb['tweet'].str.findall(r'#\w+').explode().reset_index(drop=True)
  result = hashtags.value_counts().reset_index()
  result.columns = ['hashtag', 'count']
  result = result.sort_values(['count', 'hashtag'], ascending=[False, False]).head(3).reset_index(drop=True)
  return result