Links Analysis Cross-Platforms/Reddit_URLs.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",
    ")\n",
    "import pandas as pd\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8b56cd59",
   "metadata": {},
   "source": [
    "# Reddit Data URLs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "2d321f99",
   "metadata": {},
   "outputs": [],
   "source": [
    "reddit_filter_path =  \"../Filtered Data/Reddit/CSV/\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "dc9936b8",
   "metadata": {},
   "outputs": [],
   "source": [
    "reddit_data_path =  \"URLs_Data/Reddit/\""
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9598ae2d",
   "metadata": {},
   "source": [
    "<a id='Reddits'></a>\n",
    "\n",
    "## Reddits\n",
    "\n",
    "\n",
    "><ul>\n",
    " <li><a href=\"#4\">4 Months</a></li>\n",
    " <li><a href=\"#12\">December</a></li>  \n",
    "\n",
    " </ul>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "4b4cf30d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df_reddit_20 = pd.read_csv(reddit_data_path + \"reddit_2020.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "2213ac35",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df_reddit_21 = pd.read_csv(reddit_data_path + \"reddit_2021.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "798d2bff",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df_reddit_20.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "c054ca44",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df_reddit_21.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "272cc9bf",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df_reddit_20[\"created_at\"] = pd.to_datetime(df_reddit_20.created_at)\n",
    "# df_reddit_21[\"created_at\"] = pd.to_datetime(df_reddit_21.created_at)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "08e9227f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# urls_reddits_20 = URLS(df_reddit_20)\n",
    "# urls_reddits_21 = URLS(df_reddit_21)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "48a7a1e4",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 4 months data\n",
    "df_reddit_4_months = urls_reddits_21.months_filteration(\n",
    "    datetime_column=\"created_at\", start=\"2021-01-01 00:00:00\", end=\"2021-05-01 00:00:00\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "cc374810",
   "metadata": {},
   "outputs": [],
   "source": [
    "# # dec data\n",
    "# df_reddit_dec = urls_reddits_20.months_filteration(\n",
    "#     datetime_column=\"created_at\", start=\"2020-12-01 00:00:00\", end=\"2021-01-01 00:00:00\"\n",
    "# )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "b8d0032f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df_reddit_4_months.created_at.min(), df_reddit_4_months.created_at.max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "2a5ebaa6",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df_reddit_dec.created_at.min(), df_reddit_dec.created_at.max()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ad2d6ef8",
   "metadata": {},
   "source": [
    "### 4 Months\n",
    "<a id='4'></a>\n",
    "\n",
    "\n",
    "><ul>\n",
    " <li><a href=\"#one4\">One Link</a></li>\n",
    " <li><a href=\"#more4\">More Than One Link</a></li>  \n",
    "\n",
    " </ul>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "b566e416",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " Volume in drive D is Essentials\n",
      " Volume Serial Number is 7063-374D\n",
      "\n",
      " Directory of D:\\Freelance\\Christina\\Filtered Data\\Reddit\\CSV\n",
      "\n",
      "02/17/2022  07:31 PM    <DIR>          .\n",
      "02/17/2022  07:31 PM    <DIR>          ..\n",
      "01/26/2022  12:46 PM             3,501 daily_creation_4_months.csv\n",
      "01/26/2022  12:47 PM               932 daily_creation_dec.csv\n",
      "01/27/2022  02:20 AM         5,912,508 reddits_4_months.csv\n",
      "01/28/2022  04:34 AM         2,434,942 reddits_4_months.xlsx\n",
      "01/27/2022  02:20 AM         3,928,694 reddits_dec.csv\n",
      "01/26/2022  12:40 PM           526,688 users_4_months.csv\n",
      "01/26/2022  12:41 PM           328,330 users_dec.csv\n",
      "               7 File(s)     13,135,595 bytes\n",
      "               2 Dir(s)  131,738,484,736 bytes free\n"
     ]
    }
   ],
   "source": [
    "ls \"../Filtered Data/Reddit/CSV/\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "42449752",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_4_months = pd.read_csv(reddit_filter_path + \"reddits_4_months.csv\" )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "bf390cb7",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_4_months.drop_duplicates(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "4e6664d8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_4_months[\"urls\"] = df_reddit_4_months.text.astype(str).apply(\n",
    "    lambda x: get_urls(\n",
    "        str(x).replace(\"[\", \" \").replace(\"]\", \" \").replace(\"(\", \" \").replace(\")\", \" \")\n",
    "    )\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "b30bbb17",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_4_months[\"n_urls\"] = df_reddit_4_months.urls.apply(lambda x: len(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "2212e63b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_4_months_urls = urls_df(df_reddit_4_months)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "1309b9c1",
   "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>_index</th>\n",
       "      <th>_type</th>\n",
       "      <th>_id</th>\n",
       "      <th>_score</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>permalink</th>\n",
       "      <th>text</th>\n",
       "      <th>parent_id</th>\n",
       "      <th>subreddit</th>\n",
       "      <th>author</th>\n",
       "      <th>created_at</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>sentiment_blob</th>\n",
       "      <th>sentiment_nltk</th>\n",
       "      <th>urls</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>Yla2ZnoBZsCJ_ScUHdvG</td>\n",
       "      <td>1.0</td>\n",
       "      <td>glh36zw</td>\n",
       "      <td>t1_glh36zw</td>\n",
       "      <td>/r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...</td>\n",
       "      <td>**OP needs help. Also, they hate it because......</td>\n",
       "      <td>t3_l9bdw3</td>\n",
       "      <td>r/TIHI</td>\n",
       "      <td>ThanksIHateClippy</td>\n",
       "      <td>2021-01-31 12:29:47+00:00</td>\n",
       "      <td>[{'display_url': 'https://github.com'}]</td>\n",
       "      <td>Negative</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://github.com/Artraxon/tihibot]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>fVa2ZnoBZsCJ_ScUHttR</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gljbkro</td>\n",
       "      <td>t1_gljbkro</td>\n",
       "      <td>/r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...</td>\n",
       "      <td>###[View link](https://redditsave.com/info?url...</td>\n",
       "      <td>t1_gljbk4n</td>\n",
       "      <td>r/TIHI</td>\n",
       "      <td>SaveVideo</td>\n",
       "      <td>2021-01-31 23:52:31+00:00</td>\n",
       "      <td>[{'display_url': 'https://redditsave.com'}, {'...</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://redditsave.com/info?url=/r/TIHI/comme...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>fla2ZnoBZsCJ_ScUHttX</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gljbmw0</td>\n",
       "      <td>t1_gljbmw0</td>\n",
       "      <td>/r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...</td>\n",
       "      <td>Here's a sneak peek of /r/Hornyjail using the ...</td>\n",
       "      <td>t1_gljblnw</td>\n",
       "      <td>r/TIHI</td>\n",
       "      <td>sneakpeekbot</td>\n",
       "      <td>2021-01-31 23:52:59+00:00</td>\n",
       "      <td>[{'display_url': 'https://np.reddit.com'}, {'d...</td>\n",
       "      <td>Negative</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://np.reddit.com/r/Hornyjail/top/?sort=t...</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>sFa2ZnoBZsCJ_ScUzNsK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gle47p6</td>\n",
       "      <td>t1_gle47p6</td>\n",
       "      <td>/r/meme/comments/l8rzkp/keanu_reeves_good_ambe...</td>\n",
       "      <td>Did you know that r/meme and r/memes have a mi...</td>\n",
       "      <td>t3_l8rzkp</td>\n",
       "      <td>r/meme</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2021-01-30 18:24:33+00:00</td>\n",
       "      <td>[{'display_url': 'https://discord.gg'}, {'disp...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Positive</td>\n",
       "      <td>[https://discord.gg/WVvXFmPQaz, https://reddit...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>x1a2ZnoBZsCJ_ScU2NvE</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gle3tan</td>\n",
       "      <td>t1_gle3tan</td>\n",
       "      <td>/r/meme/comments/l8rx09/keanu_reeves_good_ambe...</td>\n",
       "      <td>Did you know that r/meme and r/memes have a mi...</td>\n",
       "      <td>t3_l8rx09</td>\n",
       "      <td>r/meme</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2021-01-30 18:21:33+00:00</td>\n",
       "      <td>[{'display_url': 'https://discord.gg'}, {'disp...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Positive</td>\n",
       "      <td>[https://discord.gg/WVvXFmPQaz, https://reddit...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>yFa2ZnoBZsCJ_ScU2NvJ</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gle3z6i</td>\n",
       "      <td>t1_gle3z6i</td>\n",
       "      <td>/r/meme/comments/l8rx09/keanu_reeves_good_ambe...</td>\n",
       "      <td>Hey!\\n\\nYou've submitted an uncropped image.\\n...</td>\n",
       "      <td>t3_l8rx09</td>\n",
       "      <td>r/meme</td>\n",
       "      <td>MAGIC_EYE_BOT</td>\n",
       "      <td>2021-01-30 18:22:46+00:00</td>\n",
       "      <td>[{'display_url': 'https://lmgtfy.com'}]</td>\n",
       "      <td>Negative</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://lmgtfy.com/?q=how+to+crop+an+image&amp;s=g]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>zFa2ZnoBZsCJ_ScU-dsn</td>\n",
       "      <td>1.0</td>\n",
       "      <td>glej2x6</td>\n",
       "      <td>t1_glej2x6</td>\n",
       "      <td>/r/explainlikeimfive/comments/l8upam/eli5_jonn...</td>\n",
       "      <td>Your submission has been removed because it co...</td>\n",
       "      <td>t3_l8upam</td>\n",
       "      <td>r/explainlikeimfive</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2021-01-30 20:19:46+00:00</td>\n",
       "      <td>[{'display_url': 'https://old.reddit.com'}]</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Positive</td>\n",
       "      <td>[https://old.reddit.com/message/compose?to=%2F...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>HVa3ZnoBZsCJ_ScUdNx-</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gldt13a</td>\n",
       "      <td>t1_gldt13a</td>\n",
       "      <td>/r/MensRights/comments/l898tv/men_and_women_al...</td>\n",
       "      <td>https://corporatefinanceinstitute.com/resource...</td>\n",
       "      <td>t1_gldflg1</td>\n",
       "      <td>r/MensRights</td>\n",
       "      <td>JohnDoe721</td>\n",
       "      <td>2021-01-30 16:59:59+00:00</td>\n",
       "      <td>[{'display_url': 'https://corporatefinanceinst...</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://corporatefinanceinstitute.com/resourc...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>WFa3ZnoBZsCJ_ScUedx8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gld501y</td>\n",
       "      <td>t1_gld501y</td>\n",
       "      <td>/r/funny/comments/l8g47j/blacklist_amber_heard...</td>\n",
       "      <td>Hi, /u/Silver-pony, your post breaks [the rule...</td>\n",
       "      <td>t3_l8g47j</td>\n",
       "      <td>r/funny</td>\n",
       "      <td>Funny-Mod</td>\n",
       "      <td>2021-01-30 13:17:25+00:00</td>\n",
       "      <td>[{'display_url': 'https://www.reddit.com'}, {'...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://www.reddit.com/r/funny/wiki/rules, ht...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>dla3ZnoBZsCJ_ScUetwN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>glcfms8</td>\n",
       "      <td>t1_glcfms8</td>\n",
       "      <td>/r/funny/comments/l8g47j/blacklist_amber_heard...</td>\n",
       "      <td>This message is a friendly reminder of the fol...</td>\n",
       "      <td>t3_l8g47j</td>\n",
       "      <td>r/funny</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2021-01-30 06:55:29+00:00</td>\n",
       "      <td>[{'display_url': 'https://www.reddit.com'}]</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://www.reddit.com/r/funny/wiki/rules]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   _index _type                   _id  _score       id        name  \\\n",
       "0  reddit  _doc  Yla2ZnoBZsCJ_ScUHdvG     1.0  glh36zw  t1_glh36zw   \n",
       "1  reddit  _doc  fVa2ZnoBZsCJ_ScUHttR     1.0  gljbkro  t1_gljbkro   \n",
       "2  reddit  _doc  fla2ZnoBZsCJ_ScUHttX     1.0  gljbmw0  t1_gljbmw0   \n",
       "3  reddit  _doc  sFa2ZnoBZsCJ_ScUzNsK     1.0  gle47p6  t1_gle47p6   \n",
       "4  reddit  _doc  x1a2ZnoBZsCJ_ScU2NvE     1.0  gle3tan  t1_gle3tan   \n",
       "5  reddit  _doc  yFa2ZnoBZsCJ_ScU2NvJ     1.0  gle3z6i  t1_gle3z6i   \n",
       "6  reddit  _doc  zFa2ZnoBZsCJ_ScU-dsn     1.0  glej2x6  t1_glej2x6   \n",
       "7  reddit  _doc  HVa3ZnoBZsCJ_ScUdNx-     1.0  gldt13a  t1_gldt13a   \n",
       "8  reddit  _doc  WFa3ZnoBZsCJ_ScUedx8     1.0  gld501y  t1_gld501y   \n",
       "9  reddit  _doc  dla3ZnoBZsCJ_ScUetwN     1.0  glcfms8  t1_glcfms8   \n",
       "\n",
       "                                           permalink  \\\n",
       "0  /r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...   \n",
       "1  /r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...   \n",
       "2  /r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...   \n",
       "3  /r/meme/comments/l8rzkp/keanu_reeves_good_ambe...   \n",
       "4  /r/meme/comments/l8rx09/keanu_reeves_good_ambe...   \n",
       "5  /r/meme/comments/l8rx09/keanu_reeves_good_ambe...   \n",
       "6  /r/explainlikeimfive/comments/l8upam/eli5_jonn...   \n",
       "7  /r/MensRights/comments/l898tv/men_and_women_al...   \n",
       "8  /r/funny/comments/l8g47j/blacklist_amber_heard...   \n",
       "9  /r/funny/comments/l8g47j/blacklist_amber_heard...   \n",
       "\n",
       "                                                text   parent_id  \\\n",
       "0  **OP needs help. Also, they hate it because......   t3_l9bdw3   \n",
       "1  ###[View link](https://redditsave.com/info?url...  t1_gljbk4n   \n",
       "2  Here's a sneak peek of /r/Hornyjail using the ...  t1_gljblnw   \n",
       "3  Did you know that r/meme and r/memes have a mi...   t3_l8rzkp   \n",
       "4  Did you know that r/meme and r/memes have a mi...   t3_l8rx09   \n",
       "5  Hey!\\n\\nYou've submitted an uncropped image.\\n...   t3_l8rx09   \n",
       "6  Your submission has been removed because it co...   t3_l8upam   \n",
       "7  https://corporatefinanceinstitute.com/resource...  t1_gldflg1   \n",
       "8  Hi, /u/Silver-pony, your post breaks [the rule...   t3_l8g47j   \n",
       "9  This message is a friendly reminder of the fol...   t3_l8g47j   \n",
       "\n",
       "             subreddit             author                 created_at  \\\n",
       "0               r/TIHI  ThanksIHateClippy  2021-01-31 12:29:47+00:00   \n",
       "1               r/TIHI          SaveVideo  2021-01-31 23:52:31+00:00   \n",
       "2               r/TIHI       sneakpeekbot  2021-01-31 23:52:59+00:00   \n",
       "3               r/meme      AutoModerator  2021-01-30 18:24:33+00:00   \n",
       "4               r/meme      AutoModerator  2021-01-30 18:21:33+00:00   \n",
       "5               r/meme      MAGIC_EYE_BOT  2021-01-30 18:22:46+00:00   \n",
       "6  r/explainlikeimfive      AutoModerator  2021-01-30 20:19:46+00:00   \n",
       "7         r/MensRights         JohnDoe721  2021-01-30 16:59:59+00:00   \n",
       "8              r/funny          Funny-Mod  2021-01-30 13:17:25+00:00   \n",
       "9              r/funny      AutoModerator  2021-01-30 06:55:29+00:00   \n",
       "\n",
       "                                       entities.urls sentiment_blob  \\\n",
       "0            [{'display_url': 'https://github.com'}]       Negative   \n",
       "1  [{'display_url': 'https://redditsave.com'}, {'...        Neutral   \n",
       "2  [{'display_url': 'https://np.reddit.com'}, {'d...       Negative   \n",
       "3  [{'display_url': 'https://discord.gg'}, {'disp...       Positive   \n",
       "4  [{'display_url': 'https://discord.gg'}, {'disp...       Positive   \n",
       "5            [{'display_url': 'https://lmgtfy.com'}]       Negative   \n",
       "6        [{'display_url': 'https://old.reddit.com'}]       Positive   \n",
       "7  [{'display_url': 'https://corporatefinanceinst...        Neutral   \n",
       "8  [{'display_url': 'https://www.reddit.com'}, {'...       Positive   \n",
       "9        [{'display_url': 'https://www.reddit.com'}]       Positive   \n",
       "\n",
       "  sentiment_nltk                                               urls  n_urls  \n",
       "0        Neutral              [https://github.com/Artraxon/tihibot]       1  \n",
       "1        Neutral  [https://redditsave.com/info?url=/r/TIHI/comme...       6  \n",
       "2        Neutral  [https://np.reddit.com/r/Hornyjail/top/?sort=t...      10  \n",
       "3       Positive  [https://discord.gg/WVvXFmPQaz, https://reddit...       2  \n",
       "4       Positive  [https://discord.gg/WVvXFmPQaz, https://reddit...       2  \n",
       "5        Neutral   [https://lmgtfy.com/?q=how+to+crop+an+image&s=g]       1  \n",
       "6       Positive  [https://old.reddit.com/message/compose?to=%2F...       1  \n",
       "7        Neutral  [https://corporatefinanceinstitute.com/resourc...       1  \n",
       "8        Neutral  [https://www.reddit.com/r/funny/wiki/rules, ht...       3  \n",
       "9        Neutral        [https://www.reddit.com/r/funny/wiki/rules]       1  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddit_4_months_urls.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "163b593e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# save data\n",
    "df_reddit_4_months_urls.to_csv(\n",
    "    reddit_data_path + \"df_reddits_4_months_urls.csv\", index=False\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "205bb7fc",
   "metadata": {},
   "source": [
    "<a id='one4'></a>\n",
    "#### One Link\n",
    "\n",
    "><ul>\n",
    " <li><a href=\"#one4\">One Link</a></li>\n",
    " <li><a href=\"#more4\">More Than One Link</a></li>  \n",
    "\n",
    " </ul>\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "bbd5140c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_4_months_urls_1_link = one_link_df(df_reddit_4_months_urls)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "92f820d0",
   "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>_index</th>\n",
       "      <th>_type</th>\n",
       "      <th>_id</th>\n",
       "      <th>_score</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>permalink</th>\n",
       "      <th>text</th>\n",
       "      <th>parent_id</th>\n",
       "      <th>subreddit</th>\n",
       "      <th>author</th>\n",
       "      <th>created_at</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>sentiment_blob</th>\n",
       "      <th>sentiment_nltk</th>\n",
       "      <th>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>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>Yla2ZnoBZsCJ_ScUHdvG</td>\n",
       "      <td>1.0</td>\n",
       "      <td>glh36zw</td>\n",
       "      <td>t1_glh36zw</td>\n",
       "      <td>/r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...</td>\n",
       "      <td>**OP needs help. Also, they hate it because......</td>\n",
       "      <td>t3_l9bdw3</td>\n",
       "      <td>r/TIHI</td>\n",
       "      <td>ThanksIHateClippy</td>\n",
       "      <td>2021-01-31 12:29:47+00:00</td>\n",
       "      <td>[{'display_url': 'https://github.com'}]</td>\n",
       "      <td>Negative</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://github.com/Artraxon/tihibot]</td>\n",
       "      <td>1</td>\n",
       "      <td>https://github.com/Artraxon/tihibot</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   _index _type                   _id  _score       id        name  \\\n",
       "0  reddit  _doc  Yla2ZnoBZsCJ_ScUHdvG     1.0  glh36zw  t1_glh36zw   \n",
       "\n",
       "                                           permalink  \\\n",
       "0  /r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...   \n",
       "\n",
       "                                                text  parent_id subreddit  \\\n",
       "0  **OP needs help. Also, they hate it because......  t3_l9bdw3    r/TIHI   \n",
       "\n",
       "              author                 created_at  \\\n",
       "0  ThanksIHateClippy  2021-01-31 12:29:47+00:00   \n",
       "\n",
       "                             entities.urls sentiment_blob sentiment_nltk  \\\n",
       "0  [{'display_url': 'https://github.com'}]       Negative        Neutral   \n",
       "\n",
       "                                    urls  n_urls  \\\n",
       "0  [https://github.com/Artraxon/tihibot]       1   \n",
       "\n",
       "                                   url  \n",
       "0  https://github.com/Artraxon/tihibot  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddit_4_months_urls_1_link.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "e7ffe4be",
   "metadata": {},
   "outputs": [],
   "source": [
    "list_reddit_4_months_urls_1_link = one_link_urls(df_reddit_4_months_urls_1_link)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "ce20bf2b",
   "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>_index</th>\n",
       "      <th>_type</th>\n",
       "      <th>_id</th>\n",
       "      <th>_score</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>permalink</th>\n",
       "      <th>text</th>\n",
       "      <th>parent_id</th>\n",
       "      <th>subreddit</th>\n",
       "      <th>author</th>\n",
       "      <th>created_at</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>sentiment_blob</th>\n",
       "      <th>sentiment_nltk</th>\n",
       "      <th>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>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>Yla2ZnoBZsCJ_ScUHdvG</td>\n",
       "      <td>1.0</td>\n",
       "      <td>glh36zw</td>\n",
       "      <td>t1_glh36zw</td>\n",
       "      <td>/r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...</td>\n",
       "      <td>**OP needs help. Also, they hate it because......</td>\n",
       "      <td>t3_l9bdw3</td>\n",
       "      <td>r/TIHI</td>\n",
       "      <td>ThanksIHateClippy</td>\n",
       "      <td>2021-01-31 12:29:47+00:00</td>\n",
       "      <td>[{'display_url': 'https://github.com'}]</td>\n",
       "      <td>Negative</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://github.com/Artraxon/tihibot]</td>\n",
       "      <td>1</td>\n",
       "      <td>https://github.com/Artraxon/tihibot</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   _index _type                   _id  _score       id        name  \\\n",
       "0  reddit  _doc  Yla2ZnoBZsCJ_ScUHdvG     1.0  glh36zw  t1_glh36zw   \n",
       "\n",
       "                                           permalink  \\\n",
       "0  /r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...   \n",
       "\n",
       "                                                text  parent_id subreddit  \\\n",
       "0  **OP needs help. Also, they hate it because......  t3_l9bdw3    r/TIHI   \n",
       "\n",
       "              author                 created_at  \\\n",
       "0  ThanksIHateClippy  2021-01-31 12:29:47+00:00   \n",
       "\n",
       "                             entities.urls sentiment_blob sentiment_nltk  \\\n",
       "0  [{'display_url': 'https://github.com'}]       Negative        Neutral   \n",
       "\n",
       "                                    urls  n_urls  \\\n",
       "0  [https://github.com/Artraxon/tihibot]       1   \n",
       "\n",
       "                                   url  \n",
       "0  https://github.com/Artraxon/tihibot  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddit_4_months_urls_1_link.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "84b46966",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_4_months_urls_1_link_ith_users_count = one_link_urls_with_count_(\n",
    "    df_reddit_4_months_urls_1_link, user_column=\"author\", url_column=\"url\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "1d4d286b",
   "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.judiciary.uk/wp-content/uploads/20...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>(zebbielm12, pecrh001, faithle55)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://www.nytimes.com/2005/09/18/movies/six-...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>(Spicy_Nana, read_listen_think, WordsinaWhisper)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.google.com/amp/s/www.dailymail.co....</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>(lesbanems, CrustyJohnson, XXAzeritsXx)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://youtu.be/1khEVKpz6Qw</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>(driverishere, _Pupa)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://mosesfarrow.blogspot.com/2018/05/a-son-...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>(jamieliddellthepoet, BananeVolante)</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>258</th>\n",
       "      <td>https://www.youtube.com/watch?v=F7Ntg58uKvc</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(sloppy_swish,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>https://youtu.be/w69z6iV-jL0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(Rrdro,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>https://en.wikipedia.org/wiki/Morals_clause</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(h0nest_Bender,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>https://www.standard.co.uk/news/uk/johnny-depp...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(CaptFeelsBad,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>https://reddit.com/mhwaic</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(CelebBattleVoteBot,)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>263 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  link  count  n_users  \\\n",
       "0    https://www.judiciary.uk/wp-content/uploads/20...      5        3   \n",
       "1    https://www.nytimes.com/2005/09/18/movies/six-...      3        3   \n",
       "2    https://www.google.com/amp/s/www.dailymail.co....      3        3   \n",
       "3                         https://youtu.be/1khEVKpz6Qw      2        2   \n",
       "4    http://mosesfarrow.blogspot.com/2018/05/a-son-...      2        2   \n",
       "..                                                 ...    ...      ...   \n",
       "258        https://www.youtube.com/watch?v=F7Ntg58uKvc      1        1   \n",
       "259                       https://youtu.be/w69z6iV-jL0      1        1   \n",
       "260        https://en.wikipedia.org/wiki/Morals_clause      1        1   \n",
       "261  https://www.standard.co.uk/news/uk/johnny-depp...      1        1   \n",
       "262                          https://reddit.com/mhwaic      1        1   \n",
       "\n",
       "                                                users  \n",
       "0                   (zebbielm12, pecrh001, faithle55)  \n",
       "1    (Spicy_Nana, read_listen_think, WordsinaWhisper)  \n",
       "2             (lesbanems, CrustyJohnson, XXAzeritsXx)  \n",
       "3                               (driverishere, _Pupa)  \n",
       "4                (jamieliddellthepoet, BananeVolante)  \n",
       "..                                                ...  \n",
       "258                                   (sloppy_swish,)  \n",
       "259                                          (Rrdro,)  \n",
       "260                                  (h0nest_Bender,)  \n",
       "261                                   (CaptFeelsBad,)  \n",
       "262                             (CelebBattleVoteBot,)  \n",
       "\n",
       "[263 rows x 4 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddit_4_months_urls_1_link_ith_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "cfea84ec",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_4_months_urls_1_link_ith_users_count[\"n_urls\"] = 1\n",
    "df_reddit_4_months_urls_1_link_ith_users_count[\n",
    "    \"n_urls\"\n",
    "] = df_reddit_4_months_urls_1_link_ith_users_count[\"n_urls\"].apply(lambda x: {x})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "be71c4a9",
   "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.judiciary.uk/wp-content/uploads/20...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>(zebbielm12, pecrh001, faithle55)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://www.nytimes.com/2005/09/18/movies/six-...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>(Spicy_Nana, read_listen_think, WordsinaWhisper)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.google.com/amp/s/www.dailymail.co....</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>(lesbanems, CrustyJohnson, XXAzeritsXx)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://youtu.be/1khEVKpz6Qw</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>(driverishere, _Pupa)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://mosesfarrow.blogspot.com/2018/05/a-son-...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>(jamieliddellthepoet, BananeVolante)</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>258</th>\n",
       "      <td>https://www.youtube.com/watch?v=F7Ntg58uKvc</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(sloppy_swish,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>https://youtu.be/w69z6iV-jL0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(Rrdro,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>https://en.wikipedia.org/wiki/Morals_clause</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(h0nest_Bender,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>https://www.standard.co.uk/news/uk/johnny-depp...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(CaptFeelsBad,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>https://reddit.com/mhwaic</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(CelebBattleVoteBot,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>263 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  link  count  n_users  \\\n",
       "0    https://www.judiciary.uk/wp-content/uploads/20...      5        3   \n",
       "1    https://www.nytimes.com/2005/09/18/movies/six-...      3        3   \n",
       "2    https://www.google.com/amp/s/www.dailymail.co....      3        3   \n",
       "3                         https://youtu.be/1khEVKpz6Qw      2        2   \n",
       "4    http://mosesfarrow.blogspot.com/2018/05/a-son-...      2        2   \n",
       "..                                                 ...    ...      ...   \n",
       "258        https://www.youtube.com/watch?v=F7Ntg58uKvc      1        1   \n",
       "259                       https://youtu.be/w69z6iV-jL0      1        1   \n",
       "260        https://en.wikipedia.org/wiki/Morals_clause      1        1   \n",
       "261  https://www.standard.co.uk/news/uk/johnny-depp...      1        1   \n",
       "262                          https://reddit.com/mhwaic      1        1   \n",
       "\n",
       "                                                users n_urls  \n",
       "0                   (zebbielm12, pecrh001, faithle55)    {1}  \n",
       "1    (Spicy_Nana, read_listen_think, WordsinaWhisper)    {1}  \n",
       "2             (lesbanems, CrustyJohnson, XXAzeritsXx)    {1}  \n",
       "3                               (driverishere, _Pupa)    {1}  \n",
       "4                (jamieliddellthepoet, BananeVolante)    {1}  \n",
       "..                                                ...    ...  \n",
       "258                                   (sloppy_swish,)    {1}  \n",
       "259                                          (Rrdro,)    {1}  \n",
       "260                                  (h0nest_Bender,)    {1}  \n",
       "261                                   (CaptFeelsBad,)    {1}  \n",
       "262                             (CelebBattleVoteBot,)    {1}  \n",
       "\n",
       "[263 rows x 5 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddit_4_months_urls_1_link_ith_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "26131532",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df_reddit_4_months_urls_1_link_ith_users_count.to_csv(\n",
    "#     reddit_filter_path\n",
    "#     + \"df_reddits_4_months_urls_1_link.csv\",\n",
    "#     index=False,\n",
    "# )"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b9c23edf",
   "metadata": {},
   "source": [
    "<a id='more4'></a>\n",
    "#### More Than One Link\n",
    "\n",
    "><ul>\n",
    " <li><a href=\"#one4\">One Link</a></li>\n",
    " <li><a href=\"#more4\">More Than One Link</a></li>  \n",
    "\n",
    " </ul>\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "37561631",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddits_4_months_urls_more = df_more_than_link(df_reddit_4_months_urls)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "42325750",
   "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>_index</th>\n",
       "      <th>_type</th>\n",
       "      <th>_id</th>\n",
       "      <th>_score</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>permalink</th>\n",
       "      <th>text</th>\n",
       "      <th>parent_id</th>\n",
       "      <th>subreddit</th>\n",
       "      <th>author</th>\n",
       "      <th>created_at</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>sentiment_blob</th>\n",
       "      <th>sentiment_nltk</th>\n",
       "      <th>urls</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>fVa2ZnoBZsCJ_ScUHttR</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gljbkro</td>\n",
       "      <td>t1_gljbkro</td>\n",
       "      <td>/r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...</td>\n",
       "      <td>###[View link](https://redditsave.com/info?url...</td>\n",
       "      <td>t1_gljbk4n</td>\n",
       "      <td>r/TIHI</td>\n",
       "      <td>SaveVideo</td>\n",
       "      <td>2021-01-31 23:52:31+00:00</td>\n",
       "      <td>[{'display_url': 'https://redditsave.com'}, {'...</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://redditsave.com/info?url=/r/TIHI/comme...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>fla2ZnoBZsCJ_ScUHttX</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gljbmw0</td>\n",
       "      <td>t1_gljbmw0</td>\n",
       "      <td>/r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...</td>\n",
       "      <td>Here's a sneak peek of /r/Hornyjail using the ...</td>\n",
       "      <td>t1_gljblnw</td>\n",
       "      <td>r/TIHI</td>\n",
       "      <td>sneakpeekbot</td>\n",
       "      <td>2021-01-31 23:52:59+00:00</td>\n",
       "      <td>[{'display_url': 'https://np.reddit.com'}, {'d...</td>\n",
       "      <td>Negative</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://np.reddit.com/r/Hornyjail/top/?sort=t...</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   _index _type                   _id  _score       id        name  \\\n",
       "0  reddit  _doc  fVa2ZnoBZsCJ_ScUHttR     1.0  gljbkro  t1_gljbkro   \n",
       "1  reddit  _doc  fla2ZnoBZsCJ_ScUHttX     1.0  gljbmw0  t1_gljbmw0   \n",
       "\n",
       "                                           permalink  \\\n",
       "0  /r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...   \n",
       "1  /r/TIHI/comments/l9bdw3/thanks_i_hate_johnny_d...   \n",
       "\n",
       "                                                text   parent_id subreddit  \\\n",
       "0  ###[View link](https://redditsave.com/info?url...  t1_gljbk4n    r/TIHI   \n",
       "1  Here's a sneak peek of /r/Hornyjail using the ...  t1_gljblnw    r/TIHI   \n",
       "\n",
       "         author                 created_at  \\\n",
       "0     SaveVideo  2021-01-31 23:52:31+00:00   \n",
       "1  sneakpeekbot  2021-01-31 23:52:59+00:00   \n",
       "\n",
       "                                       entities.urls sentiment_blob  \\\n",
       "0  [{'display_url': 'https://redditsave.com'}, {'...        Neutral   \n",
       "1  [{'display_url': 'https://np.reddit.com'}, {'d...       Negative   \n",
       "\n",
       "  sentiment_nltk                                               urls  n_urls  \n",
       "0        Neutral  [https://redditsave.com/info?url=/r/TIHI/comme...       6  \n",
       "1        Neutral  [https://np.reddit.com/r/Hornyjail/top/?sort=t...      10  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddits_4_months_urls_more.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "01c0b1cb",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddits_4_months_urls_more_link_with_users_count = more_than_one_link_with_count_(\n",
    "    df_reddits_4_months_urls_more, \"author\", \"urls\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "871b3f3d",
   "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://redditsave.com/info?url=/r/TIHI/commen...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{SaveVideo}</td>\n",
       "      <td>{6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://np.reddit.com/user/SaveVideo/comments/...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{SaveVideo}</td>\n",
       "      <td>{6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://np.reddit.com/message/compose/?to=Kryp...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>{GetVideoBot, SaveVideo}</td>\n",
       "      <td>{5, 6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://ko-fi.com/getvideo</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>{GetVideoBot, SaveVideo}</td>\n",
       "      <td>{5, 6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://np.reddit.com/message/compose/?to=Kryp...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>{GetVideoBot, SaveVideo}</td>\n",
       "      <td>{5, 6}</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>399</th>\n",
       "      <td>https://www.reddit.com/r/FamosasGostosas</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{4}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>400</th>\n",
       "      <td>https://www.reddit.com/r/Rebolando_</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{4}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>401</th>\n",
       "      <td>https://www.reddit.com/r/FamosasGostosas/w/rules</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{4}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>https://redditsave.com/info?url=https://www.re...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{4}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>https://www.youtube.com/watch?app=desktop&amp;v=Cg...</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>{b---l-_-l---d}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>404 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  link  count  n_users  \\\n",
       "0    https://redditsave.com/info?url=/r/TIHI/commen...      1        1   \n",
       "1    https://np.reddit.com/user/SaveVideo/comments/...      1        1   \n",
       "2    https://np.reddit.com/message/compose/?to=Kryp...      2        2   \n",
       "3                           https://ko-fi.com/getvideo      2        2   \n",
       "4    https://np.reddit.com/message/compose/?to=Kryp...      2        2   \n",
       "..                                                 ...    ...      ...   \n",
       "399           https://www.reddit.com/r/FamosasGostosas      1        1   \n",
       "400                https://www.reddit.com/r/Rebolando_      1        1   \n",
       "401   https://www.reddit.com/r/FamosasGostosas/w/rules      1        1   \n",
       "402  https://redditsave.com/info?url=https://www.re...      1        1   \n",
       "403  https://www.youtube.com/watch?app=desktop&v=Cg...      2        1   \n",
       "\n",
       "                        users  n_urls  \n",
       "0                 {SaveVideo}     {6}  \n",
       "1                 {SaveVideo}     {6}  \n",
       "2    {GetVideoBot, SaveVideo}  {5, 6}  \n",
       "3    {GetVideoBot, SaveVideo}  {5, 6}  \n",
       "4    {GetVideoBot, SaveVideo}  {5, 6}  \n",
       "..                        ...     ...  \n",
       "399           {AutoModerator}     {4}  \n",
       "400           {AutoModerator}     {4}  \n",
       "401           {AutoModerator}     {4}  \n",
       "402           {AutoModerator}     {4}  \n",
       "403           {b---l-_-l---d}     {2}  \n",
       "\n",
       "[404 rows x 5 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddits_4_months_urls_more_link_with_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "54718199",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddits_4_months_urls_with_users_count = pd.concat(\n",
    "    [\n",
    "        df_reddit_4_months_urls_1_link_ith_users_count,\n",
    "        df_reddits_4_months_urls_more_link_with_users_count,\n",
    "    ]\n",
    ").sort_values(\"count\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "f689fc99",
   "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>24</th>\n",
       "      <td>https://jerkofftocelebs.com/</td>\n",
       "      <td>139</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{4, 5, 6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://discord.gg/FMhrH2j</td>\n",
       "      <td>139</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{4, 5, 6}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            link  count  n_users            users     n_urls\n",
       "24  https://jerkofftocelebs.com/    139        1  {AutoModerator}  {4, 5, 6}\n",
       "25    https://discord.gg/FMhrH2j    139        1  {AutoModerator}  {4, 5, 6}"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddits_4_months_urls_with_users_count.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "7048c88b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddits_4_months_urls_with_users_count.to_csv(\n",
    "    reddit_data_path + \"df_reddits_4_months_urls_with_users_count.csv\",\n",
    "    index=False,\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f92b6f3a",
   "metadata": {},
   "source": [
    "### December\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": 46,
   "id": "8e909624",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_dec = pd.read_csv(reddit_filter_path + \"reddits_dec.csv\" )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "4996582f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_dec[\"urls\"] = df_reddit_dec.text.astype(str).apply(\n",
    "    lambda x: get_urls(\n",
    "        str(x).replace(\"[\", \" \").replace(\"]\", \" \").replace(\"(\", \" \").replace(\")\", \" \")\n",
    "    )\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "0f5594ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_dec[\"n_urls\"] = df_reddit_dec.urls.apply(lambda x: len(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "0cf8ce5e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_dec_urls = urls_df(df_reddit_dec)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "19a90542",
   "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>_index</th>\n",
       "      <th>_type</th>\n",
       "      <th>_id</th>\n",
       "      <th>_score</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>permalink</th>\n",
       "      <th>text</th>\n",
       "      <th>parent_id</th>\n",
       "      <th>subreddit</th>\n",
       "      <th>author</th>\n",
       "      <th>created_at</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>sentiment_blob</th>\n",
       "      <th>sentiment_nltk</th>\n",
       "      <th>urls</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>KlbLZnoBZsCJ_ScUdu6b</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghmy7as</td>\n",
       "      <td>t1_ghmy7as</td>\n",
       "      <td>/r/AskReddit/comments/knx3g5/people_who_were_v...</td>\n",
       "      <td>**Attention! [Serious] Tag Notice**\\n\\n* Jokes...</td>\n",
       "      <td>t3_knx3g5</td>\n",
       "      <td>r/AskReddit</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2020-12-31 20:09:48+00:00</td>\n",
       "      <td>[{'display_url': 'https://www.rainn.org'}, {'d...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://www.rainn.org/about-national-sexual-a...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>N1bLZnoBZsCJ_ScUhe6J</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghm0lpd</td>\n",
       "      <td>t1_ghm0lpd</td>\n",
       "      <td>/r/Celebhub/comments/knrnyq/amber_heard/ghm0lpd/</td>\n",
       "      <td>Make sure to follow our community guidelines.\\...</td>\n",
       "      <td>t3_knrnyq</td>\n",
       "      <td>r/Celebhub</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2020-12-31 15:14:29+00:00</td>\n",
       "      <td>[{'display_url': 'https://redd.it'}, {'display...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Positive</td>\n",
       "      <td>[https://redd.it/e0a4mn, https://www.instagram...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>SFbLZnoBZsCJ_ScUuO66</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghml9xi</td>\n",
       "      <td>t1_ghml9xi</td>\n",
       "      <td>/r/DCEUboners/comments/knv14h/amber_heard/ghml...</td>\n",
       "      <td>[mp4 link](https://preview.redd.it/p2wcbwuidk8...</td>\n",
       "      <td>t3_knv14h</td>\n",
       "      <td>r/DCEUboners</td>\n",
       "      <td>anti-gif-bot</td>\n",
       "      <td>2020-12-31 18:16:05+00:00</td>\n",
       "      <td>[{'display_url': 'https://preview.redd.it'}, {...</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://preview.redd.it/p2wcbwuidk861.gif?for...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>VlbMZnoBZsCJ_ScUCO4R</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghjddhj</td>\n",
       "      <td>t1_ghjddhj</td>\n",
       "      <td>/r/SubredditDrama/comments/knay25/rdc_cinemati...</td>\n",
       "      <td>If SRD is a smugness LARP, does that make [mod...</td>\n",
       "      <td>t3_knay25</td>\n",
       "      <td>r/SubredditDrama</td>\n",
       "      <td>SnapshillBot</td>\n",
       "      <td>2020-12-30 21:15:57+00:00</td>\n",
       "      <td>[{'display_url': 'https://i.imgur.com'}, {'dis...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Negative</td>\n",
       "      <td>[https://i.imgur.com/njajazj.png, https://web....</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>dFbMZnoBZsCJ_ScUCO6p</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghjxix9</td>\n",
       "      <td>t1_ghjxix9</td>\n",
       "      <td>/r/SubredditDrama/comments/knay25/rdc_cinemati...</td>\n",
       "      <td>How could that movie have possibly been so bla...</td>\n",
       "      <td>t1_ghjgpqv</td>\n",
       "      <td>r/SubredditDrama</td>\n",
       "      <td>SpitefulShrimp</td>\n",
       "      <td>2020-12-31 00:07:01+00:00</td>\n",
       "      <td>[{'display_url': 'https://news.sky.com'}]</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Positive</td>\n",
       "      <td>[https://news.sky.com/story/children-accidenta...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   _index _type                   _id  _score       id        name  \\\n",
       "0  reddit  _doc  KlbLZnoBZsCJ_ScUdu6b     1.0  ghmy7as  t1_ghmy7as   \n",
       "1  reddit  _doc  N1bLZnoBZsCJ_ScUhe6J     1.0  ghm0lpd  t1_ghm0lpd   \n",
       "2  reddit  _doc  SFbLZnoBZsCJ_ScUuO66     1.0  ghml9xi  t1_ghml9xi   \n",
       "3  reddit  _doc  VlbMZnoBZsCJ_ScUCO4R     1.0  ghjddhj  t1_ghjddhj   \n",
       "4  reddit  _doc  dFbMZnoBZsCJ_ScUCO6p     1.0  ghjxix9  t1_ghjxix9   \n",
       "\n",
       "                                           permalink  \\\n",
       "0  /r/AskReddit/comments/knx3g5/people_who_were_v...   \n",
       "1   /r/Celebhub/comments/knrnyq/amber_heard/ghm0lpd/   \n",
       "2  /r/DCEUboners/comments/knv14h/amber_heard/ghml...   \n",
       "3  /r/SubredditDrama/comments/knay25/rdc_cinemati...   \n",
       "4  /r/SubredditDrama/comments/knay25/rdc_cinemati...   \n",
       "\n",
       "                                                text   parent_id  \\\n",
       "0  **Attention! [Serious] Tag Notice**\\n\\n* Jokes...   t3_knx3g5   \n",
       "1  Make sure to follow our community guidelines.\\...   t3_knrnyq   \n",
       "2  [mp4 link](https://preview.redd.it/p2wcbwuidk8...   t3_knv14h   \n",
       "3  If SRD is a smugness LARP, does that make [mod...   t3_knay25   \n",
       "4  How could that movie have possibly been so bla...  t1_ghjgpqv   \n",
       "\n",
       "          subreddit          author                 created_at  \\\n",
       "0       r/AskReddit   AutoModerator  2020-12-31 20:09:48+00:00   \n",
       "1        r/Celebhub   AutoModerator  2020-12-31 15:14:29+00:00   \n",
       "2      r/DCEUboners    anti-gif-bot  2020-12-31 18:16:05+00:00   \n",
       "3  r/SubredditDrama    SnapshillBot  2020-12-30 21:15:57+00:00   \n",
       "4  r/SubredditDrama  SpitefulShrimp  2020-12-31 00:07:01+00:00   \n",
       "\n",
       "                                       entities.urls sentiment_blob  \\\n",
       "0  [{'display_url': 'https://www.rainn.org'}, {'d...       Positive   \n",
       "1  [{'display_url': 'https://redd.it'}, {'display...       Positive   \n",
       "2  [{'display_url': 'https://preview.redd.it'}, {...        Neutral   \n",
       "3  [{'display_url': 'https://i.imgur.com'}, {'dis...       Positive   \n",
       "4          [{'display_url': 'https://news.sky.com'}]       Positive   \n",
       "\n",
       "  sentiment_nltk                                               urls  n_urls  \n",
       "0        Neutral  [https://www.rainn.org/about-national-sexual-a...       6  \n",
       "1       Positive  [https://redd.it/e0a4mn, https://www.instagram...       2  \n",
       "2        Neutral  [https://preview.redd.it/p2wcbwuidk861.gif?for...       4  \n",
       "3       Negative  [https://i.imgur.com/njajazj.png, https://web....      11  \n",
       "4       Positive  [https://news.sky.com/story/children-accidenta...       1  "
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddit_dec_urls.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "53223395",
   "metadata": {},
   "outputs": [],
   "source": [
    "# save data\n",
    "df_reddit_dec_urls.to_csv(\n",
    "    reddit_data_path + \"df_reddits_dec_urls.csv\", index=False\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e386243e",
   "metadata": {},
   "source": [
    "<a id='one12'></a>\n",
    "#### One Link\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>\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "430b3825",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_dec_urls_1_link = one_link_df(df_reddit_dec_urls)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "eb6ec772",
   "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>_index</th>\n",
       "      <th>_type</th>\n",
       "      <th>_id</th>\n",
       "      <th>_score</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>permalink</th>\n",
       "      <th>text</th>\n",
       "      <th>parent_id</th>\n",
       "      <th>subreddit</th>\n",
       "      <th>author</th>\n",
       "      <th>created_at</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>sentiment_blob</th>\n",
       "      <th>sentiment_nltk</th>\n",
       "      <th>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>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>dFbMZnoBZsCJ_ScUCO6p</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghjxix9</td>\n",
       "      <td>t1_ghjxix9</td>\n",
       "      <td>/r/SubredditDrama/comments/knay25/rdc_cinemati...</td>\n",
       "      <td>How could that movie have possibly been so bla...</td>\n",
       "      <td>t1_ghjgpqv</td>\n",
       "      <td>r/SubredditDrama</td>\n",
       "      <td>SpitefulShrimp</td>\n",
       "      <td>2020-12-31 00:07:01+00:00</td>\n",
       "      <td>[{'display_url': 'https://news.sky.com'}]</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Positive</td>\n",
       "      <td>[https://news.sky.com/story/children-accidenta...</td>\n",
       "      <td>1</td>\n",
       "      <td>https://news.sky.com/story/children-accidental...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   _index _type                   _id  _score       id        name  \\\n",
       "0  reddit  _doc  dFbMZnoBZsCJ_ScUCO6p     1.0  ghjxix9  t1_ghjxix9   \n",
       "\n",
       "                                           permalink  \\\n",
       "0  /r/SubredditDrama/comments/knay25/rdc_cinemati...   \n",
       "\n",
       "                                                text   parent_id  \\\n",
       "0  How could that movie have possibly been so bla...  t1_ghjgpqv   \n",
       "\n",
       "          subreddit          author                 created_at  \\\n",
       "0  r/SubredditDrama  SpitefulShrimp  2020-12-31 00:07:01+00:00   \n",
       "\n",
       "                               entities.urls sentiment_blob sentiment_nltk  \\\n",
       "0  [{'display_url': 'https://news.sky.com'}]       Positive       Positive   \n",
       "\n",
       "                                                urls  n_urls  \\\n",
       "0  [https://news.sky.com/story/children-accidenta...       1   \n",
       "\n",
       "                                                 url  \n",
       "0  https://news.sky.com/story/children-accidental...  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddit_dec_urls_1_link.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "0c6ff838",
   "metadata": {},
   "outputs": [],
   "source": [
    "list_reddit_dec_urls_1_link = one_link_urls(df_reddit_dec_urls_1_link)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "29c0e894",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_dec_urls_1_link_ith_users_count = one_link_urls_with_count_(\n",
    "    df_reddit_dec_urls_1_link, user_column=\"author\", url_column=\"url\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "92901846",
   "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.hollywoodreporter.com/features/hes...</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>(Chicken-n-Waffles, Baramos_, Poppin_Fresh_Bro...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://youtu.be/uretrfMA-Io</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>(n4pth4, Snow_blind1211, mastercontroversy, ID...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-79477...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>(Wolfe244, Runyc2000, HipsterBrewfus, Wanderlo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.judiciary.uk/judgments/depp-v-news...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>(faithle55, yo_bandit, monsieuremilie)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://youtu.be/XiuUzvZMyro</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>(Nesrovlah26, sarahtookthekids, BraxHecker)</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>150</th>\n",
       "      <td>https://old.reddit.com/message/compose?to=%2Fr...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(AutoModerator,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>https://reddit.com/kel08m</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(CelebBattleVoteBot,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>https://greatnonprofits.org/categories/view/do...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(Hundifer,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>https://m.ranker.com/list/celebrities-charged-...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(arm-n-hammerinmycoke,)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>https://youtu.be/mUclMrpr6UU</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(Swat4584,)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>155 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  link  count  n_users  \\\n",
       "0    https://www.hollywoodreporter.com/features/hes...      7        6   \n",
       "1                         https://youtu.be/uretrfMA-Io      7        6   \n",
       "2    https://www.dailymail.co.uk/news/article-79477...      4        4   \n",
       "3    https://www.judiciary.uk/judgments/depp-v-news...      7        3   \n",
       "4                         https://youtu.be/XiuUzvZMyro      5        3   \n",
       "..                                                 ...    ...      ...   \n",
       "150  https://old.reddit.com/message/compose?to=%2Fr...      1        1   \n",
       "151                          https://reddit.com/kel08m      1        1   \n",
       "152  https://greatnonprofits.org/categories/view/do...      1        1   \n",
       "153  https://m.ranker.com/list/celebrities-charged-...      1        1   \n",
       "154                       https://youtu.be/mUclMrpr6UU      1        1   \n",
       "\n",
       "                                                 users  \n",
       "0    (Chicken-n-Waffles, Baramos_, Poppin_Fresh_Bro...  \n",
       "1    (n4pth4, Snow_blind1211, mastercontroversy, ID...  \n",
       "2    (Wolfe244, Runyc2000, HipsterBrewfus, Wanderlo...  \n",
       "3               (faithle55, yo_bandit, monsieuremilie)  \n",
       "4          (Nesrovlah26, sarahtookthekids, BraxHecker)  \n",
       "..                                                 ...  \n",
       "150                                   (AutoModerator,)  \n",
       "151                              (CelebBattleVoteBot,)  \n",
       "152                                        (Hundifer,)  \n",
       "153                            (arm-n-hammerinmycoke,)  \n",
       "154                                        (Swat4584,)  \n",
       "\n",
       "[155 rows x 4 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddit_dec_urls_1_link_ith_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "5e79bd22",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddit_dec_urls_1_link_ith_users_count[\"n_urls\"] = 1\n",
    "df_reddit_dec_urls_1_link_ith_users_count[\n",
    "    \"n_urls\"\n",
    "] = df_reddit_dec_urls_1_link_ith_users_count[\"n_urls\"].apply(lambda x: {x})"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5153bda7",
   "metadata": {},
   "source": [
    "<a id='more4'></a>\n",
    "#### More Than One Link\n",
    "\n",
    "><ul>\n",
    " <li><a href=\"#one4\">One Link</a></li>\n",
    " <li><a href=\"#more4\">More Than One Link</a></li>  \n",
    "\n",
    " </ul>\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "7a61bfe7",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddits_dec_urls_urls_more = df_more_than_link(df_reddit_dec_urls)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "c64fbcec",
   "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>_index</th>\n",
       "      <th>_type</th>\n",
       "      <th>_id</th>\n",
       "      <th>_score</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>permalink</th>\n",
       "      <th>text</th>\n",
       "      <th>parent_id</th>\n",
       "      <th>subreddit</th>\n",
       "      <th>author</th>\n",
       "      <th>created_at</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>sentiment_blob</th>\n",
       "      <th>sentiment_nltk</th>\n",
       "      <th>urls</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>KlbLZnoBZsCJ_ScUdu6b</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghmy7as</td>\n",
       "      <td>t1_ghmy7as</td>\n",
       "      <td>/r/AskReddit/comments/knx3g5/people_who_were_v...</td>\n",
       "      <td>**Attention! [Serious] Tag Notice**\\n\\n* Jokes...</td>\n",
       "      <td>t3_knx3g5</td>\n",
       "      <td>r/AskReddit</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2020-12-31 20:09:48+00:00</td>\n",
       "      <td>[{'display_url': 'https://www.rainn.org'}, {'d...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://www.rainn.org/about-national-sexual-a...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>N1bLZnoBZsCJ_ScUhe6J</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghm0lpd</td>\n",
       "      <td>t1_ghm0lpd</td>\n",
       "      <td>/r/Celebhub/comments/knrnyq/amber_heard/ghm0lpd/</td>\n",
       "      <td>Make sure to follow our community guidelines.\\...</td>\n",
       "      <td>t3_knrnyq</td>\n",
       "      <td>r/Celebhub</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2020-12-31 15:14:29+00:00</td>\n",
       "      <td>[{'display_url': 'https://redd.it'}, {'display...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Positive</td>\n",
       "      <td>[https://redd.it/e0a4mn, https://www.instagram...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   _index _type                   _id  _score       id        name  \\\n",
       "0  reddit  _doc  KlbLZnoBZsCJ_ScUdu6b     1.0  ghmy7as  t1_ghmy7as   \n",
       "1  reddit  _doc  N1bLZnoBZsCJ_ScUhe6J     1.0  ghm0lpd  t1_ghm0lpd   \n",
       "\n",
       "                                           permalink  \\\n",
       "0  /r/AskReddit/comments/knx3g5/people_who_were_v...   \n",
       "1   /r/Celebhub/comments/knrnyq/amber_heard/ghm0lpd/   \n",
       "\n",
       "                                                text  parent_id    subreddit  \\\n",
       "0  **Attention! [Serious] Tag Notice**\\n\\n* Jokes...  t3_knx3g5  r/AskReddit   \n",
       "1  Make sure to follow our community guidelines.\\...  t3_knrnyq   r/Celebhub   \n",
       "\n",
       "          author                 created_at  \\\n",
       "0  AutoModerator  2020-12-31 20:09:48+00:00   \n",
       "1  AutoModerator  2020-12-31 15:14:29+00:00   \n",
       "\n",
       "                                       entities.urls sentiment_blob  \\\n",
       "0  [{'display_url': 'https://www.rainn.org'}, {'d...       Positive   \n",
       "1  [{'display_url': 'https://redd.it'}, {'display...       Positive   \n",
       "\n",
       "  sentiment_nltk                                               urls  n_urls  \n",
       "0        Neutral  [https://www.rainn.org/about-national-sexual-a...       6  \n",
       "1       Positive  [https://redd.it/e0a4mn, https://www.instagram...       2  "
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddits_dec_urls_urls_more.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "0311375e",
   "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>_index</th>\n",
       "      <th>_type</th>\n",
       "      <th>_id</th>\n",
       "      <th>_score</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>permalink</th>\n",
       "      <th>text</th>\n",
       "      <th>parent_id</th>\n",
       "      <th>subreddit</th>\n",
       "      <th>author</th>\n",
       "      <th>created_at</th>\n",
       "      <th>entities.urls</th>\n",
       "      <th>sentiment_blob</th>\n",
       "      <th>sentiment_nltk</th>\n",
       "      <th>urls</th>\n",
       "      <th>n_urls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>KlbLZnoBZsCJ_ScUdu6b</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghmy7as</td>\n",
       "      <td>t1_ghmy7as</td>\n",
       "      <td>/r/AskReddit/comments/knx3g5/people_who_were_v...</td>\n",
       "      <td>**Attention! [Serious] Tag Notice**\\n\\n* Jokes...</td>\n",
       "      <td>t3_knx3g5</td>\n",
       "      <td>r/AskReddit</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2020-12-31 20:09:48+00:00</td>\n",
       "      <td>[{'display_url': 'https://www.rainn.org'}, {'d...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://www.rainn.org/about-national-sexual-a...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>N1bLZnoBZsCJ_ScUhe6J</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghm0lpd</td>\n",
       "      <td>t1_ghm0lpd</td>\n",
       "      <td>/r/Celebhub/comments/knrnyq/amber_heard/ghm0lpd/</td>\n",
       "      <td>Make sure to follow our community guidelines.\\...</td>\n",
       "      <td>t3_knrnyq</td>\n",
       "      <td>r/Celebhub</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2020-12-31 15:14:29+00:00</td>\n",
       "      <td>[{'display_url': 'https://redd.it'}, {'display...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Positive</td>\n",
       "      <td>[https://redd.it/e0a4mn, https://www.instagram...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>SFbLZnoBZsCJ_ScUuO66</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghml9xi</td>\n",
       "      <td>t1_ghml9xi</td>\n",
       "      <td>/r/DCEUboners/comments/knv14h/amber_heard/ghml...</td>\n",
       "      <td>[mp4 link](https://preview.redd.it/p2wcbwuidk8...</td>\n",
       "      <td>t3_knv14h</td>\n",
       "      <td>r/DCEUboners</td>\n",
       "      <td>anti-gif-bot</td>\n",
       "      <td>2020-12-31 18:16:05+00:00</td>\n",
       "      <td>[{'display_url': 'https://preview.redd.it'}, {...</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://preview.redd.it/p2wcbwuidk861.gif?for...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>VlbMZnoBZsCJ_ScUCO4R</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghjddhj</td>\n",
       "      <td>t1_ghjddhj</td>\n",
       "      <td>/r/SubredditDrama/comments/knay25/rdc_cinemati...</td>\n",
       "      <td>If SRD is a smugness LARP, does that make [mod...</td>\n",
       "      <td>t3_knay25</td>\n",
       "      <td>r/SubredditDrama</td>\n",
       "      <td>SnapshillBot</td>\n",
       "      <td>2020-12-30 21:15:57+00:00</td>\n",
       "      <td>[{'display_url': 'https://i.imgur.com'}, {'dis...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Negative</td>\n",
       "      <td>[https://i.imgur.com/njajazj.png, https://web....</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>r1bMZnoBZsCJ_ScU5u_i</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ghe7ml4</td>\n",
       "      <td>t1_ghe7ml4</td>\n",
       "      <td>/r/peachykeenocean/comments/kmbx33/do_you_thin...</td>\n",
       "      <td>Johnny Depp has supported the following charit...</td>\n",
       "      <td>t1_ghe6a12</td>\n",
       "      <td>r/peachykeenocean</td>\n",
       "      <td>-banned-</td>\n",
       "      <td>2020-12-29 14:32:59+00:00</td>\n",
       "      <td>[{'display_url': 'https://www.looktothestars.o...</td>\n",
       "      <td>Negative</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://www.looktothestars.org/charity/actors...</td>\n",
       "      <td>23</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>XVfpZnoBZsCJ_ScUUBbI</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ge8eze1</td>\n",
       "      <td>t1_ge8eze1</td>\n",
       "      <td>/r/196/comments/k3x5hd/amber_heard_more_like_a...</td>\n",
       "      <td>Here's a sneak peek of /r/nicebot2 using the [...</td>\n",
       "      <td>t1_ge8eyfo</td>\n",
       "      <td>r/196</td>\n",
       "      <td>sneakpeekbot</td>\n",
       "      <td>2020-12-01 05:42:48+00:00</td>\n",
       "      <td>[{'display_url': 'https://np.reddit.com'}, {'d...</td>\n",
       "      <td>Negative</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://np.reddit.com/r/nicebot2/top/?sort=to...</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>g1fpZnoBZsCJ_ScUVxap</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ge8bjg2</td>\n",
       "      <td>t1_ge8bjg2</td>\n",
       "      <td>/r/ihaveihaveihavereddit/comments/k3x4tt/amber...</td>\n",
       "      <td>Here is your video at 4x speed\\n\\nhttps://gfyc...</td>\n",
       "      <td>t1_ge8bfgd</td>\n",
       "      <td>r/ihaveihaveihavereddit</td>\n",
       "      <td>redditspeedbot</td>\n",
       "      <td>2020-12-01 05:00:17+00:00</td>\n",
       "      <td>[{'display_url': 'https://gfycat.com'}, {'disp...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://gfycat.com/RashEssentialChihuahua, ht...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>hFfpZnoBZsCJ_ScUVxav</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ge8dfxm</td>\n",
       "      <td>t1_ge8dfxm</td>\n",
       "      <td>/r/ihaveihaveihavereddit/comments/k3x4tt/amber...</td>\n",
       "      <td>*beep. boop.* 🤖 I'm a bot that helps you downl...</td>\n",
       "      <td>t1_ge8d443</td>\n",
       "      <td>r/ihaveihaveihavereddit</td>\n",
       "      <td>downloadvideo</td>\n",
       "      <td>2020-12-01 05:23:00+00:00</td>\n",
       "      <td>[{'display_url': 'https://www.reddit.watch'}, ...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://www.reddit.watch/r/ihaveihaveihavered...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>xVfpZnoBZsCJ_ScUfhbA</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ge8cuqt</td>\n",
       "      <td>t1_ge8cuqt</td>\n",
       "      <td>/r/JerkOffToCelebs/comments/k4edo9/she_is_a_ho...</td>\n",
       "      <td>### [Browse JerkOffChallenges](https://jerkoff...</td>\n",
       "      <td>t3_k4edo9</td>\n",
       "      <td>r/JerkOffToCelebs</td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>2020-12-01 05:15:47+00:00</td>\n",
       "      <td>[{'display_url': 'https://jerkofftocelebs.com'...</td>\n",
       "      <td>Positive</td>\n",
       "      <td>Positive</td>\n",
       "      <td>[https://jerkofftocelebs.com/actors/, https://...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>reddit</td>\n",
       "      <td>_doc</td>\n",
       "      <td>aFcBZ3oBZsCJ_ScUmULv</td>\n",
       "      <td>1.0</td>\n",
       "      <td>gfd7l4q</td>\n",
       "      <td>t1_gfd7l4q</td>\n",
       "      <td>/r/Aquaman/comments/js9755/can_we_stop_with_th...</td>\n",
       "      <td>Oh... I see how it is.  \\n[https://giphy.com/g...</td>\n",
       "      <td>t3_js9755</td>\n",
       "      <td>r/Aquaman</td>\n",
       "      <td>AguamanTeeFan</td>\n",
       "      <td>2020-12-11 06:02:49+00:00</td>\n",
       "      <td>[{'display_url': 'https://giphy.com'}, {'displ...</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>[https://giphy.com/gifs/EYmAHLpw5LBbG/html5, h...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>189 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     _index _type                   _id  _score       id        name  \\\n",
       "0    reddit  _doc  KlbLZnoBZsCJ_ScUdu6b     1.0  ghmy7as  t1_ghmy7as   \n",
       "1    reddit  _doc  N1bLZnoBZsCJ_ScUhe6J     1.0  ghm0lpd  t1_ghm0lpd   \n",
       "2    reddit  _doc  SFbLZnoBZsCJ_ScUuO66     1.0  ghml9xi  t1_ghml9xi   \n",
       "3    reddit  _doc  VlbMZnoBZsCJ_ScUCO4R     1.0  ghjddhj  t1_ghjddhj   \n",
       "4    reddit  _doc  r1bMZnoBZsCJ_ScU5u_i     1.0  ghe7ml4  t1_ghe7ml4   \n",
       "..      ...   ...                   ...     ...      ...         ...   \n",
       "184  reddit  _doc  XVfpZnoBZsCJ_ScUUBbI     1.0  ge8eze1  t1_ge8eze1   \n",
       "185  reddit  _doc  g1fpZnoBZsCJ_ScUVxap     1.0  ge8bjg2  t1_ge8bjg2   \n",
       "186  reddit  _doc  hFfpZnoBZsCJ_ScUVxav     1.0  ge8dfxm  t1_ge8dfxm   \n",
       "187  reddit  _doc  xVfpZnoBZsCJ_ScUfhbA     1.0  ge8cuqt  t1_ge8cuqt   \n",
       "188  reddit  _doc  aFcBZ3oBZsCJ_ScUmULv     1.0  gfd7l4q  t1_gfd7l4q   \n",
       "\n",
       "                                             permalink  \\\n",
       "0    /r/AskReddit/comments/knx3g5/people_who_were_v...   \n",
       "1     /r/Celebhub/comments/knrnyq/amber_heard/ghm0lpd/   \n",
       "2    /r/DCEUboners/comments/knv14h/amber_heard/ghml...   \n",
       "3    /r/SubredditDrama/comments/knay25/rdc_cinemati...   \n",
       "4    /r/peachykeenocean/comments/kmbx33/do_you_thin...   \n",
       "..                                                 ...   \n",
       "184  /r/196/comments/k3x5hd/amber_heard_more_like_a...   \n",
       "185  /r/ihaveihaveihavereddit/comments/k3x4tt/amber...   \n",
       "186  /r/ihaveihaveihavereddit/comments/k3x4tt/amber...   \n",
       "187  /r/JerkOffToCelebs/comments/k4edo9/she_is_a_ho...   \n",
       "188  /r/Aquaman/comments/js9755/can_we_stop_with_th...   \n",
       "\n",
       "                                                  text   parent_id  \\\n",
       "0    **Attention! [Serious] Tag Notice**\\n\\n* Jokes...   t3_knx3g5   \n",
       "1    Make sure to follow our community guidelines.\\...   t3_knrnyq   \n",
       "2    [mp4 link](https://preview.redd.it/p2wcbwuidk8...   t3_knv14h   \n",
       "3    If SRD is a smugness LARP, does that make [mod...   t3_knay25   \n",
       "4    Johnny Depp has supported the following charit...  t1_ghe6a12   \n",
       "..                                                 ...         ...   \n",
       "184  Here's a sneak peek of /r/nicebot2 using the [...  t1_ge8eyfo   \n",
       "185  Here is your video at 4x speed\\n\\nhttps://gfyc...  t1_ge8bfgd   \n",
       "186  *beep. boop.* 🤖 I'm a bot that helps you downl...  t1_ge8d443   \n",
       "187  ### [Browse JerkOffChallenges](https://jerkoff...   t3_k4edo9   \n",
       "188  Oh... I see how it is.  \\n[https://giphy.com/g...   t3_js9755   \n",
       "\n",
       "                   subreddit          author                 created_at  \\\n",
       "0                r/AskReddit   AutoModerator  2020-12-31 20:09:48+00:00   \n",
       "1                 r/Celebhub   AutoModerator  2020-12-31 15:14:29+00:00   \n",
       "2               r/DCEUboners    anti-gif-bot  2020-12-31 18:16:05+00:00   \n",
       "3           r/SubredditDrama    SnapshillBot  2020-12-30 21:15:57+00:00   \n",
       "4          r/peachykeenocean        -banned-  2020-12-29 14:32:59+00:00   \n",
       "..                       ...             ...                        ...   \n",
       "184                    r/196    sneakpeekbot  2020-12-01 05:42:48+00:00   \n",
       "185  r/ihaveihaveihavereddit  redditspeedbot  2020-12-01 05:00:17+00:00   \n",
       "186  r/ihaveihaveihavereddit   downloadvideo  2020-12-01 05:23:00+00:00   \n",
       "187        r/JerkOffToCelebs   AutoModerator  2020-12-01 05:15:47+00:00   \n",
       "188                r/Aquaman   AguamanTeeFan  2020-12-11 06:02:49+00:00   \n",
       "\n",
       "                                         entities.urls sentiment_blob  \\\n",
       "0    [{'display_url': 'https://www.rainn.org'}, {'d...       Positive   \n",
       "1    [{'display_url': 'https://redd.it'}, {'display...       Positive   \n",
       "2    [{'display_url': 'https://preview.redd.it'}, {...        Neutral   \n",
       "3    [{'display_url': 'https://i.imgur.com'}, {'dis...       Positive   \n",
       "4    [{'display_url': 'https://www.looktothestars.o...       Negative   \n",
       "..                                                 ...            ...   \n",
       "184  [{'display_url': 'https://np.reddit.com'}, {'d...       Negative   \n",
       "185  [{'display_url': 'https://gfycat.com'}, {'disp...       Positive   \n",
       "186  [{'display_url': 'https://www.reddit.watch'}, ...       Positive   \n",
       "187  [{'display_url': 'https://jerkofftocelebs.com'...       Positive   \n",
       "188  [{'display_url': 'https://giphy.com'}, {'displ...        Neutral   \n",
       "\n",
       "    sentiment_nltk                                               urls  n_urls  \n",
       "0          Neutral  [https://www.rainn.org/about-national-sexual-a...       6  \n",
       "1         Positive  [https://redd.it/e0a4mn, https://www.instagram...       2  \n",
       "2          Neutral  [https://preview.redd.it/p2wcbwuidk861.gif?for...       4  \n",
       "3         Negative  [https://i.imgur.com/njajazj.png, https://web....      11  \n",
       "4          Neutral  [https://www.looktothestars.org/charity/actors...      23  \n",
       "..             ...                                                ...     ...  \n",
       "184        Neutral  [https://np.reddit.com/r/nicebot2/top/?sort=to...       9  \n",
       "185        Neutral  [https://gfycat.com/RashEssentialChihuahua, ht...       4  \n",
       "186        Neutral  [https://www.reddit.watch/r/ihaveihaveihavered...       4  \n",
       "187       Positive  [https://jerkofftocelebs.com/actors/, https://...       5  \n",
       "188        Neutral  [https://giphy.com/gifs/EYmAHLpw5LBbG/html5, h...       2  \n",
       "\n",
       "[189 rows x 17 columns]"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddits_dec_urls_urls_more"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "3a1a93fa",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddits_dec_urls_urls_more_with_users_count = more_than_one_link_with_count_(\n",
    "    df_reddits_dec_urls_urls_more, \"author\", \"urls\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "f47e9c23",
   "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.rainn.org/about-national-sexual-as...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://www.hotpeachpages.net/a/countries.html</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{6}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                link  count  n_users  \\\n",
       "0  https://www.rainn.org/about-national-sexual-as...      1        1   \n",
       "1      http://www.hotpeachpages.net/a/countries.html      1        1   \n",
       "\n",
       "             users n_urls  \n",
       "0  {AutoModerator}    {6}  \n",
       "1  {AutoModerator}    {6}  "
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddits_dec_urls_urls_more_with_users_count.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "0f538ed2",
   "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.hollywoodreporter.com/features/hes...</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>(Chicken-n-Waffles, Baramos_, Poppin_Fresh_Bro...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://youtu.be/uretrfMA-Io</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>(n4pth4, Snow_blind1211, mastercontroversy, ID...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.dailymail.co.uk/news/article-79477...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>(Wolfe244, Runyc2000, HipsterBrewfus, Wanderlo...</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.judiciary.uk/judgments/depp-v-news...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>(faithle55, yo_bandit, monsieuremilie)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://youtu.be/XiuUzvZMyro</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>(Nesrovlah26, sarahtookthekids, BraxHecker)</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>150</th>\n",
       "      <td>https://old.reddit.com/message/compose?to=%2Fr...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(AutoModerator,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>https://reddit.com/kel08m</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(CelebBattleVoteBot,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>https://greatnonprofits.org/categories/view/do...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(Hundifer,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>https://m.ranker.com/list/celebrities-charged-...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(arm-n-hammerinmycoke,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>https://youtu.be/mUclMrpr6UU</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(Swat4584,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>155 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  link  count  n_users  \\\n",
       "0    https://www.hollywoodreporter.com/features/hes...      7        6   \n",
       "1                         https://youtu.be/uretrfMA-Io      7        6   \n",
       "2    https://www.dailymail.co.uk/news/article-79477...      4        4   \n",
       "3    https://www.judiciary.uk/judgments/depp-v-news...      7        3   \n",
       "4                         https://youtu.be/XiuUzvZMyro      5        3   \n",
       "..                                                 ...    ...      ...   \n",
       "150  https://old.reddit.com/message/compose?to=%2Fr...      1        1   \n",
       "151                          https://reddit.com/kel08m      1        1   \n",
       "152  https://greatnonprofits.org/categories/view/do...      1        1   \n",
       "153  https://m.ranker.com/list/celebrities-charged-...      1        1   \n",
       "154                       https://youtu.be/mUclMrpr6UU      1        1   \n",
       "\n",
       "                                                 users n_urls  \n",
       "0    (Chicken-n-Waffles, Baramos_, Poppin_Fresh_Bro...    {1}  \n",
       "1    (n4pth4, Snow_blind1211, mastercontroversy, ID...    {1}  \n",
       "2    (Wolfe244, Runyc2000, HipsterBrewfus, Wanderlo...    {1}  \n",
       "3               (faithle55, yo_bandit, monsieuremilie)    {1}  \n",
       "4          (Nesrovlah26, sarahtookthekids, BraxHecker)    {1}  \n",
       "..                                                 ...    ...  \n",
       "150                                   (AutoModerator,)    {1}  \n",
       "151                              (CelebBattleVoteBot,)    {1}  \n",
       "152                                        (Hundifer,)    {1}  \n",
       "153                            (arm-n-hammerinmycoke,)    {1}  \n",
       "154                                        (Swat4584,)    {1}  \n",
       "\n",
       "[155 rows x 5 columns]"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddit_dec_urls_1_link_ith_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "ace92433",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddits_dec_urls_urls_more_with_users_count = pd.concat(\n",
    "    [\n",
    "        df_reddit_dec_urls_1_link_ith_users_count,\n",
    "        df_reddits_dec_urls_urls_more_with_users_count,\n",
    "    ]\n",
    ").sort_values(\"count\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "ae7c221c",
   "metadata": {
    "scrolled": true
   },
   "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>55</th>\n",
       "      <td>https://jerkofftocelebs.com/</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{5, 6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>https://discord.gg/FMhrH2j</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{5, 6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>https://jerkofftocelebs.com/actors/</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{5, 6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>https://jerkofftocelebs.com/pictures/</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{5, 6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>https://jerkofftocelebs.com/reddit-nsfw-list/</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>{AutoModerator}</td>\n",
       "      <td>{5, 6}</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>38</th>\n",
       "      <td>https://m.youtube.com/watch?v=Nhz9PCbnkkQ</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(PlasticPaulBunyan,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>https://en.wikipedia.org/wiki/DARVO</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(hpdefaults,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>https://www.google.com/amp/s/www.insider.com/j...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(golddragon51296,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>https://www.tmz.com/2016/08/15/johnny-depp-cut...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>(AverageLiberalJoe,)</td>\n",
       "      <td>{1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>https://youtu.be/XiuUzvZMyro</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>{Psycho8Everything}</td>\n",
       "      <td>{2}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>456 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  link  count  n_users  \\\n",
       "55                        https://jerkofftocelebs.com/     36        1   \n",
       "56                          https://discord.gg/FMhrH2j     36        1   \n",
       "52                 https://jerkofftocelebs.com/actors/     35        1   \n",
       "53               https://jerkofftocelebs.com/pictures/     35        1   \n",
       "57       https://jerkofftocelebs.com/reddit-nsfw-list/     35        1   \n",
       "..                                                 ...    ...      ...   \n",
       "38           https://m.youtube.com/watch?v=Nhz9PCbnkkQ      1        1   \n",
       "39                 https://en.wikipedia.org/wiki/DARVO      1        1   \n",
       "40   https://www.google.com/amp/s/www.insider.com/j...      1        1   \n",
       "41   https://www.tmz.com/2016/08/15/johnny-depp-cut...      1        1   \n",
       "101                       https://youtu.be/XiuUzvZMyro      1        1   \n",
       "\n",
       "                    users  n_urls  \n",
       "55        {AutoModerator}  {5, 6}  \n",
       "56        {AutoModerator}  {5, 6}  \n",
       "52        {AutoModerator}  {5, 6}  \n",
       "53        {AutoModerator}  {5, 6}  \n",
       "57        {AutoModerator}  {5, 6}  \n",
       "..                    ...     ...  \n",
       "38   (PlasticPaulBunyan,)     {1}  \n",
       "39          (hpdefaults,)     {1}  \n",
       "40     (golddragon51296,)     {1}  \n",
       "41   (AverageLiberalJoe,)     {1}  \n",
       "101   {Psycho8Everything}     {2}  \n",
       "\n",
       "[456 rows x 5 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_reddits_dec_urls_urls_more_with_users_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "7d60f0cc",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reddits_dec_urls_urls_more_with_users_count.to_csv(\n",
    "    reddit_data_path + \"df_reddits_dec_urls_urls_more_with_users_count.csv\", index=False\n",
    ")"
   ]
  }
 ],
 "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
}