Links Analysis Cross-Platforms/Twitter_URLs_2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "726a693c",
   "metadata": {},
   "outputs": [],
   "source": [
    "from helpers import (\n",
    "    URLS,\n",
    "    get_urls,\n",
    "    urls_df,\n",
    "    one_link_df,\n",
    "    one_link_urls,\n",
    "    one_link_urls_with_count_,\n",
    "    df_more_than_link, more_than_one_link_with_count_,\n",
    "    one_link_urls_with_count\n",
    ")\n",
    "import pandas as pd\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "fbf9cfba",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import urlexpander\n",
    "def expand(url):\n",
    "    url_ = urlexpander.expand(url)\n",
    "    if \"ERROR\" in url_:\n",
    "        return np.nan\n",
    "    return url_"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8b56cd59",
   "metadata": {},
   "source": [
    "# Twitter Data URLs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "2d321f99",
   "metadata": {},
   "outputs": [],
   "source": [
    "twitter_path =  \"../Twitter/Unshorten_Data/\""
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a191bdbf",
   "metadata": {},
   "source": [
    "### dec\n",
    "<a id='12'></a>\n",
    "\n",
    "\n",
    "><ul>\n",
    " <li><a href=\"#one12\">One Link</a></li>\n",
    " <li><a href=\"#more12\">More Than One Link</a></li>  \n",
    "\n",
    " </ul>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a5b487c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls = pd.read_csv(twitter_path + \"df_tweets_dec_urls.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "0b467e31",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_one = df_tweets_dec_urls[df_tweets_dec_urls.n_urls == 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "85e1d5a3",
   "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>id_str</th>\n",
       "      <th>created_at</th>\n",
       "      <th>full_text</th>\n",
       "      <th>user.id_str</th>\n",
       "      <th>user.screen_name</th>\n",
       "      <th>user.name</th>\n",
       "      <th>user.created_at</th>\n",
       "      <th>urls</th>\n",
       "      <th>n_urls</th>\n",
       "      <th>unshorten_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.338250e+18</td>\n",
       "      <td>2020-12-13 22:43:30+00:00</td>\n",
       "      <td>It Is just me? Or everybody does when sees Joh...</td>\n",
       "      <td>1.327950e+18</td>\n",
       "      <td>Camilaalustiza3</td>\n",
       "      <td>OnlyForJohnny</td>\n",
       "      <td>2020-11-15 12:31:21+00:00</td>\n",
       "      <td>['https://t.co/UzOD82X1oU']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/Camilaalustiza3/status/133...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.338250e+18</td>\n",
       "      <td>2020-12-13 22:43:23+00:00</td>\n",
       "      <td>I reckon the old boy is behind all of this.\\nP...</td>\n",
       "      <td>1.329500e+18</td>\n",
       "      <td>Aishacat5</td>\n",
       "      <td>Aishacat🏴‍☠️😻</td>\n",
       "      <td>2020-11-19 19:03:24+00:00</td>\n",
       "      <td>['https://t.co/cSg2ieMaaA']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://chng.it/Z9hCPtzh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.338250e+18</td>\n",
       "      <td>2020-12-13 22:36:59+00:00</td>\n",
       "      <td>Yesterday I went to a store and asked for the ...</td>\n",
       "      <td>1.231252e+09</td>\n",
       "      <td>cat_a_estranha</td>\n",
       "      <td>tiny hot topic bitch</td>\n",
       "      <td>2013-03-01 20:17:55+00:00</td>\n",
       "      <td>['https://t.co/iIKojPGvhY']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/cat_a_estranha/status/1338...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.338250e+18</td>\n",
       "      <td>2020-12-13 22:35:31+00:00</td>\n",
       "      <td>@feral_feminist @Zephyrdust8 @win_confidante @...</td>\n",
       "      <td>1.302990e+18</td>\n",
       "      <td>JustMe_Katiebee</td>\n",
       "      <td>Katie-Waldman-Depphead</td>\n",
       "      <td>2020-09-07 15:23:20+00:00</td>\n",
       "      <td>['https://t.co/Up8gbWyjkv']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/JustMe_Katiebee/status/133...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.338250e+18</td>\n",
       "      <td>2020-12-13 22:34:26+00:00</td>\n",
       "      <td>#JusticeForJohnnyDepp\\n\\nWe really need to get...</td>\n",
       "      <td>4.962274e+07</td>\n",
       "      <td>Binx1969</td>\n",
       "      <td>Belinda 🇬🇧</td>\n",
       "      <td>2009-06-22 13:09:57+00:00</td>\n",
       "      <td>['https://t.co/8JNyM7PhY0']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://www.change.org/p/rupert-murdoch-probe-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23021</th>\n",
       "      <td>1.335460e+18</td>\n",
       "      <td>2020-12-06 05:54:59+00:00</td>\n",
       "      <td>Soooo Amber Heard and Pirates of the Caribbean...</td>\n",
       "      <td>5.742834e+08</td>\n",
       "      <td>AvaBaudelaire</td>\n",
       "      <td>A.M. Mondesir</td>\n",
       "      <td>2012-05-08 04:42:09+00:00</td>\n",
       "      <td>['https://t.co/4X8aFKF1pl']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/AvaBaudelaire/status/13354...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23022</th>\n",
       "      <td>1.335460e+18</td>\n",
       "      <td>2020-12-06 05:53:27+00:00</td>\n",
       "      <td>Only Johnny knows how to put that powerful loo...</td>\n",
       "      <td>1.331010e+18</td>\n",
       "      <td>JohnnyDeppGIF</td>\n",
       "      <td>Johnny Depp Gifs</td>\n",
       "      <td>2020-11-23 23:18:49+00:00</td>\n",
       "      <td>['https://t.co/55S6L5AQPA']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/JohnnyDeppGIF/status/13354...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23023</th>\n",
       "      <td>1.335460e+18</td>\n",
       "      <td>2020-12-06 05:47:44+00:00</td>\n",
       "      <td>@Allure_magazine Please help sign, share &amp;amp;...</td>\n",
       "      <td>1.266710e+18</td>\n",
       "      <td>Irina_Skywalker</td>\n",
       "      <td>Irina Skywalker</td>\n",
       "      <td>2020-05-30 12:47:40+00:00</td>\n",
       "      <td>['https://t.co/p7SBtTMNbI']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://chng.it/d7pDjTXB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23024</th>\n",
       "      <td>1.335460e+18</td>\n",
       "      <td>2020-12-06 05:45:32+00:00</td>\n",
       "      <td>EVERYONE : Cancel Amber Heard domestic abuser!...</td>\n",
       "      <td>1.313880e+18</td>\n",
       "      <td>Harleycosplay1</td>\n",
       "      <td>Harleycosplay</td>\n",
       "      <td>2020-10-07 16:33:47+00:00</td>\n",
       "      <td>['https://t.co/9fgaSRtGQf']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://chng.it/Tt9w4DXq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23025</th>\n",
       "      <td>1.335460e+18</td>\n",
       "      <td>2020-12-06 05:41:52+00:00</td>\n",
       "      <td>#JusticeForJohnnyDepp https://t.co/Q3GSkvO1QM</td>\n",
       "      <td>1.055731e+08</td>\n",
       "      <td>stockyjulz</td>\n",
       "      <td>julie stockbridge</td>\n",
       "      <td>2010-01-16 19:43:51+00:00</td>\n",
       "      <td>['https://t.co/Q3GSkvO1QM']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/stockyjulz/status/13354594...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23026 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             id_str                 created_at  \\\n",
       "0      1.338250e+18  2020-12-13 22:43:30+00:00   \n",
       "1      1.338250e+18  2020-12-13 22:43:23+00:00   \n",
       "2      1.338250e+18  2020-12-13 22:36:59+00:00   \n",
       "3      1.338250e+18  2020-12-13 22:35:31+00:00   \n",
       "4      1.338250e+18  2020-12-13 22:34:26+00:00   \n",
       "...             ...                        ...   \n",
       "23021  1.335460e+18  2020-12-06 05:54:59+00:00   \n",
       "23022  1.335460e+18  2020-12-06 05:53:27+00:00   \n",
       "23023  1.335460e+18  2020-12-06 05:47:44+00:00   \n",
       "23024  1.335460e+18  2020-12-06 05:45:32+00:00   \n",
       "23025  1.335460e+18  2020-12-06 05:41:52+00:00   \n",
       "\n",
       "                                               full_text   user.id_str  \\\n",
       "0      It Is just me? Or everybody does when sees Joh...  1.327950e+18   \n",
       "1      I reckon the old boy is behind all of this.\\nP...  1.329500e+18   \n",
       "2      Yesterday I went to a store and asked for the ...  1.231252e+09   \n",
       "3      @feral_feminist @Zephyrdust8 @win_confidante @...  1.302990e+18   \n",
       "4      #JusticeForJohnnyDepp\\n\\nWe really need to get...  4.962274e+07   \n",
       "...                                                  ...           ...   \n",
       "23021  Soooo Amber Heard and Pirates of the Caribbean...  5.742834e+08   \n",
       "23022  Only Johnny knows how to put that powerful loo...  1.331010e+18   \n",
       "23023  @Allure_magazine Please help sign, share &amp;...  1.266710e+18   \n",
       "23024  EVERYONE : Cancel Amber Heard domestic abuser!...  1.313880e+18   \n",
       "23025      #JusticeForJohnnyDepp https://t.co/Q3GSkvO1QM  1.055731e+08   \n",
       "\n",
       "      user.screen_name               user.name            user.created_at  \\\n",
       "0      Camilaalustiza3           OnlyForJohnny  2020-11-15 12:31:21+00:00   \n",
       "1            Aishacat5           Aishacat🏴‍☠️😻  2020-11-19 19:03:24+00:00   \n",
       "2       cat_a_estranha    tiny hot topic bitch  2013-03-01 20:17:55+00:00   \n",
       "3      JustMe_Katiebee  Katie-Waldman-Depphead  2020-09-07 15:23:20+00:00   \n",
       "4             Binx1969              Belinda 🇬🇧  2009-06-22 13:09:57+00:00   \n",
       "...                ...                     ...                        ...   \n",
       "23021    AvaBaudelaire           A.M. Mondesir  2012-05-08 04:42:09+00:00   \n",
       "23022    JohnnyDeppGIF        Johnny Depp Gifs  2020-11-23 23:18:49+00:00   \n",
       "23023  Irina_Skywalker         Irina Skywalker  2020-05-30 12:47:40+00:00   \n",
       "23024   Harleycosplay1           Harleycosplay  2020-10-07 16:33:47+00:00   \n",
       "23025       stockyjulz       julie stockbridge  2010-01-16 19:43:51+00:00   \n",
       "\n",
       "                              urls  n_urls  \\\n",
       "0      ['https://t.co/UzOD82X1oU']       1   \n",
       "1      ['https://t.co/cSg2ieMaaA']       1   \n",
       "2      ['https://t.co/iIKojPGvhY']       1   \n",
       "3      ['https://t.co/Up8gbWyjkv']       1   \n",
       "4      ['https://t.co/8JNyM7PhY0']       1   \n",
       "...                            ...     ...   \n",
       "23021  ['https://t.co/4X8aFKF1pl']       1   \n",
       "23022  ['https://t.co/55S6L5AQPA']       1   \n",
       "23023  ['https://t.co/p7SBtTMNbI']       1   \n",
       "23024  ['https://t.co/9fgaSRtGQf']       1   \n",
       "23025  ['https://t.co/Q3GSkvO1QM']       1   \n",
       "\n",
       "                                          unshorten_urls  \n",
       "0      https://twitter.com/Camilaalustiza3/status/133...  \n",
       "1                               https://chng.it/Z9hCPtzh  \n",
       "2      https://twitter.com/cat_a_estranha/status/1338...  \n",
       "3      https://twitter.com/JustMe_Katiebee/status/133...  \n",
       "4      https://www.change.org/p/rupert-murdoch-probe-...  \n",
       "...                                                  ...  \n",
       "23021  https://twitter.com/AvaBaudelaire/status/13354...  \n",
       "23022  https://twitter.com/JohnnyDeppGIF/status/13354...  \n",
       "23023                           https://chng.it/d7pDjTXB  \n",
       "23024                           https://chng.it/Tt9w4DXq  \n",
       "23025  https://twitter.com/stockyjulz/status/13354594...  \n",
       "\n",
       "[23026 rows x 10 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_dec_urls_one"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e9ddd07e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_one.rename(\n",
    "    columns={\"urls\": \"short_urls\", \"unshorten_urls\": \"urls\"}, inplace=True\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "f4349811",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_one.rename(columns={\"urls\": \"url\"}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "7d6c7aca",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_with_users_count = one_link_urls_with_count_(df_tweets_dec_urls_one, \"user.id_str\", \"url\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "b4e7ea09",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_with_users_count[\"n_urls\"] = 1\n",
    "df_tweets_dec_urls_with_users_count[\"n_urls\"] = df_tweets_dec_urls_with_users_count[\"n_urls\"].apply(lambda x: {x})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "6591ce43",
   "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>link</th>\n",
       "      <th>count</th>\n",
       "      <th>n_users</th>\n",
       "      <th>users</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://youtu.be/1yuki8YG3xA</td>\n",
       "      <td>49</td>\n",
       "      <td>47</td>\n",
       "      <td>(8.87661e+17, 1.28344e+18, 8.09094e+17, 1.1839...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://youtu.be/U_MYHvZZizY</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "      <td>(1.04191e+18, 1.22796e+18, 1.33976e+18, 1.1884...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.change.org/p/dc-entertainment-remo...</td>\n",
       "      <td>105</td>\n",
       "      <td>40</td>\n",
       "      <td>(1.18243e+18, 8.95712e+17, 1.28422e+18, 1.2864...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://youtu.be/uretrfMA-Io</td>\n",
       "      <td>42</td>\n",
       "      <td>38</td>\n",
       "      <td>(1.14262e+18, 1.33083e+18, 1.33206e+18, 1.3246...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://youtu.be/4Sy-9UnO_hE</td>\n",
       "      <td>38</td>\n",
       "      <td>37</td>\n",
       "      <td>(7.75355e+17, 1.28422e+18, 1.26416e+18, 8.7793...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19619</th>\n",
       "      <td>https://twitter.com/Soledad15981419/status/134...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.34015e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19620</th>\n",
       "      <td>https://twitter.com/Soledad15981419/status/134...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.34015e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19621</th>\n",
       "      <td>https://twitter.com/Soledad15981419/status/134...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.34015e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19622</th>\n",
       "      <td>https://twitter.com/Soledad15981419/status/134...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.34015e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19623</th>\n",
       "      <td>https://twitter.com/stockyjulz/status/13354594...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(105573068.0,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>19624 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    link  count  n_users  \\\n",
       "0                           https://youtu.be/1yuki8YG3xA     49       47   \n",
       "1                           https://youtu.be/U_MYHvZZizY     47       47   \n",
       "2      https://www.change.org/p/dc-entertainment-remo...    105       40   \n",
       "3                           https://youtu.be/uretrfMA-Io     42       38   \n",
       "4                           https://youtu.be/4Sy-9UnO_hE     38       37   \n",
       "...                                                  ...    ...      ...   \n",
       "19619  https://twitter.com/Soledad15981419/status/134...      1        1   \n",
       "19620  https://twitter.com/Soledad15981419/status/134...      1        1   \n",
       "19621  https://twitter.com/Soledad15981419/status/134...      1        1   \n",
       "19622  https://twitter.com/Soledad15981419/status/134...      1        1   \n",
       "19623  https://twitter.com/stockyjulz/status/13354594...      1        1   \n",
       "\n",
       "                                                   users n_urls  \n",
       "0      (8.87661e+17, 1.28344e+18, 8.09094e+17, 1.1839...    {1}  \n",
       "1      (1.04191e+18, 1.22796e+18, 1.33976e+18, 1.1884...    {1}  \n",
       "2      (1.18243e+18, 8.95712e+17, 1.28422e+18, 1.2864...    {1}  \n",
       "3      (1.14262e+18, 1.33083e+18, 1.33206e+18, 1.3246...    {1}  \n",
       "4      (7.75355e+17, 1.28422e+18, 1.26416e+18, 8.7793...    {1}  \n",
       "...                                                  ...    ...  \n",
       "19619                                     (1.34015e+18,)    {1}  \n",
       "19620                                     (1.34015e+18,)    {1}  \n",
       "19621                                     (1.34015e+18,)    {1}  \n",
       "19622                                     (1.34015e+18,)    {1}  \n",
       "19623                                     (105573068.0,)    {1}  \n",
       "\n",
       "[19624 rows x 5 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_dec_urls_with_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "0ed789fa",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_more = df_tweets_dec_urls[df_tweets_dec_urls.n_urls > 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "4888d349",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_more.rename(\n",
    "    columns={\"urls\": \"short_urls\", \"unshorten_urls\": \"url\"}, inplace=True\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "6fb17c34",
   "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>id_str</th>\n",
       "      <th>created_at</th>\n",
       "      <th>full_text</th>\n",
       "      <th>user.id_str</th>\n",
       "      <th>user.screen_name</th>\n",
       "      <th>user.name</th>\n",
       "      <th>user.created_at</th>\n",
       "      <th>short_urls</th>\n",
       "      <th>n_urls</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23026</th>\n",
       "      <td>1.338252e+18</td>\n",
       "      <td>2020-12-13 22:40:00+00:00</td>\n",
       "      <td>Johnny Depp exige a Warner Bros. sacar a Amber...</td>\n",
       "      <td>2.442187e+08</td>\n",
       "      <td>SinEmbargoMX</td>\n",
       "      <td>Sin Embargo MX</td>\n",
       "      <td>2011-01-28 20:21:23+00:00</td>\n",
       "      <td>['https://t.co/NHto0O1Ftk', 'https://t.co/v6P2...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.sinembargo.mx/13-12-2020/3909331...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23027</th>\n",
       "      <td>1.338262e+18</td>\n",
       "      <td>2020-12-13 23:20:00+00:00</td>\n",
       "      <td>Johnny Depp exige a Warner Bros. sacar a Amber...</td>\n",
       "      <td>4.151552e+08</td>\n",
       "      <td>MagazineSEMX</td>\n",
       "      <td>Sin Embargo Magazine</td>\n",
       "      <td>2011-11-17 23:55:57+00:00</td>\n",
       "      <td>['https://t.co/quKtMDv5Ry', 'https://t.co/N4Nw...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.sinembargo.mx/13-12-2020/3909331...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23028</th>\n",
       "      <td>1.338012e+18</td>\n",
       "      <td>2020-12-13 06:44:32+00:00</td>\n",
       "      <td>Petition · DC Entertainment: Remove Amber Hear...</td>\n",
       "      <td>5.255582e+08</td>\n",
       "      <td>thepaigeyg4</td>\n",
       "      <td>paige ||-//</td>\n",
       "      <td>2012-03-15 17:13:16+00:00</td>\n",
       "      <td>['https://t.co/jf9x3qHzsf', 'https://t.co/gMdY...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.change.org/', 'https://www.chang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23029</th>\n",
       "      <td>1.338166e+18</td>\n",
       "      <td>2020-12-13 16:57:49+00:00</td>\n",
       "      <td>LIVE in 1 hour! 😉\\n\\nJoin me with several supp...</td>\n",
       "      <td>1.016592e+18</td>\n",
       "      <td>StevieJRaw</td>\n",
       "      <td>🏴‍☠️Stevie J Raw🏴‍☠️</td>\n",
       "      <td>2018-07-10 07:57:44+00:00</td>\n",
       "      <td>['https://t.co/zaKIpSAbfR', 'https://t.co/PweL...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.youtube.com/watch?v=mxTefwgl5HQ&amp;...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23030</th>\n",
       "      <td>1.338119e+18</td>\n",
       "      <td>2020-12-13 13:49:25+00:00</td>\n",
       "      <td>Are women good and innocent by nature? Of cour...</td>\n",
       "      <td>1.296166e+18</td>\n",
       "      <td>bazarette74</td>\n",
       "      <td>Bazarette74</td>\n",
       "      <td>2020-08-19 19:23:20+00:00</td>\n",
       "      <td>['https://t.co/X9Hvg1aGqz', 'https://t.co/SE2B...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://en.m.wikipedia.org/wiki/Category:Ame...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23965</th>\n",
       "      <td>1.335602e+18</td>\n",
       "      <td>2020-12-06 15:10:20+00:00</td>\n",
       "      <td>Amber Heard estaría en negociaciones con Marve...</td>\n",
       "      <td>6.826098e+07</td>\n",
       "      <td>PeriodistaMarco</td>\n",
       "      <td>Marco A. Lizarraga</td>\n",
       "      <td>2009-08-23 23:07:14+00:00</td>\n",
       "      <td>['https://t.co/6MnEDIUqNH', 'https://t.co/kmK1...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.entreveredas.com.mx/2020/12/ambe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23966</th>\n",
       "      <td>1.335664e+18</td>\n",
       "      <td>2020-12-06 19:15:36+00:00</td>\n",
       "      <td>Same Time's Up that mishandled donations?\\nhtt...</td>\n",
       "      <td>1.323348e+18</td>\n",
       "      <td>phimvle</td>\n",
       "      <td>Phimvlegnon</td>\n",
       "      <td>2020-11-02 19:35:41+00:00</td>\n",
       "      <td>['https://t.co/PiefnnTXxT', 'https://t.co/HhmJ...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://nypost.com/2020/11/28/star-studded-t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23967</th>\n",
       "      <td>1.335660e+18</td>\n",
       "      <td>2020-12-06 18:59:01+00:00</td>\n",
       "      <td>Amber Heard negocia con Marvel dos protagónico...</td>\n",
       "      <td>1.110184e+08</td>\n",
       "      <td>rvanguardia</td>\n",
       "      <td>Radio Vanguardia</td>\n",
       "      <td>2010-02-03 14:49:48+00:00</td>\n",
       "      <td>['https://t.co/QPNoiSsZlY', 'https://t.co/iLgJ...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.radiovanguardia.com/2020/12/06/a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23968</th>\n",
       "      <td>1.335465e+18</td>\n",
       "      <td>2020-12-06 06:05:53+00:00</td>\n",
       "      <td>SOMEBODY please go over here and show this per...</td>\n",
       "      <td>1.324794e+18</td>\n",
       "      <td>BraveMoonGirl1</td>\n",
       "      <td>BraveMoonGirl</td>\n",
       "      <td>2020-11-06 19:22:12+00:00</td>\n",
       "      <td>['https://t.co/KnT32KU5dF', 'https://t.co/TeSY...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.reddit.com/r/memes/comments/k5ao...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23969</th>\n",
       "      <td>1.335465e+18</td>\n",
       "      <td>2020-12-06 06:02:52+00:00</td>\n",
       "      <td>We recently hit 1.7 million! And Warner brothe...</td>\n",
       "      <td>1.296264e+18</td>\n",
       "      <td>Emily58807415</td>\n",
       "      <td>Emily</td>\n",
       "      <td>2020-08-20 01:55:14+00:00</td>\n",
       "      <td>['https://t.co/T2kgwOMPKr', 'https://t.co/PqT4...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.change.org/', 'https://www.chang...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>944 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             id_str                 created_at  \\\n",
       "23026  1.338252e+18  2020-12-13 22:40:00+00:00   \n",
       "23027  1.338262e+18  2020-12-13 23:20:00+00:00   \n",
       "23028  1.338012e+18  2020-12-13 06:44:32+00:00   \n",
       "23029  1.338166e+18  2020-12-13 16:57:49+00:00   \n",
       "23030  1.338119e+18  2020-12-13 13:49:25+00:00   \n",
       "...             ...                        ...   \n",
       "23965  1.335602e+18  2020-12-06 15:10:20+00:00   \n",
       "23966  1.335664e+18  2020-12-06 19:15:36+00:00   \n",
       "23967  1.335660e+18  2020-12-06 18:59:01+00:00   \n",
       "23968  1.335465e+18  2020-12-06 06:05:53+00:00   \n",
       "23969  1.335465e+18  2020-12-06 06:02:52+00:00   \n",
       "\n",
       "                                               full_text   user.id_str  \\\n",
       "23026  Johnny Depp exige a Warner Bros. sacar a Amber...  2.442187e+08   \n",
       "23027  Johnny Depp exige a Warner Bros. sacar a Amber...  4.151552e+08   \n",
       "23028  Petition · DC Entertainment: Remove Amber Hear...  5.255582e+08   \n",
       "23029  LIVE in 1 hour! 😉\\n\\nJoin me with several supp...  1.016592e+18   \n",
       "23030  Are women good and innocent by nature? Of cour...  1.296166e+18   \n",
       "...                                                  ...           ...   \n",
       "23965  Amber Heard estaría en negociaciones con Marve...  6.826098e+07   \n",
       "23966  Same Time's Up that mishandled donations?\\nhtt...  1.323348e+18   \n",
       "23967  Amber Heard negocia con Marvel dos protagónico...  1.110184e+08   \n",
       "23968  SOMEBODY please go over here and show this per...  1.324794e+18   \n",
       "23969  We recently hit 1.7 million! And Warner brothe...  1.296264e+18   \n",
       "\n",
       "      user.screen_name             user.name            user.created_at  \\\n",
       "23026     SinEmbargoMX        Sin Embargo MX  2011-01-28 20:21:23+00:00   \n",
       "23027     MagazineSEMX  Sin Embargo Magazine  2011-11-17 23:55:57+00:00   \n",
       "23028      thepaigeyg4           paige ||-//  2012-03-15 17:13:16+00:00   \n",
       "23029       StevieJRaw  🏴‍☠️Stevie J Raw🏴‍☠️  2018-07-10 07:57:44+00:00   \n",
       "23030      bazarette74           Bazarette74  2020-08-19 19:23:20+00:00   \n",
       "...                ...                   ...                        ...   \n",
       "23965  PeriodistaMarco    Marco A. Lizarraga  2009-08-23 23:07:14+00:00   \n",
       "23966          phimvle           Phimvlegnon  2020-11-02 19:35:41+00:00   \n",
       "23967      rvanguardia      Radio Vanguardia  2010-02-03 14:49:48+00:00   \n",
       "23968   BraveMoonGirl1         BraveMoonGirl  2020-11-06 19:22:12+00:00   \n",
       "23969    Emily58807415                 Emily  2020-08-20 01:55:14+00:00   \n",
       "\n",
       "                                              short_urls  n_urls  \\\n",
       "23026  ['https://t.co/NHto0O1Ftk', 'https://t.co/v6P2...       2   \n",
       "23027  ['https://t.co/quKtMDv5Ry', 'https://t.co/N4Nw...       2   \n",
       "23028  ['https://t.co/jf9x3qHzsf', 'https://t.co/gMdY...       2   \n",
       "23029  ['https://t.co/zaKIpSAbfR', 'https://t.co/PweL...       2   \n",
       "23030  ['https://t.co/X9Hvg1aGqz', 'https://t.co/SE2B...       2   \n",
       "...                                                  ...     ...   \n",
       "23965  ['https://t.co/6MnEDIUqNH', 'https://t.co/kmK1...       2   \n",
       "23966  ['https://t.co/PiefnnTXxT', 'https://t.co/HhmJ...       2   \n",
       "23967  ['https://t.co/QPNoiSsZlY', 'https://t.co/iLgJ...       2   \n",
       "23968  ['https://t.co/KnT32KU5dF', 'https://t.co/TeSY...       2   \n",
       "23969  ['https://t.co/T2kgwOMPKr', 'https://t.co/PqT4...       2   \n",
       "\n",
       "                                                     url  \n",
       "23026  ['https://www.sinembargo.mx/13-12-2020/3909331...  \n",
       "23027  ['https://www.sinembargo.mx/13-12-2020/3909331...  \n",
       "23028  ['https://www.change.org/', 'https://www.chang...  \n",
       "23029  ['https://www.youtube.com/watch?v=mxTefwgl5HQ&...  \n",
       "23030  ['https://en.m.wikipedia.org/wiki/Category:Ame...  \n",
       "...                                                  ...  \n",
       "23965  ['https://www.entreveredas.com.mx/2020/12/ambe...  \n",
       "23966  ['https://nypost.com/2020/11/28/star-studded-t...  \n",
       "23967  ['https://www.radiovanguardia.com/2020/12/06/a...  \n",
       "23968  ['https://www.reddit.com/r/memes/comments/k5ao...  \n",
       "23969  ['https://www.change.org/', 'https://www.chang...  \n",
       "\n",
       "[944 rows x 10 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_dec_urls_more"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "070a7243",
   "metadata": {},
   "outputs": [],
   "source": [
    "from ast import literal_eval as le"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "f5d8500e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_more[\"url\"] = df_tweets_dec_urls_more[\"url\"].apply(lambda x: le(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "8984c671",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_more_with_users_count = more_than_one_link_with_count_(\n",
    "    df_tweets_dec_urls_more, \"user.id_str\", \"url\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "bab9e5e2",
   "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>link</th>\n",
       "      <th>count</th>\n",
       "      <th>n_users</th>\n",
       "      <th>users</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://www.sinembargo.mx/13-12-2020/3909331</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>{244218738.0, 415155226.0}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://twitter.com/SinEmbargoMX/status/133825...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{244218738.0}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://twitter.com/MagazineSEMX/status/133826...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{415155226.0}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.change.org/</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>{1.2525096682216284e+18, 1.2850933833256673e+1...</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://www.change.org/p/dc-entertainment-remo...</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>{1.182426890956464e+18, 1.2850933833256673e+18...</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1578</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-89977...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{1.3233480042801605e+18}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1579</th>\n",
       "      <td>https://www.radiovanguardia.com/2020/12/06/amb...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{111018390.0}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1580</th>\n",
       "      <td>https://twitter.com/rvanguardia/status/1335660...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{111018390.0}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1581</th>\n",
       "      <td>https://www.reddit.com/r/memes/comments/k5ao7x...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{1.324794194448257e+18}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1582</th>\n",
       "      <td>https://twitter.com/BraveMoonGirl1/status/1335...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{1.324794194448257e+18}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1583 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   link  count  n_users  \\\n",
       "0          https://www.sinembargo.mx/13-12-2020/3909331      2        2   \n",
       "1     https://twitter.com/SinEmbargoMX/status/133825...      1        1   \n",
       "2     https://twitter.com/MagazineSEMX/status/133826...      1        1   \n",
       "3                               https://www.change.org/     33       20   \n",
       "4     https://www.change.org/p/dc-entertainment-remo...     14       13   \n",
       "...                                                 ...    ...      ...   \n",
       "1578  https://www.dailymail.co.uk/news/article-89977...      1        1   \n",
       "1579  https://www.radiovanguardia.com/2020/12/06/amb...      1        1   \n",
       "1580  https://twitter.com/rvanguardia/status/1335660...      1        1   \n",
       "1581  https://www.reddit.com/r/memes/comments/k5ao7x...      1        1   \n",
       "1582  https://twitter.com/BraveMoonGirl1/status/1335...      1        1   \n",
       "\n",
       "                                                  users n_urls  \n",
       "0                            {244218738.0, 415155226.0}    {2}  \n",
       "1                                         {244218738.0}    {2}  \n",
       "2                                         {415155226.0}    {2}  \n",
       "3     {1.2525096682216284e+18, 1.2850933833256673e+1...    {2}  \n",
       "4     {1.182426890956464e+18, 1.2850933833256673e+18...    {2}  \n",
       "...                                                 ...    ...  \n",
       "1578                           {1.3233480042801605e+18}    {2}  \n",
       "1579                                      {111018390.0}    {2}  \n",
       "1580                                      {111018390.0}    {2}  \n",
       "1581                            {1.324794194448257e+18}    {2}  \n",
       "1582                            {1.324794194448257e+18}    {2}  \n",
       "\n",
       "[1583 rows x 5 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_dec_urls_more_with_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "30214cbe",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_with_users_count = pd.concat(\n",
    "    [df_tweets_dec_urls_with_users_count, df_tweets_dec_urls_more_with_users_count]\n",
    ").sort_values(\"count\", ascending=False).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "7dba040b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_dec_urls_with_users_count.to_csv(\n",
    "    \"URLs_Data/Twitter/\" + \"df_tweets_dec_urls_with_users_count.csv\", index=False\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "57b27a9b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6a5f92b4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "6f41b5f6",
   "metadata": {},
   "source": [
    "### 4 Months\n",
    "<a id='12'></a>\n",
    "\n",
    "\n",
    "><ul>\n",
    " <li><a href=\"#one12\">One Link</a></li>\n",
    " <li><a href=\"#more12\">More Than One Link</a></li>  \n",
    "\n",
    " </ul>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "c26ba0ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls = pd.read_csv(twitter_path + \"df_tweets_4_months_urls.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "b838e72f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_one = df_tweets_4_months_urls[df_tweets_4_months_urls.n_urls == 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "41f268fe",
   "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>id_str</th>\n",
       "      <th>created_at</th>\n",
       "      <th>full_text</th>\n",
       "      <th>lang</th>\n",
       "      <th>in_reply_to_status_id_str</th>\n",
       "      <th>in_reply_to_user_id</th>\n",
       "      <th>entities.hashtags</th>\n",
       "      <th>entities.media</th>\n",
       "      <th>entities.symbols</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>...</th>\n",
       "      <th>user.name</th>\n",
       "      <th>user.screen_name</th>\n",
       "      <th>user.profile_banner_url</th>\n",
       "      <th>user.profile_image_url</th>\n",
       "      <th>user.statuses_count</th>\n",
       "      <th>user.url</th>\n",
       "      <th>user.verified</th>\n",
       "      <th>short_urls</th>\n",
       "      <th>n_urls</th>\n",
       "      <th>urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1345358697959047168</td>\n",
       "      <td>2021-01-02 13:18:03+00:00</td>\n",
       "      <td>@_missyc97_ 2021 to Amber Heard.😂 https://t.co...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.345358e+18</td>\n",
       "      <td>1.083787e+18</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 296, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Liono</td>\n",
       "      <td>f_liono</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/12438150...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1384133945...</td>\n",
       "      <td>28996.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/5djnLz36zv']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://twitter.com/f_liono/status/134535869...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1345357307115307009</td>\n",
       "      <td>2021-01-02 13:12:32+00:00</td>\n",
       "      <td>When Amber Heard is in the mood but her mortal...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 548, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>frank drebin</td>\n",
       "      <td>danblock4</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/71012719...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1261067409...</td>\n",
       "      <td>3976.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/MYFspp5yLA']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://twitter.com/danblock4/status/1345357...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1345357193709826052</td>\n",
       "      <td>2021-01-02 13:12:05+00:00</td>\n",
       "      <td>@kathygriffin These didn’t age well. Oh Kathy ...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.114829e+07</td>\n",
       "      <td>[{'indices': [46, 86], 'text': 'WomenSupportin...</td>\n",
       "      <td>[{'original_info': {'width': 750, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Jacke</td>\n",
       "      <td>MsDizzyGillespi</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/18912893...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1341369245...</td>\n",
       "      <td>11003.0</td>\n",
       "      <td>http://t.co/3lEGt9dix4</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/nrcetCauxr']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://twitter.com/MsDizzyGillespi/status/1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1345356222191591424</td>\n",
       "      <td>2021-01-02 13:08:13+00:00</td>\n",
       "      <td>Amores, hoje vai rolar mais uma #DeppMovieNigh...</td>\n",
       "      <td>pt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [32, 47], 'text': 'DeppMovieNight...</td>\n",
       "      <td>[{'original_info': {'width': 1280, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Princess Consuela Bananahammock</td>\n",
       "      <td>PrinConsuella_</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/98724083...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1379816511...</td>\n",
       "      <td>30153.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/0Byxh0wpBr']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://twitter.com/PrinConsuella_/status/13...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1345354652930494465</td>\n",
       "      <td>2021-01-02 13:01:59+00:00</td>\n",
       "      <td>Buenos días 🌞 \\n\\n#JohnnyDepp \\n#JusticeForJoh...</td>\n",
       "      <td>es</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [16, 27], 'text': 'JohnnyDepp'}, ...</td>\n",
       "      <td>[{'original_info': {'width': 682, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Johnny Depp Uruguay 🇺🇾</td>\n",
       "      <td>DeppUruguay</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/13355872...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1387060061...</td>\n",
       "      <td>1302.0</td>\n",
       "      <td>https://t.co/o4CeiJw6BO</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/YFGIgE3xoJ']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://twitter.com/DeppUruguay/status/13453...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62949</th>\n",
       "      <td>1379904862549381120</td>\n",
       "      <td>2021-04-07 21:12:11+00:00</td>\n",
       "      <td>💜#PositivityForJohnnyDepp #LoveProtectSupportJ...</td>\n",
       "      <td>und</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [1, 25], 'text': 'PositivityForJo...</td>\n",
       "      <td>[{'original_info': {'width': 828, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>💜Jayne B Waldmignon💜🏴‍☠️🇬🇧</td>\n",
       "      <td>jayneb68910675</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/12777026...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1379803963...</td>\n",
       "      <td>2321.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/nlRDSBpRpk']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://twitter.com/jayneb68910675/status/13...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62950</th>\n",
       "      <td>1379904853770657802</td>\n",
       "      <td>2021-04-07 21:12:09+00:00</td>\n",
       "      <td>I just went on a blocking rampage through the ...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [174, 195], 'text': 'JusticeForJo...</td>\n",
       "      <td>[{'original_info': {'width': 500, 'height': 31...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Montse 🏳️‍🌈</td>\n",
       "      <td>montselech</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/16108340...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1380282251...</td>\n",
       "      <td>3823.0</td>\n",
       "      <td>https://t.co/IpyGgJY4aw</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/gRF8FDriMC']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://twitter.com/montselech/status/137990...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62951</th>\n",
       "      <td>1379904292358914050</td>\n",
       "      <td>2021-04-07 21:09:55+00:00</td>\n",
       "      <td>Judge finds Amber Heard GUILTY of LYING, FRAUD...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [164, 179], 'text': 'FireAmberHea...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'youtu.be/waXKykBTrQI', 'indi...</td>\n",
       "      <td>...</td>\n",
       "      <td>DoubleR3</td>\n",
       "      <td>DoubleR310</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/38204428...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/6499246169...</td>\n",
       "      <td>405.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/UIDQw7a4c2']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://www.youtube.com/watch?v=waXKykBTrQI&amp;...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62952</th>\n",
       "      <td>1379903624248188932</td>\n",
       "      <td>2021-04-07 21:07:16+00:00</td>\n",
       "      <td>💜💜 “I had a lovely time working with Johnny De...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [98, 122], 'text': 'PositivityFor...</td>\n",
       "      <td>[{'original_info': {'width': 1427, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>💜Jayne B Waldmignon💜🏴‍☠️🇬🇧</td>\n",
       "      <td>jayneb68910675</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/12777026...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1379803963...</td>\n",
       "      <td>2321.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/NI5aXL1X7R']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://twitter.com/jayneb68910675/status/13...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62953</th>\n",
       "      <td>1379903143274803204</td>\n",
       "      <td>2021-04-07 21:05:21+00:00</td>\n",
       "      <td>How quickly I changed my tune when I realized ...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.379903e+18</td>\n",
       "      <td>1.482895e+07</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'twitter.com/Astartiel/stat…'...</td>\n",
       "      <td>...</td>\n",
       "      <td>Jᴇɴɴɪᴇ Asᴛᴀʀᴛɪᴇʟ Isʜᴛᴀʀ Asᴇᴛ Iɴᴀɴɴᴀ Mᴏʀɴɪɴɢsᴛᴀʀ 🎶</td>\n",
       "      <td>Astartiel</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/14828950...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1385454858...</td>\n",
       "      <td>429036.0</td>\n",
       "      <td>https://t.co/x5kKCLYbYy</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/GOOQGL79GP']</td>\n",
       "      <td>1</td>\n",
       "      <td>['https://twitter.com/Astartiel/status/1379898...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62954 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id_str                 created_at  \\\n",
       "0      1345358697959047168  2021-01-02 13:18:03+00:00   \n",
       "1      1345357307115307009  2021-01-02 13:12:32+00:00   \n",
       "2      1345357193709826052  2021-01-02 13:12:05+00:00   \n",
       "3      1345356222191591424  2021-01-02 13:08:13+00:00   \n",
       "4      1345354652930494465  2021-01-02 13:01:59+00:00   \n",
       "...                    ...                        ...   \n",
       "62949  1379904862549381120  2021-04-07 21:12:11+00:00   \n",
       "62950  1379904853770657802  2021-04-07 21:12:09+00:00   \n",
       "62951  1379904292358914050  2021-04-07 21:09:55+00:00   \n",
       "62952  1379903624248188932  2021-04-07 21:07:16+00:00   \n",
       "62953  1379903143274803204  2021-04-07 21:05:21+00:00   \n",
       "\n",
       "                                               full_text lang  \\\n",
       "0      @_missyc97_ 2021 to Amber Heard.😂 https://t.co...   en   \n",
       "1      When Amber Heard is in the mood but her mortal...   en   \n",
       "2      @kathygriffin These didn’t age well. Oh Kathy ...   en   \n",
       "3      Amores, hoje vai rolar mais uma #DeppMovieNigh...   pt   \n",
       "4      Buenos días 🌞 \\n\\n#JohnnyDepp \\n#JusticeForJoh...   es   \n",
       "...                                                  ...  ...   \n",
       "62949  💜#PositivityForJohnnyDepp #LoveProtectSupportJ...  und   \n",
       "62950  I just went on a blocking rampage through the ...   en   \n",
       "62951  Judge finds Amber Heard GUILTY of LYING, FRAUD...   en   \n",
       "62952  💜💜 “I had a lovely time working with Johnny De...   en   \n",
       "62953  How quickly I changed my tune when I realized ...   en   \n",
       "\n",
       "       in_reply_to_status_id_str  in_reply_to_user_id  \\\n",
       "0                   1.345358e+18         1.083787e+18   \n",
       "1                            NaN                  NaN   \n",
       "2                            NaN         2.114829e+07   \n",
       "3                            NaN                  NaN   \n",
       "4                            NaN                  NaN   \n",
       "...                          ...                  ...   \n",
       "62949                        NaN                  NaN   \n",
       "62950                        NaN                  NaN   \n",
       "62951                        NaN                  NaN   \n",
       "62952                        NaN                  NaN   \n",
       "62953               1.379903e+18         1.482895e+07   \n",
       "\n",
       "                                       entities.hashtags  \\\n",
       "0                                                     []   \n",
       "1                                                     []   \n",
       "2      [{'indices': [46, 86], 'text': 'WomenSupportin...   \n",
       "3      [{'indices': [32, 47], 'text': 'DeppMovieNight...   \n",
       "4      [{'indices': [16, 27], 'text': 'JohnnyDepp'}, ...   \n",
       "...                                                  ...   \n",
       "62949  [{'indices': [1, 25], 'text': 'PositivityForJo...   \n",
       "62950  [{'indices': [174, 195], 'text': 'JusticeForJo...   \n",
       "62951  [{'indices': [164, 179], 'text': 'FireAmberHea...   \n",
       "62952  [{'indices': [98, 122], 'text': 'PositivityFor...   \n",
       "62953                                                 []   \n",
       "\n",
       "                                          entities.media entities.symbols  \\\n",
       "0      [{'original_info': {'width': 296, 'focus_rects...               []   \n",
       "1      [{'original_info': {'width': 548, 'focus_rects...               []   \n",
       "2      [{'original_info': {'width': 750, 'focus_rects...               []   \n",
       "3      [{'original_info': {'width': 1280, 'focus_rect...               []   \n",
       "4      [{'original_info': {'width': 682, 'focus_rects...               []   \n",
       "...                                                  ...              ...   \n",
       "62949  [{'original_info': {'width': 828, 'focus_rects...               []   \n",
       "62950  [{'original_info': {'width': 500, 'height': 31...               []   \n",
       "62951                                                NaN               []   \n",
       "62952  [{'original_info': {'width': 1427, 'focus_rect...               []   \n",
       "62953                                                NaN               []   \n",
       "\n",
       "                                           entities.urls  ...  \\\n",
       "0                                                     []  ...   \n",
       "1                                                     []  ...   \n",
       "2                                                     []  ...   \n",
       "3                                                     []  ...   \n",
       "4                                                     []  ...   \n",
       "...                                                  ...  ...   \n",
       "62949                                                 []  ...   \n",
       "62950                                                 []  ...   \n",
       "62951  [{'display_url': 'youtu.be/waXKykBTrQI', 'indi...  ...   \n",
       "62952                                                 []  ...   \n",
       "62953  [{'display_url': 'twitter.com/Astartiel/stat…'...  ...   \n",
       "\n",
       "                                               user.name user.screen_name  \\\n",
       "0                                                  Liono          f_liono   \n",
       "1                                           frank drebin        danblock4   \n",
       "2                                                  Jacke  MsDizzyGillespi   \n",
       "3                        Princess Consuela Bananahammock   PrinConsuella_   \n",
       "4                                 Johnny Depp Uruguay 🇺🇾      DeppUruguay   \n",
       "...                                                  ...              ...   \n",
       "62949                         💜Jayne B Waldmignon💜🏴‍☠️🇬🇧   jayneb68910675   \n",
       "62950                                        Montse 🏳️‍🌈       montselech   \n",
       "62951                                           DoubleR3       DoubleR310   \n",
       "62952                         💜Jayne B Waldmignon💜🏴‍☠️🇬🇧   jayneb68910675   \n",
       "62953  Jᴇɴɴɪᴇ Asᴛᴀʀᴛɪᴇʟ Isʜᴛᴀʀ Asᴇᴛ Iɴᴀɴɴᴀ Mᴏʀɴɪɴɢsᴛᴀʀ 🎶        Astartiel   \n",
       "\n",
       "                                 user.profile_banner_url  \\\n",
       "0      https://pbs.twimg.com/profile_banners/12438150...   \n",
       "1      https://pbs.twimg.com/profile_banners/71012719...   \n",
       "2      https://pbs.twimg.com/profile_banners/18912893...   \n",
       "3      https://pbs.twimg.com/profile_banners/98724083...   \n",
       "4      https://pbs.twimg.com/profile_banners/13355872...   \n",
       "...                                                  ...   \n",
       "62949  https://pbs.twimg.com/profile_banners/12777026...   \n",
       "62950  https://pbs.twimg.com/profile_banners/16108340...   \n",
       "62951  https://pbs.twimg.com/profile_banners/38204428...   \n",
       "62952  https://pbs.twimg.com/profile_banners/12777026...   \n",
       "62953  https://pbs.twimg.com/profile_banners/14828950...   \n",
       "\n",
       "                                  user.profile_image_url user.statuses_count  \\\n",
       "0      http://pbs.twimg.com/profile_images/1384133945...             28996.0   \n",
       "1      http://pbs.twimg.com/profile_images/1261067409...              3976.0   \n",
       "2      http://pbs.twimg.com/profile_images/1341369245...             11003.0   \n",
       "3      http://pbs.twimg.com/profile_images/1379816511...             30153.0   \n",
       "4      http://pbs.twimg.com/profile_images/1387060061...              1302.0   \n",
       "...                                                  ...                 ...   \n",
       "62949  http://pbs.twimg.com/profile_images/1379803963...              2321.0   \n",
       "62950  http://pbs.twimg.com/profile_images/1380282251...              3823.0   \n",
       "62951  http://pbs.twimg.com/profile_images/6499246169...               405.0   \n",
       "62952  http://pbs.twimg.com/profile_images/1379803963...              2321.0   \n",
       "62953  http://pbs.twimg.com/profile_images/1385454858...            429036.0   \n",
       "\n",
       "                      user.url  user.verified                   short_urls  \\\n",
       "0                          NaN          False  ['https://t.co/5djnLz36zv']   \n",
       "1                          NaN          False  ['https://t.co/MYFspp5yLA']   \n",
       "2       http://t.co/3lEGt9dix4          False  ['https://t.co/nrcetCauxr']   \n",
       "3                          NaN          False  ['https://t.co/0Byxh0wpBr']   \n",
       "4      https://t.co/o4CeiJw6BO          False  ['https://t.co/YFGIgE3xoJ']   \n",
       "...                        ...            ...                          ...   \n",
       "62949                      NaN          False  ['https://t.co/nlRDSBpRpk']   \n",
       "62950  https://t.co/IpyGgJY4aw          False  ['https://t.co/gRF8FDriMC']   \n",
       "62951                      NaN          False  ['https://t.co/UIDQw7a4c2']   \n",
       "62952                      NaN          False  ['https://t.co/NI5aXL1X7R']   \n",
       "62953  https://t.co/x5kKCLYbYy          False  ['https://t.co/GOOQGL79GP']   \n",
       "\n",
       "      n_urls                                               urls  \n",
       "0          1  ['https://twitter.com/f_liono/status/134535869...  \n",
       "1          1  ['https://twitter.com/danblock4/status/1345357...  \n",
       "2          1  ['https://twitter.com/MsDizzyGillespi/status/1...  \n",
       "3          1  ['https://twitter.com/PrinConsuella_/status/13...  \n",
       "4          1  ['https://twitter.com/DeppUruguay/status/13453...  \n",
       "...      ...                                                ...  \n",
       "62949      1  ['https://twitter.com/jayneb68910675/status/13...  \n",
       "62950      1  ['https://twitter.com/montselech/status/137990...  \n",
       "62951      1  ['https://www.youtube.com/watch?v=waXKykBTrQI&...  \n",
       "62952      1  ['https://twitter.com/jayneb68910675/status/13...  \n",
       "62953      1  ['https://twitter.com/Astartiel/status/1379898...  \n",
       "\n",
       "[62954 rows x 42 columns]"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_4_months_urls_one"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "78dabfa8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_one.rename(\n",
    "    columns={ \"urls\": \"url\"}, inplace=True\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "86aea30f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_one[\"url\"] = df_tweets_4_months_urls_one[\"url\"].apply(\n",
    "    lambda x: x[2:-2]\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "29e26231",
   "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>id_str</th>\n",
       "      <th>created_at</th>\n",
       "      <th>full_text</th>\n",
       "      <th>lang</th>\n",
       "      <th>in_reply_to_status_id_str</th>\n",
       "      <th>in_reply_to_user_id</th>\n",
       "      <th>entities.hashtags</th>\n",
       "      <th>entities.media</th>\n",
       "      <th>entities.symbols</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>...</th>\n",
       "      <th>user.name</th>\n",
       "      <th>user.screen_name</th>\n",
       "      <th>user.profile_banner_url</th>\n",
       "      <th>user.profile_image_url</th>\n",
       "      <th>user.statuses_count</th>\n",
       "      <th>user.url</th>\n",
       "      <th>user.verified</th>\n",
       "      <th>short_urls</th>\n",
       "      <th>n_urls</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1345358697959047168</td>\n",
       "      <td>2021-01-02 13:18:03+00:00</td>\n",
       "      <td>@_missyc97_ 2021 to Amber Heard.😂 https://t.co...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.345358e+18</td>\n",
       "      <td>1.083787e+18</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 296, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Liono</td>\n",
       "      <td>f_liono</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/12438150...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1384133945...</td>\n",
       "      <td>28996.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/5djnLz36zv']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/f_liono/status/13453586979...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1345357307115307009</td>\n",
       "      <td>2021-01-02 13:12:32+00:00</td>\n",
       "      <td>When Amber Heard is in the mood but her mortal...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 548, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>frank drebin</td>\n",
       "      <td>danblock4</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/71012719...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1261067409...</td>\n",
       "      <td>3976.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/MYFspp5yLA']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/danblock4/status/134535730...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1345357193709826052</td>\n",
       "      <td>2021-01-02 13:12:05+00:00</td>\n",
       "      <td>@kathygriffin These didn’t age well. Oh Kathy ...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.114829e+07</td>\n",
       "      <td>[{'indices': [46, 86], 'text': 'WomenSupportin...</td>\n",
       "      <td>[{'original_info': {'width': 750, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Jacke</td>\n",
       "      <td>MsDizzyGillespi</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/18912893...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1341369245...</td>\n",
       "      <td>11003.0</td>\n",
       "      <td>http://t.co/3lEGt9dix4</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/nrcetCauxr']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/MsDizzyGillespi/status/134...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1345356222191591424</td>\n",
       "      <td>2021-01-02 13:08:13+00:00</td>\n",
       "      <td>Amores, hoje vai rolar mais uma #DeppMovieNigh...</td>\n",
       "      <td>pt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [32, 47], 'text': 'DeppMovieNight...</td>\n",
       "      <td>[{'original_info': {'width': 1280, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Princess Consuela Bananahammock</td>\n",
       "      <td>PrinConsuella_</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/98724083...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1379816511...</td>\n",
       "      <td>30153.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/0Byxh0wpBr']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/PrinConsuella_/status/1345...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1345354652930494465</td>\n",
       "      <td>2021-01-02 13:01:59+00:00</td>\n",
       "      <td>Buenos días 🌞 \\n\\n#JohnnyDepp \\n#JusticeForJoh...</td>\n",
       "      <td>es</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [16, 27], 'text': 'JohnnyDepp'}, ...</td>\n",
       "      <td>[{'original_info': {'width': 682, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Johnny Depp Uruguay 🇺🇾</td>\n",
       "      <td>DeppUruguay</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/13355872...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1387060061...</td>\n",
       "      <td>1302.0</td>\n",
       "      <td>https://t.co/o4CeiJw6BO</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/YFGIgE3xoJ']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/DeppUruguay/status/1345354...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62949</th>\n",
       "      <td>1379904862549381120</td>\n",
       "      <td>2021-04-07 21:12:11+00:00</td>\n",
       "      <td>💜#PositivityForJohnnyDepp #LoveProtectSupportJ...</td>\n",
       "      <td>und</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [1, 25], 'text': 'PositivityForJo...</td>\n",
       "      <td>[{'original_info': {'width': 828, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>💜Jayne B Waldmignon💜🏴‍☠️🇬🇧</td>\n",
       "      <td>jayneb68910675</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/12777026...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1379803963...</td>\n",
       "      <td>2321.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/nlRDSBpRpk']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/jayneb68910675/status/1379...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62950</th>\n",
       "      <td>1379904853770657802</td>\n",
       "      <td>2021-04-07 21:12:09+00:00</td>\n",
       "      <td>I just went on a blocking rampage through the ...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [174, 195], 'text': 'JusticeForJo...</td>\n",
       "      <td>[{'original_info': {'width': 500, 'height': 31...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>Montse 🏳️‍🌈</td>\n",
       "      <td>montselech</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/16108340...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1380282251...</td>\n",
       "      <td>3823.0</td>\n",
       "      <td>https://t.co/IpyGgJY4aw</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/gRF8FDriMC']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/montselech/status/13799048...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62951</th>\n",
       "      <td>1379904292358914050</td>\n",
       "      <td>2021-04-07 21:09:55+00:00</td>\n",
       "      <td>Judge finds Amber Heard GUILTY of LYING, FRAUD...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [164, 179], 'text': 'FireAmberHea...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'youtu.be/waXKykBTrQI', 'indi...</td>\n",
       "      <td>...</td>\n",
       "      <td>DoubleR3</td>\n",
       "      <td>DoubleR310</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/38204428...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/6499246169...</td>\n",
       "      <td>405.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/UIDQw7a4c2']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://www.youtube.com/watch?v=waXKykBTrQI&amp;fe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62952</th>\n",
       "      <td>1379903624248188932</td>\n",
       "      <td>2021-04-07 21:07:16+00:00</td>\n",
       "      <td>💜💜 “I had a lovely time working with Johnny De...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [98, 122], 'text': 'PositivityFor...</td>\n",
       "      <td>[{'original_info': {'width': 1427, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>...</td>\n",
       "      <td>💜Jayne B Waldmignon💜🏴‍☠️🇬🇧</td>\n",
       "      <td>jayneb68910675</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/12777026...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1379803963...</td>\n",
       "      <td>2321.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/NI5aXL1X7R']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/jayneb68910675/status/1379...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62953</th>\n",
       "      <td>1379903143274803204</td>\n",
       "      <td>2021-04-07 21:05:21+00:00</td>\n",
       "      <td>How quickly I changed my tune when I realized ...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.379903e+18</td>\n",
       "      <td>1.482895e+07</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'twitter.com/Astartiel/stat…'...</td>\n",
       "      <td>...</td>\n",
       "      <td>Jᴇɴɴɪᴇ Asᴛᴀʀᴛɪᴇʟ Isʜᴛᴀʀ Asᴇᴛ Iɴᴀɴɴᴀ Mᴏʀɴɪɴɢsᴛᴀʀ 🎶</td>\n",
       "      <td>Astartiel</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/14828950...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1385454858...</td>\n",
       "      <td>429036.0</td>\n",
       "      <td>https://t.co/x5kKCLYbYy</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/GOOQGL79GP']</td>\n",
       "      <td>1</td>\n",
       "      <td>https://twitter.com/Astartiel/status/137989817...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62954 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id_str                 created_at  \\\n",
       "0      1345358697959047168  2021-01-02 13:18:03+00:00   \n",
       "1      1345357307115307009  2021-01-02 13:12:32+00:00   \n",
       "2      1345357193709826052  2021-01-02 13:12:05+00:00   \n",
       "3      1345356222191591424  2021-01-02 13:08:13+00:00   \n",
       "4      1345354652930494465  2021-01-02 13:01:59+00:00   \n",
       "...                    ...                        ...   \n",
       "62949  1379904862549381120  2021-04-07 21:12:11+00:00   \n",
       "62950  1379904853770657802  2021-04-07 21:12:09+00:00   \n",
       "62951  1379904292358914050  2021-04-07 21:09:55+00:00   \n",
       "62952  1379903624248188932  2021-04-07 21:07:16+00:00   \n",
       "62953  1379903143274803204  2021-04-07 21:05:21+00:00   \n",
       "\n",
       "                                               full_text lang  \\\n",
       "0      @_missyc97_ 2021 to Amber Heard.😂 https://t.co...   en   \n",
       "1      When Amber Heard is in the mood but her mortal...   en   \n",
       "2      @kathygriffin These didn’t age well. Oh Kathy ...   en   \n",
       "3      Amores, hoje vai rolar mais uma #DeppMovieNigh...   pt   \n",
       "4      Buenos días 🌞 \\n\\n#JohnnyDepp \\n#JusticeForJoh...   es   \n",
       "...                                                  ...  ...   \n",
       "62949  💜#PositivityForJohnnyDepp #LoveProtectSupportJ...  und   \n",
       "62950  I just went on a blocking rampage through the ...   en   \n",
       "62951  Judge finds Amber Heard GUILTY of LYING, FRAUD...   en   \n",
       "62952  💜💜 “I had a lovely time working with Johnny De...   en   \n",
       "62953  How quickly I changed my tune when I realized ...   en   \n",
       "\n",
       "       in_reply_to_status_id_str  in_reply_to_user_id  \\\n",
       "0                   1.345358e+18         1.083787e+18   \n",
       "1                            NaN                  NaN   \n",
       "2                            NaN         2.114829e+07   \n",
       "3                            NaN                  NaN   \n",
       "4                            NaN                  NaN   \n",
       "...                          ...                  ...   \n",
       "62949                        NaN                  NaN   \n",
       "62950                        NaN                  NaN   \n",
       "62951                        NaN                  NaN   \n",
       "62952                        NaN                  NaN   \n",
       "62953               1.379903e+18         1.482895e+07   \n",
       "\n",
       "                                       entities.hashtags  \\\n",
       "0                                                     []   \n",
       "1                                                     []   \n",
       "2      [{'indices': [46, 86], 'text': 'WomenSupportin...   \n",
       "3      [{'indices': [32, 47], 'text': 'DeppMovieNight...   \n",
       "4      [{'indices': [16, 27], 'text': 'JohnnyDepp'}, ...   \n",
       "...                                                  ...   \n",
       "62949  [{'indices': [1, 25], 'text': 'PositivityForJo...   \n",
       "62950  [{'indices': [174, 195], 'text': 'JusticeForJo...   \n",
       "62951  [{'indices': [164, 179], 'text': 'FireAmberHea...   \n",
       "62952  [{'indices': [98, 122], 'text': 'PositivityFor...   \n",
       "62953                                                 []   \n",
       "\n",
       "                                          entities.media entities.symbols  \\\n",
       "0      [{'original_info': {'width': 296, 'focus_rects...               []   \n",
       "1      [{'original_info': {'width': 548, 'focus_rects...               []   \n",
       "2      [{'original_info': {'width': 750, 'focus_rects...               []   \n",
       "3      [{'original_info': {'width': 1280, 'focus_rect...               []   \n",
       "4      [{'original_info': {'width': 682, 'focus_rects...               []   \n",
       "...                                                  ...              ...   \n",
       "62949  [{'original_info': {'width': 828, 'focus_rects...               []   \n",
       "62950  [{'original_info': {'width': 500, 'height': 31...               []   \n",
       "62951                                                NaN               []   \n",
       "62952  [{'original_info': {'width': 1427, 'focus_rect...               []   \n",
       "62953                                                NaN               []   \n",
       "\n",
       "                                           entities.urls  ...  \\\n",
       "0                                                     []  ...   \n",
       "1                                                     []  ...   \n",
       "2                                                     []  ...   \n",
       "3                                                     []  ...   \n",
       "4                                                     []  ...   \n",
       "...                                                  ...  ...   \n",
       "62949                                                 []  ...   \n",
       "62950                                                 []  ...   \n",
       "62951  [{'display_url': 'youtu.be/waXKykBTrQI', 'indi...  ...   \n",
       "62952                                                 []  ...   \n",
       "62953  [{'display_url': 'twitter.com/Astartiel/stat…'...  ...   \n",
       "\n",
       "                                               user.name user.screen_name  \\\n",
       "0                                                  Liono          f_liono   \n",
       "1                                           frank drebin        danblock4   \n",
       "2                                                  Jacke  MsDizzyGillespi   \n",
       "3                        Princess Consuela Bananahammock   PrinConsuella_   \n",
       "4                                 Johnny Depp Uruguay 🇺🇾      DeppUruguay   \n",
       "...                                                  ...              ...   \n",
       "62949                         💜Jayne B Waldmignon💜🏴‍☠️🇬🇧   jayneb68910675   \n",
       "62950                                        Montse 🏳️‍🌈       montselech   \n",
       "62951                                           DoubleR3       DoubleR310   \n",
       "62952                         💜Jayne B Waldmignon💜🏴‍☠️🇬🇧   jayneb68910675   \n",
       "62953  Jᴇɴɴɪᴇ Asᴛᴀʀᴛɪᴇʟ Isʜᴛᴀʀ Asᴇᴛ Iɴᴀɴɴᴀ Mᴏʀɴɪɴɢsᴛᴀʀ 🎶        Astartiel   \n",
       "\n",
       "                                 user.profile_banner_url  \\\n",
       "0      https://pbs.twimg.com/profile_banners/12438150...   \n",
       "1      https://pbs.twimg.com/profile_banners/71012719...   \n",
       "2      https://pbs.twimg.com/profile_banners/18912893...   \n",
       "3      https://pbs.twimg.com/profile_banners/98724083...   \n",
       "4      https://pbs.twimg.com/profile_banners/13355872...   \n",
       "...                                                  ...   \n",
       "62949  https://pbs.twimg.com/profile_banners/12777026...   \n",
       "62950  https://pbs.twimg.com/profile_banners/16108340...   \n",
       "62951  https://pbs.twimg.com/profile_banners/38204428...   \n",
       "62952  https://pbs.twimg.com/profile_banners/12777026...   \n",
       "62953  https://pbs.twimg.com/profile_banners/14828950...   \n",
       "\n",
       "                                  user.profile_image_url user.statuses_count  \\\n",
       "0      http://pbs.twimg.com/profile_images/1384133945...             28996.0   \n",
       "1      http://pbs.twimg.com/profile_images/1261067409...              3976.0   \n",
       "2      http://pbs.twimg.com/profile_images/1341369245...             11003.0   \n",
       "3      http://pbs.twimg.com/profile_images/1379816511...             30153.0   \n",
       "4      http://pbs.twimg.com/profile_images/1387060061...              1302.0   \n",
       "...                                                  ...                 ...   \n",
       "62949  http://pbs.twimg.com/profile_images/1379803963...              2321.0   \n",
       "62950  http://pbs.twimg.com/profile_images/1380282251...              3823.0   \n",
       "62951  http://pbs.twimg.com/profile_images/6499246169...               405.0   \n",
       "62952  http://pbs.twimg.com/profile_images/1379803963...              2321.0   \n",
       "62953  http://pbs.twimg.com/profile_images/1385454858...            429036.0   \n",
       "\n",
       "                      user.url  user.verified                   short_urls  \\\n",
       "0                          NaN          False  ['https://t.co/5djnLz36zv']   \n",
       "1                          NaN          False  ['https://t.co/MYFspp5yLA']   \n",
       "2       http://t.co/3lEGt9dix4          False  ['https://t.co/nrcetCauxr']   \n",
       "3                          NaN          False  ['https://t.co/0Byxh0wpBr']   \n",
       "4      https://t.co/o4CeiJw6BO          False  ['https://t.co/YFGIgE3xoJ']   \n",
       "...                        ...            ...                          ...   \n",
       "62949                      NaN          False  ['https://t.co/nlRDSBpRpk']   \n",
       "62950  https://t.co/IpyGgJY4aw          False  ['https://t.co/gRF8FDriMC']   \n",
       "62951                      NaN          False  ['https://t.co/UIDQw7a4c2']   \n",
       "62952                      NaN          False  ['https://t.co/NI5aXL1X7R']   \n",
       "62953  https://t.co/x5kKCLYbYy          False  ['https://t.co/GOOQGL79GP']   \n",
       "\n",
       "      n_urls                                                url  \n",
       "0          1  https://twitter.com/f_liono/status/13453586979...  \n",
       "1          1  https://twitter.com/danblock4/status/134535730...  \n",
       "2          1  https://twitter.com/MsDizzyGillespi/status/134...  \n",
       "3          1  https://twitter.com/PrinConsuella_/status/1345...  \n",
       "4          1  https://twitter.com/DeppUruguay/status/1345354...  \n",
       "...      ...                                                ...  \n",
       "62949      1  https://twitter.com/jayneb68910675/status/1379...  \n",
       "62950      1  https://twitter.com/montselech/status/13799048...  \n",
       "62951      1  https://www.youtube.com/watch?v=waXKykBTrQI&fe...  \n",
       "62952      1  https://twitter.com/jayneb68910675/status/1379...  \n",
       "62953      1  https://twitter.com/Astartiel/status/137989817...  \n",
       "\n",
       "[62954 rows x 42 columns]"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_4_months_urls_one"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "a3dbe67c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_with_users_count = one_link_urls_with_count_(df_tweets_4_months_urls_one, \"user.id_str\", \"url\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "e203f63d",
   "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>link</th>\n",
       "      <th>count</th>\n",
       "      <th>n_users</th>\n",
       "      <th>users</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-94749...</td>\n",
       "      <td>234</td>\n",
       "      <td>192</td>\n",
       "      <td>(1.355610488391e+18, 7.445623713063977e+17, 1....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://insidethemagic.net/2021/04/justiceforj...</td>\n",
       "      <td>93</td>\n",
       "      <td>91</td>\n",
       "      <td>(1.3248298810630226e+18, 31155713.0, 1.3549834...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-91189...</td>\n",
       "      <td>77</td>\n",
       "      <td>64</td>\n",
       "      <td>(1.1968158989816054e+18, 1.285571857584984e+18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.youtube.com/watch?v=3R_emk-Fzh8&amp;fe...</td>\n",
       "      <td>72</td>\n",
       "      <td>63</td>\n",
       "      <td>(1.280435057925206e+18, 1.3250679941590794e+18...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-94749...</td>\n",
       "      <td>80</td>\n",
       "      <td>61</td>\n",
       "      <td>(1.2804332108543836e+18, 1.2401548263292027e+1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53079</th>\n",
       "      <td>https://twitter.com/1009REDkml/status/13610878...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.3248189829317304e+18,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53080</th>\n",
       "      <td>https://twitter.com/FMGiveMeTruth/status/13631...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.0204089576959058e+18,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53081</th>\n",
       "      <td>https://twitter.com/Platoon1979/status/1363135...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.2906385898067397e+18,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53082</th>\n",
       "      <td>https://twitter.com/Amaby14/status/13631308955...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.3401340418367652e+18,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53083</th>\n",
       "      <td>https://twitter.com/Astartiel/status/137989817...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(14828950.0,)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>53084 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    link  count  n_users  \\\n",
       "0      https://www.dailymail.co.uk/news/article-94749...    234      192   \n",
       "1      https://insidethemagic.net/2021/04/justiceforj...     93       91   \n",
       "2      https://www.dailymail.co.uk/news/article-91189...     77       64   \n",
       "3      https://www.youtube.com/watch?v=3R_emk-Fzh8&fe...     72       63   \n",
       "4      https://www.dailymail.co.uk/news/article-94749...     80       61   \n",
       "...                                                  ...    ...      ...   \n",
       "53079  https://twitter.com/1009REDkml/status/13610878...      1        1   \n",
       "53080  https://twitter.com/FMGiveMeTruth/status/13631...      1        1   \n",
       "53081  https://twitter.com/Platoon1979/status/1363135...      1        1   \n",
       "53082  https://twitter.com/Amaby14/status/13631308955...      1        1   \n",
       "53083  https://twitter.com/Astartiel/status/137989817...      1        1   \n",
       "\n",
       "                                                   users  \n",
       "0      (1.355610488391e+18, 7.445623713063977e+17, 1....  \n",
       "1      (1.3248298810630226e+18, 31155713.0, 1.3549834...  \n",
       "2      (1.1968158989816054e+18, 1.285571857584984e+18...  \n",
       "3      (1.280435057925206e+18, 1.3250679941590794e+18...  \n",
       "4      (1.2804332108543836e+18, 1.2401548263292027e+1...  \n",
       "...                                                  ...  \n",
       "53079                          (1.3248189829317304e+18,)  \n",
       "53080                          (1.0204089576959058e+18,)  \n",
       "53081                          (1.2906385898067397e+18,)  \n",
       "53082                          (1.3401340418367652e+18,)  \n",
       "53083                                      (14828950.0,)  \n",
       "\n",
       "[53084 rows x 4 columns]"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_4_months_urls_with_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "5daa92f0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_with_users_count[\"n_urls\"] = 1\n",
    "df_tweets_4_months_urls_with_users_count[\n",
    "    \"n_urls\"\n",
    "] = df_tweets_4_months_urls_with_users_count[\"n_urls\"].apply(lambda x: {x})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "277853f4",
   "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>link</th>\n",
       "      <th>count</th>\n",
       "      <th>n_users</th>\n",
       "      <th>users</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-94749...</td>\n",
       "      <td>234</td>\n",
       "      <td>192</td>\n",
       "      <td>(1.355610488391e+18, 7.445623713063977e+17, 1....</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://insidethemagic.net/2021/04/justiceforj...</td>\n",
       "      <td>93</td>\n",
       "      <td>91</td>\n",
       "      <td>(1.3248298810630226e+18, 31155713.0, 1.3549834...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-91189...</td>\n",
       "      <td>77</td>\n",
       "      <td>64</td>\n",
       "      <td>(1.1968158989816054e+18, 1.285571857584984e+18...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.youtube.com/watch?v=3R_emk-Fzh8&amp;fe...</td>\n",
       "      <td>72</td>\n",
       "      <td>63</td>\n",
       "      <td>(1.280435057925206e+18, 1.3250679941590794e+18...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-94749...</td>\n",
       "      <td>80</td>\n",
       "      <td>61</td>\n",
       "      <td>(1.2804332108543836e+18, 1.2401548263292027e+1...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53079</th>\n",
       "      <td>https://twitter.com/1009REDkml/status/13610878...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.3248189829317304e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53080</th>\n",
       "      <td>https://twitter.com/FMGiveMeTruth/status/13631...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.0204089576959058e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53081</th>\n",
       "      <td>https://twitter.com/Platoon1979/status/1363135...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.2906385898067397e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53082</th>\n",
       "      <td>https://twitter.com/Amaby14/status/13631308955...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.3401340418367652e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53083</th>\n",
       "      <td>https://twitter.com/Astartiel/status/137989817...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(14828950.0,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>53084 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    link  count  n_users  \\\n",
       "0      https://www.dailymail.co.uk/news/article-94749...    234      192   \n",
       "1      https://insidethemagic.net/2021/04/justiceforj...     93       91   \n",
       "2      https://www.dailymail.co.uk/news/article-91189...     77       64   \n",
       "3      https://www.youtube.com/watch?v=3R_emk-Fzh8&fe...     72       63   \n",
       "4      https://www.dailymail.co.uk/news/article-94749...     80       61   \n",
       "...                                                  ...    ...      ...   \n",
       "53079  https://twitter.com/1009REDkml/status/13610878...      1        1   \n",
       "53080  https://twitter.com/FMGiveMeTruth/status/13631...      1        1   \n",
       "53081  https://twitter.com/Platoon1979/status/1363135...      1        1   \n",
       "53082  https://twitter.com/Amaby14/status/13631308955...      1        1   \n",
       "53083  https://twitter.com/Astartiel/status/137989817...      1        1   \n",
       "\n",
       "                                                   users n_urls  \n",
       "0      (1.355610488391e+18, 7.445623713063977e+17, 1....    {1}  \n",
       "1      (1.3248298810630226e+18, 31155713.0, 1.3549834...    {1}  \n",
       "2      (1.1968158989816054e+18, 1.285571857584984e+18...    {1}  \n",
       "3      (1.280435057925206e+18, 1.3250679941590794e+18...    {1}  \n",
       "4      (1.2804332108543836e+18, 1.2401548263292027e+1...    {1}  \n",
       "...                                                  ...    ...  \n",
       "53079                          (1.3248189829317304e+18,)    {1}  \n",
       "53080                          (1.0204089576959058e+18,)    {1}  \n",
       "53081                          (1.2906385898067397e+18,)    {1}  \n",
       "53082                          (1.3401340418367652e+18,)    {1}  \n",
       "53083                                      (14828950.0,)    {1}  \n",
       "\n",
       "[53084 rows x 5 columns]"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_4_months_urls_with_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "392f34a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_more = df_tweets_4_months_urls[df_tweets_4_months_urls.n_urls > 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "2482f8cf",
   "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>id_str</th>\n",
       "      <th>created_at</th>\n",
       "      <th>full_text</th>\n",
       "      <th>lang</th>\n",
       "      <th>in_reply_to_status_id_str</th>\n",
       "      <th>in_reply_to_user_id</th>\n",
       "      <th>entities.hashtags</th>\n",
       "      <th>entities.media</th>\n",
       "      <th>entities.symbols</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>...</th>\n",
       "      <th>user.name</th>\n",
       "      <th>user.screen_name</th>\n",
       "      <th>user.profile_banner_url</th>\n",
       "      <th>user.profile_image_url</th>\n",
       "      <th>user.statuses_count</th>\n",
       "      <th>user.url</th>\n",
       "      <th>user.verified</th>\n",
       "      <th>short_urls</th>\n",
       "      <th>n_urls</th>\n",
       "      <th>urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>62954</th>\n",
       "      <td>1345233358889091074</td>\n",
       "      <td>2021-01-02 05:00:00+00:00</td>\n",
       "      <td>\"Just that JOHNNY DEPP IS INNOCENT \"\\n\\nTake t...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.340073e+18</td>\n",
       "      <td>1.338967e+18</td>\n",
       "      <td>[{'indices': [130, 151], 'text': 'JusticeForJo...</td>\n",
       "      <td>[{'original_info': {'width': 733, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'at-angys.de/jd/survey.html',...</td>\n",
       "      <td>...</td>\n",
       "      <td>JD's Supporters Survey 🏴‍☠️</td>\n",
       "      <td>JDsupportSurvey</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/13389670...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1380597112...</td>\n",
       "      <td>595.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/b0JfHT49Ax', 'https://t.co/4yk1...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://at-angys.de/jd/survey.html', 'https:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62955</th>\n",
       "      <td>1353271503526227968</td>\n",
       "      <td>2021-01-24 09:20:43+00:00</td>\n",
       "      <td>I have an Instagram for this account aswell bt...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [98, 109], 'text': 'johnnydepp'},...</td>\n",
       "      <td>[{'original_info': {'width': 1152, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'instagram.com/jdforeveruk', ...</td>\n",
       "      <td>...</td>\n",
       "      <td>Johnny Depp Forever 🖤</td>\n",
       "      <td>JDForeverUK</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/13305377...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1343145607...</td>\n",
       "      <td>1678.0</td>\n",
       "      <td>https://t.co/HsVNkUX82V</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/HsVNkUX82V', 'https://t.co/NAQZ...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.instagram.com/jdforeveruk', 'htt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62956</th>\n",
       "      <td>1353381685555990529</td>\n",
       "      <td>2021-01-24 16:38:33+00:00</td>\n",
       "      <td>¿Valentino Lanus y Amber Heard mantuvieron un ...</td>\n",
       "      <td>es</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 1280, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'dlvr.it/RrFH8w', 'indices': ...</td>\n",
       "      <td>...</td>\n",
       "      <td>Manu OS</td>\n",
       "      <td>janoboy</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/15400933...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1244451764...</td>\n",
       "      <td>160133.0</td>\n",
       "      <td>https://t.co/6G19lL5qB6</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/wLLqLpUQ2G', 'https://t.co/wg7c...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://heraldodemexico.com.mx/espectaculos/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62957</th>\n",
       "      <td>1353338286174064640</td>\n",
       "      <td>2021-01-24 13:46:05+00:00</td>\n",
       "      <td>@EnterHacker is #LiveNow WITH HIS GOOD PAL #ch...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.353335e+18</td>\n",
       "      <td>2.330008e+08</td>\n",
       "      <td>[{'indices': [16, 24], 'text': 'LiveNow'}, {'i...</td>\n",
       "      <td>[{'original_info': {'width': 110, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'twitter.com/BIGDaddio29/st…'...</td>\n",
       "      <td>...</td>\n",
       "      <td>✝️🏴󠁧󠁢󠁳󠁣󠁴󠁿 BIGDaddioJohnB😎 #TheFandomMenace</td>\n",
       "      <td>BIGDaddio29</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/23300083...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1371577260...</td>\n",
       "      <td>11132.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/mBMSclCmPV', 'https://t.co/L0Us...</td>\n",
       "      <td>3</td>\n",
       "      <td>['https://twitter.com/BIGDaddio29/status/13533...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62958</th>\n",
       "      <td>1345247636224262145</td>\n",
       "      <td>2021-01-02 05:56:44+00:00</td>\n",
       "      <td>Petition · Have Amber Heard Removed As ACLU Am...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'Change.org', 'indices': [76,...</td>\n",
       "      <td>...</td>\n",
       "      <td>🏴‍☠️Justice JD 2022💜</td>\n",
       "      <td>GenevieDEPP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://abs.twimg.com/sticky/default_profile_im...</td>\n",
       "      <td>16162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/lG8E0ayjE6', 'https://t.co/v58T...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.change.org/', 'https://www.chang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65864</th>\n",
       "      <td>1379617305340997632</td>\n",
       "      <td>2021-04-07 02:09:32+00:00</td>\n",
       "      <td>@Eve_Barlow @realamberheard @JuliaDavisNews @r...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.379612e+18</td>\n",
       "      <td>9.349442e+17</td>\n",
       "      <td>[{'indices': [369, 374], 'text': 'Musk'}]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'go.recordedfuture.com/hubfs/...</td>\n",
       "      <td>...</td>\n",
       "      <td>Motivator Network: Sarah Walker2🎥🚒</td>\n",
       "      <td>MotivatorNet2</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/93494423...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1383596124...</td>\n",
       "      <td>1339.0</td>\n",
       "      <td>https://t.co/DYst1fjdIt</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/AD2zJT8SUH', 'https://t.co/Febt...</td>\n",
       "      <td>3</td>\n",
       "      <td>['https://go.recordedfuture.com/hubfs/reports/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65865</th>\n",
       "      <td>1379944326504022021</td>\n",
       "      <td>2021-04-07 23:49:00+00:00</td>\n",
       "      <td>Johnny Depp: Pirates star's exciting new work ...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [142, 164], 'text': 'Piratesofthe...</td>\n",
       "      <td>[{'original_info': {'width': 1200, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'express.co.uk/entertainment/...</td>\n",
       "      <td>...</td>\n",
       "      <td>Daily Express</td>\n",
       "      <td>Daily_Express</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/17895820...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1326819212...</td>\n",
       "      <td>888812.0</td>\n",
       "      <td>http://t.co/s6YQUMB0NH</td>\n",
       "      <td>True</td>\n",
       "      <td>['https://t.co/EEoW1VyNYx', 'https://t.co/weom...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.express.co.uk/entertainment/musi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65866</th>\n",
       "      <td>1379687604707205124</td>\n",
       "      <td>2021-04-07 06:48:52+00:00</td>\n",
       "      <td>New video is up! 😉\\n\\nFull Statement of Samant...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [67, 88], 'text': 'JusticeForJohn...</td>\n",
       "      <td>[{'original_info': {'width': 1280, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'youtu.be/yQuC3ZMqwCk', 'indi...</td>\n",
       "      <td>...</td>\n",
       "      <td>🏴‍☠️Stevie J Raw🏴‍☠️</td>\n",
       "      <td>StevieJRaw</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/10165922...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1384579481...</td>\n",
       "      <td>10477.0</td>\n",
       "      <td>https://t.co/DeHsrGL3N8</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/9C5QJu1mRg', 'https://t.co/bp9F...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.youtube.com/watch?v=yQuC3ZMqwCk&amp;...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65867</th>\n",
       "      <td>1379599985428332549</td>\n",
       "      <td>2021-04-07 01:00:42+00:00</td>\n",
       "      <td>How Terrible Are Justice League Costumes? Ambe...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 1200, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'ow.ly/rVul50EhetQ', 'indices...</td>\n",
       "      <td>...</td>\n",
       "      <td>Marsh Myers</td>\n",
       "      <td>marshmyers</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/50990311...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/9092142801...</td>\n",
       "      <td>21153.0</td>\n",
       "      <td>https://t.co/u8ovswHs2n</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/WQ3F9RHy1q', 'https://t.co/gaMU...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://ow.ly/rVul50EhetQ', 'https://twitter...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65868</th>\n",
       "      <td>1379586486471958528</td>\n",
       "      <td>2021-04-07 00:07:04+00:00</td>\n",
       "      <td>'Liga da Justiça': Amber Heard posta vídeo mos...</td>\n",
       "      <td>pt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 1280, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'cinepop.com.br/liga-da-justi...</td>\n",
       "      <td>...</td>\n",
       "      <td>CinePOP</td>\n",
       "      <td>cinepop</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/14500217...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1119629213...</td>\n",
       "      <td>163252.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>['https://t.co/eCfEpq7jkS', 'https://t.co/9blq...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://cinepop.com.br/liga-da-justica-amber...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2915 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id_str                 created_at  \\\n",
       "62954  1345233358889091074  2021-01-02 05:00:00+00:00   \n",
       "62955  1353271503526227968  2021-01-24 09:20:43+00:00   \n",
       "62956  1353381685555990529  2021-01-24 16:38:33+00:00   \n",
       "62957  1353338286174064640  2021-01-24 13:46:05+00:00   \n",
       "62958  1345247636224262145  2021-01-02 05:56:44+00:00   \n",
       "...                    ...                        ...   \n",
       "65864  1379617305340997632  2021-04-07 02:09:32+00:00   \n",
       "65865  1379944326504022021  2021-04-07 23:49:00+00:00   \n",
       "65866  1379687604707205124  2021-04-07 06:48:52+00:00   \n",
       "65867  1379599985428332549  2021-04-07 01:00:42+00:00   \n",
       "65868  1379586486471958528  2021-04-07 00:07:04+00:00   \n",
       "\n",
       "                                               full_text lang  \\\n",
       "62954  \"Just that JOHNNY DEPP IS INNOCENT \"\\n\\nTake t...   en   \n",
       "62955  I have an Instagram for this account aswell bt...   en   \n",
       "62956  ¿Valentino Lanus y Amber Heard mantuvieron un ...   es   \n",
       "62957  @EnterHacker is #LiveNow WITH HIS GOOD PAL #ch...   en   \n",
       "62958  Petition · Have Amber Heard Removed As ACLU Am...   en   \n",
       "...                                                  ...  ...   \n",
       "65864  @Eve_Barlow @realamberheard @JuliaDavisNews @r...   en   \n",
       "65865  Johnny Depp: Pirates star's exciting new work ...   en   \n",
       "65866  New video is up! 😉\\n\\nFull Statement of Samant...   en   \n",
       "65867  How Terrible Are Justice League Costumes? Ambe...   en   \n",
       "65868  'Liga da Justiça': Amber Heard posta vídeo mos...   pt   \n",
       "\n",
       "       in_reply_to_status_id_str  in_reply_to_user_id  \\\n",
       "62954               1.340073e+18         1.338967e+18   \n",
       "62955                        NaN                  NaN   \n",
       "62956                        NaN                  NaN   \n",
       "62957               1.353335e+18         2.330008e+08   \n",
       "62958                        NaN                  NaN   \n",
       "...                          ...                  ...   \n",
       "65864               1.379612e+18         9.349442e+17   \n",
       "65865                        NaN                  NaN   \n",
       "65866                        NaN                  NaN   \n",
       "65867                        NaN                  NaN   \n",
       "65868                        NaN                  NaN   \n",
       "\n",
       "                                       entities.hashtags  \\\n",
       "62954  [{'indices': [130, 151], 'text': 'JusticeForJo...   \n",
       "62955  [{'indices': [98, 109], 'text': 'johnnydepp'},...   \n",
       "62956                                                 []   \n",
       "62957  [{'indices': [16, 24], 'text': 'LiveNow'}, {'i...   \n",
       "62958                                                 []   \n",
       "...                                                  ...   \n",
       "65864          [{'indices': [369, 374], 'text': 'Musk'}]   \n",
       "65865  [{'indices': [142, 164], 'text': 'Piratesofthe...   \n",
       "65866  [{'indices': [67, 88], 'text': 'JusticeForJohn...   \n",
       "65867                                                 []   \n",
       "65868                                                 []   \n",
       "\n",
       "                                          entities.media entities.symbols  \\\n",
       "62954  [{'original_info': {'width': 733, 'focus_rects...               []   \n",
       "62955  [{'original_info': {'width': 1152, 'focus_rect...               []   \n",
       "62956  [{'original_info': {'width': 1280, 'focus_rect...               []   \n",
       "62957  [{'original_info': {'width': 110, 'focus_rects...               []   \n",
       "62958                                                NaN               []   \n",
       "...                                                  ...              ...   \n",
       "65864                                                NaN               []   \n",
       "65865  [{'original_info': {'width': 1200, 'focus_rect...               []   \n",
       "65866  [{'original_info': {'width': 1280, 'focus_rect...               []   \n",
       "65867  [{'original_info': {'width': 1200, 'focus_rect...               []   \n",
       "65868  [{'original_info': {'width': 1280, 'focus_rect...               []   \n",
       "\n",
       "                                           entities.urls  ...  \\\n",
       "62954  [{'display_url': 'at-angys.de/jd/survey.html',...  ...   \n",
       "62955  [{'display_url': 'instagram.com/jdforeveruk', ...  ...   \n",
       "62956  [{'display_url': 'dlvr.it/RrFH8w', 'indices': ...  ...   \n",
       "62957  [{'display_url': 'twitter.com/BIGDaddio29/st…'...  ...   \n",
       "62958  [{'display_url': 'Change.org', 'indices': [76,...  ...   \n",
       "...                                                  ...  ...   \n",
       "65864  [{'display_url': 'go.recordedfuture.com/hubfs/...  ...   \n",
       "65865  [{'display_url': 'express.co.uk/entertainment/...  ...   \n",
       "65866  [{'display_url': 'youtu.be/yQuC3ZMqwCk', 'indi...  ...   \n",
       "65867  [{'display_url': 'ow.ly/rVul50EhetQ', 'indices...  ...   \n",
       "65868  [{'display_url': 'cinepop.com.br/liga-da-justi...  ...   \n",
       "\n",
       "                                        user.name user.screen_name  \\\n",
       "62954                 JD's Supporters Survey 🏴‍☠️  JDsupportSurvey   \n",
       "62955                       Johnny Depp Forever 🖤      JDForeverUK   \n",
       "62956                                    Manu OS          janoboy   \n",
       "62957  ✝️🏴󠁧󠁢󠁳󠁣󠁴󠁿 BIGDaddioJohnB😎 #TheFandomMenace      BIGDaddio29   \n",
       "62958                        🏴‍☠️Justice JD 2022💜      GenevieDEPP   \n",
       "...                                           ...              ...   \n",
       "65864          Motivator Network: Sarah Walker2🎥🚒    MotivatorNet2   \n",
       "65865                               Daily Express    Daily_Express   \n",
       "65866                        🏴‍☠️Stevie J Raw🏴‍☠️       StevieJRaw   \n",
       "65867                                 Marsh Myers       marshmyers   \n",
       "65868                                     CinePOP          cinepop   \n",
       "\n",
       "                                 user.profile_banner_url  \\\n",
       "62954  https://pbs.twimg.com/profile_banners/13389670...   \n",
       "62955  https://pbs.twimg.com/profile_banners/13305377...   \n",
       "62956  https://pbs.twimg.com/profile_banners/15400933...   \n",
       "62957  https://pbs.twimg.com/profile_banners/23300083...   \n",
       "62958                                                NaN   \n",
       "...                                                  ...   \n",
       "65864  https://pbs.twimg.com/profile_banners/93494423...   \n",
       "65865  https://pbs.twimg.com/profile_banners/17895820...   \n",
       "65866  https://pbs.twimg.com/profile_banners/10165922...   \n",
       "65867  https://pbs.twimg.com/profile_banners/50990311...   \n",
       "65868  https://pbs.twimg.com/profile_banners/14500217...   \n",
       "\n",
       "                                  user.profile_image_url user.statuses_count  \\\n",
       "62954  http://pbs.twimg.com/profile_images/1380597112...               595.0   \n",
       "62955  http://pbs.twimg.com/profile_images/1343145607...              1678.0   \n",
       "62956  http://pbs.twimg.com/profile_images/1244451764...            160133.0   \n",
       "62957  http://pbs.twimg.com/profile_images/1371577260...             11132.0   \n",
       "62958  http://abs.twimg.com/sticky/default_profile_im...             16162.0   \n",
       "...                                                  ...                 ...   \n",
       "65864  http://pbs.twimg.com/profile_images/1383596124...              1339.0   \n",
       "65865  http://pbs.twimg.com/profile_images/1326819212...            888812.0   \n",
       "65866  http://pbs.twimg.com/profile_images/1384579481...             10477.0   \n",
       "65867  http://pbs.twimg.com/profile_images/9092142801...             21153.0   \n",
       "65868  http://pbs.twimg.com/profile_images/1119629213...            163252.0   \n",
       "\n",
       "                      user.url  user.verified  \\\n",
       "62954                      NaN          False   \n",
       "62955  https://t.co/HsVNkUX82V          False   \n",
       "62956  https://t.co/6G19lL5qB6          False   \n",
       "62957                      NaN          False   \n",
       "62958                      NaN          False   \n",
       "...                        ...            ...   \n",
       "65864  https://t.co/DYst1fjdIt          False   \n",
       "65865   http://t.co/s6YQUMB0NH           True   \n",
       "65866  https://t.co/DeHsrGL3N8          False   \n",
       "65867  https://t.co/u8ovswHs2n          False   \n",
       "65868                      NaN           True   \n",
       "\n",
       "                                              short_urls n_urls  \\\n",
       "62954  ['https://t.co/b0JfHT49Ax', 'https://t.co/4yk1...      2   \n",
       "62955  ['https://t.co/HsVNkUX82V', 'https://t.co/NAQZ...      2   \n",
       "62956  ['https://t.co/wLLqLpUQ2G', 'https://t.co/wg7c...      2   \n",
       "62957  ['https://t.co/mBMSclCmPV', 'https://t.co/L0Us...      3   \n",
       "62958  ['https://t.co/lG8E0ayjE6', 'https://t.co/v58T...      2   \n",
       "...                                                  ...    ...   \n",
       "65864  ['https://t.co/AD2zJT8SUH', 'https://t.co/Febt...      3   \n",
       "65865  ['https://t.co/EEoW1VyNYx', 'https://t.co/weom...      2   \n",
       "65866  ['https://t.co/9C5QJu1mRg', 'https://t.co/bp9F...      2   \n",
       "65867  ['https://t.co/WQ3F9RHy1q', 'https://t.co/gaMU...      2   \n",
       "65868  ['https://t.co/eCfEpq7jkS', 'https://t.co/9blq...      2   \n",
       "\n",
       "                                                    urls  \n",
       "62954  ['https://at-angys.de/jd/survey.html', 'https:...  \n",
       "62955  ['https://www.instagram.com/jdforeveruk', 'htt...  \n",
       "62956  ['https://heraldodemexico.com.mx/espectaculos/...  \n",
       "62957  ['https://twitter.com/BIGDaddio29/status/13533...  \n",
       "62958  ['https://www.change.org/', 'https://www.chang...  \n",
       "...                                                  ...  \n",
       "65864  ['https://go.recordedfuture.com/hubfs/reports/...  \n",
       "65865  ['https://www.express.co.uk/entertainment/musi...  \n",
       "65866  ['https://www.youtube.com/watch?v=yQuC3ZMqwCk&...  \n",
       "65867  ['https://ow.ly/rVul50EhetQ', 'https://twitter...  \n",
       "65868  ['https://cinepop.com.br/liga-da-justica-amber...  \n",
       "\n",
       "[2915 rows x 42 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_4_months_urls_more"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "69b1b6c5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_more.rename(columns={\"urls\": \"url\"}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "a3d61278",
   "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>id_str</th>\n",
       "      <th>created_at</th>\n",
       "      <th>full_text</th>\n",
       "      <th>lang</th>\n",
       "      <th>in_reply_to_status_id_str</th>\n",
       "      <th>in_reply_to_user_id</th>\n",
       "      <th>entities.hashtags</th>\n",
       "      <th>entities.media</th>\n",
       "      <th>entities.symbols</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>...</th>\n",
       "      <th>user.name</th>\n",
       "      <th>user.screen_name</th>\n",
       "      <th>user.profile_banner_url</th>\n",
       "      <th>user.profile_image_url</th>\n",
       "      <th>user.statuses_count</th>\n",
       "      <th>user.url</th>\n",
       "      <th>user.verified</th>\n",
       "      <th>short_urls</th>\n",
       "      <th>n_urls</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>62954</th>\n",
       "      <td>1345233358889091074</td>\n",
       "      <td>2021-01-02 05:00:00+00:00</td>\n",
       "      <td>\"Just that JOHNNY DEPP IS INNOCENT \"\\n\\nTake t...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.340073e+18</td>\n",
       "      <td>1.338967e+18</td>\n",
       "      <td>[{'indices': [130, 151], 'text': 'JusticeForJo...</td>\n",
       "      <td>[{'original_info': {'width': 733, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'at-angys.de/jd/survey.html',...</td>\n",
       "      <td>...</td>\n",
       "      <td>JD's Supporters Survey 🏴‍☠️</td>\n",
       "      <td>JDsupportSurvey</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/13389670...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1380597112...</td>\n",
       "      <td>595.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/b0JfHT49Ax', 'https://t.co/4yk1...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://at-angys.de/jd/survey.html', 'https:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62955</th>\n",
       "      <td>1353271503526227968</td>\n",
       "      <td>2021-01-24 09:20:43+00:00</td>\n",
       "      <td>I have an Instagram for this account aswell bt...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [98, 109], 'text': 'johnnydepp'},...</td>\n",
       "      <td>[{'original_info': {'width': 1152, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'instagram.com/jdforeveruk', ...</td>\n",
       "      <td>...</td>\n",
       "      <td>Johnny Depp Forever 🖤</td>\n",
       "      <td>JDForeverUK</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/13305377...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1343145607...</td>\n",
       "      <td>1678.0</td>\n",
       "      <td>https://t.co/HsVNkUX82V</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/HsVNkUX82V', 'https://t.co/NAQZ...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.instagram.com/jdforeveruk', 'htt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62956</th>\n",
       "      <td>1353381685555990529</td>\n",
       "      <td>2021-01-24 16:38:33+00:00</td>\n",
       "      <td>¿Valentino Lanus y Amber Heard mantuvieron un ...</td>\n",
       "      <td>es</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 1280, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'dlvr.it/RrFH8w', 'indices': ...</td>\n",
       "      <td>...</td>\n",
       "      <td>Manu OS</td>\n",
       "      <td>janoboy</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/15400933...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1244451764...</td>\n",
       "      <td>160133.0</td>\n",
       "      <td>https://t.co/6G19lL5qB6</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/wLLqLpUQ2G', 'https://t.co/wg7c...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://heraldodemexico.com.mx/espectaculos/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62957</th>\n",
       "      <td>1353338286174064640</td>\n",
       "      <td>2021-01-24 13:46:05+00:00</td>\n",
       "      <td>@EnterHacker is #LiveNow WITH HIS GOOD PAL #ch...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.353335e+18</td>\n",
       "      <td>2.330008e+08</td>\n",
       "      <td>[{'indices': [16, 24], 'text': 'LiveNow'}, {'i...</td>\n",
       "      <td>[{'original_info': {'width': 110, 'focus_rects...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'twitter.com/BIGDaddio29/st…'...</td>\n",
       "      <td>...</td>\n",
       "      <td>✝️🏴󠁧󠁢󠁳󠁣󠁴󠁿 BIGDaddioJohnB😎 #TheFandomMenace</td>\n",
       "      <td>BIGDaddio29</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/23300083...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1371577260...</td>\n",
       "      <td>11132.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/mBMSclCmPV', 'https://t.co/L0Us...</td>\n",
       "      <td>3</td>\n",
       "      <td>['https://twitter.com/BIGDaddio29/status/13533...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62958</th>\n",
       "      <td>1345247636224262145</td>\n",
       "      <td>2021-01-02 05:56:44+00:00</td>\n",
       "      <td>Petition · Have Amber Heard Removed As ACLU Am...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'Change.org', 'indices': [76,...</td>\n",
       "      <td>...</td>\n",
       "      <td>🏴‍☠️Justice JD 2022💜</td>\n",
       "      <td>GenevieDEPP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://abs.twimg.com/sticky/default_profile_im...</td>\n",
       "      <td>16162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/lG8E0ayjE6', 'https://t.co/v58T...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.change.org/', 'https://www.chang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65864</th>\n",
       "      <td>1379617305340997632</td>\n",
       "      <td>2021-04-07 02:09:32+00:00</td>\n",
       "      <td>@Eve_Barlow @realamberheard @JuliaDavisNews @r...</td>\n",
       "      <td>en</td>\n",
       "      <td>1.379612e+18</td>\n",
       "      <td>9.349442e+17</td>\n",
       "      <td>[{'indices': [369, 374], 'text': 'Musk'}]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'go.recordedfuture.com/hubfs/...</td>\n",
       "      <td>...</td>\n",
       "      <td>Motivator Network: Sarah Walker2🎥🚒</td>\n",
       "      <td>MotivatorNet2</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/93494423...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1383596124...</td>\n",
       "      <td>1339.0</td>\n",
       "      <td>https://t.co/DYst1fjdIt</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/AD2zJT8SUH', 'https://t.co/Febt...</td>\n",
       "      <td>3</td>\n",
       "      <td>['https://go.recordedfuture.com/hubfs/reports/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65865</th>\n",
       "      <td>1379944326504022021</td>\n",
       "      <td>2021-04-07 23:49:00+00:00</td>\n",
       "      <td>Johnny Depp: Pirates star's exciting new work ...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [142, 164], 'text': 'Piratesofthe...</td>\n",
       "      <td>[{'original_info': {'width': 1200, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'express.co.uk/entertainment/...</td>\n",
       "      <td>...</td>\n",
       "      <td>Daily Express</td>\n",
       "      <td>Daily_Express</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/17895820...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1326819212...</td>\n",
       "      <td>888812.0</td>\n",
       "      <td>http://t.co/s6YQUMB0NH</td>\n",
       "      <td>True</td>\n",
       "      <td>['https://t.co/EEoW1VyNYx', 'https://t.co/weom...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.express.co.uk/entertainment/musi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65866</th>\n",
       "      <td>1379687604707205124</td>\n",
       "      <td>2021-04-07 06:48:52+00:00</td>\n",
       "      <td>New video is up! 😉\\n\\nFull Statement of Samant...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'indices': [67, 88], 'text': 'JusticeForJohn...</td>\n",
       "      <td>[{'original_info': {'width': 1280, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'youtu.be/yQuC3ZMqwCk', 'indi...</td>\n",
       "      <td>...</td>\n",
       "      <td>🏴‍☠️Stevie J Raw🏴‍☠️</td>\n",
       "      <td>StevieJRaw</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/10165922...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1384579481...</td>\n",
       "      <td>10477.0</td>\n",
       "      <td>https://t.co/DeHsrGL3N8</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/9C5QJu1mRg', 'https://t.co/bp9F...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://www.youtube.com/watch?v=yQuC3ZMqwCk&amp;...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65867</th>\n",
       "      <td>1379599985428332549</td>\n",
       "      <td>2021-04-07 01:00:42+00:00</td>\n",
       "      <td>How Terrible Are Justice League Costumes? Ambe...</td>\n",
       "      <td>en</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 1200, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'ow.ly/rVul50EhetQ', 'indices...</td>\n",
       "      <td>...</td>\n",
       "      <td>Marsh Myers</td>\n",
       "      <td>marshmyers</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/50990311...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/9092142801...</td>\n",
       "      <td>21153.0</td>\n",
       "      <td>https://t.co/u8ovswHs2n</td>\n",
       "      <td>False</td>\n",
       "      <td>['https://t.co/WQ3F9RHy1q', 'https://t.co/gaMU...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://ow.ly/rVul50EhetQ', 'https://twitter...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65868</th>\n",
       "      <td>1379586486471958528</td>\n",
       "      <td>2021-04-07 00:07:04+00:00</td>\n",
       "      <td>'Liga da Justiça': Amber Heard posta vídeo mos...</td>\n",
       "      <td>pt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'original_info': {'width': 1280, 'focus_rect...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'display_url': 'cinepop.com.br/liga-da-justi...</td>\n",
       "      <td>...</td>\n",
       "      <td>CinePOP</td>\n",
       "      <td>cinepop</td>\n",
       "      <td>https://pbs.twimg.com/profile_banners/14500217...</td>\n",
       "      <td>http://pbs.twimg.com/profile_images/1119629213...</td>\n",
       "      <td>163252.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>['https://t.co/eCfEpq7jkS', 'https://t.co/9blq...</td>\n",
       "      <td>2</td>\n",
       "      <td>['https://cinepop.com.br/liga-da-justica-amber...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2915 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id_str                 created_at  \\\n",
       "62954  1345233358889091074  2021-01-02 05:00:00+00:00   \n",
       "62955  1353271503526227968  2021-01-24 09:20:43+00:00   \n",
       "62956  1353381685555990529  2021-01-24 16:38:33+00:00   \n",
       "62957  1353338286174064640  2021-01-24 13:46:05+00:00   \n",
       "62958  1345247636224262145  2021-01-02 05:56:44+00:00   \n",
       "...                    ...                        ...   \n",
       "65864  1379617305340997632  2021-04-07 02:09:32+00:00   \n",
       "65865  1379944326504022021  2021-04-07 23:49:00+00:00   \n",
       "65866  1379687604707205124  2021-04-07 06:48:52+00:00   \n",
       "65867  1379599985428332549  2021-04-07 01:00:42+00:00   \n",
       "65868  1379586486471958528  2021-04-07 00:07:04+00:00   \n",
       "\n",
       "                                               full_text lang  \\\n",
       "62954  \"Just that JOHNNY DEPP IS INNOCENT \"\\n\\nTake t...   en   \n",
       "62955  I have an Instagram for this account aswell bt...   en   \n",
       "62956  ¿Valentino Lanus y Amber Heard mantuvieron un ...   es   \n",
       "62957  @EnterHacker is #LiveNow WITH HIS GOOD PAL #ch...   en   \n",
       "62958  Petition · Have Amber Heard Removed As ACLU Am...   en   \n",
       "...                                                  ...  ...   \n",
       "65864  @Eve_Barlow @realamberheard @JuliaDavisNews @r...   en   \n",
       "65865  Johnny Depp: Pirates star's exciting new work ...   en   \n",
       "65866  New video is up! 😉\\n\\nFull Statement of Samant...   en   \n",
       "65867  How Terrible Are Justice League Costumes? Ambe...   en   \n",
       "65868  'Liga da Justiça': Amber Heard posta vídeo mos...   pt   \n",
       "\n",
       "       in_reply_to_status_id_str  in_reply_to_user_id  \\\n",
       "62954               1.340073e+18         1.338967e+18   \n",
       "62955                        NaN                  NaN   \n",
       "62956                        NaN                  NaN   \n",
       "62957               1.353335e+18         2.330008e+08   \n",
       "62958                        NaN                  NaN   \n",
       "...                          ...                  ...   \n",
       "65864               1.379612e+18         9.349442e+17   \n",
       "65865                        NaN                  NaN   \n",
       "65866                        NaN                  NaN   \n",
       "65867                        NaN                  NaN   \n",
       "65868                        NaN                  NaN   \n",
       "\n",
       "                                       entities.hashtags  \\\n",
       "62954  [{'indices': [130, 151], 'text': 'JusticeForJo...   \n",
       "62955  [{'indices': [98, 109], 'text': 'johnnydepp'},...   \n",
       "62956                                                 []   \n",
       "62957  [{'indices': [16, 24], 'text': 'LiveNow'}, {'i...   \n",
       "62958                                                 []   \n",
       "...                                                  ...   \n",
       "65864          [{'indices': [369, 374], 'text': 'Musk'}]   \n",
       "65865  [{'indices': [142, 164], 'text': 'Piratesofthe...   \n",
       "65866  [{'indices': [67, 88], 'text': 'JusticeForJohn...   \n",
       "65867                                                 []   \n",
       "65868                                                 []   \n",
       "\n",
       "                                          entities.media entities.symbols  \\\n",
       "62954  [{'original_info': {'width': 733, 'focus_rects...               []   \n",
       "62955  [{'original_info': {'width': 1152, 'focus_rect...               []   \n",
       "62956  [{'original_info': {'width': 1280, 'focus_rect...               []   \n",
       "62957  [{'original_info': {'width': 110, 'focus_rects...               []   \n",
       "62958                                                NaN               []   \n",
       "...                                                  ...              ...   \n",
       "65864                                                NaN               []   \n",
       "65865  [{'original_info': {'width': 1200, 'focus_rect...               []   \n",
       "65866  [{'original_info': {'width': 1280, 'focus_rect...               []   \n",
       "65867  [{'original_info': {'width': 1200, 'focus_rect...               []   \n",
       "65868  [{'original_info': {'width': 1280, 'focus_rect...               []   \n",
       "\n",
       "                                           entities.urls  ...  \\\n",
       "62954  [{'display_url': 'at-angys.de/jd/survey.html',...  ...   \n",
       "62955  [{'display_url': 'instagram.com/jdforeveruk', ...  ...   \n",
       "62956  [{'display_url': 'dlvr.it/RrFH8w', 'indices': ...  ...   \n",
       "62957  [{'display_url': 'twitter.com/BIGDaddio29/st…'...  ...   \n",
       "62958  [{'display_url': 'Change.org', 'indices': [76,...  ...   \n",
       "...                                                  ...  ...   \n",
       "65864  [{'display_url': 'go.recordedfuture.com/hubfs/...  ...   \n",
       "65865  [{'display_url': 'express.co.uk/entertainment/...  ...   \n",
       "65866  [{'display_url': 'youtu.be/yQuC3ZMqwCk', 'indi...  ...   \n",
       "65867  [{'display_url': 'ow.ly/rVul50EhetQ', 'indices...  ...   \n",
       "65868  [{'display_url': 'cinepop.com.br/liga-da-justi...  ...   \n",
       "\n",
       "                                        user.name user.screen_name  \\\n",
       "62954                 JD's Supporters Survey 🏴‍☠️  JDsupportSurvey   \n",
       "62955                       Johnny Depp Forever 🖤      JDForeverUK   \n",
       "62956                                    Manu OS          janoboy   \n",
       "62957  ✝️🏴󠁧󠁢󠁳󠁣󠁴󠁿 BIGDaddioJohnB😎 #TheFandomMenace      BIGDaddio29   \n",
       "62958                        🏴‍☠️Justice JD 2022💜      GenevieDEPP   \n",
       "...                                           ...              ...   \n",
       "65864          Motivator Network: Sarah Walker2🎥🚒    MotivatorNet2   \n",
       "65865                               Daily Express    Daily_Express   \n",
       "65866                        🏴‍☠️Stevie J Raw🏴‍☠️       StevieJRaw   \n",
       "65867                                 Marsh Myers       marshmyers   \n",
       "65868                                     CinePOP          cinepop   \n",
       "\n",
       "                                 user.profile_banner_url  \\\n",
       "62954  https://pbs.twimg.com/profile_banners/13389670...   \n",
       "62955  https://pbs.twimg.com/profile_banners/13305377...   \n",
       "62956  https://pbs.twimg.com/profile_banners/15400933...   \n",
       "62957  https://pbs.twimg.com/profile_banners/23300083...   \n",
       "62958                                                NaN   \n",
       "...                                                  ...   \n",
       "65864  https://pbs.twimg.com/profile_banners/93494423...   \n",
       "65865  https://pbs.twimg.com/profile_banners/17895820...   \n",
       "65866  https://pbs.twimg.com/profile_banners/10165922...   \n",
       "65867  https://pbs.twimg.com/profile_banners/50990311...   \n",
       "65868  https://pbs.twimg.com/profile_banners/14500217...   \n",
       "\n",
       "                                  user.profile_image_url user.statuses_count  \\\n",
       "62954  http://pbs.twimg.com/profile_images/1380597112...               595.0   \n",
       "62955  http://pbs.twimg.com/profile_images/1343145607...              1678.0   \n",
       "62956  http://pbs.twimg.com/profile_images/1244451764...            160133.0   \n",
       "62957  http://pbs.twimg.com/profile_images/1371577260...             11132.0   \n",
       "62958  http://abs.twimg.com/sticky/default_profile_im...             16162.0   \n",
       "...                                                  ...                 ...   \n",
       "65864  http://pbs.twimg.com/profile_images/1383596124...              1339.0   \n",
       "65865  http://pbs.twimg.com/profile_images/1326819212...            888812.0   \n",
       "65866  http://pbs.twimg.com/profile_images/1384579481...             10477.0   \n",
       "65867  http://pbs.twimg.com/profile_images/9092142801...             21153.0   \n",
       "65868  http://pbs.twimg.com/profile_images/1119629213...            163252.0   \n",
       "\n",
       "                      user.url  user.verified  \\\n",
       "62954                      NaN          False   \n",
       "62955  https://t.co/HsVNkUX82V          False   \n",
       "62956  https://t.co/6G19lL5qB6          False   \n",
       "62957                      NaN          False   \n",
       "62958                      NaN          False   \n",
       "...                        ...            ...   \n",
       "65864  https://t.co/DYst1fjdIt          False   \n",
       "65865   http://t.co/s6YQUMB0NH           True   \n",
       "65866  https://t.co/DeHsrGL3N8          False   \n",
       "65867  https://t.co/u8ovswHs2n          False   \n",
       "65868                      NaN           True   \n",
       "\n",
       "                                              short_urls n_urls  \\\n",
       "62954  ['https://t.co/b0JfHT49Ax', 'https://t.co/4yk1...      2   \n",
       "62955  ['https://t.co/HsVNkUX82V', 'https://t.co/NAQZ...      2   \n",
       "62956  ['https://t.co/wLLqLpUQ2G', 'https://t.co/wg7c...      2   \n",
       "62957  ['https://t.co/mBMSclCmPV', 'https://t.co/L0Us...      3   \n",
       "62958  ['https://t.co/lG8E0ayjE6', 'https://t.co/v58T...      2   \n",
       "...                                                  ...    ...   \n",
       "65864  ['https://t.co/AD2zJT8SUH', 'https://t.co/Febt...      3   \n",
       "65865  ['https://t.co/EEoW1VyNYx', 'https://t.co/weom...      2   \n",
       "65866  ['https://t.co/9C5QJu1mRg', 'https://t.co/bp9F...      2   \n",
       "65867  ['https://t.co/WQ3F9RHy1q', 'https://t.co/gaMU...      2   \n",
       "65868  ['https://t.co/eCfEpq7jkS', 'https://t.co/9blq...      2   \n",
       "\n",
       "                                                     url  \n",
       "62954  ['https://at-angys.de/jd/survey.html', 'https:...  \n",
       "62955  ['https://www.instagram.com/jdforeveruk', 'htt...  \n",
       "62956  ['https://heraldodemexico.com.mx/espectaculos/...  \n",
       "62957  ['https://twitter.com/BIGDaddio29/status/13533...  \n",
       "62958  ['https://www.change.org/', 'https://www.chang...  \n",
       "...                                                  ...  \n",
       "65864  ['https://go.recordedfuture.com/hubfs/reports/...  \n",
       "65865  ['https://www.express.co.uk/entertainment/musi...  \n",
       "65866  ['https://www.youtube.com/watch?v=yQuC3ZMqwCk&...  \n",
       "65867  ['https://ow.ly/rVul50EhetQ', 'https://twitter...  \n",
       "65868  ['https://cinepop.com.br/liga-da-justica-amber...  \n",
       "\n",
       "[2915 rows x 42 columns]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_4_months_urls_more"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "a7f27fdd",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_more[\"url\"] = df_tweets_4_months_urls_more[\"url\"].apply(lambda x: le(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "7cdf04e0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_more_with_users_count = more_than_one_link_with_count_(\n",
    "    df_tweets_4_months_urls_more, \"user.id_str\", \"url\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "d4e6b414",
   "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>link</th>\n",
       "      <th>count</th>\n",
       "      <th>n_users</th>\n",
       "      <th>users</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://at-angys.de/jd/survey.html</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>{1.338967066469167e+18}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://twitter.com/JDsupportSurvey/status/134...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{1.338967066469167e+18}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.instagram.com/jdforeveruk</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{1.330537710369579e+18}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://twitter.com/JDForeverUK/status/1353271...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{1.330537710369579e+18}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://heraldodemexico.com.mx/espectaculos/20...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{15400933.0}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3280</th>\n",
       "      <td>https://www.youtube.com/watch?v=yQuC3ZMqwCk&amp;fe...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{1.0165922916942396e+18}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3281</th>\n",
       "      <td>https://twitter.com/StevieJRaw/status/13796876...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{1.0165922916942396e+18}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3282</th>\n",
       "      <td>https://ow.ly/rVul50EhetQ</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{50990311.0}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3283</th>\n",
       "      <td>https://twitter.com/marshmyers/status/13795999...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{50990311.0}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3284</th>\n",
       "      <td>https://twitter.com/cinepop/status/13795864864...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{14500217.0}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3285 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   link  count  n_users  \\\n",
       "0                    https://at-angys.de/jd/survey.html      8        1   \n",
       "1     https://twitter.com/JDsupportSurvey/status/134...      1        1   \n",
       "2                 https://www.instagram.com/jdforeveruk      1        1   \n",
       "3     https://twitter.com/JDForeverUK/status/1353271...      1        1   \n",
       "4     https://heraldodemexico.com.mx/espectaculos/20...      1        1   \n",
       "...                                                 ...    ...      ...   \n",
       "3280  https://www.youtube.com/watch?v=yQuC3ZMqwCk&fe...      1        1   \n",
       "3281  https://twitter.com/StevieJRaw/status/13796876...      1        1   \n",
       "3282                          https://ow.ly/rVul50EhetQ      1        1   \n",
       "3283  https://twitter.com/marshmyers/status/13795999...      1        1   \n",
       "3284  https://twitter.com/cinepop/status/13795864864...      1        1   \n",
       "\n",
       "                         users n_urls  \n",
       "0      {1.338967066469167e+18}    {2}  \n",
       "1      {1.338967066469167e+18}    {2}  \n",
       "2      {1.330537710369579e+18}    {2}  \n",
       "3      {1.330537710369579e+18}    {2}  \n",
       "4                 {15400933.0}    {2}  \n",
       "...                        ...    ...  \n",
       "3280  {1.0165922916942396e+18}    {2}  \n",
       "3281  {1.0165922916942396e+18}    {2}  \n",
       "3282              {50990311.0}    {2}  \n",
       "3283              {50990311.0}    {2}  \n",
       "3284              {14500217.0}    {2}  \n",
       "\n",
       "[3285 rows x 5 columns]"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_4_months_urls_more_with_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "b116301c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_with_users_count = pd.concat(\n",
    "    [df_tweets_4_months_urls_more_with_users_count, df_tweets_4_months_urls_with_users_count]\n",
    ").sort_values(\"count\", ascending=False).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "92f62b39",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls_with_users_count[df_tweets_4_months_urls_with_users_count.link != \"connection error\"].to_csv(\n",
    "    \"URLs_Data/Twitter/\" + \"df_tweets_4_months_urls_with_users_count.csv\", index=False\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "d5a8cea4",
   "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>link</th>\n",
       "      <th>count</th>\n",
       "      <th>n_users</th>\n",
       "      <th>users</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://www.nickwallis.com/depp-trial</td>\n",
       "      <td>311</td>\n",
       "      <td>14</td>\n",
       "      <td>(1.3421675271080714e+18, 1.2888656612598497e+1...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-94749...</td>\n",
       "      <td>234</td>\n",
       "      <td>192</td>\n",
       "      <td>(1.355610488391e+18, 7.445623713063977e+17, 1....</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.youtube.com/watch?v=ny3A4kBbUvE</td>\n",
       "      <td>146</td>\n",
       "      <td>1</td>\n",
       "      <td>{4583281223.0}</td>\n",
       "      <td>{2, 3}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://fandango.com/city-of-lies-212058/movie...</td>\n",
       "      <td>146</td>\n",
       "      <td>1</td>\n",
       "      <td>{4583281223.0}</td>\n",
       "      <td>{2, 3}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://www.change.org/p/dc-entertainment-remo...</td>\n",
       "      <td>101</td>\n",
       "      <td>45</td>\n",
       "      <td>(8.957123023593964e+17, 1.32725448511522e+18, ...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56364</th>\n",
       "      <td>https://twitter.com/AllshineWe/status/13794453...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.32725448511522e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56365</th>\n",
       "      <td>https://twitter.com/bling52274867/status/13794...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(1.3533213312999383e+18,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56366</th>\n",
       "      <td>https://twitter.com/NFL_Journal/status/1379442...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(3040033208.0,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56367</th>\n",
       "      <td>https://twitter.com/aviaum/status/137944147323...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(305700310.0,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56368</th>\n",
       "      <td>https://twitter.com/Astartiel/status/137989817...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(14828950.0,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>56368 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    link  count  n_users  \\\n",
       "1                  https://www.nickwallis.com/depp-trial    311       14   \n",
       "2      https://www.dailymail.co.uk/news/article-94749...    234      192   \n",
       "3            https://www.youtube.com/watch?v=ny3A4kBbUvE    146        1   \n",
       "4      https://fandango.com/city-of-lies-212058/movie...    146        1   \n",
       "5      https://www.change.org/p/dc-entertainment-remo...    101       45   \n",
       "...                                                  ...    ...      ...   \n",
       "56364  https://twitter.com/AllshineWe/status/13794453...      1        1   \n",
       "56365  https://twitter.com/bling52274867/status/13794...      1        1   \n",
       "56366  https://twitter.com/NFL_Journal/status/1379442...      1        1   \n",
       "56367  https://twitter.com/aviaum/status/137944147323...      1        1   \n",
       "56368  https://twitter.com/Astartiel/status/137989817...      1        1   \n",
       "\n",
       "                                                   users  n_urls  \n",
       "1      (1.3421675271080714e+18, 1.2888656612598497e+1...     {1}  \n",
       "2      (1.355610488391e+18, 7.445623713063977e+17, 1....     {1}  \n",
       "3                                         {4583281223.0}  {2, 3}  \n",
       "4                                         {4583281223.0}  {2, 3}  \n",
       "5      (8.957123023593964e+17, 1.32725448511522e+18, ...     {1}  \n",
       "...                                                  ...     ...  \n",
       "56364                            (1.32725448511522e+18,)     {1}  \n",
       "56365                          (1.3533213312999383e+18,)     {1}  \n",
       "56366                                    (3040033208.0,)     {1}  \n",
       "56367                                     (305700310.0,)     {1}  \n",
       "56368                                      (14828950.0,)     {1}  \n",
       "\n",
       "[56368 rows x 5 columns]"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tweets_4_months_urls_with_users_count[df_tweets_4_months_urls_with_users_count.link != \"connection error\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "e542dc88",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls.to_csv(r\"URLs_Data/Twitter/df_tweets_4_months_urls.csv\", compression=\"zip\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "f0cdff68",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tweets_4_months_urls.drop(\n",
    "    columns=[\"user.profile_banner_url\", \"user.profile_image_url\", \"entities.media\"]\n",
    ").to_csv(r\"URLs_Data/Twitter/df_tweets_4_months_urls.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6d68f615",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}