bts_scraping.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# BTS Tweet Scraping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import Tweetkey and my api keys \n",
    "from tweetkey import consumer_api_key, consumer_api_secret_key, access_token, access_secret_token"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import necessary dependencies\n",
    "import tweepy\n",
    "import pandas as pd\n",
    "import time "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Authorize the tweepy with OAuthHandler method from tweepy documentation \n",
    "# Set up my access token\n",
    "auth = tweepy.OAuthHandler(consumer_api_key, consumer_api_secret_key)\n",
    "auth.set_access_token(access_token, access_secret_token)\n",
    "\n",
    "api = tweepy.API(auth, wait_on_rate_limit=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reference for searching items using key words or phrases \n",
    "# Method 1\n",
    "\n",
    "# try:\n",
    " # Creation of query method using parameters\n",
    "#  bts_tweets = tweepy.Cursor(api.search,q='bts butter',result_type='popular').items(150)\n",
    " \n",
    " # Pulling information from tweets iterable object\n",
    "#  bts_tweets_list = [[bts_tweet.created_at, bts_tweet.id, bts_tweet.text, bts_tweet.favorite_count] for bts_tweet in bts_tweets]\n",
    " \n",
    " # Creation of dataframe from tweets list\n",
    " # Add or remove columns as you remove tweet information\n",
    "#  bts_tweets_df = pd.DataFrame(bts_tweets_list)\n",
    " \n",
    "# except BaseException as e:\n",
    "#     print('failed to load,',str(e))\n",
    "#     time.sleep(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Search by the artist group name and show the results for popular ones up to 150 items\n",
    "# Method 2\n",
    "\n",
    "bts_tweets = tweepy.Cursor(api.search,q='bts butter',result_type='popular').items(150)\n",
    "bts_tweets_list = [[bts_tweet.created_at, bts_tweet.id, bts_tweet.text, bts_tweet.favorite_count] for bts_tweet in bts_tweets]\n",
    "\n",
    "bts_tweets_df = pd.DataFrame(bts_tweets_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-05-13 15:00:02</td>\n",
       "      <td>1392857170404806668</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...</td>\n",
       "      <td>1180312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-05-13 15:00:06</td>\n",
       "      <td>1392857187433684995</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...</td>\n",
       "      <td>1177937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-05-13 15:00:10</td>\n",
       "      <td>1392857205137842181</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...</td>\n",
       "      <td>1312670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-05-13 20:01:50</td>\n",
       "      <td>1392933121641771009</td>\n",
       "      <td>BTS released some more teasers for ‘Butter’ an...</td>\n",
       "      <td>41077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-05-13 17:59:57</td>\n",
       "      <td>1392902451565584384</td>\n",
       "      <td>#BTS share their first teaser pic of the very ...</td>\n",
       "      <td>13112</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0                    1  \\\n",
       "0 2021-05-13 15:00:02  1392857170404806668   \n",
       "1 2021-05-13 15:00:06  1392857187433684995   \n",
       "2 2021-05-13 15:00:10  1392857205137842181   \n",
       "3 2021-05-13 20:01:50  1392933121641771009   \n",
       "4 2021-05-13 17:59:57  1392902451565584384   \n",
       "\n",
       "                                                   2        3  \n",
       "0  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...  1180312  \n",
       "1  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...  1177937  \n",
       "2  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...  1312670  \n",
       "3  BTS released some more teasers for ‘Butter’ an...    41077  \n",
       "4  #BTS share their first teaser pic of the very ...    13112  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# See first top 5 items on the table\n",
    "bts_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2021-05-07 19:37:09</td>\n",
       "      <td>1390752583300616192</td>\n",
       "      <td>You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...</td>\n",
       "      <td>392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2021-05-08 06:05:04</td>\n",
       "      <td>1390910603250716673</td>\n",
       "      <td>It may have only meant to tease the new song b...</td>\n",
       "      <td>553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2021-05-07 15:34:47</td>\n",
       "      <td>1390691590222454785</td>\n",
       "      <td>BTS are releasing their new English single, ‘B...</td>\n",
       "      <td>284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2021-05-08 16:11:40</td>\n",
       "      <td>1391063261622251523</td>\n",
       "      <td>The #bts #ButterBus unexpectedly rolled into G...</td>\n",
       "      <td>597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2021-05-08 00:07:55</td>\n",
       "      <td>1390820724504399874</td>\n",
       "      <td>More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     0                    1  \\\n",
       "33 2021-05-07 19:37:09  1390752583300616192   \n",
       "34 2021-05-08 06:05:04  1390910603250716673   \n",
       "35 2021-05-07 15:34:47  1390691590222454785   \n",
       "36 2021-05-08 16:11:40  1391063261622251523   \n",
       "37 2021-05-08 00:07:55  1390820724504399874   \n",
       "\n",
       "                                                    2    3  \n",
       "33  You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...  392  \n",
       "34  It may have only meant to tease the new song b...  553  \n",
       "35  BTS are releasing their new English single, ‘B...  284  \n",
       "36  The #bts #ButterBus unexpectedly rolled into G...  597  \n",
       "37  More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...  105  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# See bottom top 5 items on the table\n",
    "bts_tweets_df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convert the datetime column and remove the time slot \n",
    "\n",
    "# bts_tweets_df[1] = pd.Timestamp(bts_tweets_df[1]).dt.date\n",
    "bts_tweets_df[0] = pd.to_datetime(bts_tweets_df[0]).dt.date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>1392857170404806668</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...</td>\n",
       "      <td>1180312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>1392857187433684995</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...</td>\n",
       "      <td>1177937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>1392857205137842181</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...</td>\n",
       "      <td>1312670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>1392933121641771009</td>\n",
       "      <td>BTS released some more teasers for ‘Butter’ an...</td>\n",
       "      <td>41077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>1392902451565584384</td>\n",
       "      <td>#BTS share their first teaser pic of the very ...</td>\n",
       "      <td>13112</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            0                    1  \\\n",
       "0  2021-05-13  1392857170404806668   \n",
       "1  2021-05-13  1392857187433684995   \n",
       "2  2021-05-13  1392857205137842181   \n",
       "3  2021-05-13  1392933121641771009   \n",
       "4  2021-05-13  1392902451565584384   \n",
       "\n",
       "                                                   2        3  \n",
       "0  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...  1180312  \n",
       "1  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...  1177937  \n",
       "2  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...  1312670  \n",
       "3  BTS released some more teasers for ‘Butter’ an...    41077  \n",
       "4  #BTS share their first teaser pic of the very ...    13112  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# See first top 5 items on the table\n",
    "bts_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>1390752583300616192</td>\n",
       "      <td>You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...</td>\n",
       "      <td>392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>1390910603250716673</td>\n",
       "      <td>It may have only meant to tease the new song b...</td>\n",
       "      <td>553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>1390691590222454785</td>\n",
       "      <td>BTS are releasing their new English single, ‘B...</td>\n",
       "      <td>284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>1391063261622251523</td>\n",
       "      <td>The #bts #ButterBus unexpectedly rolled into G...</td>\n",
       "      <td>597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>1390820724504399874</td>\n",
       "      <td>More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             0                    1  \\\n",
       "33  2021-05-07  1390752583300616192   \n",
       "34  2021-05-08  1390910603250716673   \n",
       "35  2021-05-07  1390691590222454785   \n",
       "36  2021-05-08  1391063261622251523   \n",
       "37  2021-05-08  1390820724504399874   \n",
       "\n",
       "                                                    2    3  \n",
       "33  You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...  392  \n",
       "34  It may have only meant to tease the new song b...  553  \n",
       "35  BTS are releasing their new English single, ‘B...  284  \n",
       "36  The #bts #ButterBus unexpectedly rolled into G...  597  \n",
       "37  More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...  105  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# See first bottom 5 items on the table\n",
    "bts_tweets_df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop the unnecessary column number 1\n",
    "cleaned_bts = bts_tweets_df.drop([1], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...</td>\n",
       "      <td>1180312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...</td>\n",
       "      <td>1177937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...</td>\n",
       "      <td>1312670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS released some more teasers for ‘Butter’ an...</td>\n",
       "      <td>41077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their first teaser pic of the very ...</td>\n",
       "      <td>13112</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            0                                                  2        3\n",
       "0  2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...  1180312\n",
       "1  2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...  1177937\n",
       "2  2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...  1312670\n",
       "3  2021-05-13  BTS released some more teasers for ‘Butter’ an...    41077\n",
       "4  2021-05-13  #BTS share their first teaser pic of the very ...    13112"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# See top 5 tweets\n",
    "cleaned_bts.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...</td>\n",
       "      <td>392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>It may have only meant to tease the new song b...</td>\n",
       "      <td>553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>BTS are releasing their new English single, ‘B...</td>\n",
       "      <td>284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>The #bts #ButterBus unexpectedly rolled into G...</td>\n",
       "      <td>597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             0                                                  2    3\n",
       "33  2021-05-07  You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...  392\n",
       "34  2021-05-08  It may have only meant to tease the new song b...  553\n",
       "35  2021-05-07  BTS are releasing their new English single, ‘B...  284\n",
       "36  2021-05-08  The #bts #ButterBus unexpectedly rolled into G...  597\n",
       "37  2021-05-08  More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...  105"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# See bottom 5 tweets\n",
    "cleaned_bts.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Tweeted Date</th>\n",
       "      <th>Tweet Description</th>\n",
       "      <th>Popularity Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...</td>\n",
       "      <td>1180312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...</td>\n",
       "      <td>1177937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...</td>\n",
       "      <td>1312670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS released some more teasers for ‘Butter’ an...</td>\n",
       "      <td>41077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their first teaser pic of the very ...</td>\n",
       "      <td>13112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter 🧈 https://t.co/TqlFZafT1L</td>\n",
       "      <td>21684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>.@bts_bighit's RM also said the song was \"very...</td>\n",
       "      <td>14837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>AMO! Foram divulgadas novas fotos promocionais...</td>\n",
       "      <td>5117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS、新曲「Butter」個別ティーザーフォトを順次公開　JUNG KOOK、RM、JIN...</td>\n",
       "      <td>16596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their first teaser pic of the very ...</td>\n",
       "      <td>4414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their 1st teaser pic of the very ta...</td>\n",
       "      <td>2847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>.@ColumbiaRecords on tour: Peter Gray's band o...</td>\n",
       "      <td>9260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2021-05-14</td>\n",
       "      <td>BTS、新曲「Butter」個別ティーザーフォトを公開　J-HOPE、JIMIN、Vでフィナ...</td>\n",
       "      <td>1829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2021-05-14</td>\n",
       "      <td>BTS、新曲「Butter」/兵役義務/アジア人に対する差別について語る https://t...</td>\n",
       "      <td>2625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS's J-Hope, Jimin, and V radiate their soft ...</td>\n",
       "      <td>2587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 슈가 (S...</td>\n",
       "      <td>1249132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 진 (Ji...</td>\n",
       "      <td>1292953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 정국 (J...</td>\n",
       "      <td>1448291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>are you ready?! the world tv debut of @BTS_twt...</td>\n",
       "      <td>196474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>We can’t hold it in any longer! Our debut perf...</td>\n",
       "      <td>820030</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Tweeted Date                                  Tweet Description  \\\n",
       "0    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...   \n",
       "1    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...   \n",
       "2    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...   \n",
       "3    2021-05-13  BTS released some more teasers for ‘Butter’ an...   \n",
       "4    2021-05-13  #BTS share their first teaser pic of the very ...   \n",
       "5    2021-05-13  #BTS #방탄소년단 #BTS_Butter 🧈 https://t.co/TqlFZafT1L   \n",
       "6    2021-05-13  .@bts_bighit's RM also said the song was \"very...   \n",
       "7    2021-05-13  AMO! Foram divulgadas novas fotos promocionais...   \n",
       "8    2021-05-13  BTS、新曲「Butter」個別ティーザーフォトを順次公開　JUNG KOOK、RM、JIN...   \n",
       "9    2021-05-13  #BTS share their first teaser pic of the very ...   \n",
       "10   2021-05-13  #BTS share their 1st teaser pic of the very ta...   \n",
       "11   2021-05-13  .@ColumbiaRecords on tour: Peter Gray's band o...   \n",
       "12   2021-05-14  BTS、新曲「Butter」個別ティーザーフォトを公開　J-HOPE、JIMIN、Vでフィナ...   \n",
       "13   2021-05-14  BTS、新曲「Butter」/兵役義務/アジア人に対する差別について語る https://t...   \n",
       "14   2021-05-13  BTS's J-Hope, Jimin, and V radiate their soft ...   \n",
       "15   2021-05-12  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 슈가 (S...   \n",
       "16   2021-05-12  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 진 (Ji...   \n",
       "17   2021-05-11  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 정국 (J...   \n",
       "18   2021-05-11  are you ready?! the world tv debut of @BTS_twt...   \n",
       "19   2021-05-11  We can’t hold it in any longer! Our debut perf...   \n",
       "\n",
       "    Popularity Count  \n",
       "0            1180312  \n",
       "1            1177937  \n",
       "2            1312670  \n",
       "3              41077  \n",
       "4              13112  \n",
       "5              21684  \n",
       "6              14837  \n",
       "7               5117  \n",
       "8              16596  \n",
       "9               4414  \n",
       "10              2847  \n",
       "11              9260  \n",
       "12              1829  \n",
       "13              2625  \n",
       "14              2587  \n",
       "15           1249132  \n",
       "16           1292953  \n",
       "17           1448291  \n",
       "18            196474  \n",
       "19            820030  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Rename the columns\n",
    "new_bts_tweets_df = cleaned_bts.rename(columns={0: \"Tweeted Date\", 2: \"Tweet Description\", 3: \"Popularity Count\"})\n",
    "\n",
    "# See top 20 tweets\n",
    "new_bts_tweets_df.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Tweeted Date</th>\n",
       "      <th>Tweet Description</th>\n",
       "      <th>Popularity Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>are you ready?! the world tv debut of @BTS_twt...</td>\n",
       "      <td>196474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>We can’t hold it in any longer! Our debut perf...</td>\n",
       "      <td>820030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>Are you smooth like Butter?\\n#SmoothLikeButter...</td>\n",
       "      <td>749484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>[#Behind_the_Magic_Door]\\n\\nPlay your song! \\n...</td>\n",
       "      <td>197193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>The @bts_bighit limited edition BUTTER 7\" viny...</td>\n",
       "      <td>44311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>[UCC] BTS's Suga trends worldwide after his \"B...</td>\n",
       "      <td>2434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>I’m so ready for “Butter”. Like vinyl already ...</td>\n",
       "      <td>19893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>any predictions on what @BTS_twt's #BBMAs perf...</td>\n",
       "      <td>97479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS share first teaser pic of #MrWorldwideHan...</td>\n",
       "      <td>10234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>This #BUTTER song is 🔥🔥🔥\\n\\n#BTS is giving us ...</td>\n",
       "      <td>9257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>Thus, in conclusion, #BTS Butter will be a hit 🧈</td>\n",
       "      <td>14320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>.@BTS_twt is dropping a limited-edition versio...</td>\n",
       "      <td>22526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>BTS are dropping a limited-edition version of ...</td>\n",
       "      <td>6974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>BTS is dropping a limited-edition version of #...</td>\n",
       "      <td>19599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>Got to hang on the #ButterBus #BTS_Butter soun...</td>\n",
       "      <td>6351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...</td>\n",
       "      <td>392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>It may have only meant to tease the new song b...</td>\n",
       "      <td>553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>BTS are releasing their new English single, ‘B...</td>\n",
       "      <td>284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>The #bts #ButterBus unexpectedly rolled into G...</td>\n",
       "      <td>597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Tweeted Date                                  Tweet Description  \\\n",
       "18   2021-05-11  are you ready?! the world tv debut of @BTS_twt...   \n",
       "19   2021-05-11  We can’t hold it in any longer! Our debut perf...   \n",
       "20   2021-05-09  Are you smooth like Butter?\\n#SmoothLikeButter...   \n",
       "21   2021-05-12  [#Behind_the_Magic_Door]\\n\\nPlay your song! \\n...   \n",
       "22   2021-05-11  The @bts_bighit limited edition BUTTER 7\" viny...   \n",
       "23   2021-05-12  [UCC] BTS's Suga trends worldwide after his \"B...   \n",
       "24   2021-05-12  I’m so ready for “Butter”. Like vinyl already ...   \n",
       "25   2021-05-11  any predictions on what @BTS_twt's #BBMAs perf...   \n",
       "26   2021-05-12  #BTS share first teaser pic of #MrWorldwideHan...   \n",
       "27   2021-05-07  This #BUTTER song is 🔥🔥🔥\\n\\n#BTS is giving us ...   \n",
       "28   2021-05-07   Thus, in conclusion, #BTS Butter will be a hit 🧈   \n",
       "29   2021-05-07  .@BTS_twt is dropping a limited-edition versio...   \n",
       "30   2021-05-07  BTS are dropping a limited-edition version of ...   \n",
       "31   2021-05-08  BTS is dropping a limited-edition version of #...   \n",
       "32   2021-05-08  Got to hang on the #ButterBus #BTS_Butter soun...   \n",
       "33   2021-05-07  You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...   \n",
       "34   2021-05-08  It may have only meant to tease the new song b...   \n",
       "35   2021-05-07  BTS are releasing their new English single, ‘B...   \n",
       "36   2021-05-08  The #bts #ButterBus unexpectedly rolled into G...   \n",
       "37   2021-05-08  More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...   \n",
       "\n",
       "    Popularity Count  \n",
       "18            196474  \n",
       "19            820030  \n",
       "20            749484  \n",
       "21            197193  \n",
       "22             44311  \n",
       "23              2434  \n",
       "24             19893  \n",
       "25             97479  \n",
       "26             10234  \n",
       "27              9257  \n",
       "28             14320  \n",
       "29             22526  \n",
       "30              6974  \n",
       "31             19599  \n",
       "32              6351  \n",
       "33               392  \n",
       "34               553  \n",
       "35               284  \n",
       "36               597  \n",
       "37               105  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# See bottom 20 tweets\n",
    "new_bts_tweets_df.tail(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Tweeted Date</th>\n",
       "      <th>Tweet Description</th>\n",
       "      <th>Popularity Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...</td>\n",
       "      <td>1180312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...</td>\n",
       "      <td>1177937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...</td>\n",
       "      <td>1312670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS released some more teasers for ‘Butter’ an...</td>\n",
       "      <td>41077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their first teaser pic of the very ...</td>\n",
       "      <td>13112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter 🧈 https://t.co/TqlFZafT1L</td>\n",
       "      <td>21684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>.@bts_bighit's RM also said the song was \"very...</td>\n",
       "      <td>14837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>AMO! Foram divulgadas novas fotos promocionais...</td>\n",
       "      <td>5117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS、新曲「Butter」個別ティーザーフォトを順次公開　JUNG KOOK、RM、JIN...</td>\n",
       "      <td>16596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their first teaser pic of the very ...</td>\n",
       "      <td>4414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their 1st teaser pic of the very ta...</td>\n",
       "      <td>2847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>.@ColumbiaRecords on tour: Peter Gray's band o...</td>\n",
       "      <td>9260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2021-05-14</td>\n",
       "      <td>BTS、新曲「Butter」個別ティーザーフォトを公開　J-HOPE、JIMIN、Vでフィナ...</td>\n",
       "      <td>1829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2021-05-14</td>\n",
       "      <td>BTS、新曲「Butter」/兵役義務/アジア人に対する差別について語る https://t...</td>\n",
       "      <td>2625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS's J-Hope, Jimin, and V radiate their soft ...</td>\n",
       "      <td>2587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 슈가 (S...</td>\n",
       "      <td>1249132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 진 (Ji...</td>\n",
       "      <td>1292953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 정국 (J...</td>\n",
       "      <td>1448291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>are you ready?! the world tv debut of @BTS_twt...</td>\n",
       "      <td>196474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>We can’t hold it in any longer! Our debut perf...</td>\n",
       "      <td>820030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>Are you smooth like Butter?\\n#SmoothLikeButter...</td>\n",
       "      <td>749484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>[#Behind_the_Magic_Door]\\n\\nPlay your song! \\n...</td>\n",
       "      <td>197193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>The @bts_bighit limited edition BUTTER 7\" viny...</td>\n",
       "      <td>44311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>[UCC] BTS's Suga trends worldwide after his \"B...</td>\n",
       "      <td>2434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>I’m so ready for “Butter”. Like vinyl already ...</td>\n",
       "      <td>19893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>any predictions on what @BTS_twt's #BBMAs perf...</td>\n",
       "      <td>97479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS share first teaser pic of #MrWorldwideHan...</td>\n",
       "      <td>10234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>This #BUTTER song is 🔥🔥🔥\\n\\n#BTS is giving us ...</td>\n",
       "      <td>9257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>Thus, in conclusion, #BTS Butter will be a hit 🧈</td>\n",
       "      <td>14320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>.@BTS_twt is dropping a limited-edition versio...</td>\n",
       "      <td>22526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>BTS are dropping a limited-edition version of ...</td>\n",
       "      <td>6974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>BTS is dropping a limited-edition version of #...</td>\n",
       "      <td>19599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>Got to hang on the #ButterBus #BTS_Butter soun...</td>\n",
       "      <td>6351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...</td>\n",
       "      <td>392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>It may have only meant to tease the new song b...</td>\n",
       "      <td>553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>BTS are releasing their new English single, ‘B...</td>\n",
       "      <td>284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>The #bts #ButterBus unexpectedly rolled into G...</td>\n",
       "      <td>597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Tweeted Date                                  Tweet Description  \\\n",
       "0    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...   \n",
       "1    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...   \n",
       "2    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...   \n",
       "3    2021-05-13  BTS released some more teasers for ‘Butter’ an...   \n",
       "4    2021-05-13  #BTS share their first teaser pic of the very ...   \n",
       "5    2021-05-13  #BTS #방탄소년단 #BTS_Butter 🧈 https://t.co/TqlFZafT1L   \n",
       "6    2021-05-13  .@bts_bighit's RM also said the song was \"very...   \n",
       "7    2021-05-13  AMO! Foram divulgadas novas fotos promocionais...   \n",
       "8    2021-05-13  BTS、新曲「Butter」個別ティーザーフォトを順次公開　JUNG KOOK、RM、JIN...   \n",
       "9    2021-05-13  #BTS share their first teaser pic of the very ...   \n",
       "10   2021-05-13  #BTS share their 1st teaser pic of the very ta...   \n",
       "11   2021-05-13  .@ColumbiaRecords on tour: Peter Gray's band o...   \n",
       "12   2021-05-14  BTS、新曲「Butter」個別ティーザーフォトを公開　J-HOPE、JIMIN、Vでフィナ...   \n",
       "13   2021-05-14  BTS、新曲「Butter」/兵役義務/アジア人に対する差別について語る https://t...   \n",
       "14   2021-05-13  BTS's J-Hope, Jimin, and V radiate their soft ...   \n",
       "15   2021-05-12  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 슈가 (S...   \n",
       "16   2021-05-12  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 진 (Ji...   \n",
       "17   2021-05-11  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 정국 (J...   \n",
       "18   2021-05-11  are you ready?! the world tv debut of @BTS_twt...   \n",
       "19   2021-05-11  We can’t hold it in any longer! Our debut perf...   \n",
       "20   2021-05-09  Are you smooth like Butter?\\n#SmoothLikeButter...   \n",
       "21   2021-05-12  [#Behind_the_Magic_Door]\\n\\nPlay your song! \\n...   \n",
       "22   2021-05-11  The @bts_bighit limited edition BUTTER 7\" viny...   \n",
       "23   2021-05-12  [UCC] BTS's Suga trends worldwide after his \"B...   \n",
       "24   2021-05-12  I’m so ready for “Butter”. Like vinyl already ...   \n",
       "25   2021-05-11  any predictions on what @BTS_twt's #BBMAs perf...   \n",
       "26   2021-05-12  #BTS share first teaser pic of #MrWorldwideHan...   \n",
       "27   2021-05-07  This #BUTTER song is 🔥🔥🔥\\n\\n#BTS is giving us ...   \n",
       "28   2021-05-07   Thus, in conclusion, #BTS Butter will be a hit 🧈   \n",
       "29   2021-05-07  .@BTS_twt is dropping a limited-edition versio...   \n",
       "30   2021-05-07  BTS are dropping a limited-edition version of ...   \n",
       "31   2021-05-08  BTS is dropping a limited-edition version of #...   \n",
       "32   2021-05-08  Got to hang on the #ButterBus #BTS_Butter soun...   \n",
       "33   2021-05-07  You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...   \n",
       "34   2021-05-08  It may have only meant to tease the new song b...   \n",
       "35   2021-05-07  BTS are releasing their new English single, ‘B...   \n",
       "36   2021-05-08  The #bts #ButterBus unexpectedly rolled into G...   \n",
       "37   2021-05-08  More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...   \n",
       "\n",
       "    Popularity Count  \n",
       "0            1180312  \n",
       "1            1177937  \n",
       "2            1312670  \n",
       "3              41077  \n",
       "4              13112  \n",
       "5              21684  \n",
       "6              14837  \n",
       "7               5117  \n",
       "8              16596  \n",
       "9               4414  \n",
       "10              2847  \n",
       "11              9260  \n",
       "12              1829  \n",
       "13              2625  \n",
       "14              2587  \n",
       "15           1249132  \n",
       "16           1292953  \n",
       "17           1448291  \n",
       "18            196474  \n",
       "19            820030  \n",
       "20            749484  \n",
       "21            197193  \n",
       "22             44311  \n",
       "23              2434  \n",
       "24             19893  \n",
       "25             97479  \n",
       "26             10234  \n",
       "27              9257  \n",
       "28             14320  \n",
       "29             22526  \n",
       "30              6974  \n",
       "31             19599  \n",
       "32              6351  \n",
       "33               392  \n",
       "34               553  \n",
       "35               284  \n",
       "36               597  \n",
       "37               105  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# See all tweets\n",
    "new_bts_tweets_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Tweeted Date</th>\n",
       "      <th>Tweet Description</th>\n",
       "      <th>Popularity Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 정국 (J...</td>\n",
       "      <td>1448291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...</td>\n",
       "      <td>1312670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 진 (Ji...</td>\n",
       "      <td>1292953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 슈가 (S...</td>\n",
       "      <td>1249132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...</td>\n",
       "      <td>1180312</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Tweeted Date                                  Tweet Description  \\\n",
       "17   2021-05-11  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 정국 (J...   \n",
       "2    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...   \n",
       "16   2021-05-12  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 진 (Ji...   \n",
       "15   2021-05-12  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 슈가 (S...   \n",
       "0    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...   \n",
       "\n",
       "    Popularity Count  \n",
       "17           1448291  \n",
       "2            1312670  \n",
       "16           1292953  \n",
       "15           1249132  \n",
       "0            1180312  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sort them in ascending order from most popular tweet on the top to the least popular tweet on the bottom \n",
    "\n",
    "# let's see top 5 popular tweets about BTS's Butter Album\n",
    "top_5_bot_5_popular_least_tweets = new_bts_tweets_df.sort_values(by=\"Popularity Count\", ascending=False)\n",
    "top_5_bot_5_popular_least_tweets.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Tweeted Date</th>\n",
       "      <th>Tweet Description</th>\n",
       "      <th>Popularity Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>The #bts #ButterBus unexpectedly rolled into G...</td>\n",
       "      <td>597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>It may have only meant to tease the new song b...</td>\n",
       "      <td>553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...</td>\n",
       "      <td>392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>BTS are releasing their new English single, ‘B...</td>\n",
       "      <td>284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Tweeted Date                                  Tweet Description  \\\n",
       "36   2021-05-08  The #bts #ButterBus unexpectedly rolled into G...   \n",
       "34   2021-05-08  It may have only meant to tease the new song b...   \n",
       "33   2021-05-07  You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...   \n",
       "35   2021-05-07  BTS are releasing their new English single, ‘B...   \n",
       "37   2021-05-08  More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...   \n",
       "\n",
       "    Popularity Count  \n",
       "36               597  \n",
       "34               553  \n",
       "33               392  \n",
       "35               284  \n",
       "37               105  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# let's see the top 5 least popular tweets about BTS's Butter Album\n",
    "top_5_bot_5_popular_least_tweets.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Tweeted Date</th>\n",
       "      <th>Tweet Description</th>\n",
       "      <th>Popularity Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 정국 (J...</td>\n",
       "      <td>1448291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...</td>\n",
       "      <td>1312670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 진 (Ji...</td>\n",
       "      <td>1292953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 슈가 (S...</td>\n",
       "      <td>1249132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...</td>\n",
       "      <td>1180312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...</td>\n",
       "      <td>1177937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>We can’t hold it in any longer! Our debut perf...</td>\n",
       "      <td>820030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>Are you smooth like Butter?\\n#SmoothLikeButter...</td>\n",
       "      <td>749484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>[#Behind_the_Magic_Door]\\n\\nPlay your song! \\n...</td>\n",
       "      <td>197193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>are you ready?! the world tv debut of @BTS_twt...</td>\n",
       "      <td>196474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>any predictions on what @BTS_twt's #BBMAs perf...</td>\n",
       "      <td>97479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2021-05-11</td>\n",
       "      <td>The @bts_bighit limited edition BUTTER 7\" viny...</td>\n",
       "      <td>44311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS released some more teasers for ‘Butter’ an...</td>\n",
       "      <td>41077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>.@BTS_twt is dropping a limited-edition versio...</td>\n",
       "      <td>22526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS #방탄소년단 #BTS_Butter 🧈 https://t.co/TqlFZafT1L</td>\n",
       "      <td>21684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>I’m so ready for “Butter”. Like vinyl already ...</td>\n",
       "      <td>19893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>BTS is dropping a limited-edition version of #...</td>\n",
       "      <td>19599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS、新曲「Butter」個別ティーザーフォトを順次公開　JUNG KOOK、RM、JIN...</td>\n",
       "      <td>16596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>.@bts_bighit's RM also said the song was \"very...</td>\n",
       "      <td>14837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>Thus, in conclusion, #BTS Butter will be a hit 🧈</td>\n",
       "      <td>14320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their first teaser pic of the very ...</td>\n",
       "      <td>13112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>#BTS share first teaser pic of #MrWorldwideHan...</td>\n",
       "      <td>10234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>.@ColumbiaRecords on tour: Peter Gray's band o...</td>\n",
       "      <td>9260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>This #BUTTER song is 🔥🔥🔥\\n\\n#BTS is giving us ...</td>\n",
       "      <td>9257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>BTS are dropping a limited-edition version of ...</td>\n",
       "      <td>6974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>Got to hang on the #ButterBus #BTS_Butter soun...</td>\n",
       "      <td>6351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>AMO! Foram divulgadas novas fotos promocionais...</td>\n",
       "      <td>5117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their first teaser pic of the very ...</td>\n",
       "      <td>4414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>#BTS share their 1st teaser pic of the very ta...</td>\n",
       "      <td>2847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2021-05-14</td>\n",
       "      <td>BTS、新曲「Butter」/兵役義務/アジア人に対する差別について語る https://t...</td>\n",
       "      <td>2625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2021-05-13</td>\n",
       "      <td>BTS's J-Hope, Jimin, and V radiate their soft ...</td>\n",
       "      <td>2587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>[UCC] BTS's Suga trends worldwide after his \"B...</td>\n",
       "      <td>2434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2021-05-14</td>\n",
       "      <td>BTS、新曲「Butter」個別ティーザーフォトを公開　J-HOPE、JIMIN、Vでフィナ...</td>\n",
       "      <td>1829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>The #bts #ButterBus unexpectedly rolled into G...</td>\n",
       "      <td>597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>It may have only meant to tease the new song b...</td>\n",
       "      <td>553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...</td>\n",
       "      <td>392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2021-05-07</td>\n",
       "      <td>BTS are releasing their new English single, ‘B...</td>\n",
       "      <td>284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Tweeted Date                                  Tweet Description  \\\n",
       "17   2021-05-11  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 정국 (J...   \n",
       "2    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 뷔 (V)...   \n",
       "16   2021-05-12  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 진 (Ji...   \n",
       "15   2021-05-12  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 슈가 (S...   \n",
       "0    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 제이홉 (...   \n",
       "1    2021-05-13  #BTS #방탄소년단 #BTS_Butter Teaser Photo 1 - 지민 (J...   \n",
       "19   2021-05-11  We can’t hold it in any longer! Our debut perf...   \n",
       "20   2021-05-09  Are you smooth like Butter?\\n#SmoothLikeButter...   \n",
       "21   2021-05-12  [#Behind_the_Magic_Door]\\n\\nPlay your song! \\n...   \n",
       "18   2021-05-11  are you ready?! the world tv debut of @BTS_twt...   \n",
       "25   2021-05-11  any predictions on what @BTS_twt's #BBMAs perf...   \n",
       "22   2021-05-11  The @bts_bighit limited edition BUTTER 7\" viny...   \n",
       "3    2021-05-13  BTS released some more teasers for ‘Butter’ an...   \n",
       "29   2021-05-07  .@BTS_twt is dropping a limited-edition versio...   \n",
       "5    2021-05-13  #BTS #방탄소년단 #BTS_Butter 🧈 https://t.co/TqlFZafT1L   \n",
       "24   2021-05-12  I’m so ready for “Butter”. Like vinyl already ...   \n",
       "31   2021-05-08  BTS is dropping a limited-edition version of #...   \n",
       "8    2021-05-13  BTS、新曲「Butter」個別ティーザーフォトを順次公開　JUNG KOOK、RM、JIN...   \n",
       "6    2021-05-13  .@bts_bighit's RM also said the song was \"very...   \n",
       "28   2021-05-07   Thus, in conclusion, #BTS Butter will be a hit 🧈   \n",
       "4    2021-05-13  #BTS share their first teaser pic of the very ...   \n",
       "26   2021-05-12  #BTS share first teaser pic of #MrWorldwideHan...   \n",
       "11   2021-05-13  .@ColumbiaRecords on tour: Peter Gray's band o...   \n",
       "27   2021-05-07  This #BUTTER song is 🔥🔥🔥\\n\\n#BTS is giving us ...   \n",
       "30   2021-05-07  BTS are dropping a limited-edition version of ...   \n",
       "32   2021-05-08  Got to hang on the #ButterBus #BTS_Butter soun...   \n",
       "7    2021-05-13  AMO! Foram divulgadas novas fotos promocionais...   \n",
       "9    2021-05-13  #BTS share their first teaser pic of the very ...   \n",
       "10   2021-05-13  #BTS share their 1st teaser pic of the very ta...   \n",
       "13   2021-05-14  BTS、新曲「Butter」/兵役義務/アジア人に対する差別について語る https://t...   \n",
       "14   2021-05-13  BTS's J-Hope, Jimin, and V radiate their soft ...   \n",
       "23   2021-05-12  [UCC] BTS's Suga trends worldwide after his \"B...   \n",
       "12   2021-05-14  BTS、新曲「Butter」個別ティーザーフォトを公開　J-HOPE、JIMIN、Vでフィナ...   \n",
       "36   2021-05-08  The #bts #ButterBus unexpectedly rolled into G...   \n",
       "34   2021-05-08  It may have only meant to tease the new song b...   \n",
       "33   2021-05-07  You ready #BTSARMY !?\\n\\nHear BTS’s #Butter on...   \n",
       "35   2021-05-07  BTS are releasing their new English single, ‘B...   \n",
       "37   2021-05-08  More 🧈🧈🧈 https://t.co/nuIBHRDXxm https://t.co/...   \n",
       "\n",
       "    Popularity Count  \n",
       "17           1448291  \n",
       "2            1312670  \n",
       "16           1292953  \n",
       "15           1249132  \n",
       "0            1180312  \n",
       "1            1177937  \n",
       "19            820030  \n",
       "20            749484  \n",
       "21            197193  \n",
       "18            196474  \n",
       "25             97479  \n",
       "22             44311  \n",
       "3              41077  \n",
       "29             22526  \n",
       "5              21684  \n",
       "24             19893  \n",
       "31             19599  \n",
       "8              16596  \n",
       "6              14837  \n",
       "28             14320  \n",
       "4              13112  \n",
       "26             10234  \n",
       "11              9260  \n",
       "27              9257  \n",
       "30              6974  \n",
       "32              6351  \n",
       "7               5117  \n",
       "9               4414  \n",
       "10              2847  \n",
       "13              2625  \n",
       "14              2587  \n",
       "23              2434  \n",
       "12              1829  \n",
       "36               597  \n",
       "34               553  \n",
       "33               392  \n",
       "35               284  \n",
       "37               105  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# all tweets about BTS's Butter Album from top to bottom\n",
    "top_5_bot_5_popular_least_tweets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "top_5_bot_5_popular_least_tweets.to_csv(\"files/bts_tweet_scraping.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}