Tweeb-Data-Wrangling.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:42:39.370911680Z",
     "start_time": "2024-04-11T08:42:39.333555802Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import re\n",
    "from bs4 import BeautifulSoup\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "source": [
    "## Requirements\n",
    "As we're creating a Job Vacancies App our requirements are\n",
    "1. Links to the twitter Posts\n",
    "2. Links to the actual websites where the job vacancies are posted\n",
    "3. The job title\n",
    "4. The company name\n",
    "5. User who posted the job\n",
    "6. Date/Time at which the job is posted\n",
    "7. Spread Factor(A gradient of how many people are talking about the job) Out of 10, based on retweets, likes and followers\n",
    "8. Source where the job is posted\n",
    "9. Text of the Tweet\n",
    "10. Hashtags used in the tweet\n",
    "11. Location of the job\n",
    "12. Verified or Not"
   ],
   "metadata": {
    "collapsed": false
   },
   "id": "96218b943c8a2ed6"
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "data": {
      "text/plain": "                    ID                  Timestamp             User  \\\n0  1211798864656769025  2019-12-30 23:58:58+00:00         SipapuNM   \n1  1211797371853705220  2019-12-30 23:53:02+00:00       LorettaOD1   \n2  1211795775363145728  2019-12-30 23:46:41+00:00  guajardo_celina   \n3  1211793355060981767  2019-12-30 23:37:04+00:00  SteveEckert_OTD   \n4  1211792689022349315  2019-12-30 23:34:25+00:00         HireLive   \n5  1211792528388841473  2019-12-30 23:33:47+00:00         HireLive   \n6  1211791693005099008  2019-12-30 23:30:28+00:00         HireLive   \n7  1211790931772477440  2019-12-30 23:27:26+00:00         HireLive   \n8  1211789520473079809  2019-12-30 23:21:50+00:00          PRGWest   \n9  1211788232620412929  2019-12-30 23:16:43+00:00           GhLisa   \n\n                                                Text  \\\n0  Looking for an exciting job where you can ski ...   \n1  Hail in Phoenix - no way!  New opportunity at ...   \n2  Rackspace is hiring! We are looking for Nation...   \n3  We are #hiring Administrative Assistant in Nan...   \n4  We are #hiring Family Service Counselor in Irv...   \n5  We are #hiring Inside Sales Representative in ...   \n6  We are #hiring Community Service Counselor in ...   \n7  We are #hiring Outside Sales Representative in...   \n8  We are #hiring Workday HRIS Manager  19-00454 ...   \n9  We are #hiring Restaurant Manager - Hourly Man...   \n\n                                             Hashtag  Retweets  Likes  \\\n0                                                NaN         0      1   \n1                                            ['job']         0      0   \n2  ['becomearacker', 'Rackspace', 'recruiting', '...         0      0   \n3                       ['hiring', 'jobs', 'Nanuet']         0      0   \n4                       ['hiring', 'jobs', 'Irvine']         0      0   \n5                       ['hiring', 'jobs', 'Irvine']         0      0   \n6                       ['hiring', 'jobs', 'Irvine']         0      0   \n7                       ['hiring', 'jobs', 'Irvine']         0      0   \n8                       ['hiring', 'jobs', 'Irvine']         0      0   \n9                       ['hiring', 'jobs', 'Laurel']         0      0   \n\n   Replies                                             Source  \\\n0        0  <a href=\"http://instagram.com\" rel=\"nofollow\">...   \n1        0  <a href=\"http://jobvite.com\" rel=\"nofollow\">Jo...   \n2        0  <a href=\"http://jobvite.com\" rel=\"nofollow\">Jo...   \n3        0  <a href=\"http://www.ziprecruiter.com\" rel=\"nof...   \n4        0  <a href=\"http://www.ziprecruiter.com\" rel=\"nof...   \n5        0  <a href=\"http://www.ziprecruiter.com\" rel=\"nof...   \n6        0  <a href=\"http://www.ziprecruiter.com\" rel=\"nof...   \n7        0  <a href=\"http://www.ziprecruiter.com\" rel=\"nof...   \n8        0  <a href=\"http://www.ziprecruiter.com\" rel=\"nof...   \n9        0  <a href=\"http://www.ziprecruiter.com\" rel=\"nof...   \n\n                    Location  Verified_Account  Followers  Following  \n0    20 miles SE of Taos, NM             False       3342        258  \n1                    Arizona             False         63        129  \n2                 Texas, USA             False         19         50  \n3  Orange County, California             False        966       1569  \n4              United States             False        983       1251  \n5              United States             False        983       1251  \n6              United States             False        983       1251  \n7              United States             False        983       1251  \n8        Southern California             False        829       1015  \n9           Mississippi, USA             False         89         80  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>ID</th>\n      <th>Timestamp</th>\n      <th>User</th>\n      <th>Text</th>\n      <th>Hashtag</th>\n      <th>Retweets</th>\n      <th>Likes</th>\n      <th>Replies</th>\n      <th>Source</th>\n      <th>Location</th>\n      <th>Verified_Account</th>\n      <th>Followers</th>\n      <th>Following</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1211798864656769025</td>\n      <td>2019-12-30 23:58:58+00:00</td>\n      <td>SipapuNM</td>\n      <td>Looking for an exciting job where you can ski ...</td>\n      <td>NaN</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://instagram.com\" rel=\"nofollow\"&gt;...</td>\n      <td>20 miles SE of Taos, NM</td>\n      <td>False</td>\n      <td>3342</td>\n      <td>258</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>1211797371853705220</td>\n      <td>2019-12-30 23:53:02+00:00</td>\n      <td>LorettaOD1</td>\n      <td>Hail in Phoenix - no way!  New opportunity at ...</td>\n      <td>['job']</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://jobvite.com\" rel=\"nofollow\"&gt;Jo...</td>\n      <td>Arizona</td>\n      <td>False</td>\n      <td>63</td>\n      <td>129</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>1211795775363145728</td>\n      <td>2019-12-30 23:46:41+00:00</td>\n      <td>guajardo_celina</td>\n      <td>Rackspace is hiring! We are looking for Nation...</td>\n      <td>['becomearacker', 'Rackspace', 'recruiting', '...</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://jobvite.com\" rel=\"nofollow\"&gt;Jo...</td>\n      <td>Texas, USA</td>\n      <td>False</td>\n      <td>19</td>\n      <td>50</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>1211793355060981767</td>\n      <td>2019-12-30 23:37:04+00:00</td>\n      <td>SteveEckert_OTD</td>\n      <td>We are #hiring Administrative Assistant in Nan...</td>\n      <td>['hiring', 'jobs', 'Nanuet']</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://www.ziprecruiter.com\" rel=\"nof...</td>\n      <td>Orange County, California</td>\n      <td>False</td>\n      <td>966</td>\n      <td>1569</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>1211792689022349315</td>\n      <td>2019-12-30 23:34:25+00:00</td>\n      <td>HireLive</td>\n      <td>We are #hiring Family Service Counselor in Irv...</td>\n      <td>['hiring', 'jobs', 'Irvine']</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://www.ziprecruiter.com\" rel=\"nof...</td>\n      <td>United States</td>\n      <td>False</td>\n      <td>983</td>\n      <td>1251</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>1211792528388841473</td>\n      <td>2019-12-30 23:33:47+00:00</td>\n      <td>HireLive</td>\n      <td>We are #hiring Inside Sales Representative in ...</td>\n      <td>['hiring', 'jobs', 'Irvine']</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://www.ziprecruiter.com\" rel=\"nof...</td>\n      <td>United States</td>\n      <td>False</td>\n      <td>983</td>\n      <td>1251</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>1211791693005099008</td>\n      <td>2019-12-30 23:30:28+00:00</td>\n      <td>HireLive</td>\n      <td>We are #hiring Community Service Counselor in ...</td>\n      <td>['hiring', 'jobs', 'Irvine']</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://www.ziprecruiter.com\" rel=\"nof...</td>\n      <td>United States</td>\n      <td>False</td>\n      <td>983</td>\n      <td>1251</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>1211790931772477440</td>\n      <td>2019-12-30 23:27:26+00:00</td>\n      <td>HireLive</td>\n      <td>We are #hiring Outside Sales Representative in...</td>\n      <td>['hiring', 'jobs', 'Irvine']</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://www.ziprecruiter.com\" rel=\"nof...</td>\n      <td>United States</td>\n      <td>False</td>\n      <td>983</td>\n      <td>1251</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>1211789520473079809</td>\n      <td>2019-12-30 23:21:50+00:00</td>\n      <td>PRGWest</td>\n      <td>We are #hiring Workday HRIS Manager  19-00454 ...</td>\n      <td>['hiring', 'jobs', 'Irvine']</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://www.ziprecruiter.com\" rel=\"nof...</td>\n      <td>Southern California</td>\n      <td>False</td>\n      <td>829</td>\n      <td>1015</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>1211788232620412929</td>\n      <td>2019-12-30 23:16:43+00:00</td>\n      <td>GhLisa</td>\n      <td>We are #hiring Restaurant Manager - Hourly Man...</td>\n      <td>['hiring', 'jobs', 'Laurel']</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>&lt;a href=\"http://www.ziprecruiter.com\" rel=\"nof...</td>\n      <td>Mississippi, USA</td>\n      <td>False</td>\n      <td>89</td>\n      <td>80</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('Job_Tweets.csv')\n",
    "df.head(10)"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:42:39.831171960Z",
     "start_time": "2024-04-11T08:42:39.373515041Z"
    }
   },
   "id": "229ef6d22b639fef",
   "execution_count": 2
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['ID', 'Timestamp', 'User', 'Text', 'Hashtag', 'Retweets', 'Likes',\n",
      "       'Replies', 'Source', 'Location', 'Verified_Account', 'Followers',\n",
      "       'Following'],\n",
      "      dtype='object')\n",
      "(50000, 13)\n"
     ]
    }
   ],
   "source": [
    "print(df.columns)\n",
    "print(df.shape)"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:42:39.835754308Z",
     "start_time": "2024-04-11T08:42:39.831485164Z"
    }
   },
   "id": "28eb87351418d8c9",
   "execution_count": 3
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 50000 entries, 0 to 49999\n",
      "Data columns (total 13 columns):\n",
      " #   Column            Non-Null Count  Dtype \n",
      "---  ------            --------------  ----- \n",
      " 0   ID                50000 non-null  int64 \n",
      " 1   Timestamp         50000 non-null  object\n",
      " 2   User              50000 non-null  object\n",
      " 3   Text              50000 non-null  object\n",
      " 4   Hashtag           40684 non-null  object\n",
      " 5   Retweets          50000 non-null  int64 \n",
      " 6   Likes             50000 non-null  int64 \n",
      " 7   Replies           50000 non-null  int64 \n",
      " 8   Source            50000 non-null  object\n",
      " 9   Location          44011 non-null  object\n",
      " 10  Verified_Account  50000 non-null  bool  \n",
      " 11  Followers         50000 non-null  int64 \n",
      " 12  Following         50000 non-null  int64 \n",
      "dtypes: bool(1), int64(6), object(6)\n",
      "memory usage: 4.6+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()\n"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:42:39.990909950Z",
     "start_time": "2024-04-11T08:42:39.866196596Z"
    }
   },
   "id": "1c30d2da7356b83",
   "execution_count": 4
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "data": {
      "text/plain": "<Axes: >"
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": "<Figure size 640x480 with 2 Axes>",
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAiEAAAIKCAYAAAD1fJ9yAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/H5lhTAAAACXBIWXMAAA9hAAAPYQGoP6dpAACiUElEQVR4nOzdeVyN6f/48VelhLK0WJNRKGvLjCEi62AGw/QxzFhGQmQLQ9l3ERHZyR7GyL7OMN8xjN3UWAZjl72SpcRRnd8f/brHmUJxH2l6Px+P83g4133f13XfTdN5n2t7G2i1Wi1CCCGEEO+ZYU7fgBBCCCHyJglChBBCCJEjJAgRQgghRI6QIEQIIYQQOUKCECGEEELkCAlChBBCCJEjJAgRQgghRI6QIEQIIYQQOUKCECGEEELkCAlChBBCCJEjcn0QEh4eTqNGjahevTrt2rXj1KlTOX1LQgghhMiCXB2E7Ny5k8DAQPr06cOmTZtwdHTE29ubuLi4nL41IYQQItc4fvw4vXr1wt3dHQcHB/bu3fvGa44ePUrbtm2pVq0aTZs2ZePGjdluN1cHIcuWLePrr7/G09OTChUqMG7cOExNTYmIiMjpWxNCCCFyjadPn+Lg4MCYMWOydH50dDQ+Pj7UqlWLLVu28N133zFy5EgOHDiQrXbzvc3Nfgg0Gg1nz57Fx8dHKTM0NKROnTpERkbm4J0JIYQQuYuHhwceHh5ZPn/dunXY2NgQEBAAgL29PSdPnmT58uXUq1cvy/Xk2p6Q+Ph4UlJSsLS01Cm3tLQkNjY2h+5KCCGE+O+LiorCzc1Np8zd3Z2oqKhs1ZNre0KEEEII8WoajQaNRqNTZmJigomJyTvXHRsbi5WVlU6ZlZUVCQkJPHv2DFNT0yzVk2uDkGLFimFkZJRhEmpcXFyGH8zr5DMpo/atCSGE+I9K1tzSa/0vYq+oVtfCtTuYM2eOTlnfvn3p16+fam28q1wbhJiYmFC1alUOHz5MkyZNAEhNTeXw4cN06tQph+9OCCGEeAupKapV5ePjg5eXl06ZGr0gkNbr8e+pD7GxsZiZmWW5FwRycRAC4OXlhb+/P9WqVaNGjRqsWLGCpKQkvvrqq5y+NSGEECJHqTX0khlnZ2d+++03nbJDhw7h7OycrXpydRDy+eef8+DBA2bPnk1MTAyVK1dmyZIl2RqOEUIIIT4Y2tQcaTYxMZEbN24o72/evMm5c+coUqQIpUuXJjg4mHv37hEUFARAhw4dCA8PJygoCE9PT44cOcKuXbtYuHBhtto10Gq1WlWfJJeROSFCCCGySu9zQu6cU60u41KVs3zu0aNH6dKlS4bytm3bMmXKFAICArh16xarVq3SuSYwMJBLly5RsmRJfH19sz0SIUGIBCFCCCGy6L8ahOSUXD0cI4QQQvyXaHNoOCanSBAihBBCfChS81YQovqOqW9KghMbG0tAQADu7u44OTnh7e3NtWvXlOMPHz5kwoQJNGvWjBo1atCgQQMmTpzIkydPMm0vPj6e+vXr4+DgwOPHj9V+HCGEEELoiepByOuS4Gi1Wvr06UN0dDTz5s1j06ZNlClTBi8vL54+fQrA/fv3uX//Pv7+/mzfvp3AwEAOHDjAiBEjMm1vxIgRODg4qP0YQgghxPunTVXvlQuoPhzzuiQ4165dIyoqiu3bt1OxYkUAxo4dS926ddmxYwft2rWjUqVKhIaGKtfY2tri5+fHkCFDSE5OJl++f255zZo1PHnyBF9f3wzrlYUQQohcR8XNynKD95rALn0P+/z58/9zA4aGmJiYcPLkyVdel5CQgJmZmU4AcunSJebNm8fUqVMxNMy1efiEEEKIf+SxnpD3+ultZ2enbHry6NEjNBoNixYt4u7du8TExGR6zYMHD5g3bx7t27dXyjQaDYMGDWLIkCGULl36fd2+EEIIIVT0XoMQY2NjQkNDuXbtGp9++inOzs4cPXqU+vXrY2BgkOH8hIQEfHx8sLe3p2/fvkp5cHAw9vb2fPnll+/z9oUQQgj9Sk1V75ULvPclutWqVWPLli08efKEFy9eYGFhQbt27ahWrZrOeQkJCXTv3p1ChQoxd+5cjI2NlWNHjhzh77//Zs+ePUDahFeA2rVr06tXL/r37//+HkgIIYRQiewT8p6Ym5sDaZNVz5w5w4ABA5RjCQkJeHt7Y2Jiwvz583XmkACEhoby7Nkz5f3p06cZPnw44eHh2Nravp8HEEIIIcQ7UT0IeVMSnF27dmFhYUHp0qW5cOECkydPpkmTJri7uwNpAUi3bt1ISkpi2rRpJCQkkJCQAICFhQVGRkYZAo34+HgA7O3tKVy4sNqPJIQQQrwfuWQYRS2qByFnzpzRSYITGBgI/JMEJyYmhilTphAXF4e1tTVffvklvr6+yvlnz57lzz//BKBp06Y6de/btw8bGxu1b1kIIYT4MOSx4RhJYCcJ7IQQQmSRvhPYPf/7oGp15a/krlpd+iK5Y0SekHT7QI60W6B0vRxpVwiRS+WxzcokCBF5ggQDQohcIY8Nx8hWo0IIIYTIEaoHIWvWrKFVq1a4urri6upK+/bt2b9/v3I8JiaGIUOGULduXZydnWnbtq2y38e/aTQavvzySxwcHDh37pzOsQMHDvD111/j4uJC7dq16devHzdv3lT7cYQQQoj3J49tVqZ6EFKyZEm+//57Nm7cSEREBLVr16ZPnz5cvHgRAH9/f65evcr8+fPZtm0bTZs2xc/Pj7/++itDXUFBQRQvXjxDeXR0NL6+vtSuXZstW7YQFhZGfHw8/fr1U/txhBBCiPcnj+WOUX1OSKNGjXTeDxw4kLVr1xIVFUXFihWJjIxkzJgx1KhRAwBfX19WrFjB2bNnqVKlinLd/v37+f333wkNDc2QIffs2bOkpqbi5+enJK/r1q0bvr6+vHjxQmd3VSFAJqYKIXKJXNKDoRa9zglJSUlhx44dPH36FBcXFwBcXFzYtWsXDx8+JDU1lR07dvD8+XM+/fRT5brY2FhGjRpFUFAQpqamGeqtWrUqBgYGREREkJKSwpMnT9iyZQt16tSRAEQIIYTIJfSyOubChQt06NCB58+fU7BgQebOnUuFChUACAkJYeDAgdSqVYt8+fJhamrKnDlzKFeuHJCWByYgIIAOHTpQvXr1TOd5lC1blqVLl+Ln58eYMWNISUnBxcWFRYsW6eNxxH+A9EgIIXIDrTZvLdHVS09I+fLl2bx5M+vXr+ebb77B39+fS5cuATBr1iweP37M8uXLiYiIwMvLCz8/Py5cuADAqlWrSExMxMfH55X1x8TEMGrUKNq0acOGDRtYvXo1xsbG9O/fnzy+95oQQojcLI/NCXkvO6Z27doVW1tbunfvTtOmTdm+fTsVK1bMcHz8+PH4+vryf//3fxgYGCjHU1JSMDIyolWrVkydOpWQkBAOHDhARESEcs7du3fx8PDghx9+wNnZOcv3JjumCiGEyCp975j6LGq7anWZOrdUrS59eS+blaWmpqLRaEhKSgJQJpOmMzIyUnowRo4ciZ+fn3Ls/v37eHt7M3PmTJycnAB49uxZhjrS36fmsUk9Qggh/kPy2GeY6kFIcHAw9evXp1SpUiQmJrJ9+3aOHTtGWFgYdnZ2lCtXjtGjR+Pv70/RokXZu3cvv//+OwsXLgSgdOnSOvUVLFgQAFtbW0qWLAmAh4cHy5cvZ86cObRs2ZLExERmzJhBmTJldFbYCCGEELlKLhlGUYvqQUhcXBz+/v7cv38fc3NzHBwcCAsLo27dugAsWrSI4OBgevXqxdOnT7G1tWXKlCl4eHhkuQ03NzeCg4NZsmQJYWFhmJqa4uzszOLFizNdTSOEEEKID49k0ZU5IXmC7BMihFCD3ueEHI9480lZZFrTU7W69EUS2Ik8QYIBIUSukMeGYySBnRBCCCFyhPSECCGEEB8KWR0jhBBCiByRx4ZjVA9CQkNDmTNnjk5Z+fLl2b17Nzdv3qRx48aZXhcSEkKLFi3YuHEjw4YNy/ScQ4cOYWlpyU8//cTatWs5d+4cGo2GihUr0rdvX+rVk3F/IYQQuZj0hLy7ihUrsmzZMuW9kZERAKVKleLgwYM65/7www+EhYVRv359AD7//PMMwURAQAAajQZLS0sAjh8/Tp06dRg4cCCFCxdm48aN9O7dm/Xr18s+IUIIIUQuoZcgxMjICGtr6yyV7927lxYtWlCoUCEATE1Ndfb6ePDgAUePHmXixIlK2YgRI3TqGDRoEPv27eOXX36RIEQIIUTulcd6QvSyOub69eu4u7vTuHFjBg8ezO3btzM978yZM5w7d47//e9/r6xr8+bNmJqa0rx581eek5qaSmJiIkWLFn3XWxdCCCFyjFabotorN1C9J6RGjRoEBgZSvnx5YmJimDt3Lh07dmTbtm2YmZnpnLthwwbs7e1xdXV9ZX0bNmygZcuWr90JNSwsjKdPn9KiRQvVnkP8t8hmZUII8eFRPQh5eft1R0dHnJycaNiwIbt27aJdu3bKsWfPnrF9+3Z8fX1fWVdkZCSXL18mKCjoleds27aNuXPnMm/ePGXOiBBCCJEr5bHhGL0v0S1cuDAfffQRN27c0CnfvXs3z549o02bNq+89scff6Ry5cpUq1Yt0+M7duxg5MiRzJo1izp16qh52+I/RnokhBC5Qh5boqv3HVMTExOJjo7OMCE1IiKCRo0aYWFh8crrdu3a9cr5Itu3b2fYsGEEBwfToEEDtW9bCCGEEHqmek/I1KlTadiwIaVLl+b+/fuEhoZiaGhIy5YtlXOuX7/O8ePHWbRo0Svr2blzJykpKbRu3TrDsW3bthEQEMDw4cNxcnIiJiYGSFtZY25urvYjCSGEEO+HDMe8m7t37zJo0CAePnyIhYUFH3/8MevXr9fp8YiIiKBkyZK4u7u/sp6IiAiaNm1K4cKFMxxbv349ycnJjB8/nvHjxyvlbdu2ZcqUKeo+kBBCCPG+5LHhGAOtVqvN6ZvISflMyuT0LQghhMglkjW39Fp/0t4FqtVVoEkv1erSF8kdI4QQQnwoZDhGCCGEEDkijw3HSBAi8gTZrEzom/yOCVVIT8i7adSoEbduZRwz+/bbbxkzZgyQtgnZzJkzOXXqFIaGhlSuXJmwsDBlV9SzZ88yffp0Tp8+jZGREZ999hkBAQFKfpl0GzduZNmyZVy7dg0zMzOaN2+utCHEy+QPtdA3+R0TIvtUD0I2bNhASso/e9ZfvHgRLy8vJfdLZGQk3bt3x8fHh1GjRmFkZMT58+cxNEzbsuTevXt4eXnRokULRo0aRUJCApMnT2bYsGHMnj1bqXfZsmUsXbqUoUOH4uTkxNOnTzMNfoQQQohcQ3pC3s2/Nx9btGgRtra2fPrppwAEBgbSuXNnevbsqZxjZ2en/PvXX38lX758jBkzRglMxo0bR+vWrbl+/TrlypXj0aNHhISEsGDBAtzc3JRrHR0d1X4cIYQQ4v2ROSHq0Wg0bN26FS8vLwwMDIiLi+PPP/+kVatWdOjQgRs3bmBnZ4efnx+ffPKJco2xsbESgADKMM3JkycpV64cv//+O6mpqdy7d48WLVqQmJiIi4sLAQEBlCpVSp+PJIQQmZI5IUJkn16DkL179/LkyRPatm0LQHR0NABz5sxh6NChVK5cmc2bN9O1a1e2b9/ORx99RO3atZkyZQpLliyhS5cuJCUlERwcDKDsjHrz5k20Wi0LFixgxIgRmJubExISgpeXF1u3bsXExESfjyWEEBlIMCBUkceGY/SaOyYiIoL69etTokQJAFL//w+3ffv2eHp6UqVKFYYPH0758uWJiIgAoGLFikyZMoVly5bh7OxM3bp1KVOmDFZWVhgYGCj1vHjxgpEjR1KvXj2cnZ2ZMWMG169f5+jRo/p8JCGEEEJ/tKnqvXIBvfWE3Lp1i0OHDhEaGqqUpSexs7e31znX3t6e27dvK+9btWpFq1atiI2NpUCBAhgYGLB8+XLKli2rU0+FChWUaywsLChWrBh37tzR1yMJIYQQQkV66wnZuHEjlpaWOhlubWxsKF68OFevXtU599q1a5Qpk3H7dCsrKwoVKsTOnTvJnz8/devWBcDV1RVAp56HDx8SHx9P6dKl9fA0QgghxHuQmqreKxfQS09IamoqGzdupE2bNuTL908TBgYGeHt7ExoaiqOjI5UrV2bTpk1cuXJFZ/nt6tWrcXFxoWDBghw6dIigoCAGDx6sJLMrX748jRs3ZtKkSYwfPx4zMzNmzJiBnZ0dtWrV0scjCSGEEPqXS4ZR1KKXIOTQoUPcvn0bT0/PDMe6du2KRqMhMDCQR48e4ejoyNKlS7G1tVXOOXXqFKGhoSQmJmJnZ8e4ceNo06aNTj1BQUFMnjwZHx8fDA0NqVmzJkuWLMHY2FgfjySEEEIIlUkWXcmiK4QQIov0nkV3w0TV6irwv5Gq1aUvkjtGCCGE+FDkkrkcapEgRAghhPhQ5LHBCb3uEyKEEEII8Sp6CUISEhKYNGkSDRs2pEaNGnTo0IFTp07pnHP58mV69erFxx9/jLOzM56enspeIQ8fPmTChAk0a9aMGjVq0KBBAyZOnMiTJ0906rh9+zY9e/bEyckJNzc3pk6dSnJysj4eSQghhNA/WaL77kaOHMnFixcJCgqiePHiSv6YnTt3UqJECW7cuMG3336Lp6cn/fv3x8zMjIsXL5I/f34A7t+/z/379/H396dChQrcunWLsWPHcv/+fWUpb0pKCj4+PlhZWbFu3TrlfGNjYwYNGqSPxxJCCCH0K5cED2pRfXXMs2fPcHV1Zd68eToblX311VfUq1ePgQMHMnDgQPLly8e0adOyXO+uXbsYMmQIUVFR5MuXj/3799OrVy8OHDiAlZUVAGvXrmX69OkcPnw4y/ljZHVM3iDJxYQQatD76pjwUarVVaDjBNXq0hfVe0KSk5NJSUlRejXS5c+fnz/++IPU1FR+/fVXunfvjre3N3/99Rc2Njb4+PjQpEmTV9abkJCAmZmZsvlZVFQUlSpVUgIQAHd3d8aOHculS5eoUqWK2o8mcjEJBoQQuUIe26xM9TkhZmZmuLi4MG/ePO7du0dKSgpbtmwhKiqK+/fvExcXx9OnT1m8eDH16tVj6dKlNG3alL59+3Ls2LFM63zw4AHz5s2jffv2SllsbKxOAAIo79Oz7QohhBC5Sg7PCQkPD6dRo0ZUr16ddu3aZZjP+W/Lly9X5m96eHgwefJknj9/nuX29DIxNSgoCK1WS/369alevTqrVq3iiy++wNDQUMmk27hxY7p27UrlypXp2bMnDRo0YN26dRnqSkhIwMfHB3t7e/r27auP2xVCCCHyvJ07dxIYGEifPn3YtGkTjo6OeHt7ExcXl+n527ZtIzg4mL59+7Jz504mTZrEzp07mTFjRpbb1EsQYmtry+rVq4mMjOTXX39lw4YNJCcnU7ZsWYoVK0a+fPnemEkX0gKQ7t27U6hQIebOnauzJbuVlRWxsbE656e/T8+yK4QQQuQqWq16r2xatmwZX3/9NZ6enlSoUIFx48ZhampKREREpudHRkbi6upKq1atsLGxwd3dnZYtW76x9+Rlet0npGDBghQvXpxHjx5x8OBBGjdujImJCdWrV39jJt2EhAS8vb0xNjZm/vz5GeaYODs78/fff+tEaIcOHcLMzIwKFSro87GEEEII/cih4RiNRsPZs2epU6eOUmZoaEidOnWIjIzM9BoXFxfOnj2rBB3R0dHs378fDw+PLLerlyW6Bw4cQKvVUr58eW7cuEFQUBB2dnZ89dVXAHh7ezNw4EBq1qxJrVq1OHDgAP/3f//HypUrgbQApFu3biQlJTFt2jQSEhJISEgAwMLCAiMjI9zd3alQoQJDhw5lyJAhxMTEEBISQseOHbO8MkYIIYT4r9JoNGg0Gp0yExOTTD8j4+PjSUlJwdLSUqfc0tKSK1euZFp/q1atiI+P59tvv0Wr1ZKcnEyHDh3o1atXlu9RL0HIkydPmDFjBnfv3qVo0aJ89tlnDBw4UBlOadq0KWPHjmXRokVMnDiR8uXLM3v2bD755BMAzp49y59//qmc+7J9+/ZhY2ODkZERCxYsYOzYsbRv354CBQrQtm1b+vfvr49HErmcLNEVQuQKKu4TsnDhQubMmaNT1rdvX/r166dK/UePHmXhwoWMGTOGGjVqcOPGDSZNmsTcuXPp06dPluqQLLqyT0ieIEGI0Df5Hcsb9L5PyBL1Nts06jIlyz0hGo0GZ2dnZs+erbNdhr+/P48fP2b+/PkZrvn2229xcnLC399fKduyZQujR48mMjISQ8M3z/iQBHZCCKECCQaEGrSp6vULvCrgeNW5VatW5fDhw0oQkpqayuHDh+nUqVOm1zx79ixDoGFkZARAVvs3JAgRQgghBF5eXvj7+1OtWjVq1KjBihUrSEpKUuZzDh06lBIlSjB48GAAGjZsyLJly6hSpYoyHDNr1iwaNmyoBCNvIkGIyBPkW6oQIlfIwdwxn3/+OQ8ePGD27NnExMRQuXJllixZomwEeufOHZ2ej969e2NgYEBISAj37t3DwsKChg0bMnDgwCy3me05IcePHycsLIwzZ84QExPD3LlzdcaPfvrpJ9atW8fZs2d5+PAhmzdvpnLlyjp1dO7cOcPuqO3bt2f8+PEZ2ouPj+fLL7/k3r17HD9+nMKFC2c45+TJk3Tu3JmKFSuyZcuW7DyOzAkRQgiRZfqeE/J0vjqTRgEK9g5VrS59yfY+IU+fPsXBwYExY8a88rirqyvff//9a+v5+uuvOXjwoPIaOnRopueNGDECBweHV9bz+PFj/P39cXNzy/pDCCGEECLHZXs4xsPD47UbkbRp0waAmzdvvrYeU1PTN+5sumbNGp48eYKvry+//fZbpueMGTOGli1bYmRkxN69e19/80IIIcSHTMWJqbmBXndMfZ1t27ZRq1YtWrZsSXBwMElJSTrHL126xLx585g6deorl/lEREQQHR0tOWWEEEL8N+RwArv3LUcmprZs2ZLSpUtTvHhxLly4wPTp07l69aqyqYpGo2HQoEEMGTKE0qVLEx0dnaGOa9euERwcTHh4OPnyyfxaIYQQIrfJkU/v9u3bK/92cHDA2tqarl27cuPGDWxtbQkODsbe3p4vv/wy0+tTUlIYPHgw/fr1o3z58u/rtoUQQgj9yiU9GGr5ILoQnJycALh+/Tq2trYcOXKEv//+mz179gD/bHpSu3ZtevXqRdeuXTlz5gznzp1jwoQJQNqmKlqtlipVqhAWFiYTVYUO2c1SCJEr5LFNzD+IIOTcuXMAykTV0NBQnj17phw/ffo0w4cPJzw8HFtbW8zMzNi2bZtOHWvWrOHIkSPMnj0bGxub93fzIleQYEAIIT482Q5CEhMTuXHjhvL+5s2bnDt3jiJFilC6dGkePnzInTt3uH//PgBXr14FwMrKCmtra27cuMG2bdvw8PCgaNGiXLhwgcDAQGrWrImjoyMAtra2Om3Gx8cDYG9vr+wTUqlSJZ1zLC0tyZ8/f4ZyIYQQIteQ4ZjXO3PmDF26dFHeBwYGAtC2bVumTJnCL7/8wrBhw5Tj6TunpWfuMzY25vDhw6xcuZKnT59SqlQpPvvsM3x9fd/1WYQQQojcLY8t0ZUsurJjqhBCiCzS+46p07qpVlfBIUtVq0tfPog5IULom0xMFUKID48EISJPkGBACJEr5LHhGAlChBBCBdLbJtSgzWMTU3Ns23YhhBBC5G3Z7gk5fvw4YWFhnDlzhpiYGObOnUuTJk2U46GhoezYsYO7d+9ibGxM1apVGThwoLIh2cs0Gg3t2rXj/PnzbN68mcqVKyvHtFotS5cuZf369dy6dYtixYrx7bff0rt3b+WcrVu3smTJEq5fv465uTn16tVj6NChFCtWLLuPJYQQ70R6JIQq8thwTLZ7Qp4+fYqDgwNjxozJ9PhHH33E6NGj2bZtG2vWrKFMmTJ069aNBw8eZDg3KCiI4sWLZ1rPpEmT+PHHHxk6dCi7du1i/vz51KhRQzl+8uRJ/P39+d///sf27dsJCQnh9OnTjBo1KruPJIQQQnwYtKnqvXKBbPeEeHh44OHh8crjrVq10nk/bNgwNmzYwIULF3S2Ut+/fz+///47oaGh/PbbbzrXXL58mbVr17Jt2zbs7OwAKFu2rM45UVFRlClTRtmzpGzZsrRv357Fixdn95GEEEIIkQP0OidEo9Hwww8/YG5ujoODg1IeGxvLqFGjCAoKwtTUNMN1v/zyCzY2Nvz66680atSIRo0aMWLECB4+fKic4+zszN27d9m/fz9arZbY2Fj27Nnz2gBJCCGE+KClatV75QJ6WR3zf//3fwwaNIikpCSsra1ZunQpFhYWQNpcj4CAADp06ED16tW5efNmhuujo6O5ffs2u3fvJigoiJSUFAIDA+nfvz8rV64E4OOPP2batGn4+fmh0WhITk6mYcOGjB49Wh+PJIQQryWrY4Qq8tjqGL0EIbVq1WLz5s3Ex8ezfv16/Pz8+PHHH7G0tGTVqlUkJibi4+Pzyuu1Wi0ajYapU6dSvnx5IG2OyFdffcWVK1ews7Pj0qVLTJo0iT59+uDu7k5MTAxBQUGMGTOGyZMn6+OxhBDilSQYECL79DIcU7BgQcqVK4ezszOTJ08mX758bNiwAYAjR44QFRVF9erVqVKlCp999hkAnp6e+Pv7A2nZdPPly6cEIJCWvA7gzp07ACxcuBBXV1e6d++Oo6Mj9erVY8yYMURERCjJ84QQQohcRYZj1JeamopGowFg5MiR+Pn5Kcfu37+Pt7c3M2fOVJbxurq6kpyczI0bN5SMuteuXQOgdOnSADx79gwjIyOddtLf5/F0OCIT0lUuhMgVcsmqFrVkOwhJTEzkxo0byvubN29y7tw5ihQpQtGiRVmwYAGNGjXC2tqa+Ph4wsPDuXfvHs2bNwf+CSLSFSxYEABbW1tKliwJQJ06dahatSrDhw9n+PDhpKamMn78eOrWrav0jjRs2JBRo0axZs0a6tWrx/3795k8eTI1atSgRIkSb/fTEP9ZEgwIIXKFXNKDoZZsByFnzpxRlsUCBAYGAtC2bVvGjRvHlStX2LRpE/Hx8RQtWpTq1asTHh5OxYoVs9yGoaEh8+fPZ+LEiXTs2JGCBQtSv359ZbgG4KuvviIxMZHw8HCmTp2Kubk5tWvXZsiQIdl9JCGEEELkAANtHh+7yGdSJqdvQQghRC6RrLml1/oThnmqVpdZYIRqdemLJLATQgghPhR5bDhGEtgJIYQQIkdIT4gQQgjxoZCekNc7fvw4vXr1wt3dHQcHB/bu3atzPCAgAAcHB52Xt7e3zjm9evWiQYMGVK9eHXd3d4YMGcK9e/d0ztm5cydffvklTk5ONGzYkCVLlugc/+mnn/Dy8qJ27dq4urrSvn17DhzImWWYQgghhCokgd3rpWfR9fT0pG/fvpmeU69ePWXVDICJiYnO8dq1a9OrVy+sra25d+8eQUFBDBgwgHXr1gFpye2GDBnCyJEjcXd35/Lly4wcORJTU1M6deoEpAVDderUYeDAgRQuXJiNGzfSu3dv1q9fT5UqVbL7WEIIIYR4z1TPogtpQYe1tfUrj3ft2lX5d5kyZejRowd9+vThxYsXGBsbs3XrVho3bsw333wDpGXI9fHxYfHixXTs2BEDAwNGjBihU+egQYPYt28fv/zyiwQhIgPZrEzom/yOCVXkseEYvcwJOXbsGG5ubhQuXJjatWvj5+dHsWLFMj334cOHbNu2DRcXF4yNjYG07Lv/zq5ramrK3bt3uXXrFjY2NhnqSU1NJTExkaJFi6r+PCL3kz/UQt/kd0yoQStByLupV68eTZs2xcbGhujoaGbMmEGPHj344YcfdLZZnzZtGuHh4SQlJeHs7MyCBQuUY+7u7gQGBnL48GFq1arF9evXWbp0KQAxMTGZBiFhYWE8ffqUFi1aqP1I4j9AvqUKIcSHR/Ug5IsvvlD+nT4xtUmTJkrvSDpvb2/+97//cfv2bebMmYO/vz8LFy7EwMCAr7/+mhs3buDj40NycjJmZmZ06dKF0NBQDA0zzqXdtm0bc+fOZd68eVhaWqr9SOI/QIIBIUSuID0h6ipbtizFihXj+vXrOkGIhYUFFhYWlC9fHnt7ezw8PIiKisLFxQUDAwOGDBnCoEGDiI2NpVixYhw+fFip72U7duxg5MiRzJo1izp16uj7cYQQQgj9Sc0dq1rUovcg5O7duzx8+PC1E1VT//8PPT3TbjojIyMlGd2OHTtwcXHBwsJCOb59+3aGDx/OjBkzaNCggfo3L/4zZDhGCJErSE/I670ui26RIkWYM2cOzZo1w8rKiujoaKZNm0a5cuWoVy/tj/Gff/7J6dOn+fjjjylcuDA3btxg1qxZ2Nra4uLiAsCDBw/Ys2cPn376KRqNhoiICHbv3s3q1auVdrdt20ZAQADDhw/HycmJmJgYIG0Cq7m5+Tv9UMR/jwQDQgjx4cl2ArujR4/qZNFN17ZtW8aOHUufPn3466+/ePLkCcWLF6du3boMGDAAKysrAC5cuMCkSZO4cOECT58+xdramnr16uHr66v0ejx48IDevXvz999/o9VqcXZ2ZuDAgTg5OSntde7cmWPHjmV6H1OmTMny80gCOyGEEFml7wR2T3o1V60u8wW7VatLXySLrgQhQgghskjfQchjn2aq1VV44R7V6tIXSWAnhBBCiBwhCexEniATU4UQuYJMTBVCCCFEjpAg5PWOHz9OWFgYZ86cISYmhrlz59KkSRPluIODQ6bXDRkyhO7duwNpWXTPnz9PXFwcRYoUwc3Nje+//16ZmPr8+XPGjBnD2bNnuXz5Mg0aNGDevHkZ6tRoNMydO5etW7cSExND8eLF8fX15X//+192H0v8x0mPhBBCfHhUz6J78OBBnfe//fYbI0aMoFmzfybbvCmLbkpKCvnz56dz587s2fPqiTUDBgwgLi6OSZMmYWtrS0xMjLLniBAvk+EYIURuILlj3uBNWXT/vSnZvn37qFWrls5Op2/KoluwYEHGjRsHwB9//MHjx48ztPPbb79x/Phx9u7dqyStyyynjBAgwYAQIpfIY0GIXlfHxMbGsn///tcOj2SWRTcrfvnlF6pVq8aSJUuoV68ezZo1Y+rUqTx79kyNWxdCCCGEnul1YuqmTZsoVKgQn332WYZjr8uimxXR0dGcPHmS/PnzM3fuXOLj4xk3bhwPHz4kMDBQrUcQQggh3p88NqNArz0hERERtGrVivz582c45u3tzaZNm1i6dCmGhob4+/uTnX3TtFotBgYGTJ8+nRo1auDh4UFAQACbNm2S3hAhhBC5kjZVq9orN9BbT8iJEye4evUqISEhmR5/XRbdrLC2tqZEiRI6eWLs7e3RarXcvXuXjz76SIWnEP8VMjFVCJEr5JLgQS16C0I2bNhA1apVcXR0fOO5r8qi+zqurq7s3r2bxMREChUqBMDVq1cxNDSkZMmSb3fT4j9LggEhhPjwqJpFt3Tp0gAkJCSwe/du/P39M1yflSy6AJcuXeLFixc8fPiQxMREzp07B0DlypUBaNmyJfPmzWPYsGH079+f+Ph4pk2bhqenJ6amptl9LCGEECLn5bE5Iapm0U3PXvvDDz8wefJkDh48qDNcAlnLogvQqFEjbt3KmCjowoULyr8vX77MxIkT+eOPPyhatCgtWrTAz88vW0GIJLATQgiRVfpOYBffroFqdRX78VfV6tIXyaIrQYgQQogskiBEXZI7RgghhPhQ5LHhGAlChBBCiA9Ebllaqxa97hMihBBCCPEq2Q5Cjh8/Tq9evXB3d8fBwYG9e/fqHI+NjSUgIAB3d3ecnJzw9vbm2rVryvGHDx8yYcIEmjVrRo0aNWjQoAETJ07kyZMnmbYXHx9P/fr1cXBwyJBD5ujRo7Rt25Zq1arRtGlTNm7cmN3HEUIIIT4cqSq+coFsByHpWXTHjBmT4ZhWq6VPnz5ER0czb948Nm3aRJkyZfDy8uLp06cA3L9/n/v37+Pv78/27dsJDAzkwIEDjBgxItP2RowYgYODQ4by6OhofHx8qFWrFlu2bOG7775j5MiRHDiQM5tSCSGEEO9Km6reKzdQNYvutWvXiIqKYvv27VSsWBGAsWPHUrduXXbs2EG7du2oVKkSoaGhyjW2trb4+fkxZMgQkpOTyZfvn1tas2YNT548wdfXl99++02nrXXr1mFjY0NAQACQtlvqyZMnWb58OfXqycZUQgghxIdO1Ymp6TuevpwrxtDQEBMTE06ePEm7du0yvS4hIQEzMzOdAOTSpUvMmzeP9evXEx0dneGaqKgo3NzcdMrc3d2ZPHmyGo8ihBDZIqkBhCpySQ+GWlSdmGpnZ0fp0qUJDg7m0aNHaDQaFi1axN27d4mJicn0mgcPHjBv3jzat2+vlGk0GgYNGsSQIUOUXVj/LTY2FisrK50yKysrEhISJIGdEEKIXEmGY96BsbExoaGhjBgxgk8//RQjIyPc3NyoX79+phlyExIS8PHxwd7enr59+yrlwcHB2Nvb8+WXX6p5e0IIoTfSIyFUkUuCB7Wovk9ItWrV2LJlC0+ePOHFixdYWFjQrl07qlWrpnNeQkIC3bt3p1ChQsydOxdjY2Pl2JEjR/j777/Zs2cPgBLA1K5dm169etG/f3+srKyIjY3VqTM2NhYzMzPJHSOEEELkAnrbrCw9Z8y1a9c4c+YMAwYMUI4lJCTg7e2NiYkJ8+fP15lDAhAaGqozpHL69GmGDx9OeHg4tra2ADg7O2eYrHro0CGcnZ319ERCCCGEfuX0MEp4eDhhYWHExMTg6OjIqFGjqFGjxivPf/z4MTNnzuTnn3/m4cOHlClThuHDh79yAcu/qZ5Fd9euXVhYWFC6dGkuXLjA5MmTadKkCe7u7kBaANKtWzeSkpKYNm0aCQkJJCQkAGBhYYGRkZESaKSLj48H0lbAFC5cGIAOHToQHh5OUFAQnp6eHDlyhF27drFw4cLsPpLIA2TSoBAiN8jJIGTnzp0EBgYybtw4nJycWLFiBd7e3uzevRtLS8sM52s0Gry8vLC0tGTWrFmUKFGC27dvK5/TWZHtIOTMmTM6WXQDAwOBf7LoxsTEMGXKFOLi4rC2tubLL7/E19dXOf/s2bP8+eefADRt2lSn7n379mFjY5Ol+yhbtiwLFy4kMDCQlStXUrJkSSZOnCjLc0WmJBgQQojXW7ZsGV9//TWenp4AjBs3jl9//ZWIiAh69uyZ4fyIiAgePXrEunXrlCkVWf0MTydZdCWLrhBCiCzSdxbdew2zNoyRFSX+b3+Wz9VoNDg7OzN79myaNGmilPv7+/P48WPmz5+f4ZoePXpQpEgRChQowL59+7CwsKBly5b06NEDIyOjLLUrCexEniDDMUKIXEFroFpVGo1G2b8rnYmJCSYmJhnOjY+PJyUlJcOwi6WlJVeuXMm0/ujoaI4cOUKrVq1YtGgRN27cYNy4cSQnJ+useH0dCUJEniDBgBAir1m4cCFz5szRKevbty/9+vVTpX6tVoulpSUTJkzAyMiIatWqce/ePcLCwiQIEUIIIXIbNSem+vj44OXlpVOWWS8IQLFixTAyMiIuLk6nPC4uLsPGoOmsra3Jly+fztCLnZ0dMTExaDSaV7b1smztmLpw4UI8PT1xcXHBzc0NX1/fDN00P/zwA507d8bV1TXTzLcA8+fPp0OHDjg5OfHJJ5+8sr2NGzfSqlUrqlevjpubG+PGjcv0vOvXr+Pi4vLauoQQQogPnTbVQLWXiYkJZmZmOq9XBQYmJiZUrVqVw4cPK2WpqakcPnwYFxeXTK9xdXXlxo0bpKb+Ezldu3YNa2vrLAUgkM0g5NixY3Ts2JH169ezbNkykpOT8fb2VjLkAiQlJVGvXj169er1ynpevHhB8+bN+eabb155zrJly5g5cyY9e/Zkx44dLFu2TFnm+++6Bg0aJAGIEEII8Q68vLxYv349mzZt4vLly4wdO5akpCS++uorAIYOHUpwcLBy/jfffMPDhw+ZNGkSV69e5ddff2XhwoV07Ngxy21mazgmLCxM5/2UKVNwc3Pj7Nmz1KxZE4CuXbsCcPTo0VfW079/fyCtpyMzjx49IiQkhAULFugkqXN0dMxwbkhICHZ2dri5uREZGZmdxxFCCCE+KDm5T8jnn3/OgwcPmD17NjExMVSuXJklS5YowzF37tzB0PCfvotSpUoRFhZGYGAgrVu3pkSJEnTp0oUePXpkuc13mhPy5MkTAIoUKfIu1WTw+++/k5qayr1792jRogWJiYm4uLgQEBBAqVKllPMOHz7M7t272bJlCz/99JOq9yCEEEK8b1oVV8e8jU6dOtGpU6dMj61atSpDmYuLC+vXr3/r9t46CElNTWXy5Mm4urpSqVKlt76BzNy8eROtVsuCBQsYMWIE5ubmhISE4OXlxdatWzExMSE+Pp5hw4Yxbdo0zMzMVG1fCCGyS5aBCzXk9Lbt71u25oS8bNy4cVy8eJGZM2eqeT9AWoDz4sULRo4cSb169XB2dmbGjBlcv35dGeYZNWoULVu2VIaBhBBCCJG7vFVPyPjx4/n1119ZvXo1JUuWVPuesLa2BqBChQpKmYWFBcWKFePOnTtAWqbdX375haVLlwJp65VTU1OpUqUK48eP53//+5/q9yWEEK8iPRJCDdrUnB2Oed+yFYRotVomTJjAzz//zKpVqyhbtqxebsrV1RWAq1evKkHOw4cPiY+Pp3Tp0kDaUuCUlBTlmn379rF48WLWrVtHiRIl9HJfQgghhD7ltUQq2QpCxo0bx/bt25k3bx6FChUiJiYGAHNzc0xNTQGIiYkhNjZWybT7999/U6hQIUqVKkXRokUBuH37No8ePeL27dukpKRw7tw5AGxtbSlUqBDly5encePGTJo0ifHjx2NmZsaMGTOws7OjVq1aQFpG3ZedOXMGQ0ND1eenCCGEEEI/spXAzsHBIdPywMBAZR1xaGhohm1i/31OQEAAmzZtynDOypUrlSAjISGByZMn8/PPP2NoaEjNmjUZMWKEzuqYl23cuJHJkydz4sSJrD4OIAns8gqZNCiEUIO+E9hdd23y5pOyqNwfe1WrS18ki64EIUIIIbJI30HINeemqtX1UdTPqtWlL2+9OkYIIYQQ4l1IAjuRJ8hwjBAiN8hrYxMShIg8QYIBIURukNeW6MpwjBBCCCFyRLaCkIULF+Lp6YmLiwtubm74+vpy5coVnXNGjx5NkyZNqFGjBrVr16Z3795cvnxZ55zbt2/Ts2dPnJyccHNzY+rUqSQnJ+ucs3XrVlq3bo2TkxPu7u4MGzaM+Ph4nXOWL19Os2bNqFGjBh4eHkyePJnnz59n55GEEEKID4ZWa6DaKzfIVhBy7NgxOnbsyPr161m2bBnJycl4e3vz9OlT5ZyqVasSGBjIzp07CQsLQ6vV4u3trWwslpKSgo+PDy9evGDdunVMmTKFTZs2MXv2bKWOkydP4u/vz//+9z+2b99OSEgIp0+fZtSoUco527ZtIzg4mL59+7Jz504mTZrEzp07mTFjxrv+TIQQQogcoU1V75UbZGtOSFhYmM77KVOm4ObmxtmzZ5UcLu3bt1eO29jY4Ofnx5dffsmtW7ewtbXl4MGDXLp0iWXLlmFlZUXlypUZMGAA06dPp2/fvpiYmBAVFUWZMmXo0qULAGXLlqV9+/YsXrxYqTsyMhJXV1datWqltNWyZUv+/PPPt/tJCCGEEDksNZf0YKjlneaEPHnyBIAiRYpkevzp06ds3LgRGxsbZfv1qKgoKlWqhJWVlXKeu7s7CQkJXLp0CQBnZ2fu3r3L/v370Wq1xMbGsmfPHjw8PJRrXFxcOHv2LKdOnQIgOjqa/fv365wjhBBCiA/XW6+OSU1NZfLkybi6umbYKj08PJzp06fz9OlTypcvz7JlyzAxMQEgNjZWJwABlPfp28B//PHHTJs2DT8/PzQaDcnJyTRs2JDRo0cr17Rq1Yr4+Hi+/fZbtFotycnJdOjQgV69er3tIwkhhBA5KrfM5VDLWwch48aN4+LFi6xZsybDsdatW1O3bl1iYmIICwvDz8+PtWvXkj9//izVfenSJSZNmkSfPn1wd3cnJiaGoKAgxowZw+TJkwE4evQoCxcuZMyYMdSoUYMbN24wadIk5s6dS58+fd72scR/lOwTIoTIDfLaEt23CkLGjx/Pr7/+yurVq5VhlpeZm5tjbm7ORx99hJOTE59++ik///wzLVu2xMrKShlCSRcbGwuAtbU1kLYKx9XVle7duwPg6OhIgQIF6NixI35+fhQvXpxZs2bRunVr2rVrB6TltXn69CmjR4+md+/eGBrK6mPxDwkGhBDiw5OtT2qtVsv48eP5+eefWbFiBWXLls3ydRqNBkib7/H3338TFxenHD906BBmZmZUqFABgGfPnmUIIoyMjJS6snqOEEIIkZtoteq9coNs9YSMGzeO7du3M2/ePAoVKqTM4TA3N8fU1JTo6Gh27txJ3bp1sbCw4O7duyxatAhTU1Nlwqi7uzsVKlRg6NChDBkyhJiYGEJCQujYsaMyb6Rhw4aMGjWKNWvWUK9ePe7fv8/kyZOpUaMGJUqUUM5ZtmwZVapUUYZjZs2aRcOGDZVgRAghhMhN8tpwTLay6Do4OGRaHhgYyFdffcW9e/cYOXIkZ8+e5fHjx1haWvLJJ5/Qp08f7OzslPNv3brF2LFjOXbsGAUKFKBt27YMHjyYfPn+iYlWrVrFunXruHnzJubm5tSuXZshQ4YoQUhycjILFixgy5Yt3Lt3DwsLCxo2bMjAgQMpXLhwln8AkkU3b5A5IUIINeg7i+5f9l+oVleVyztUq0tfshWE/BdJECKEECKr9B2EnLFrqVpd1a5sV60ufZEEdkIIIcQHIq8t0ZUlJEIIIYTIEdITIoQQQnwg8toECdWz6Hbu3BkHBwed18s7ncKbs+jev3+fwYMH06xZMxwdHZk0aVKGe1m/fj3ffvstNWvWpGbNmnTt2jXD/iNCCCFEbpKqNVDtlRtkqyckPYtu9erVSUlJYcaMGXh7e7Njxw4KFiyonPf111/Tv39/5X2BAgWUf6dn0bWysmLdunXcv38ff39/jI2NGTRoEAAajYZixYrRu3dvli9fnum9HD16lC+++AJXV1dMTExYsmQJ3bp1Y8eOHcoKGiGEECI3yWtzQt5pdcyDBw9wc3Nj9erVShbdzp074+joyIgRIzK9Zv/+/fTq1YsDBw4oOWPWrl3L9OnTOXz4sLJXSLo31ZcuJSWFmjVrMnr0aNq0aZPlZ5DVMUIIIbJK36tjIm2/VK0ulxtbVKtLX/SSRXfbtm3UqlWLli1bEhwcTFJSknIsK1l030ZSUhLJycmvzOgrhBBCfOhkx9QselUW3ZYtW1K6dGmKFy/OhQsXmD59OlevXmXOnDlA1rLovo3p06dTvHhx6tSp89Z1CCGEEDkpt8zlUIvqWXTbt2+v/NvBwQFra2u6du3KjRs3sLW1ffs7fY1Fixaxc+dOVq5cmeVMvUIIIYTIWW81HJOeRXfFihWZZtF9mZOTEwDXr18H0no90rPmpvt3Ft3sCAsLY9GiRYSFheHo6Jjt64UQQogPhVZroNorN9B7Ft1z584B/wQYWcmim1WLFy9m3rx5LFmyhOrVq2frWiGEEOJDI0t0X+NNWXRv3LjBtm3b8PDwoGjRoly4cIHAwEBq1qyp9FJkJYsu/BO8JCYm8uDBA86dO4exsbESqCxatIjZs2cTHBxMmTJllHspWLAghQoVevefjBBCCCH0StUsunfu3GHIkCFcvHiRp0+fUqpUKZo0aYKvry9mZmbK+VnJoptZW2XKlOGXX34BoFGjRty6lXGpVN++fenXr19WH0mW6AohVCGZmvMGfS/RPVL6K9Xqqn17o2p16Ytk0ZUgRAghRBbpOwg5VMpTtbrq3IlQrS59kQR2QgghhMgRksBO5AnSVS6EyA1yy6oWtUgQIoQQKpBAV6ghNadv4D3LVhCycOFCfvrpJ65cuYKpqSkuLi58//332NnZ6ZwXGRnJzJkzOXXqFIaGhlSuXJmwsDBMTU0BOHv2LNOnT+f06dMYGRnx2WefERAQoKxqiY+P5/vvv+fChQs8fPgQS0tLGjduzKBBg3QmuGo0GubOncvWrVuJiYmhePHi+Pr68r///e9dfy7iP0b+UAt9k98xoQYteasnJFsTU729vfniiy90suhevHhRJ4tuZGQk3bt3x8fHh4YNG2JkZMT58+dp0qQJJiYm3Lt3j1atWtGiRQu+++47EhISmDx5MsWLF2f27NkAPHr0iB07dlC9enUsLCy4ceMG48aNo2rVqgQHByv307t3b+Li4vDz88PW1paYmBhSU1P5+OOPs/wDkImpQgghskrfE1N/K9lOtbrq3/1Rtbr0RfUsul9//TV16tTBz88v02t++OEHZs2axcGDBzE0TJsXe+HCBVq3bs1PP/1EuXLlMr1u5cqVhIWFsX//fgB+++03Bg0axN69eylatOjbPoIEIUIIIbJM30HIryXUC0Ia3PvwgxBVs+jGxcXx559/YmlpSYcOHahTpw6dOnXixIkTyjUajQZjY2MlAAGUYZqTJ09m2s69e/f4+eeflUAH4JdffqFatWosWbKEevXq0axZM6ZOncqzZ8/e5ZGEEEKIHJOKgWqv3OCtg5DMsuhGR0cDMGfOHNq1a8eSJUuoUqUKXbt25dq1awDUrl2b2NhYlixZgkaj4dGjR8oQy7+z6A4aNAgnJyfq169PoUKFmDRpknIsOjqakydPcvHiRebOncvw4cPZs2cP48aNe9tHEkIIIcR7pGoW3dTUtHm97du3x9MzbcOVKlWqcPjwYSIiIhg8eDAVK1ZkypQpTJkyhRkzZmBoaEjnzp2xsrLCwEA3chs2bBh9+vTh2rVrzJgxg8DAQMaOHQuk5bExMDBg+vTpmJubAxAQEED//v0ZM2aM0rsihBDvg6yOEWrIaxNT3yoISc+iu3r1ap0suulJ6uzt7XXOt7e35/bt28r7Vq1a0apVK2JjYylQoAAGBgYsX748Q0I8a2trrK2tsbe3p0iRInTs2BFfX1+KFy+OtbU1JUqUUAKQ9Ha0Wi13797lo48+eptHE0KItyLBgFBDXluiq2oWXRsbG4oXL87Vq1d1yq9du0aZMhkngFpZWVGoUCF27txJ/vz5qVu37mvbhrQ5JQCurq7cv3+fxMRE5ZyrV69iaGioExgJIYQQ4sOkahZdAwMDvL29CQ0NxdHRkcqVK7Np0yauXLmiLL8FWL16NS4uLhQsWJBDhw4RFBTE4MGDKVy4MAD79+8nNjaW6tWrU7BgQS5dukRQUBCurq7Y2NgA0LJlS+bNm8ewYcPo378/8fHxTJs2DU9PTxmKEUIIkSvlteEYVbPoplu0aBHh4eE8evQIR0dHvv/+ez755BPl+NChQ9m/fz+JiYnY2dnRrVs32rRpoxw/cuQIISEhXLp0CY1GQ6lSpWjatCk9e/ZUAhWAy5cvM3HiRP744w+KFi1KixYt8PPzy1YQIkt0hRBCZJW+l+juLtFBtbqa31unWl36Ill0JQgRQgiRRfoOQnaqGIR8nguCEMkdI/IEWbkghBAfHglCRJ4gwYAQIjfIa3NCJAgRQgghPhCpeSsGyd4S3YULF+Lp6YmLiwtubm74+vpy5coVnXNiYmIYMmQIdevWxdnZmbZt27Jnzx6dc65evUrv3r2pVasWrq6ufPPNNxw5ciRDexs3bqRVq1ZUr14dNze3DLuhnj9/nm+//Zbq1avj4eHB4sWLs/M4QgghhMhB2eoJOXbsGB07dtTJouvt7a2TRdff35/Hjx8zf/58ihUrxrZt2/Dz8yMiIoIqVaoA0KtXL8qVK8eKFSswNTVlxYoV9OrVi59//lnZ8GzZsmUsXbqUoUOH4uTkxNOnT7l1658JQQkJCXh7eyvByd9//83w4cMpXLgw7du3V+vnI4QQQrw3uSXni1pUz6Lr4uLCmDFjdJbc1qpVi++//5527dop14SHhyvLdhMSEvj4449ZtmwZderU4dGjR9SvX58FCxbg5uaWadtr1qwhJCSEgwcPYmJiAsD06dPZu3cvu3fvzvIzyOoYIYQQWaXv1TGbS36rWl1t7q5580k5TNUsupAWhOzatYuHDx+SmprKjh07eP78OZ9++ikAxYoVo3z58mzevJmnT5+SnJzMDz/8gKWlJVWrVgXg999/JzU1lXv37tGiRQvq16/PgAEDuHPnjtJOVFQUn3zyiRKAALi7u3P16lUePXr0Lo8lhBBCiPfgrSemZpZFFyAkJISBAwdSq1Yt8uXLh6mpKXPmzKFcuXIASp4YX19fXF1dMTQ0xMLCgiVLlijBzM2bN9FqtSxYsIARI0Zgbm5OSEgIXl5ebN26FRMTE2JjY5XdU9NZWVkBEBsbqxMYCSGEELmB5I7JovQsujNnztQpnzVrFo8fP2b58uVERETg5eWFn58fFy5cANJywIwbNw5LS0vCw8P58ccfadKkCb169eL+/ftAWoDz4sULRo4cSb169XB2dmbGjBlcv36do0ePvsPjCiGEEB+uVAMD1V65gapZdG/cuMHq1avZvn07FStWBMDR0ZETJ04QHh7O+PHjOXLkCL/++ivHjx/HzMwMgKpVq3Lo0CE2b95Mz549lcmpFSpUUOq2sLCgWLFiypCMlZUVsbGxOveV/j69R0QIIYQQHy5Vs+gmJSWlVWqoW62RkZGSBTf9HIN/RWkGBgakpqZ1RLm6ugLoZON9+PAh8fHxlC5dGgBnZ2dOnDjBixcvlHMOHTpE+fLlZShGCCFErqRV8ZUbZCsIGTduHFu3biU4OFjJohsTE8OzZ88AsLOzo1y5cowePZpTp05x48YNli5dyu+//06TJk2AtOChcOHCBAQEcP78ea5evcrUqVO5desWDRo0AKB8+fI0btyYSZMm8ccff/D3338TEBCAnZ0dtWrVAqBVq1YYGxszYsQILl68yM6dO1m5ciVeXl4q/niEEEKI9ydVxVduoHoW3WvXrhEcHMzJkyd5+vQptra2GbLknj59mpCQEM6cOcOLFy+oWLEivr6+eHh4KOckJCQwefJkfv75ZwwNDalZsyYjRoygVKlSyjnnz59n/PjxnD59mmLFitGpUyd69uyZrR+ALNHNGyR3jBBCDfpeoru2dEfV6vrmdrhqdemLZNGVIEQIIUQW/deDkPDwcMLCwoiJicHR0ZFRo0ZRo0aNN163Y8cOBg0aROPGjZk3b16W23unfUKEEEIIoZ5UDFR7ZdfOnTsJDAykT58+bNq0CUdHR7y9vYmLi3vtdTdv3mTq1KnKBqTZIUGIEEII8YHIyYmpy5Yt4+uvv8bT05MKFSowbtw4TE1NiYiIeOU1KSkpfP/99/Tr1y/DYpWskCBECCGEyOM0Gg1nz56lTp06SpmhoSF16tQhMjLyldfNnTsXS0tL2rVr91btvvWOqULkJjIxVQiRG6SquMeYRqNBo9HolJmYmOikO0kXHx9PSkoKlpaWOuWWlpZcuXIl0/pPnDjBhg0b2Lx581vfY7aCkDVr1rB27Volm+2/V7U8f/6cKVOmsHPnTjQaDe7u7owZM0bZPGzjxo0MGzYs07oPHTqkPPzWrVtZsmQJ169fx9zcnHr16jF06FCKFSuW4bq3nQwj8hYJBoQQuYGaS2sXLlzInDlzdMr69u1Lv3793rnuhIQEhg4dyoQJE7CwsHjrerIVhJQsWZLvv/+ecuXKodVq2bx5szKBpWLFikyePJn9+/cTEhKCubk5EyZMoG/fvqxbtw6Azz//nHr1dD8MAgIC0Gg0SgBy8uRJ/P39GTZsGA0bNuTevXuMHTuWUaNGZfhhvstkGCGEEOK/zMfHJ8PeWZn1gkBaclkjI6MMk1Dj4uIy3YU8OjqaW7du0bt3b6UsfcPRKlWqsHv3bmxtbd94j9kKQho1aqTzfuDAgaxdu5aoqChKlixJREQE06dPx83NDYDJkyfz+eefExUVhbOzM6amppiamirXP3jwgKNHjzJx4kSlLCoqijJlytClSxcAypYtS/v27Vm8eLFO2y9Phjl58iSPHz/OzqOIPEaGY4QQuYGae2a8aujlVedWrVqVw4cPK5uLpqamcvjwYTp16pThfDs7O7Zt26ZTFhISQmJiIiNGjNBJ6fI6bz0nJCUlhd27d/P06VNcXFyUjcdentRib29P6dKllSDk3zZv3oypqSnNmzdXypydnZk5cyb79++nfv36xMXFsWfPHp2NzEB3MszJkyff9jFEHiHBgBAiN1BzTkh2eXl54e/vT7Vq1ahRowYrVqwgKSlJ2Yx06NChlChRgsGDB5M/f34qVaqkc33hwoUBMpS/TraDkAsXLtChQweeP39OwYIFmTt3LhUqVODcuXMYGxsrN5HO0tKSmJiYTOvasGEDLVu21Okd+fjjj5k2bRp+fn5oNBqSk5Np2LAho0ePVs5RYzKMEEIIIf7x+eef8+DBA2bPnk1MTAyVK1dmyZIlynDMnTt3MuSGe1fZDkLKly/P5s2befLkCXv27MHf35/Vq1dnu+HIyEguX75MUFCQTvmlS5eYNGkSffr0wd3dnZiYGIKCghgzZgyTJ09WbTKMEEII8aHJ6ZwvnTp1ynT4BWDVqlWvvXbKlCnZbi/bQYiJiQnlypUDoFq1apw+fZqVK1fSokULXrx4wePHj3V6Q+Li4rC2ts5Qz48//kjlypWpVq2aTvnChQtxdXWle/fuADg6OlKgQAE6duyIn58fcXFxqkyGEUIIIT40OR2EvG/vvE9IamoqGo2GatWqYWxszOHDh2nWrBkAV65c4fbt2xnmgyQmJrJr1y4GDx6cob5nz55hZGSkU5b+XqvVqjYZRggh1CSTn4UatDk4JyQnZCsICQ4Opn79+pQqVYrExES2b9/OsWPHCAsLw9zcHE9PT6ZMmUKRIkUwMzNj4sSJuLi4ZAhCdu7cSUpKCq1bt87QRsOGDRk1ahRr1qyhXr163L9/n8mTJ1OjRg1KlCgBZJz08jaTYYQQQk0SDAiRfdkKQuLi4vD39+f+/fuYm5vj4OBAWFgYdevWBWD48OEYGhrSv39/nc3K/i0iIoKmTZtmmMQK8NVXX5GYmEh4eDhTp07F3Nyc2rVrM2TIkLd8RCHkW6oQInfIa8MxBlqtVs1lyblOPpMyOX0L4j2QIEQIoYZkzS291j+nbOaTQt9G3+jsLxp53yR3jMgTJBgQQogPjwQhIk+QnhChb/I7JtSQ14YmJAgReYL8oRb6Jr9jQg05uWNqTsjW1mdr1qyhVatWuLq64urqSvv27dm/fz8ADx8+ZMKECTRr1owaNWrQoEEDJk6cyJMnT5TrN27ciIODQ6avl5PmHD16lLZt21KtWjWaNm3Kxo0bde4jJSWFkJAQGjVqRI0aNWjSpAlz584lj09vEUIIIXIV1bLoarVa7t+/j7+/PxUqVODWrVuMHTuW+/fvM3v2bCBrWXSjo6Px8fGhQ4cOTJ8+ncOHDzNy5Eisra2VaxcvXszatWuZOnUqFSpU4MyZMwwbNgxzc3Ml8Z0QL5OuciFEbpDXVseolkW3Xbt2hIaGKsdsbW3x8/NjyJAhJCcnky9fvixl0V23bh02NjYEBAQAaUnwTp48yfLly5UgJDIyksaNG9OgQQMAbGxs2LFjB6dOncre04s8Q4IBIURukNeCkLfORJOSksKOHTuULLqZSUhIwMzMjHz5Mo91MsuiGxUVhZubm8557u7uREVFKe9dXFw4cuQIV69eBeD8+fOcPHmS+vXrv+3jCCGEEOI9Uy2L7r89ePCAefPm0b59+1fWlVkW3djYWCVjXzorKysSEhJ49uwZpqam9OzZk4SEBFq0aIGRkREpKSkMHDgw0x1YhRBCiNwir81sVC2L7suBSEJCAj4+Ptjb29O3b99M63lVFt2s2LVrF9u2bSM4OJgKFSpw7tw5AgMDKV68OG3bts12fUIIIcSHIK+tjlEti+748eOBtACke/fuFCpUiLlz52JsbJxpPa/KomtlZUVsbKxOWWxsLGZmZkqPSVBQED179uSLL74AwMHBgdu3b7Nw4UIJQoQQQuRaeW1OiGpZdCEtAPH29sbExIT58+eTP3/+TK95XRZdZ2dnfvvtN52yQ4cO6STBe/bsGQYGuuGikZGRLNEVrySrY4QQ4sOjWhbdhIQEunXrRlJSEtOmTSMhIYGEhAQALCwsMDIyUup5XRbdDh06EB4eTlBQEJ6enhw5coRdu3axcOFC5ZyGDRuyYMECSpcurQzHLFu2DE9Pz7f9OYj/OAkGhBC5QV77Kp2tBHbDhw/nyJEjOll0e/ToQd26dTl69Ogr9+jYt28fNjY2yvsOHTpQpkwZgoODMz3/6NGjBAYGcunSJUqWLImvry9fffWVcjwhIYFZs2axd+9e4uLiKF68OF988QV9+vTBxMQkq48DSAK7vEJ6QoS+ye9Y3qDvBHaTynVUra4R18NVq0tfJIuuBCFCCCGySIIQdUnuGCGEEOIDIRNThRBCZJsMxwg15LWhibfeMVUIIYQQ4l1kqydkzZo1rF27llu30sbEKlasiK+vLx4eHjrnabVaevTowYEDB5g7dy5NmjTROb5x40aWLVvGtWvXMDMzo3nz5owZMwaAK1euMGbMGC5fvsyTJ08oXrw4LVu2pG/fvsqeI+vXr2fz5s1cvHgRgKpVqzJo0CBq1Kjxdj8F8Z8n31KFELmBDMe8xuuy6FasWFE5b8WKFRn28Ui3bNkyli5dytChQ3FycuLp06dKUANgbGxMmzZtqFq1Kubm5pw/f55Ro0ah1WoZNGgQkLZ65osvvsDV1RUTExOWLFlCt27d2LFjByVKlHibn4MQQrwTCTiFGmTH1Nd4XRbd9CDk3LlzLF26lIiICNzd3XXOf/ToESEhISxYsEAnSZ2jo6Py77Jly1K2bFnlfZkyZTh27BgnTpxQyv69tHfixIns2bOHw4cP06ZNm+w8ksgj5ANC6Jv0tgmRfapm0U1KSmLw4MGMHj0aa2vrDNf8/vvvpKamcu/ePVq0aEH9+vUZMGAAd+7ceWU7169f58CBA9SsWfOV5yQlJZGcnEyRIkXe9nGEEEKIHJeKVrVXbqBqFt3AwEBcXFwyzAFJd/PmTbRaLQsWLGDEiBGYm5sTEhKCl5cXW7du1dlorEOHDpw9exaNRkP79u0ZMGDAK+9p+vTpFC9enDp16mT3cYQQQhXSIyHUkDtCB/WolkX3+vXrHDlyhE2bNr3y2tTUVF68eMHIkSOVoZoZM2YoO67Wq/fP/8QzZ84kMTGR8+fPExQURFhYGD169MhQ56JFi9i5cycrV658Za4aIYQQIjeQialv8Kosuvnz5+fGjRsZhk369evHJ598wqpVq5QhmvSeE0jLK1OsWLEMQzKlSpVSzk1JSWH06NF069ZNJwdNWFgYixYtYtmyZTrzSoQQQgjx4VMti26/fv1o166dzrFWrVoxbNgwGjZsCICrqysAV69epWTJkgA8fPiQ+Ph4Spcu/co2tFotycnJpKamKkHI4sWLWbBgAWFhYVSvXv1dH0MIIYTIcbllLodaVMuia21tnelk1NKlSyurXcqXL0/jxo2ZNGkS48ePx8zMjBkzZmBnZ0etWrUA2Lp1K/ny5cPBwQETExNOnz5NcHAwLVq0UPYJWbRoEbNnzyY4OJgyZcoQExMDQMGCBSlUqNA7/UCEEOJtyOoYoYa8FYJkMwiJi4vD399fJ4tuWFgYdevWzXIdQUFBTJ48GR8fHwwNDalZsyZLlixRAox8+fKxZMkSrl69CqQFMZ06daJr165KHevWrePFixf0799fp+6+ffvSr1+/7DySEEKoQoIBIbJPsuhKFl0hhBBZpO8sut9/9I1qdU2/tla1uvRFEtgJIYQQHwiZEyKEECLbZE6IENknQYgQQqhAggGhhrzVD6KHLLqRkZHMnDmTU6dOYWhoSOXKlQkLC8PU1BRIyz/zcsI6gMGDB9OzZ08gbVfVxo0bZ2j7hx9+wNnZWXn/+PFjZs6cyc8//8zDhw8pU6YMw4cPz5DRVwgh3gfpCRFqkM3KXuNNWXQjIyPp3r07Pj4+jBo1CiMjI86fP4+hoW6Kmv79+/P1118r7zNbVrt8+XKdTc2KFi2q/Fuj0eDl5YWlpSWzZs2iRIkS3L59m8KFC2fncYQQQgiRg1TNohsYGEjnzp2VXg0AOzu7DPUUKlQo0z1FXla0aNFXnhMREcGjR49Yt26dsrTXxsYmO48ihBCqkh4JoQZtHhuQUS2LblxcHH/++SeWlpZ06NCBOnXq0KlTJ06cOJHh2sWLF1OrVi3atGnDkiVLSE5OznBO7969cXNz45tvvmHfvn06x3755RecnZ0ZP348derUoWXLlixYsICUlJS3fRwhhBAix6Wq+MoNVMuiGxUVBcCcOXMYOnQolStXZvPmzXTt2pXt27fz0UcfAdC5c2eqVKlCkSJFiIyMZMaMGcTExDBs2DAgbdfTgIAAXF1dMTAw4KeffqJPnz7MnTtXmSsSHR3NkSNHaNWqFYsWLeLGjRuMGzeO5ORk+vbtq85PRgghhHjP8toS3WxvVqbRaLhz546SRffHH39k9erVPH78mG+++QYfHx8GDRqknN+qVSsaNGjA4MGDM61vw4YNjBkzhsjISExMTDI9Z+jQody8eZM1a9YA0KxZM54/f86+ffuUXDLLli0jLCyMgwcPZudxZLMyIYQQWabvzcp8P/r6zSdl0bxr61WrS1+yPRyTnkW3WrVqDB48GEdHR1auXKnM37C3t9c5397entu3b7+yPicnJ5KTk7l58+Zrz7lx44by3tramo8++kgno66dnR0xMTFoNJrsPpIQQgjxQdCq+MoN3npOSLr0LLo2NjYUL15cyfmS7tq1a5Qp8+rehnPnzmFoaIilpeVrz3l5kqqrqys3btwgNfWfUa9r165hbW39yt4UIYQQ4kOXila1V26gWhZdAwMDvL29CQ0NxdHRkcqVK7Np0yauXLnC7NmzgbQ9RP78809q165NoUKFiIyMJDAwkNatW1OkSBEANm3ahLGxMZUrVwbg559/JiIigokTJyr38c0337B69WomTZpEp06duH79OgsXLqRz585q/VyEEEIIoWeqZtHt2rUrGo2GwMBAHj16hKOjI0uXLsXW1hZIG8rZuXMnc+bMUXpPunbtipeXl0478+bN4/bt2xgZGWFnZ8fMmTNp3ry5crxUqVKEhYUpAUyJEiXo0qULPXr0eNefhxBCCJFjcsuqFrVIFl2ZmJonyG6WQgg16HtiaveP/qdaXUuubVCtLn2R3DEiT5BgQAghPjwShIg8QXpChL7J75hQQ14bjpEgRAghVCDBgFBDXtu2XdUsujExMQQFBXHo0CESExMpX748vXr1olmzZhnq0mg0tGvXjvPnz7N582ZlNQzAgQMHCA0N5eLFi+TPn5+aNWvi7++vkx/m6NGjTJkyhYsXL1KqVCl69+7NV1999VY/BPHfJx8QQgjx4cnWPiHpWXQ3btxIREQEtWvXpk+fPly8eBEAf39/rl69yvz589m2bRtNmzbFz8+Pv/76K0NdQUFBFC9ePEN5dHQ0vr6+1K5dmy1bthAWFkZ8fDz9+vXTOcfHx4datWqxZcsWvvvuO0aOHMmBAznTHSqEEEKoIa/ljslWENKoUSM8PDz46KOPKF++PAMHDqRgwYJK3pjIyEg6depEjRo1KFu2LL6+vhQuXJizZ8/q1LN//35+//13/P39M7Rx9uxZUlNT8fPzw9bWlqpVq9KtWzfOnTvHixcvAFi3bh02NjYEBARgb29Pp06daNasGcuXL3+7n4IQQgjxAUjValV75QaqZdEFcHFxYdeuXTx8+JDU1FR27NjB8+fP+fTTT5XrYmNjGTVqFEFBQZiammaot2rVqhgYGBAREUFKSgpPnjxhy5Yt1KlTB2NjYwCioqJwc3PTuc7d3V0JhoQQQojcKK9t265aFl2AkJAQBg4cSK1atciXLx+mpqbMmTOHcuXKAaDVagkICKBDhw5Ur14903wxZcuWZenSpfj5+TFmzBhSUlJwcXFh0aJFyjmxsbFYWVnpXGdlZUVCQgLPnj3LNLgRQgghxIcl2z0h5cuXZ/Pmzaxfv55vvvkGf39/Ll26BMCsWbN4/Pgxy5cvJyIiAi8vL/z8/Lhw4QIAq1atIjExER8fn1fWHxMTw6hRo2jTpg0bNmxg9erVGBsb079/f/L4vmpCCCH+4yR3zBukZ9EFqFatGqdPn2blypV0796d1atXs337dipWrAiAo6MjJ06cIDw8nPHjx3PkyBGioqKoXr26Tp2enp60atWKqVOnEh4ejpmZGUOHDlWOT5s2DQ8PD/7880+cnZ2xsrIiNjZWp47Y2FjMzMykF0QIkSNknxChBlmim03pWXSTkpIAMDTU7VwxMjJSejBGjhyJn5+fcuz+/ft4e3szc+ZMnJycAHj27FmGOtLfp2fNdXZ25rffftM559ChQzg7O7/r4wghhBDiPVEti66dnR3lypVj9OjR+Pv7U7RoUfbu3cvvv//OwoULAShdurROfQULFgTA1taWkiVLAuDh4cHy5cuZM2cOLVu2JDExkRkzZlCmTBmqVKkCQIcOHQgPDycoKAhPT0+OHDnCrl27lHaE+Df5lir0Tf5bCzXklqW1aslWArvhw4dz5MgRnSy6PXr0ULLoXrt2jeDgYE6ePMnTp0+xtbWlW7dutGnTJtP6bt68SePGjTNsVrZjxw6WLFnCtWvXMDU1xdnZme+//x57e3vlnKNHjxIYGMilS5coWbIkvr6+b7VZmSSwE0IIkVX6TmDXrtyXqtX14/UtqtWlL5JFV4IQIYQQWSRBiLokd4wQQqhAhvyEGmRiqhBCiGyTYECoIa/NCZEgROQJ8i1V6Jv8jon/gvDwcMLCwoiJicHR0ZFRo0ZRo0aNTM9dv349mzdvVvLHVa1alUGDBr3y/MxIECKEECqQYECoISenae7cuZPAwEDGjRuHk5MTK1aswNvbm927d2NpaZnh/KNHj/LFF1/g6uqKiYkJS5YsoVu3buzYsYMSJUpkqc13mpi6aNEigoOD6dKlCyNGjADg+fPnTJkyhZ07d6LRaHB3d2fMmDEZtlkHiI+P58svv+TevXscP36cwoUL6zzclClTuHjxIqVKlaJ3796vXP2S2X1klUxMFUKoQXpC8gZ9T0z90ralanVtubE9W+e3a9eO6tWrM3r0aCBtby4PDw86d+5Mz54933h9SkoKNWvWZPTo0a9cFftvb90TcurUKdatW4eDg4NO+eTJk9m/fz8hISGYm5szYcIE+vbty7p16zLUMWLECBwcHLh3755OeXR0ND4+PnTo0IHp06dz+PBhRo4cibW1NfXq6f4P96r7EEKI90mCAaGGnJoTotFoOHv2rE5aFUNDQ+rUqUNkZGSW6khKSiI5OZkiRYpkud23CkISExMZMmQIEydOZP78+Ur5kydPiIiIYPr06UqW28mTJ/P5558TFRWls6PpmjVrePLkCb6+vhl2P123bh02NjYEBAQAYG9vz8mTJ1m+fLlOEPKq+xDi3+RbqhAir9FoNGg0Gp0yExMTTExMMpwbHx9PSkpKhmEXS0tLrly5kqX2pk+fTvHixalTp06W7/GtgpDx48fj4eFBnTp1dD78z5w5w4sXL3RuwN7entKlS+sEIZcuXWLevHmsX7+e6OjoDPVHRUUpQUw6d3d3Jk+enKX7EOLfJBgQQuQGai7RXbhwIXPmzNEp69u3L/369VOtjXSLFi1i586drFy5kvz582f5umwHITt27OCvv/5iw4YNGY7FxsZibGysM7cD0iKpmJgYIC0yGzRoEEOGDKF06dKZBiGxsbEZ5pBYWVmRkJDAs2fPMDU1fe19CCGEELmRmtlvfXx88PLy0inLrBcEoFixYhgZGREXF6dTHhcXl+mczpeFhYWxaNEili1bhqOjY7bu0fDNp/zjzp07TJo0iWnTpmUr0nlZcHAw9vb2fPnl2+8Kp8Z9CCGEEP9lJiYmmJmZ6bxeFYSYmJhQtWpVDh8+rJSlpqZy+PBhXFxcXtnG4sWLmTdvHkuWLKF69erZvsds9YScPXuWuLg4nVUqKSkpHD9+XFlb/OLFCx4/fqzTGxIXF4e1tTUAR44c4e+//2bPnj3AP8uRateuTa9evejfvz9WVlbExsbqtB0bG4uZmRmmpqZvvI/Tp09jZGSUzR+FEEK8PZl3JNSQk0t0vby88Pf3p1q1atSoUYMVK1aQlJSkfNYOHTqUEiVKMHjwYCBtCGb27NkEBwdTpkwZZcSjYMGCFCpUKEttZisIqV27Ntu2bdMpGzZsGHZ2dvTo0YNSpUphbGzM4cOHadasGQBXrlzh9u3bynyQ0NBQnj17plx/+vRphg8fTnh4OLa2tgA4OztnmKx66NAhpY433YcEIOLf5ANCCJEb5OSOqZ9//jkPHjxg9uzZxMTEULlyZZYsWaIMx9y5cwdDw38GUNatW8eLFy/o37+/Tj3ZmXeSrSDEzMyMSpUq6ZQVLFiQokWLKuWenp5MmTKFIkWKYGZmxsSJE3FxcVECiPRAI118fDyQNoE1vfekQ4cOhIeHExQUhKenJ0eOHGHXrl0sXLgwy/chxMskGBD6Jr9j4r+gU6dOdOrUKdNjq1at0nn/yy+/vHN7qu+YOnz4cAwNDenfv7/OZmXZUbZsWRYuXEhgYCArV66kZMmSTJw4McMeIUIIIcR/SV5LYPdOO6b+F8iOqUIIIbJK3zumNinbTLW69kbvUa0ufcnW6hghhBBCCLVIAjshhBDiA5HXBickCBFCCBXICiyhBjU3K8sN3ikI+Xf22ocPHxIaGsrBgwe5c+cOFhYWNGnShAEDBmBubg6krYb5/vvvuXDhAg8fPsTS0pLGjRszaNAgzMzMAPjpp59Yu3Yt586dQ6PRULFiRfr27aszMTUlJYXQ0FC2bt1KbGwsxYsXp23btvj6+mJgYPAujyX+g+QDQuib/LcWashrE1NVzaJ7//597t+/j7+/PxUqVODWrVuMHTuW+/fvM3v2bCAtK1/jxo3x8/PDwsKCGzduMG7cOB49ekRwcDAAx48fp06dOgwcOJDChQuzceNGevfuzfr166lSpQqQtkvb2rVrmTp1KhUqVODMmTMMGzYMc3NzunTp8i4/E/EfJB8QQgjx4VE1i26lSpUIDQ1V3tva2uLn58eQIUNITk4mX758FClShG+//VY5p0yZMnz77beEhYUpZSNGjNBpb9CgQezbt49ffvlFCUIiIyNp3LgxDRo0AMDGxoYdO3Zw6tSpt3kkIYQQIsel5rE5IW+1Oubl7LVvkpCQgJmZGfnyZR7v3Lt3j59//pmaNWu+so7U1FQSExMpWrSoUubi4sKRI0e4evUqAOfPn+fkyZPUr18/ew8jhBBCfCC0Kr5yA1Wz6P7bgwcPmDdvHu3bt89wLL1349mzZzRs2JBJkya9sp6wsDCePn1KixYtlLKePXuSkJBAixYtMDIyIiUlhYEDB9K6devsPpLIA2ROiBBCfHiyFYSkZ69dunTpG7PXJiQk4OPjg729PX379s1wfNiwYfTp04dr164xY8YMAgMDGTt2bIbztm3bxty5c5k3bx6WlpZK+a5du9i2bRvBwcFUqFCBc+fOERgYqExQFeJlEgwIfZNAV6ghr62OydaOqXv37qVPnz46CeJSUlIwMDDA0NBQyV6bkJBA9+7dMTU1ZeHChW8MWE6cOEHHjh05cOAAxYsXV8p37NjB8OHDmTVrljL3I52Hhwc9e/akY8eOStm8efPYunUru3fvzuojyY6pQgghskzfO6a6lWmoWl2Hb/2fanXpi6pZdNMDEG9vb0xMTJg/f/4bAxD4Z3MWjUajlG3fvp3hw4czY8aMDAEIwLNnzzIsxTUyMspzG70IIYQQuZWqWXQTEhLo1q0bSUlJTJs2jYSEBBISEgCwsLDAyMiI/fv3ExsbS/Xq1SlYsCCXLl0iKCgIV1dXbGxsgLQhmICAAIYPH46TkxMxMTEAmJqaKvuNNGzYkAULFlC6dGllOGbZsmV4enq+8w9F/PdIV7kQIjfIa1+k3zmBXefOnXF0dGTEiBEcPXr0lXt07Nu3DxsbG44cOUJISAiXLl1Co9FQqlQpmjZtSs+ePSlcuLBS57FjxzLU0bZtW6ZMmQKkzTmZNWsWe/fuJS4ujuLFi/PFF1/Qp08fTExMsnz/MhwjhBAiq/Q9HPNpaQ/V6jp2e79qdemLZNGVICRPkJ4QIYQaJAhRl+SOEXmCBANCiNxAtm0XQgghRI7Ia4MTEoQIIYQQH4i8tk/IW23bnm7RokU4ODhkutupVqule/fuODg4sHfvXqX8/PnzDBo0CA8PD2rUqEGLFi1YsWKFzrVHjx7FwcEhwyt9lQzAwoUL8fT0xMXFBTc3N3x9fbly5cq7PI4QQggh3iNVs+i+bMWKFRn28QA4c+YMFhYWTJs2jVKlSvHHH38wevRojIyM6NSpk865u3fvxszMTHn/8o6px44do2PHjlSvXp2UlBRmzJiBt7c3O3bsoGDBgm/7WEIIIUSOkeGYLHhVFt10586dY+nSpURERODu7q5z7H//+5/O+7JlyxIVFcVPP/2UIQixtLRUlu3+28tZdwGmTJmCm5sbZ8+efW0yPJE3yeoYIURukNeGY94qCHk5i+6/g5CkpCQGDx7M6NGjsba2zlJ9T5480cmQm65NmzZoNBoqVqxI3759+fjjj19bB0CRIkWy/iAiz5BgQAghPjyqZ9ENDAzExcWFJk2aZKm+P/74g127drFw4UKlzNramnHjxlGtWjU0Gg0//vgjXbp0Yf369VStWjVDHampqUyePBlXV9cMO7oKAdITIoTIHWSJ7mu8KYvuvn37OHLkCJs2bcpSfX///Te+vr706dNHZ9jGzs4OOzs75b2rqyvR0dEsX76cadOmZahn3LhxXLx4kTVr1mTncUQeIsGA0DcJdIUaUmVOyKudPXuWuLg4vvrqK6UsJSWF48ePEx4ezjfffMONGzcyzMno168fn3zyCatWrVLKLl26RNeuXWnfvj2+vr5vbLt69er88ccfGcrHjx/Pr7/+yurVqylZsmR2HkcIIVQjwYAQ2adqFt1ixYrRvn17neOtWrVi2LBhNGz4T3riixcv8t1339GmTRsGDhyYpbbPnz+vM8dEq9UyYcIEfv75Z1atWkXZsmWz8yhCCKEq6QkRapDhmNd4UxZdINPJqKVLl1aChL///pvvvvsOd3d3vLy8lL0/jIyMsLCwAGD58uXY2NhQsWJFnj9/zo8//siRI0dYunSpUue4cePYvn078+bNo1ChQko95ubmmJqaZuexhBDinUkwINQgwzF6tmfPHh48eMDWrVvZunWrUl6mTBl++eUXAF68eMHUqVO5d+8eBQoUoFKlSixbtozatWsr569duxZIy7j7ssDAQJ3hIiFAvqUKIcSHSLLoShbdPEGCECGEGvSdRdexuHr7XJ2/f1y1uvRFcscIIYQQHwgZjhHiP0h6JIQQuUFem5j6TgnshBBCCCHell6y6EZGRtKlSxecnZ1xdXWlY8eOPHv2TDk+f/58OnTogJOTE5988kmGejdu3JhpFl0HBwfi4uKU8zQaDTNnzqRhw4ZUq1aNRo0avXInVyGEEOJDl6rVqvbKDVTPohsZGUn37t3x8fFh1KhRGBkZcf78eQwN/4l3Xrx4QfPmzXF2ds40aPj888+pV0+3+zwgIACNRqOTSXfAgAHExcUxadIkbG1tiYmJITU19W0fSQgh3ppMfhZqyGvDMapn0Q0MDKRz58707NlTKXt5C3aA/v37A2k9HpkxNTXV2evjwYMHHD16lIkTJyplv/32G8ePH2fv3r1K8jsbG5u3eRwhhHhnEgwIkX2qZtGNi4vjzz//pFWrVnTo0IEbN25gZ2eHn59fpsMuWbV582ZMTU1p3ry5UvbLL79QrVo1lixZwpYtWyhYsCCNGjViwIABslmZyEC+pQohcgOtNm/15quaRTc6OhqAOXPmMHToUCpXrszmzZvp2rUr27dv56OPPnqrm9ywYQMtW7bUCS6io6M5efIk+fPnZ+7cucTHxzNu3DgePnxIYGDgW7Uj/rskGBBC5AapeWw4JlsTU9Oz6E6bNi3TLLrp8zHat2+Pp6cnVapUYfjw4ZQvX56IiIi3usHIyEguX77M//73P51yrVaLgYEB06dPp0aNGnh4eBAQEMCmTZt0JsEKIYQQ4sOkahbd3bt3A2Bvb69znb29Pbdv336rG/zxxx+pXLky1apV0ym3tramRIkSmJub67Sj1Wq5e/fuW/e6CCGEEDklr21irmoW3bJly1K8eHGuXr2qc861a9eoX79+tm8uMTGRXbt2MXjw4AzHXF1d2b17N4mJiRQqVAiAq1evYmhoSMmSJbPdlhBCCJHT8tpwjOpZdL29vQkNDcXR0ZHKlSuzadMmrly5wuzZs5Vrbt++zaNHj7h9+zYpKSmcO3cOAFtbWyWgANi5cycpKSm0bt06w720bNmSefPmMWzYMPr37098fDzTpk3D09NTJqYKIYQQuYDq27Z37doVjUZDYGAgjx49wtHRkaVLl2Jra6ucM3v2bDZt2qS8b9OmDQArV66kVq1aSnlERARNmzalcOHCGdopVKgQS5cuZeLEiXh6elK0aFFatGiBn5+f2o8k/gNkdYwQIjfIa8MxkkVXsugKIYTIIn1n0S1VtIpqdd15+JdqdemLJLATeYL0hAghcgPZMVWI/yAJBoQQ4sMjQYgQQgjxgchrMyQkCBFCCCE+EHltiW62dkz9t0WLFuHg4MCkSZOUspiYGIYMGULdunVxdnambdu27NmzR+e6+fPn06FDB5ycnF6ZU+b27dv07NkTJycn3NzcmDp1KsnJyTrnHD16lLZt21KtWjWaNm36yoR4QgghhPjwvHVPyKlTp1i3bh0ODg465f7+/jx+/Jj58+dTrFgxtm3bhp+fHxEREVSpkjbr98WLFzRv3hxnZ+dMc9CkpKTg4+ODlZUV69at4/79+/j7+2NsbMygQYOAtNwxPj4+dOjQgenTp3P48GFGjhyJtbU19erJ+L/QJRNThRC5gQzHZEFiYiJDhgxh4sSJOll0IS3Xy5gxY6hRowYAvr6+rFixgrNnzypBSP/+/QFe2XNx8OBBLl26xLJly7CysqJy5coMGDCA6dOn07dvX0xMTFi3bh02NjYEBAQAaVu2nzx5kuXLl0sQIjKQYEAIkRuk5rEg5K2GY8aPH4+Hhwd16tTJcMzFxYVdu3bx8OFDUlNT2bFjB8+fP+fTTz/Ncv1RUVFUqlQJKysrpczd3Z2EhAQuXbqknOPm5qZznbu7O1FRUW/zSEIIIYR4z7LdE7Jjxw7++uuvTIdRAEJCQhg4cCC1atUiX758mJqaMmfOHMqVK5flNmJjY3UCEEB5HxMT89pzEhISePbsmWzdLnTIcIwQIjeQ4ZjXuHPnDpMmTWLp0qXkz58/03NmzZrF48ePWb58OcWKFWPv3r34+fkRHh6eYf6IEEIIIf6R11bHZCsIOXv2LHFxcXz11VdKWUpKCsePHyc8PJzdu3ezevVqtm/fTsWKFQFwdHTkxIkThIeHM378+Cy1Y2VlxalTp3TKYmNjAbC2tlbOSS97+RwzMzPpBREZSI+EEEJ8eLIVhNSuXZtt27bplA0bNgw7Ozt69OhBUlISAIaGulNNjIyMstXF5OzszIIFC4iLi8PS0hKAQ4cOYWZmRoUKFZRzfvvtN53rDh06hLOzc3YeSQghhPhgyHDMa5iZmVGpUiWdsoIFC1K0aFEqVarEixcvKFeuHKNHj8bf35+iRYuyd+9efv/9dxYuXKhcc/v2bR49esTt27dJSUnh3LlzANja2lKoUCHc3d2pUKECQ4cOZciQIcTExBASEkLHjh0xMTEBoEOHDoSHhxMUFISnpydHjhxh165dOu0IIYQQuUleWx3zzll0O3fujKOjIyNGjADg2rVrBAcHc/LkSZ4+fYqtrS3dunWjTZs2yjUBAQFs2rQpQ10rV66kVq1aANy6dYuxY8dy7NgxChQoQNu2bRk8eDD58v0TNx09epTAwEAuXbpEyZIl8fX11RkqygrJoiuEECKr9J1Ft1DBj1SrK/HpNdXq0pd3DkJyOwlChBBqkBVYeYMEIeqS3DFCCKECCQaEGvLacIwEISJPkG+pQojcIK8NTkgQIvIECQaEEOLDI0GIEEII8YHQ5rHNyt4qd4wQQggh1KfValV7vY3w8HAaNWpE9erVadeuXYaNQ/9t165dNG/enOrVq9OqVSv279+frfZkdYysjskTZE6I0Df5Hcsb9L06xiS/jWp1aZ7fzNb5O3fuZOjQoYwbNw4nJydWrFjB7t272b17t7Jx6Mv++OMPOnXqxKBBg2jYsCHbtm1jyZIlbNy4McOeYq8iQYgEIUIIIbJI30GIsYqfSS+yea/t2rWjevXqjB49GoDU1FQ8PDzo3LkzPXv2zHC+n58fSUlJOpuEfv311zg6OmY5TYsMxwghhBAfCK2Kr+zQaDScPXuWOnXqKGWGhobUqVOHyMjITK+JiorCzc1Np8zd3Z2oqKgstysTU4UQQoj/II1Gg0aj0SkzMTFR0p+8LD4+npSUlAzDLpaWlly5ciXT+mNjY7Gysspw/r+Ty75Ong9C9N21JoQQQmSVmp9JoaGhzJkzR6esb9++9OvXT7U23lWeD0KEEEKI/yIfHx+8vLx0yjLrBQEoVqwYRkZGxMXF6ZTHxcVl6O1IZ2VllaHX43XnZ0bmhAghhBD/QSYmJpiZmem8XhWEmJiYULVqVQ4fPqyUpaamcvjwYVxcXDK9xtnZmSNHjuiUHTp0CGdn5yzfowQhQgghhMDLy4v169ezadMmLl++zNixY0lKSlKy0w8dOpTg4GDl/C5dunDgwAGWLl3K5cuXCQ0N5cyZM3Tq1CnLbcpwjBBCCCH4/PPPefDgAbNnzyYmJobKlSuzZMkSZXjlzp07GBr+03fh6urK9OnTCQkJYcaMGXz00UfMnTs3y3uEgOwTIoQQQogcIsMxQgghhMgREoQIIYQQIkdIECKEEEKIHCFBiBBCCCFyhAQh4oPUpUsXHj9+nKE8ISGBLl265MAdCSGEUJss0c0lrly5wurVq7l8+TIA9vb2dOrUCTs7uxy+M/04duwYL168yFD+/PlzTp48mQN3JETut3nzZj7//PMMG1ZpNBp27txJmzZtcubGRJ4lPSG5wJ49e2jVqhVnz57F0dERR0dH/vrrL1q1asWePXv01m5ycjJz5szh7t27emvj386fP8/58+cBuHTpkvL+/Pnz/PXXX2zYsIESJUq8t/vJaQkJCezdu1cJPt+nlJQUzp07x6NHj95725n1gunD5s2b6dChA+7u7ty6lZazY/ny5ezdu/e9tP++DRs2jCdPnmQoT0xMZNiwYe/1XnLyd1t8OKQnJItSU1PZuHEjP//8M7du3cLAwIAyZcrQvHlzvvzySwwMDPTW9rRp0+jZsycDBgzQKZ89ezbTpk2jWbNmemk3X758hIWFvddvR23atMHAwAADAwO+++67DMdNTU0ZOXKk3u8jMDAw03IDAwPy58+Pra0tjRs3pmjRoqq2O2DAAGrWrEmnTp149uwZnp6e3Lp1C61Wy4wZM/T23xpg0qRJVKpUiXbt2pGSkkKnTp2IjIykQIECLFiwgFq1auml3UWLFmFjY8Pnn38OpP0MfvrpJ6ysrFi8eDGOjo56aXfNmjXMnj2b7777jgULFpCamgpA4cKFWbFiBU2aNNFLu5AW4G3cuJEjR44QFxentJ1u5cqVemlXq9Vm+rfq3r17mJub66XNdDn5u53+d+XfDAwMMDExoVy5crRt25batWvr7R5E5iQIyQKtVkvv3r3Zv38/jo6OVKpUCa1Wy+XLlwkICOCnn35i3rx5ems/JiYm00CgdevWhIWF6a1dgNq1a3P8+HFsbGz02k66ffv2odVqadKkCT/++CMWFhbKMWNjYywtLTEyMtL7ffz111/89ddfpKamUr58eQCuXr2KkZERdnZ2rFmzhqlTp7JmzRoqVKigWrsnTpygd+/eAPz8889otVqOHz/Opk2bmD9/vl7/UO/Zs4fWrVsD8H//93/cvHmTXbt2sWXLFmbOnMm6dev00u66deuYPn06AL///juHDh1i8eLF7Nq1i6CgIJYuXaqXdlevXs3EiRNp0qQJixYtUsqrVavG1KlT9dJmukmTJrFp0yY8PDyoWLGiXr/EQMbgPl++f/70p6SkcPPmTerVq6fXe8jJ3+169eqxdu1aKlWqRI0aNQA4ffo0Fy5coG3btly+fBkvLy9CQ0P1GnyKjCQIyYKNGzdy/Phxli9fniFSPnz4MH369GHz5s166zH49NNPOXHiBOXKldMpP3nyJJ988ole2kxXv359goOD+fvvv6latSoFChTQOd64cWNV2ytTpgyAMiSTmVd9m1NTei9HYGAgZmZmADx58oQRI0bw8ccf8/XXXzN48GACAwNVDQSfPHlCkSJFADhw4ACfffYZBQoUoEGDBkybNk21djITHx+PtbU1APv376d58+aUL18eT09PvX0zB4iNjaVUqVJAWvDTokUL3N3dKVOmDF9//bXe2r158yaVK1fOUG5iYkJSUpLe2gXYsWMHISEheHh46LWddOkfrOfOncPd3Z1ChQopx4yNjSlTpgyfffaZXu8hp3+3vby86NOnj075vHnzuH37NkuXLmX27NnMmzdPgpD3TIKQLNixYwe9evXKtKvOzc2Nnj17sm3bNr0FIY0aNWL69OmcPXsWJycnAP788092795Nv3792Ldvn3Ku2kHBuHHjAFi2bFmGYwYGBpw7d07V9tIFBAQwevRoChYsqFN+8+ZNhg4dypo1a/TSbrqwsDCWLVumBCAA5ubm9OvXj27duvHdd9/Rp08funXrpmq7pUqVIjIykiJFinDgwAFmzJgBpM2ReFX2S7VYWVlx6dIlrK2tOXDgAGPHjgXg2bNneu19Kly4MHfu3KFUqVIcOHAAPz8/IC3YTElJ0Vu7NjY2nDt3Tgl80x04cAB7e3u9tQtpH/y2trZ6beNlffv2BdKC/M8//5z8+fO/t7bT5eTv9q5du9i4cWOG8i+++IKvvvqKiRMn8sUXX2T6d07olwQhWXDhwgWGDBnyyuP169dn1apVems/PRBYs2ZNhg/f9GOgn6DgdT0S+nT+/Hlat27NtGnTlDTSmzZtYuLEie9l3DYhIYG4uLgMQy0PHjwgISEBSPvwzGwFz7vo0qULQ4YMoWDBgpQuXVqZh3H8+PFsJYV6G1999RV+fn5YW1tjYGBAnTp1gLSAV5+rsD777DO+//57ypUrx8OHD6lfvz6Q9q39371/avLy8mL8+PFoNBoATp06xfbt21m0aBETJ07UW7sA3bp1Y+XKlYwePVrvvXova9u2LZC2GubBgwcZ5qKULl1ab23n5O92/vz5iYyMzPD7FBkZqQRkWq02R4KzvE6CkCx49OgRlpaWrzxuaWmp1xUEORUI/Nvz58/f2/+kP/74IzNmzKBz585069aN69ev89tvvzFs2DC9dtGna9SoEcOHDycgIIDq1asDaWPIU6dOVbprT506xUcffaRqux07dsTJyYk7d+5Qp04dJWNl2bJlGThwoKpt/Vu/fv2oWLEid+/epXnz5sq3UyMjI3r06KG3docNG0aZMmW4c+cOQ4YMUYYKYmJi+Pbbb/XWbrt27cifPz8hISEkJSUxePBgihcvzvDhw/niiy/01i6kDaUePXqU3377jYoVK+rM0QCYM2eOXtq9du0aw4cPJzIyUqc8fYhTXz2b8Prf7fTeL33p1KkTY8aM4cyZMzr/P2/YsAEfHx8ADh48mOnwnNAvyaKbBZUrV+b333/XmST5stjYWOrVq6fX/4FzSkpKCgsWLGDdunXExcWxZ88eypYtS0hICGXKlKFdu3Z6bT99nDZfvnysWrVK6RXRt8TERAIDA9m8ebMyJGBkZETbtm0ZNmwYBQsWVP57q/mHa86cOXh7e2eYe/Ps2TOWLFmidKvr2/sMOD8ESUlJPH369LVfNtT0puWwr1qd9a46dOhAvnz56NGjB8WLF8/QC6OvlUgvXrygRYsWLFy4UO9DXa+ydetWwsPDuXr1KgDly5enU6dOtGrVCkj7fyx99Zt4fyQIyQJHR0fq16//ynFLjUbDgQMH9BqEnDp1iqNHj2baharP9f1z5sxh8+bN9O/fn1GjRrF9+3bKli3Lzp07WbFiBT/88INe2n3x4gXBwcGEh4fTrVs3Tp48ybVr15g0adJ7m8wHacFIdHQ0kPaN7eUJffpQuXJlDh48mOHDMD4+njp16uj1dywnA87Nmzfzww8/EB0dzQ8//ECZMmVYvnw5NjY2epsoGB0dTUpKSoberGvXrpEvX773tiLsfXJ2diYiIiJHAoF69eqxfPnyHAtCxIdJNivLgjZt2mBpaYm5uXmmL0tLS73upbFgwQK+/vprNm7cyJkzZ5Tlo3/99Zfee1+2bNnChAkTaN26tdJ9CuDg4MCVK1f01q6npye//PILq1atYuDAgaxatYouXbrQt29fZcLk+1CoUCFlgzh9ByDw6pU/58+fV1YW6Mv8+fPZtGkTQ4YMwdjYWCmvVKkSGzZs0Fu7a9asYcqUKdSvX58nT55k2K9DX4YNG5ZhWALS5sC8r427Hjx4wIkTJzhx4gQPHjzQe3v29vbEx8frvZ3MdOzYkcWLF5OcnJwj7UPaF8a7d+9y+/ZtnZfIOTInJAumTJmSo+2vXLmSyZMn89VXX733tu/du5fpLH6tVqvXPybVqlVj5MiRyuoYAwMDevbsibu7O0OHDtVbuy87ffo0u3bt4s6dOxkmoKo9Zl+zZk1lH4dmzZrpBCIpKSk8ffqUDh06qNrmv6UHnG5ubowZM0Yp13fAmVP7dfz1119MmjQpQ7mzszMTJkzQW7sAT58+ZcKECWzZskUJuoyMjPjyyy8ZNWpUhuE4tXz//fdMnz6dgQMHUqlSJZ1gE9BZDaa206dPc/jwYQ4ePIiDg0OGZ9TXPBjI2bkw4vUkCMmCrIzDGxgYEBoaqpf2DQ0NcXV11Uvdb1KhQgVOnDiRYRnj7t279TqJa/LkyZmWV6lSJdOldmrbsWMH/v7+uLu7c/DgQdzd3bl69SpxcXE0bdpU9faGDx+OVqtl+PDh9OvXT2f3yvR9HPQ9HyanAs6c2q/DwMCAxMTEDOVPnjzR69JgSPtic/z4cebPn8/HH38MpE1WnThxIlOmTNFZ9aYmLy8vALp27apT/j4+jAsXLqzXDcleJyAggHz58rFgwYJM58KInCNBSBboezvjN/nuu+8IDw9nxIgR771tX19fAgICuHfvHlqtlp9++omrV6+yefNmFi5cqNe2N2/ezLp167h58+Z7myeQbsGCBQwbNoyOHTvi4uLCiBEjsLGxYfTo0cqGXmpKXzppY2ODq6trhtUS70NOBZw5tV9HzZo1WbhwITNmzFD2QUlJSWHRokVKYKAve/bsYfbs2Tpb4Xt4eJA/f378/Pz0FoToc9O5N9HXZNusOH/+fI7NhRGvJ0FIFuTk/zwA3t7e9OzZkyZNmlChQoX3tpwP0nZaXLBgAXPnzqVAgQLMnj2bKlWqsGDBAurWrau3dnMyrwekTVpMnwBrYmLC06dPMTAwoGvXrnz33Xf0799fL+1++umn3Lhxg4iICKKjoxkxYgSWlpbs37+f0qVLU7FiRb20CzkXcObUfh2DBw+mU6dONG/eXNl5+MSJEyQkJOh1LgqkrcSwsrLKUG5pacmzZ8/01u6nn36qt7qzIjk5mWPHjnHjxg1atmyJmZkZ9+7dw8zMTK9zrnJyLox4PQlCcoGJEydy9OhRatWqRdGiRd97V+Inn3zy3ncSzMm8HpAW7KR31RcvXpyLFy/i4ODA48eP9TpEcOzYMXr06IGrqyvHjx9n4MCBWFpacuHCBSIiIpg9e7be2s6pgDOn9uuoWLGismzz/PnzmJqa8uWXX9KpUyfVExP+m7OzM7NnzyYoKEhZEvrs2TPmzJmDs7Oz3to9fvz4a4/XrFlTb23funWL7t27c+fOHTQaDXXr1sXMzIzFixej0WgYP3683trOybkw4vUkCMkFNm3aRGhoKA0aNHjvbd+5cwcDAwNKliwJpH1L3bZtGxUqVKB9+/Z6azcn83pA2h/jQ4cO4eDgQPPmzZk0aRJHjhzh0KFDuLm56a3d4OBg/Pz88PLy0pkDUrt2bVavXq23dgHu3r37yoAzKipKrx+OrVu3pnXr1u9tv44XL17QvXt3xo0bx6BBg/TaVmZGjBiBt7c39evXV/bmOH/+PPnz59drUsrOnTtnKHv5S40+54RMmjSJatWqsWXLFp1hqKZNmzJq1Ci9tQs5OxdGvJ4EIblA0aJFKVu2bI60PXjwYL7++mvatGlDTEwMXbt2pVKlSmzbto2YmBi9bZ6Vk3k9AEaNGsXz588B6N27N8bGxvzxxx989tlnSiZQffj777+VjLIvs7Cw0Ht3crdu3VizZk2GXoCTJ0/i4+PDiRMn9No+QIECBfS2MuRlxsbGXLhwQe/tvEqlSpX46aef2LZtm7LyqGXLlrRq1QpTU1O9tfvvnpAXL15w7tw5Zs2apfcdeU+ePMnatWsz7LdUpkwZ7t27p9e2c3IujHg9CUJygb59+xIaGkpgYOB7+QP9sosXLyqpr3ft2kWlSpVYt24dBw8eZMyYMaoHIek7huZkXg9A54PY0NCQnj176r1NSJsEHRMTkyHoPHfuHCVKlNBr205OTkpOk/Tu6ePHj9OrVy/69eunaltt27Zl+fLlFClSREkz/yqbNm1Ste10rVu3ZsOGDXz//fd6qf9NChQo8F5SELwss0n2devWxdjYmClTpuh15VlqamqGjRYhrQdO33vw5PRcGPFqEoTkAqtWreLGjRvUqVMHGxubDBNT9fVHGtImkqV/czl06BCNGjUCwM7OjpiYGNXbmzt3Lt98802O5vWAnNu59IsvvmD69OnMmjULAwMDUlNTOXnyJFOnTtXrhniQ1l3ev39/evfuTVhYGH/88Qe9e/fGz8+P7777TtW2GjdurPxe5VTq9JSUFNauXcuhQ4eoVq1ahgBf7Q3L9u3bR/369TE2NtbJfJ0ZtbNhv4mlpaWynbm+1K1blxUrVujswZKYmEhoaKhedkE+f/48lSpVwtDQ8I35t/S1Xb14M9m2PRd40+oXfeYTadeuHbVq1aJBgwZ069aN9evX4+joSFRUFP379+e3335TtT1HR0d+//13nQ//953X41X3AWl7aTRt2pRTp07ppd30CXqbNm0iJSWFfPnykZKSQsuWLZkyZYqylFRfNBoNPj4+JCUlceHCBWUFyX9RZvMj0hkYGKjehf/y79TrPvT0OUchsw/j+/fvKzuZrl27Vi/tQlqPh7e3N1qtluvXr1OtWjWuXbtGsWLFCA8PV/3/73//vA0MDMjs407mhOQsCULEax09epS+ffvy5MkT2rZtqyxXnjFjBleuXFF9ebCjoyOHDh16ZbJAfUv/4AkMDGTAgAHKjq2Q1p18/Phxbt26xebNm/V6H7dv3+bixYskJiZSpUoV1bP1psvsQykxMZHBgwfj4eHBN998o5TLt8Xc71Ufxs7OzkyaNEnv862Sk5PZsWMHFy5c4OnTp1StWlVv82Bu3bpF6dKlMTAw4NatW689999zz8T7I0GIeKOUlBQSEhJ0cpfcvHmTAgUK6OXbi7m5+RuXIR87dkzVdtOlDzfdvn2bkiVL6uTLMTY2xsbGhv79++Pk5KSX9tNpNBpu3ryJra2tXjcuy+xD6eX36f9W+9ti+jb1WaGv/9Y5afPmzXz++ecZJmlqNBp27typt6G3f38YGxoaYmFhIZljRY6RICQXSElJYfny5a/MY6KPP9Kv+pAwMzOjfPnydOvWTS97Rzg6OjJ8+PA37lKbvsOovnTu3Jk5c+boPWncvyUlJTFhwgSlpyU9k+2ECRMoUaKE6hNk3/QN8WVqflvMzjwmff237ty582sDIX2uqMjJbMk5pUGDBnz66afUrFmT2rVrv9cVfy+3XatWrUzTE4icIRNTc4E5c+bw448/0q1bN0JCQujVqxe3bt1i79699OnTRy9tDh8+PNPyx48fc/bsWXx8fJg9e7bSc6CmL7744r3O/8jMqlWrcqTd4OBgzp8/z8qVK+nRo4dS7ubmxpw5c1QPQnKqG1rfQWRW/HsfmuTkZM6dO8fFixf1Pgn4VdmS7927p/c0EceOHWPp0qVcvnwZSNtNtHv37squsfoycOBATpw4wZIlSxg1ahQlSpSgZs2afPrpp3z66ad6G3LM6bbF60kQkgts27aNiRMn0qBBA0JDQ2nZsiW2trY4ODjw559/6qXNN31IVK5cmUWLFv2/9u48KMorawP40ypuuCSgMuCOLK1igkZAIpPEBddxG0WNJq6gwZ0ZFZeoUUDNqBCiRoPrkBi1AAF3YsgQB1AbBU0UGwM64hYGUFFsDKHt7w+q36FtJc58/fbby/OrSpX9NuW5WoY+3HvuOQZPQkxlsJRarcahQ4dw9uxZlJaW6l0tFOun5NTUVERFRek1BnN1dUVhYaEo8UzhxoZarcapU6eED0YXFxf069dP1KOolyXamzdvhkqlEiWm9jqyTCbD5MmTdf58arUat2/fxh//+EdRYgPVk5KXLVsGf39/oTA3OzsbU6ZMwbp16zBs2DDRYo8YMQIjRowAUF0Mm5WVhX/84x9YvXo1nj17Juruj5SxqXZMQsxASUkJ3NzcAAC2trZ4/PgxAKBPnz6Ijo6WZE3vvfcetm3bZvDf11ROByMiIpCYmIh3330Xrq6uRkuO7t+//8JdoIqKClHWMHv2bOEGQW27amLeIPj5558RHByMkpISdOzYEQCwc+dOvP7669i+fbvwb99Yhg8fjoCAAISGhhr899ZeR7569Sr8/Px0+mNopyUPGDDA4HG1tm/fjkWLFul0Dp00aRL27NmDL774QtQkBKj+d3zhwgUoFAqcO3cOubm5cHV1NUofDylj08sxCTEDDg4OKC4uhpOTE9q2bYuMjAx07doVP/30k15hm7FUVlbqzV8whN+7z28sx44dw2effSZK/4LaeHh4IC0tTe/6aFxcnCht02v+fb/s7/7evXvYunWrwWNrffzxx3BxcUFCQoJQg1NWVoYlS5Zg5cqVOHDggGixXyQnJ0e0/6+01+lbt26NIUOGGL0g9NatW+jTp4/e8759+yIyMlLU2OPHj0dubi46deoEb29vBAUFwcvLyyh1V1LGptoxCTED/v7+OHPmDN588018+OGHWLRoEeLj43H37l29WQjGEh8fb9FXNm1sbCQpXgsJCUFQUBDy8/OhVqsRGxuLgoIC5OTkSFanUlZWhoSEBNE61V69elUnAQGA5s2bIyQkBGPGjBElJqDfX0ej0aC4uBiXL1/GrFmzRIsLSFcT4+joiDNnzqB9+/Y6zzMzM+Ho6Chq7OvXr6NRo0ZwdnaGs7MzOnXqZLQkQMrYVDsmIWagZlvpIUOGwMnJCTk5OWjfvr0ohaEAhH4gz3v8+DFyc3Pxr3/9S/SBalLSti9fuXKlUetUevbsieTkZMTExMDNzQ0ZGRno0qULDhw4AHd3d6Otw5g6dOiAkpISuLq66jwvLS3V+7A0pOcLQGUyGTp27Ih58+bBz89PtLiANDfegOpBbuHh4bh69aowIDE7OxuJiYlYvny5KDG1zp07h7y8PCgUCqSnpyMqKgo2Njbw9vaGj4+PqC3spYxNteMVXTOQlZWF7t276xXpVVVVIScnR5Tx2y/rJqm9ovv+++9LNlRPLM//ZHz27Fk0b94crq6uen/3hm7SZsqUSiVGjRolWk3IDz/8gA0bNmDOnDnCkdPFixexdetWLFy4EG+99ZbwtZYycj06OrrWG2+TJk0SLfapU6ewe/duYXCes7Mzpk+fbtT2+RqNBpcvX8a+fftw5MgRoxaHShmb9DEJMQPW2FNACv/NrJCX7RT9fy1evBg+Pj7w9vY2mSRP7CSk5rGedtepZrM07WuximMvX74s3MpxdXVFly5dDB7jef3798fHH3+M9957D927d0dycjLatWuH2NhYXLp0CZs2bRJ9DcZ25coVoSg0OzsbT548gZubm9C/Q8wkSMrYVDsex5iBl/UUePjwodGn6loysRKL/4aNjQ1iYmKwfPlyoZeBj48PvLy8ROtl8Huzhx49eiRKXC2pxqyXlpYiJCQECoUCzZo1A1D9Z/Xx8UFUVJSoowOkuvH2448/QqPR6HX8vXTpEurUqYNu3bqJFjsgIACdO3eGt7c3xo4dCy8vL9F7ophCbKodkxATpv1wkMlkWLJkiU7FvlqtRl5ennCuS4b19OlTaDQaIcm7c+cOTp06BRcXF1HrBSIiIgBUN63KysoSGkutXLkSLVu2NPjAQODF492ff1/MpmZSXZEMCwvDkydPcOzYMWFmSn5+PkJDQxEeHi7qbRGpbrytWbMGgYGBeklIUVERduzYgbi4ONFiKxQKyY7TpIxNtWMSYsK0Hw4ajQa2trY6Q55sbGzg6emJgIAAqZZn0WbNmgV/f3+8//77ePToEQICAmBjY4MHDx5gyZIlmDBhgqjxmzVrhtdeew3NmzdHs2bNULduXdF+MjeFHaDz58/jwIEDuH37NqKjo+Hg4ICkpCS0adNGtE6e//znP7Fnzx6doW0uLi5YtWoVpk2bJkpMLaluvBUUFKBr1656zzt37oz8/HzR4gL/qeepefzl4uLywvVYUmyqHZMQE6b9cGjdujWmTZumM9GVxHXlyhWhRiQlJQUtWrRAUlISUlJS8Pnnn4uWhERGRkKhUAg9Dby8vCy+p0FKSgoWL16MYcOG4cqVK6isrAQAlJeX48svvxQtCXn27NkLe93Uq1dPr0OuoUlx4w0A6tevj5KSEr16o+LiYlG70wLVx18LFixAVlaW0Y+/pIxNtavz+19CUgsMDNSpCblz5w727t2L9PR0CVdl2Z4+fSp0s0xPT8eAAQNQp04deHp64u7du6LFjYmJQWFhIebMmYPIyEgsW7YM/fv3t9gEBAC2bduG1atXIzw8XOeDsEePHsjNzRUtbq9evRAREYGioiLhWVFREdatWwdfX1/R4r6Ip6cnpk6dKmoCAgC9e/dGZGSkUIMCVH8YR0VF4e233xY1dlhYGFQqFY4dOwaFQgGFQoGjR4+ivLxctB40phCbasedEDMg9dGANWrXrh2+++47+Pv7Iz09XdgiLy0tFfVsOSkpSfgmuXv3bqGXgfY/bVtzS3Ljxo0X7nY0bdpU1KLYlStXIjg4GP369cMf/vAHANXdYd3c3LBhwwbR4gLAl19+CXt7e71mbPHx8bh//77BBxVqhYaGYuLEiejTp48wwE+pVMLe3h5/+9vfRImpJeXxl5SxqXZMQsyAVEcD1mz27NlYuHCh8FOxtgA4IyNDb/qqIcnlcsjlcqFPhFKpxN69e7FmzRqL7WfQokULFBYWok2bNjrPL1y4IOo1ZUdHRyQmJiIzM1PomeHi4mKUXZCDBw9i48aNes9dXV0REhIiWhLi4OCAw4cP48iRI1AqlWjYsCFGjx6NoUOHijKGoSYpj7+kjE21YxJiBqQ6GrBmgwYNwltvvYXi4mKdPha+vr6i9hTQaDTIzc3V6WlQXl4Od3d3UZrSmYKxY8ciIiICa9euhUwmQ1FREXJycrB+/fpah+r9r3JycvDw4UP06dMHMpkMvXv3xr///W9s3rwZFRUV6N+/P1asWCHqLZXi4mK0bNlS77mdnR2Ki4tFiwsAjRs3xrhx40SN8SLa469NmzbBwcEBgPGOv6SMTbVjEmIGpDoasHYtW7bU+6B44403RI3p7e0NlUoFd3d3oadBz549hWI6SzRjxgw8e/YMU6ZMQUVFBT744APUr18f06dPF+X219atW+Ht7S0McsvLy8OKFSswcuRIdOrUCbt27UKrVq0wd+5cg8fWcnR0RHZ2tt5Oz4ULF9CqVSvR4kp1DAS8+Pjrl19+gaurq+jHX1LGptqxY6oZOHnyJBYuXAi1Wo1evXphz549AKq/oWRlZWHnzp0Sr9Ay/fTTTy+d7SFW2/a0tDT07NnTKpPLyspKFBYWQqVSoVOnTjh48CB27dqFjIwMg8bx8/PDtm3bhMZcUVFRUCgU2L9/PwDgxIkT2Lx5M44fP27QuDXt2LEDO3fuxOLFi9GrVy8AwJkzZ7BhwwZMmzYNM2fOFCVu3759sXHjRvTo0UPn+aVLlxASEoLvv/9elLhaGo1G5/irU6dOohfEmkJsejnuhJgBqY4GrNmxY8cQGhoKPz8/pKenw8/PDzdu3EBpaSn8/f1Fi5uSkvLCIk2VSoWwsDCT6OlhKJWVldi8eTMyMjJQv359BAYGon///khISMDs2bNRt25dTJ482eBxy8rK0KJFC+G1QqHAO++8I7zu1q0b7t27Z/C4NQUGBuLhw4dYvXq1kOA2aNAAgYGBoiUggLTHQACE46/evXuLHsuUYtPLMQkxEy1btoRKpUJGRga8vLzQsGFDdOvWzagTXq3J9u3bsXTpUkycOBHdu3fH8uXL0aZNG6FzqViSkpKwcOFCvZ2Qp0+fIjk52aKSkOjoaBw8eBBvv/02srOzMX/+fPz5z3/GxYsXsWTJEgwaNAh169Y1eNwWLVrg9u3bcHR0RGVlJXJzczFv3jzh/SdPnohepCmTybBo0SLMmjULBQUFaNiwITp06CBqHQpg/GOg/6Ylv6GH9kkZm14dkxAz8ODBAyxYsADnzp2DTCbDt99+i7Zt22LZsmVo3rw5lixZIvUSLc6tW7fw7rvvAqhu8KRSqSCTyTBlyhRMnjxZ50PLEMrLy6HRaKDRaPDkyRM0aNBAeE+tVuP06dMW11Dp5MmT+PTTT9GvXz9cu3YNw4cPR1VVFQ4fPixqcv3OO+9g06ZNWLhwIb777js0bNhQZ1JvXl6e0YYH2traCh/+YicgQPUMlbVr16KqquqFx0CGtnfv3lf6OplMZvBEQMrY9OqYhJiBdevWoV69ekhLS8PgwYOF50OGDMH69euZhIigWbNmePLkCQCgVatW+Pnnn+Hu7o5Hjx6hoqLC4PF69uwJmUwGmUyGgQMH6r0vk8lELZSUQlFRETw8PAAAbm5uqF+/PqZMmSL67t78+fMxd+5cfPDBB2jcuDE+/fRTnQQgISFB1PlAQPWV0S+++AJ79uyBSqUCUJ2QTJ06FcHBwahTR5w+krUdA4lRlCp2jYmpxqZXxyTEDGRkZGDXrl1CVbdWhw4deEVXJF5eXsjMzIS7uzsGDRqEiIgInD17FpmZmaJc6YuNjYVGo8HkyZOxefNmnQ6pNjY2cHJyEq4WWgq1Wq1z7FG3bl2jjCaws7PDvn378PjxYzRu3FjvyCc6Olr0dURFRSE+Ph5//etfhSLRCxcuYMuWLaisrERISIgocWs7BlKr1aIcfxHVhkmIGVCpVDrD67QePnxolC1ca7RixQr8+uuvAIDg4GDY2NggOzsbAwYMQHBwsMHjaSfJpqamwsnJySpqfTQajc506MrKSnzyySfC5GItsW4ivWx68GuvvSZKvJoSExMRHh6Ofv36Cc/kcjkcHBywevVq0ZIQLVtbW+G6+Y0bNxAfH4/k5GSDj4L4b2qYtA0ZLSE2vTomIWagZ8+eSEpKwoIFC4Rnz549w86dO+Hj4yPdwixQeXk5gOpOivXq1RNeT5gwwSidaVu3bi3JRFkpjBo1Suf18OHDJVqJ8ZWVlcHZ2VnvubOzM8rKykSPX1FRgePHjyMhIQEXL16Eh4eHKNN7X3X2jxhJt5Sx6dWxT4gZuHbtGqZMmYIuXbrg7Nmz6Nu3L/Lz81FWVob9+/ejXbt2Ui/RYsjl8lf6piRW+/SaE2WTk5Nx/PhxtG3bFl9//TV++OEH7NixQ5S4ZFwBAQF488038fHHH+s8DwsLw48//oi4uDhR4l68eBFxcXE4efIknJycUFBQgNjYWItKbsm8cCfEDLi5uSElJQVff/01bG1toVKp4O/vj4kTJ4raXdEa1bzWp9FoMGPGDISHhxutHkM7UXbkyJE4duyY8LxHjx7Ytm2bUdZA4lu0aBFmzpyJzMxMeHp6AqhOEO7duydKorl7924kJCTg8ePHGDp0KPbt2we5XI6uXbsa5fjpeb/88gsA6NW5WXps0sckxEw0bdpUlFoE0qWtzdDSzugx1pVNqSbKknF5e3vj5MmT+Oabb4QOnv7+/hg3bhy2bdtm8J2JjRs3IigoCPPmzZOs+FSqG0FSx6baMQkxE7/++ivy8vJQWlqqN/WxZnEbmTepJsqS8Tk4OOgVoCqVSsTHxyMsLMygsebPn49Dhw4hOTkZQ4cOxYgRI+Dm5mbQGL9HqhtBUsem2jEJMQOnT59GaGgoHjx4oPeeTCazyPHu1srYE2XJOsycORMzZ86EQqFAQkICxo4di3bt2kGj0RilEBaQ9kaQ1LeR6OWYhJiB8PBwDBo0CLNnz9aZeUGWx9gTZcm6eHt7w9vbGytWrMDRo0eRkJCADz/8EG+88QYGDhyIqVOnihZbyhtBUt9GopdjEmIGSkpKMHXqVCYgRjBnzhyd18buXSGTyRAcHIzp06frTZTt16+fwSfKknVq0qQJxo8fj/HjxyMvLw/x8fGIiYkRNQmRy+XYt2+f3o0gbZGsmKSMTbVjEmIGBg4ciHPnzvEqrhE838DKWL0rpJooS8b1fJL7PCmKj93d3bF8+XIsXrxYeDZs2DDExMTA0dHRYHGMfSPIVGJT7dgnxAxUVFRg/vz5sLOzg5ubG+rV080dOXzJ/G3YsEFnouyDBw+EibIfffSRaBNlybhetTOn1NOSu3fvjsOHDxukGPrWrVto06aNUONU80aQs7MzJkyYINoVeClj06vhTogZOHr0qPATskKh0HmPEyAtg1QTZcm4pE4upDBgwACkp6fD3t4eDg4OuHnzJlatWmWU42UpY9OrYRJiBj777DPMnTsXM2bM4H12CyXVRFkisT2/2X769GlRJlGbWmx6NfxEMwO//fYbhgwZwgTEgkk1UZbI2KSsAGD1genhTogZGDlyJI4fP46PPvpI6qWQSKSeKEskFplMJtmOnpSx6dUwCTED2om56enpcHd31ytM5Rhq82fNE2XJskmZYDO5N31MQsxAXl4eOnfuDKB6om5NzPItgzUWLJLpWrNmDezt7Q3ye0mZYDO5N328oktEZMFqTob+PbxpR8bGJISIyIL17dtX5/WDBw9QUVGBZs2aAahukNaoUSPY2dkhNTVViiWSFeNxjImaM2cO1q9fjyZNmvxul0WeZxLRy3z//ffCr48cOYJvvvkGERERwiyV69evY8WKFRg3bpxUSyQrxiTERNVsH/58K3Eiov9FdHQ0Pv/8c51hbs7Ozli6dCnmzZvHmgkyOiYhJmrdunXYsmULpk+fzqJFIjKI4uJiVFVV6T1/9uwZSktLJVgRWTt2vzJhW7duhUqlknoZRGQhfH19sWrVKly5ckV4dvnyZXzyySfw9fWVcGVkrbgTYsJYM0xEhrR27VqEhoZi9OjRQr8htVoNPz8/RERESLw6ska8HWPC5HI5MjMzYWdnJ/VSiMiC3LhxQ2eabMeOHSVeEVkrJiEmTC6Xo2nTpr/bkOz5ybpERLWprKzE7du30a5dO70OzETGxH99Jm7u3Lm8HUNEBlFRUYGwsDAkJSUBAFJSUtC2bVuEhYXBwcEBM2bMkHaBZHWYhJi4oUOHGqx9MhFZt02bNkGpVCI2NhZBQUHCc19fX2zZsoVJCBkdkxATxrkwRGRIqampiIqKgqenp85zV1dXFBYWSrMosmq8omvCWK5DRIZ0//79F+6sVlRU8IcekgSTEBOmVCp5FENEBuPh4YG0tDS953FxcXq7I0TGwOMYIiIrERISgqCgIOTn50OtViM2NhYFBQXIycnBV199JfXyyArxii4RkRUpLCxETEwMlEolVCoVunTpgqCgILi7u0u9NLJCTEKIiIhIEjyOISKyYOXl5WjSpInw69pov47IWLgTQkRkwTp37oz09HTY29tDLpe/8BaMRqOBTCbD1atXJVghWTPuhBARWbC///3vaN68OQAgNjZW4tUQ6WISQkRkwWJjY9GlSxc0adIEd+/exZAhQ1C/fn2pl0UEgH1CiIgsWlpaGlQqFQBg6dKlePz4scQrIvoP7oQQEVmwjh07IjIyEj4+PtBoNDhx4sRLC1BHjhxp3MWR1WNhKhGRBcvOzsb69etRWFiIsrIy2NravrA4VSaTQaFQSLBCsmZMQoiIrIRcLkdGRgbHQZDJYBJCRGQl7ty5AycnJw6rI5PBJISIyIIplUq4ubmhTp06UCqVtX6tXC430qqIqjEJISKyYDWPYLTNymp+29e+ZrMykgKTECIiC1bzCObOnTu1fm3r1q2NtCqiakxCiIiswG+//YaVK1di1qxZaNu2rdTLIQLAZmVERFbBxsYG3377rdTLINLBJISIyEr0798fqampUi+DSMCOqUREVqJ9+/bYunUrsrOz0bVrVzRq1Ejn/UmTJkm0MrJWrAkhIrISffv2fel7MpmMuyRkdExCiIiISBKsCSEisjKVlZW4fv06qqqqpF4KWTkmIUREVqKiogLLli2Dp6cn/vSnP+HevXsAgLCwMMTExEi8OrJGTEKIiKzEpk2boFQqERsbiwYNGgjPfX19cfz4cQlXRtaKt2OIiKxEamoqoqKi4OnpqfPc1dUVhYWF0iyKrBp3QoiIrMT9+/dhb2+v97yiooKTdUkSTEKIiKyEh4cH0tLS9J7HxcXp7Y4QGQOPY4iILNy1a9fg5uaGv/zlLwgMDER+fj6qqqoQGxuLgoIC5OTk4KuvvpJ6mWSFuBNCRGThhg8fjoCAABQUFGD//v1Qq9Vwd3dHRkYG7OzscODAAXh4eEi9TLJCbFZGRGThzp8/j4SEBKSkpECj0WDAgAEYM2YMvLy8pF4aWTkmIUREVkKlUuHEiRNITEzE+fPn0b59e4wePRqjRo1Cy5YtpV4eWSEmIUREVujmzZs4dOgQkpOTUVJSAj8/P2zfvl3qZZGVYRJCRGSlVCoVjhw5gsjISDx69AhXr16VeklkZXg7hojIymRlZQk1InXq1MHgwYMxZswYqZdFVog7IUREVqCoqAiJiYlITEzEzZs30b17d4wZMwaDBw9G48aNpV4eWSnuhBARWbjAwECcOXMGr7/+OkaMGIHRo0fD2dlZ6mURMQkhIrJ09erVQ3R0NPr06YO6detKvRwiAY9jiIiISBLsmEpERESSYBJCREREkmASQkRERJJgEkJERESSYBJCREREkmASQkRERJJgEkJERESSYBJCREREkvg/Z9feLCRJ8QoAAAAASUVORK5CYII="
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.heatmap(df.isnull())"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:42:42.130987091Z",
     "start_time": "2024-04-11T08:42:39.910142928Z"
    }
   },
   "id": "f8510e2d7af9eb0",
   "execution_count": 5
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "data": {
      "text/plain": "Empty DataFrame\nColumns: [tlink, wlink, user, datetime, spreadfactor, hiringchance, source, text, hashtags, location, verified]\nIndex: []",
      "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>tlink</th>\n      <th>wlink</th>\n      <th>user</th>\n      <th>datetime</th>\n      <th>spreadfactor</th>\n      <th>hiringchance</th>\n      <th>source</th>\n      <th>text</th>\n      <th>hashtags</th>\n      <th>location</th>\n      <th>verified</th>\n    </tr>\n  </thead>\n  <tbody>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf = pd.DataFrame(\n",
    "    columns=['tlink', 'wlink', 'user', 'datetime', 'spreadfactor', 'hiringchance', 'source', 'text', 'hashtags',\n",
    "             'location', 'verified'])\n",
    "newdf"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:42:42.147801672Z",
     "start_time": "2024-04-11T08:42:42.130444575Z"
    }
   },
   "id": "f16cb7498f91f798",
   "execution_count": 6
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "data": {
      "text/plain": "                                                   tlink wlink user datetime  \\\n0      https://twitter.com/SipapuNM/status/1211798864...   NaN  NaN      NaN   \n1      https://twitter.com/LorettaOD1/status/12117973...   NaN  NaN      NaN   \n2      https://twitter.com/guajardo_celina/status/121...   NaN  NaN      NaN   \n3      https://twitter.com/SteveEckert_OTD/status/121...   NaN  NaN      NaN   \n4      https://twitter.com/HireLive/status/1211792689...   NaN  NaN      NaN   \n...                                                  ...   ...  ...      ...   \n49995  https://twitter.com/babelsblessing/status/1636...   NaN  NaN      NaN   \n49996  https://twitter.com/SSARecruit/status/16363065...   NaN  NaN      NaN   \n49997  https://twitter.com/StaffYourDealer/status/163...   NaN  NaN      NaN   \n49998  https://twitter.com/StaffYourDealer/status/163...   NaN  NaN      NaN   \n49999  https://twitter.com/PragatiEmpower/status/1636...   NaN  NaN      NaN   \n\n      spreadfactor hiringchance source text hashtags location verified  \n0              NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n1              NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n2              NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n3              NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n4              NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n...            ...          ...    ...  ...      ...      ...      ...  \n49995          NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n49996          NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n49997          NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n49998          NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n49999          NaN          NaN    NaN  NaN      NaN      NaN      NaN  \n\n[50000 rows x 11 columns]",
      "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>tlink</th>\n      <th>wlink</th>\n      <th>user</th>\n      <th>datetime</th>\n      <th>spreadfactor</th>\n      <th>hiringchance</th>\n      <th>source</th>\n      <th>text</th>\n      <th>hashtags</th>\n      <th>location</th>\n      <th>verified</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>https://twitter.com/SipapuNM/status/1211798864...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>https://twitter.com/LorettaOD1/status/12117973...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>https://twitter.com/guajardo_celina/status/121...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>https://twitter.com/SteveEckert_OTD/status/121...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>https://twitter.com/HireLive/status/1211792689...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</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    </tr>\n    <tr>\n      <th>49995</th>\n      <td>https://twitter.com/babelsblessing/status/1636...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>49996</th>\n      <td>https://twitter.com/SSARecruit/status/16363065...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>49997</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>49998</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>49999</th>\n      <td>https://twitter.com/PragatiEmpower/status/1636...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>50000 rows × 11 columns</p>\n</div>"
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf['tlink'] = 'https://twitter.com/' + df['User'] + '/status/' + df['ID'].astype(str)\n",
    "newdf"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:42:42.267591428Z",
     "start_time": "2024-04-11T08:42:42.143395650Z"
    }
   },
   "id": "22e5a3b405963ce7",
   "execution_count": 7
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "data": {
      "text/plain": "                                                   tlink  \\\n0      https://twitter.com/SipapuNM/status/1211798864...   \n1      https://twitter.com/LorettaOD1/status/12117973...   \n2      https://twitter.com/guajardo_celina/status/121...   \n3      https://twitter.com/SteveEckert_OTD/status/121...   \n4      https://twitter.com/HireLive/status/1211792689...   \n...                                                  ...   \n49995  https://twitter.com/babelsblessing/status/1636...   \n49996  https://twitter.com/SSARecruit/status/16363065...   \n49997  https://twitter.com/StaffYourDealer/status/163...   \n49998  https://twitter.com/StaffYourDealer/status/163...   \n49999  https://twitter.com/PragatiEmpower/status/1636...   \n\n                             wlink user datetime spreadfactor hiringchance  \\\n0      (https://t.co/imMnymMfwW, )  NaN      NaN          NaN          NaN   \n1      (https://t.co/CFAKKQHeFJ, )  NaN      NaN          NaN          NaN   \n2      (https://t.co/XuSMG0eSgs, )  NaN      NaN          NaN          NaN   \n3      (https://t.co/3IGxFiCXUI, )  NaN      NaN          NaN          NaN   \n4      (https://t.co/XAianPE9mX, )  NaN      NaN          NaN          NaN   \n...                            ...  ...      ...          ...          ...   \n49995  (https://t.co/WG1UTWmsHZ, )  NaN      NaN          NaN          NaN   \n49996  (https://t.co/En3UQHu7GO, )  NaN      NaN          NaN          NaN   \n49997  (https://t.co/r52DOaqMRS, )  NaN      NaN          NaN          NaN   \n49998  (https://t.co/FsVlBkNmmd, )  NaN      NaN          NaN          NaN   \n49999  (https://t.co/t0III7CMEM, )  NaN      NaN          NaN          NaN   \n\n      source text hashtags location verified  \n0        NaN  NaN      NaN      NaN      NaN  \n1        NaN  NaN      NaN      NaN      NaN  \n2        NaN  NaN      NaN      NaN      NaN  \n3        NaN  NaN      NaN      NaN      NaN  \n4        NaN  NaN      NaN      NaN      NaN  \n...      ...  ...      ...      ...      ...  \n49995    NaN  NaN      NaN      NaN      NaN  \n49996    NaN  NaN      NaN      NaN      NaN  \n49997    NaN  NaN      NaN      NaN      NaN  \n49998    NaN  NaN      NaN      NaN      NaN  \n49999    NaN  NaN      NaN      NaN      NaN  \n\n[50000 rows x 11 columns]",
      "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>tlink</th>\n      <th>wlink</th>\n      <th>user</th>\n      <th>datetime</th>\n      <th>spreadfactor</th>\n      <th>hiringchance</th>\n      <th>source</th>\n      <th>text</th>\n      <th>hashtags</th>\n      <th>location</th>\n      <th>verified</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>https://twitter.com/SipapuNM/status/1211798864...</td>\n      <td>(https://t.co/imMnymMfwW, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>https://twitter.com/LorettaOD1/status/12117973...</td>\n      <td>(https://t.co/CFAKKQHeFJ, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>https://twitter.com/guajardo_celina/status/121...</td>\n      <td>(https://t.co/XuSMG0eSgs, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>https://twitter.com/SteveEckert_OTD/status/121...</td>\n      <td>(https://t.co/3IGxFiCXUI, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>https://twitter.com/HireLive/status/1211792689...</td>\n      <td>(https://t.co/XAianPE9mX, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</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    </tr>\n    <tr>\n      <th>49995</th>\n      <td>https://twitter.com/babelsblessing/status/1636...</td>\n      <td>(https://t.co/WG1UTWmsHZ, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>49996</th>\n      <td>https://twitter.com/SSARecruit/status/16363065...</td>\n      <td>(https://t.co/En3UQHu7GO, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>49997</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>(https://t.co/r52DOaqMRS, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>49998</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>(https://t.co/FsVlBkNmmd, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>49999</th>\n      <td>https://twitter.com/PragatiEmpower/status/1636...</td>\n      <td>(https://t.co/t0III7CMEM, )</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>50000 rows × 11 columns</p>\n</div>"
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def extract_links(df, col):\n",
    "    links = pd.Series(dtype=object)\n",
    "    for index, row in df.iterrows():\n",
    "        text = row[col]\n",
    "        matches = re.findall(r'(https?://[^\\s]+)|(www\\.[^\\s]+)', text)\n",
    "        if matches:\n",
    "            link = matches[0]\n",
    "            links.loc[index] = link\n",
    "        else:\n",
    "            links.loc[index] = None\n",
    "    return links\n",
    "\n",
    "\n",
    "newdf['wlink'] = extract_links(df, 'Text')\n",
    "newdf"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:43:44.622984676Z",
     "start_time": "2024-04-11T08:42:42.201622687Z"
    }
   },
   "id": "7d46538fcfd32898",
   "execution_count": 8
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "data": {
      "text/plain": "                                                   tlink  \\\n0      https://twitter.com/SipapuNM/status/1211798864...   \n1      https://twitter.com/LorettaOD1/status/12117973...   \n2      https://twitter.com/guajardo_celina/status/121...   \n3      https://twitter.com/SteveEckert_OTD/status/121...   \n4      https://twitter.com/HireLive/status/1211792689...   \n...                                                  ...   \n49995  https://twitter.com/babelsblessing/status/1636...   \n49996  https://twitter.com/SSARecruit/status/16363065...   \n49997  https://twitter.com/StaffYourDealer/status/163...   \n49998  https://twitter.com/StaffYourDealer/status/163...   \n49999  https://twitter.com/PragatiEmpower/status/1636...   \n\n                             wlink             user  \\\n0      (https://t.co/imMnymMfwW, )         SipapuNM   \n1      (https://t.co/CFAKKQHeFJ, )       LorettaOD1   \n2      (https://t.co/XuSMG0eSgs, )  guajardo_celina   \n3      (https://t.co/3IGxFiCXUI, )  SteveEckert_OTD   \n4      (https://t.co/XAianPE9mX, )         HireLive   \n...                            ...              ...   \n49995  (https://t.co/WG1UTWmsHZ, )   babelsblessing   \n49996  (https://t.co/En3UQHu7GO, )       SSARecruit   \n49997  (https://t.co/r52DOaqMRS, )  StaffYourDealer   \n49998  (https://t.co/FsVlBkNmmd, )  StaffYourDealer   \n49999  (https://t.co/t0III7CMEM, )   PragatiEmpower   \n\n                        datetime spreadfactor hiringchance source  \\\n0      2019-12-30 23:58:58+00:00          NaN          NaN    NaN   \n1      2019-12-30 23:53:02+00:00          NaN          NaN    NaN   \n2      2019-12-30 23:46:41+00:00          NaN          NaN    NaN   \n3      2019-12-30 23:37:04+00:00          NaN          NaN    NaN   \n4      2019-12-30 23:34:25+00:00          NaN          NaN    NaN   \n...                          ...          ...          ...    ...   \n49995  2023-03-16 10:04:39+00:00          NaN          NaN    NaN   \n49996  2023-03-16 10:01:07+00:00          NaN          NaN    NaN   \n49997  2023-03-16 09:55:14+00:00          NaN          NaN    NaN   \n49998  2023-03-16 09:54:43+00:00          NaN          NaN    NaN   \n49999  2023-03-16 09:54:42+00:00          NaN          NaN    NaN   \n\n                                                    text  \\\n0      Looking for an exciting job where you can ski ...   \n1      Hail in Phoenix - no way!  New opportunity at ...   \n2      Rackspace is hiring! We are looking for Nation...   \n3      We are #hiring Administrative Assistant in Nan...   \n4      We are #hiring Family Service Counselor in Irv...   \n...                                                  ...   \n49995  We are hiring! 😍\\nIf you have experience in pr...   \n49996  A lovely review from one of our wonderful cand...   \n49997  We are #hiring Automotive Service Advisor Writ...   \n49998  We are #hiring Automotive Sales Consultant in ...   \n49999  We Are Hiring!\\n\\nIf you think you fit in this...   \n\n                                                hashtags  \\\n0                                                    NaN   \n1                                                ['job']   \n2      ['becomearacker', 'Rackspace', 'recruiting', '...   \n3                           ['hiring', 'jobs', 'Nanuet']   \n4                           ['hiring', 'jobs', 'Irvine']   \n...                                                  ...   \n49995           ['projectcoordinator', 'london', 'jobs']   \n49996  ['SSADigital', 'Recruitment', 'Hiring', 'Review']   \n49997                     ['hiring', 'jobs', 'Grayling']   \n49998                     ['hiring', 'jobs', 'Grayling']   \n49999  ['hiring', 'nqsf', 'recruitment', 'vocationalt...   \n\n                             location  verified  \n0             20 miles SE of Taos, NM     False  \n1                             Arizona     False  \n2                          Texas, USA     False  \n3           Orange County, California     False  \n4                       United States     False  \n...                               ...       ...  \n49995                 London, England     False  \n49996  Innovation Centre, Silverstone     False  \n49997                  Tampa, Florida     False  \n49998                  Tampa, Florida     False  \n49999                             NaN     False  \n\n[50000 rows x 11 columns]",
      "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>tlink</th>\n      <th>wlink</th>\n      <th>user</th>\n      <th>datetime</th>\n      <th>spreadfactor</th>\n      <th>hiringchance</th>\n      <th>source</th>\n      <th>text</th>\n      <th>hashtags</th>\n      <th>location</th>\n      <th>verified</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>https://twitter.com/SipapuNM/status/1211798864...</td>\n      <td>(https://t.co/imMnymMfwW, )</td>\n      <td>SipapuNM</td>\n      <td>2019-12-30 23:58:58+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Looking for an exciting job where you can ski ...</td>\n      <td>NaN</td>\n      <td>20 miles SE of Taos, NM</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>https://twitter.com/LorettaOD1/status/12117973...</td>\n      <td>(https://t.co/CFAKKQHeFJ, )</td>\n      <td>LorettaOD1</td>\n      <td>2019-12-30 23:53:02+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Hail in Phoenix - no way!  New opportunity at ...</td>\n      <td>['job']</td>\n      <td>Arizona</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>https://twitter.com/guajardo_celina/status/121...</td>\n      <td>(https://t.co/XuSMG0eSgs, )</td>\n      <td>guajardo_celina</td>\n      <td>2019-12-30 23:46:41+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Rackspace is hiring! We are looking for Nation...</td>\n      <td>['becomearacker', 'Rackspace', 'recruiting', '...</td>\n      <td>Texas, USA</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>https://twitter.com/SteveEckert_OTD/status/121...</td>\n      <td>(https://t.co/3IGxFiCXUI, )</td>\n      <td>SteveEckert_OTD</td>\n      <td>2019-12-30 23:37:04+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>We are #hiring Administrative Assistant in Nan...</td>\n      <td>['hiring', 'jobs', 'Nanuet']</td>\n      <td>Orange County, California</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>https://twitter.com/HireLive/status/1211792689...</td>\n      <td>(https://t.co/XAianPE9mX, )</td>\n      <td>HireLive</td>\n      <td>2019-12-30 23:34:25+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>We are #hiring Family Service Counselor in Irv...</td>\n      <td>['hiring', 'jobs', 'Irvine']</td>\n      <td>United States</td>\n      <td>False</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    </tr>\n    <tr>\n      <th>49995</th>\n      <td>https://twitter.com/babelsblessing/status/1636...</td>\n      <td>(https://t.co/WG1UTWmsHZ, )</td>\n      <td>babelsblessing</td>\n      <td>2023-03-16 10:04:39+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>We are hiring! 😍\\nIf you have experience in pr...</td>\n      <td>['projectcoordinator', 'london', 'jobs']</td>\n      <td>London, England</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49996</th>\n      <td>https://twitter.com/SSARecruit/status/16363065...</td>\n      <td>(https://t.co/En3UQHu7GO, )</td>\n      <td>SSARecruit</td>\n      <td>2023-03-16 10:01:07+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>A lovely review from one of our wonderful cand...</td>\n      <td>['SSADigital', 'Recruitment', 'Hiring', 'Review']</td>\n      <td>Innovation Centre, Silverstone</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49997</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>(https://t.co/r52DOaqMRS, )</td>\n      <td>StaffYourDealer</td>\n      <td>2023-03-16 09:55:14+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>We are #hiring Automotive Service Advisor Writ...</td>\n      <td>['hiring', 'jobs', 'Grayling']</td>\n      <td>Tampa, Florida</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49998</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>(https://t.co/FsVlBkNmmd, )</td>\n      <td>StaffYourDealer</td>\n      <td>2023-03-16 09:54:43+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>We are #hiring Automotive Sales Consultant in ...</td>\n      <td>['hiring', 'jobs', 'Grayling']</td>\n      <td>Tampa, Florida</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49999</th>\n      <td>https://twitter.com/PragatiEmpower/status/1636...</td>\n      <td>(https://t.co/t0III7CMEM, )</td>\n      <td>PragatiEmpower</td>\n      <td>2023-03-16 09:54:42+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>We Are Hiring!\\n\\nIf you think you fit in this...</td>\n      <td>['hiring', 'nqsf', 'recruitment', 'vocationalt...</td>\n      <td>NaN</td>\n      <td>False</td>\n    </tr>\n  </tbody>\n</table>\n<p>50000 rows × 11 columns</p>\n</div>"
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf['user'] = df['User']\n",
    "newdf['datetime'] = df['Timestamp']\n",
    "newdf['text'] = df['Text']\n",
    "newdf['hashtags'] = df['Hashtag']\n",
    "newdf['location'] = df['Location']\n",
    "newdf['verified'] = df['Verified_Account']\n",
    "newdf"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:43:44.658569764Z",
     "start_time": "2024-04-11T08:43:44.625438735Z"
    }
   },
   "id": "60a476a886a70be0",
   "execution_count": 9
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "data": {
      "text/plain": "                                                   tlink  \\\n0      https://twitter.com/SipapuNM/status/1211798864...   \n1      https://twitter.com/LorettaOD1/status/12117973...   \n2      https://twitter.com/guajardo_celina/status/121...   \n3      https://twitter.com/SteveEckert_OTD/status/121...   \n4      https://twitter.com/HireLive/status/1211792689...   \n...                                                  ...   \n49995  https://twitter.com/babelsblessing/status/1636...   \n49996  https://twitter.com/SSARecruit/status/16363065...   \n49997  https://twitter.com/StaffYourDealer/status/163...   \n49998  https://twitter.com/StaffYourDealer/status/163...   \n49999  https://twitter.com/PragatiEmpower/status/1636...   \n\n                             wlink             user  \\\n0      (https://t.co/imMnymMfwW, )         SipapuNM   \n1      (https://t.co/CFAKKQHeFJ, )       LorettaOD1   \n2      (https://t.co/XuSMG0eSgs, )  guajardo_celina   \n3      (https://t.co/3IGxFiCXUI, )  SteveEckert_OTD   \n4      (https://t.co/XAianPE9mX, )         HireLive   \n...                            ...              ...   \n49995  (https://t.co/WG1UTWmsHZ, )   babelsblessing   \n49996  (https://t.co/En3UQHu7GO, )       SSARecruit   \n49997  (https://t.co/r52DOaqMRS, )  StaffYourDealer   \n49998  (https://t.co/FsVlBkNmmd, )  StaffYourDealer   \n49999  (https://t.co/t0III7CMEM, )   PragatiEmpower   \n\n                        datetime spreadfactor hiringchance  \\\n0      2019-12-30 23:58:58+00:00          NaN          NaN   \n1      2019-12-30 23:53:02+00:00          NaN          NaN   \n2      2019-12-30 23:46:41+00:00          NaN          NaN   \n3      2019-12-30 23:37:04+00:00          NaN          NaN   \n4      2019-12-30 23:34:25+00:00          NaN          NaN   \n...                          ...          ...          ...   \n49995  2023-03-16 10:04:39+00:00          NaN          NaN   \n49996  2023-03-16 10:01:07+00:00          NaN          NaN   \n49997  2023-03-16 09:55:14+00:00          NaN          NaN   \n49998  2023-03-16 09:54:43+00:00          NaN          NaN   \n49999  2023-03-16 09:54:42+00:00          NaN          NaN   \n\n                       source  \\\n0                   Instagram   \n1                     Jobvite   \n2                     Jobvite   \n3      ZipRecruiter Post Jobs   \n4      ZipRecruiter Post Jobs   \n...                       ...   \n49995      Twitter for iPhone   \n49996                  Buffer   \n49997  ZipRecruiter Post Jobs   \n49998  ZipRecruiter Post Jobs   \n49999         Twitter Web App   \n\n                                                    text  \\\n0      Looking for an exciting job where you can ski ...   \n1      Hail in Phoenix - no way!  New opportunity at ...   \n2      Rackspace is hiring! We are looking for Nation...   \n3      We are #hiring Administrative Assistant in Nan...   \n4      We are #hiring Family Service Counselor in Irv...   \n...                                                  ...   \n49995  We are hiring! 😍\\nIf you have experience in pr...   \n49996  A lovely review from one of our wonderful cand...   \n49997  We are #hiring Automotive Service Advisor Writ...   \n49998  We are #hiring Automotive Sales Consultant in ...   \n49999  We Are Hiring!\\n\\nIf you think you fit in this...   \n\n                                                hashtags  \\\n0                                                    NaN   \n1                                                ['job']   \n2      ['becomearacker', 'Rackspace', 'recruiting', '...   \n3                           ['hiring', 'jobs', 'Nanuet']   \n4                           ['hiring', 'jobs', 'Irvine']   \n...                                                  ...   \n49995           ['projectcoordinator', 'london', 'jobs']   \n49996  ['SSADigital', 'Recruitment', 'Hiring', 'Review']   \n49997                     ['hiring', 'jobs', 'Grayling']   \n49998                     ['hiring', 'jobs', 'Grayling']   \n49999  ['hiring', 'nqsf', 'recruitment', 'vocationalt...   \n\n                             location  verified  \n0             20 miles SE of Taos, NM     False  \n1                             Arizona     False  \n2                          Texas, USA     False  \n3           Orange County, California     False  \n4                       United States     False  \n...                               ...       ...  \n49995                 London, England     False  \n49996  Innovation Centre, Silverstone     False  \n49997                  Tampa, Florida     False  \n49998                  Tampa, Florida     False  \n49999                             NaN     False  \n\n[50000 rows x 11 columns]",
      "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>tlink</th>\n      <th>wlink</th>\n      <th>user</th>\n      <th>datetime</th>\n      <th>spreadfactor</th>\n      <th>hiringchance</th>\n      <th>source</th>\n      <th>text</th>\n      <th>hashtags</th>\n      <th>location</th>\n      <th>verified</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>https://twitter.com/SipapuNM/status/1211798864...</td>\n      <td>(https://t.co/imMnymMfwW, )</td>\n      <td>SipapuNM</td>\n      <td>2019-12-30 23:58:58+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Instagram</td>\n      <td>Looking for an exciting job where you can ski ...</td>\n      <td>NaN</td>\n      <td>20 miles SE of Taos, NM</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>https://twitter.com/LorettaOD1/status/12117973...</td>\n      <td>(https://t.co/CFAKKQHeFJ, )</td>\n      <td>LorettaOD1</td>\n      <td>2019-12-30 23:53:02+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Jobvite</td>\n      <td>Hail in Phoenix - no way!  New opportunity at ...</td>\n      <td>['job']</td>\n      <td>Arizona</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>https://twitter.com/guajardo_celina/status/121...</td>\n      <td>(https://t.co/XuSMG0eSgs, )</td>\n      <td>guajardo_celina</td>\n      <td>2019-12-30 23:46:41+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Jobvite</td>\n      <td>Rackspace is hiring! We are looking for Nation...</td>\n      <td>['becomearacker', 'Rackspace', 'recruiting', '...</td>\n      <td>Texas, USA</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>https://twitter.com/SteveEckert_OTD/status/121...</td>\n      <td>(https://t.co/3IGxFiCXUI, )</td>\n      <td>SteveEckert_OTD</td>\n      <td>2019-12-30 23:37:04+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>ZipRecruiter Post Jobs</td>\n      <td>We are #hiring Administrative Assistant in Nan...</td>\n      <td>['hiring', 'jobs', 'Nanuet']</td>\n      <td>Orange County, California</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>https://twitter.com/HireLive/status/1211792689...</td>\n      <td>(https://t.co/XAianPE9mX, )</td>\n      <td>HireLive</td>\n      <td>2019-12-30 23:34:25+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>ZipRecruiter Post Jobs</td>\n      <td>We are #hiring Family Service Counselor in Irv...</td>\n      <td>['hiring', 'jobs', 'Irvine']</td>\n      <td>United States</td>\n      <td>False</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    </tr>\n    <tr>\n      <th>49995</th>\n      <td>https://twitter.com/babelsblessing/status/1636...</td>\n      <td>(https://t.co/WG1UTWmsHZ, )</td>\n      <td>babelsblessing</td>\n      <td>2023-03-16 10:04:39+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Twitter for iPhone</td>\n      <td>We are hiring! 😍\\nIf you have experience in pr...</td>\n      <td>['projectcoordinator', 'london', 'jobs']</td>\n      <td>London, England</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49996</th>\n      <td>https://twitter.com/SSARecruit/status/16363065...</td>\n      <td>(https://t.co/En3UQHu7GO, )</td>\n      <td>SSARecruit</td>\n      <td>2023-03-16 10:01:07+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Buffer</td>\n      <td>A lovely review from one of our wonderful cand...</td>\n      <td>['SSADigital', 'Recruitment', 'Hiring', 'Review']</td>\n      <td>Innovation Centre, Silverstone</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49997</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>(https://t.co/r52DOaqMRS, )</td>\n      <td>StaffYourDealer</td>\n      <td>2023-03-16 09:55:14+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>ZipRecruiter Post Jobs</td>\n      <td>We are #hiring Automotive Service Advisor Writ...</td>\n      <td>['hiring', 'jobs', 'Grayling']</td>\n      <td>Tampa, Florida</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49998</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>(https://t.co/FsVlBkNmmd, )</td>\n      <td>StaffYourDealer</td>\n      <td>2023-03-16 09:54:43+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>ZipRecruiter Post Jobs</td>\n      <td>We are #hiring Automotive Sales Consultant in ...</td>\n      <td>['hiring', 'jobs', 'Grayling']</td>\n      <td>Tampa, Florida</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49999</th>\n      <td>https://twitter.com/PragatiEmpower/status/1636...</td>\n      <td>(https://t.co/t0III7CMEM, )</td>\n      <td>PragatiEmpower</td>\n      <td>2023-03-16 09:54:42+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Twitter Web App</td>\n      <td>We Are Hiring!\\n\\nIf you think you fit in this...</td>\n      <td>['hiring', 'nqsf', 'recruitment', 'vocationalt...</td>\n      <td>NaN</td>\n      <td>False</td>\n    </tr>\n  </tbody>\n</table>\n<p>50000 rows × 11 columns</p>\n</div>"
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def extract_source(df, col):\n",
    "    source = pd.Series(dtype=object)\n",
    "    for index, row in df.iterrows():\n",
    "        element = row[col]\n",
    "        soup = BeautifulSoup(element, 'html.parser')\n",
    "        a = soup.find('a')\n",
    "        if a:\n",
    "            text = a.text.strip()\n",
    "            source.loc[index] = text\n",
    "        else:\n",
    "            source.loc[index] = None\n",
    "    return source\n",
    "\n",
    "\n",
    "newdf['source'] = extract_source(df, 'Source')\n",
    "newdf"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:45:04.006483434Z",
     "start_time": "2024-04-11T08:43:44.653100195Z"
    }
   },
   "id": "38ea3672592b96df",
   "execution_count": 10
  },
  {
   "cell_type": "markdown",
   "source": [
    "\n",
    "\n",
    "spreadfactor is a gradient(from 0 to 10) about how much the tweets have spread. More spreadfactor means it has spread more and the chances of hiring are less\n",
    "The gradients that define it are Likes, Replies, Retweets, Followers, and Following. \n",
    "Likes, Replies, and Retweets have more weightage to the factor, while the other two have less\n",
    "\n",
    "hiringchance is basically another gradient from 1 to 10 about the hiring chance, the more the hiringchance, the better the chances of getting hired\n",
    "here the column \"Time\" is incorporated in as more Time goes by the Hiring Chance Decreases. \n",
    "spreadfactor is also incorporated, more the spreadfactor, less are the chances you get hired"
   ],
   "metadata": {
    "collapsed": false
   },
   "id": "f42d780529466361"
  },
  {
   "cell_type": "code",
   "outputs": [],
   "source": [
    "def calculate_spreadfactor(row):\n",
    "    weights = {\"Likes\": 0.35, \"Replies\": 0.35, \"Retweets\": 0.349, \"Followers\": 0.0005, \"Following\": 0.0005}\n",
    "    spreadfactor = sum(row[col] * weights[col] for col in weights.keys())\n",
    "    return min(max(spreadfactor, 0), 10)\n",
    "\n",
    "\n",
    "def calculate_hiringchance(row):\n",
    "    # print(pd.to_datetime(pd.Timestamp.now().strftime('%Y-%m-%d %H:%M:%S')))\n",
    "    # print(pd.to_datetime(pd.to_datetime(row[\"datetime\"]).strftime('%Y-%m-%d %H:%M:%S')))\n",
    "    time_delta = (pd.to_datetime(pd.Timestamp.now().strftime('%Y-%m-%d %H:%M:%S')) - pd.to_datetime(\n",
    "        pd.to_datetime(row[\"datetime\"]).strftime('%Y-%m-%d %H:%M:%S'))) / pd.Timedelta(days=1)\n",
    "    hiringchance = 10 - ((time_delta - 1554) * 50) - (row[\"spreadfactor\"] * 0.2)\n",
    "    # print(hiringchance)\n",
    "    # return min(max(hiringchance, 1), 10)\n",
    "    if hiringchance:return hiringchance\n",
    "    else: return 0\n",
    "\n",
    "\n",
    "x = df.apply(calculate_spreadfactor, axis=1)\n",
    "x_norm = (x - np.min(x)) / (np.max(x) - np.min(x))\n",
    "\n",
    "y = newdf.apply(calculate_hiringchance, axis=1)\n",
    "y_norm = (y - np.min(y)) / (np.max(y) - np.min(y))\n",
    "\n",
    "\n"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:46:30.034972849Z",
     "start_time": "2024-04-11T08:45:04.010913887Z"
    }
   },
   "id": "91c46c60ae24c75d",
   "execution_count": 11
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "data": {
      "text/plain": "                                                   tlink  \\\n0      https://twitter.com/SipapuNM/status/1211798864...   \n1      https://twitter.com/LorettaOD1/status/12117973...   \n2      https://twitter.com/guajardo_celina/status/121...   \n3      https://twitter.com/SteveEckert_OTD/status/121...   \n4      https://twitter.com/HireLive/status/1211792689...   \n...                                                  ...   \n49995  https://twitter.com/babelsblessing/status/1636...   \n49996  https://twitter.com/SSARecruit/status/16363065...   \n49997  https://twitter.com/StaffYourDealer/status/163...   \n49998  https://twitter.com/StaffYourDealer/status/163...   \n49999  https://twitter.com/PragatiEmpower/status/1636...   \n\n                             wlink             user  \\\n0      (https://t.co/imMnymMfwW, )         SipapuNM   \n1      (https://t.co/CFAKKQHeFJ, )       LorettaOD1   \n2      (https://t.co/XuSMG0eSgs, )  guajardo_celina   \n3      (https://t.co/3IGxFiCXUI, )  SteveEckert_OTD   \n4      (https://t.co/XAianPE9mX, )         HireLive   \n...                            ...              ...   \n49995  (https://t.co/WG1UTWmsHZ, )   babelsblessing   \n49996  (https://t.co/En3UQHu7GO, )       SSARecruit   \n49997  (https://t.co/r52DOaqMRS, )  StaffYourDealer   \n49998  (https://t.co/FsVlBkNmmd, )  StaffYourDealer   \n49999  (https://t.co/t0III7CMEM, )   PragatiEmpower   \n\n                        datetime  spreadfactor  hiringchance  \\\n0      2019-12-30 23:58:58+00:00       0.21500           NaN   \n1      2019-12-30 23:53:02+00:00       0.00960           NaN   \n2      2019-12-30 23:46:41+00:00       0.00345           NaN   \n3      2019-12-30 23:37:04+00:00       0.12675           NaN   \n4      2019-12-30 23:34:25+00:00       0.11170           NaN   \n...                          ...           ...           ...   \n49995  2023-03-16 10:04:39+00:00       0.09800           NaN   \n49996  2023-03-16 10:01:07+00:00       0.63935           NaN   \n49997  2023-03-16 09:55:14+00:00       0.12870           NaN   \n49998  2023-03-16 09:54:43+00:00       0.12870           NaN   \n49999  2023-03-16 09:54:42+00:00       0.14955           NaN   \n\n                       source  \\\n0                   Instagram   \n1                     Jobvite   \n2                     Jobvite   \n3      ZipRecruiter Post Jobs   \n4      ZipRecruiter Post Jobs   \n...                       ...   \n49995      Twitter for iPhone   \n49996                  Buffer   \n49997  ZipRecruiter Post Jobs   \n49998  ZipRecruiter Post Jobs   \n49999         Twitter Web App   \n\n                                                    text  \\\n0      Looking for an exciting job where you can ski ...   \n1      Hail in Phoenix - no way!  New opportunity at ...   \n2      Rackspace is hiring! We are looking for Nation...   \n3      We are #hiring Administrative Assistant in Nan...   \n4      We are #hiring Family Service Counselor in Irv...   \n...                                                  ...   \n49995  We are hiring! 😍\\nIf you have experience in pr...   \n49996  A lovely review from one of our wonderful cand...   \n49997  We are #hiring Automotive Service Advisor Writ...   \n49998  We are #hiring Automotive Sales Consultant in ...   \n49999  We Are Hiring!\\n\\nIf you think you fit in this...   \n\n                                                hashtags  \\\n0                                                    NaN   \n1                                                ['job']   \n2      ['becomearacker', 'Rackspace', 'recruiting', '...   \n3                           ['hiring', 'jobs', 'Nanuet']   \n4                           ['hiring', 'jobs', 'Irvine']   \n...                                                  ...   \n49995           ['projectcoordinator', 'london', 'jobs']   \n49996  ['SSADigital', 'Recruitment', 'Hiring', 'Review']   \n49997                     ['hiring', 'jobs', 'Grayling']   \n49998                     ['hiring', 'jobs', 'Grayling']   \n49999  ['hiring', 'nqsf', 'recruitment', 'vocationalt...   \n\n                             location  verified  \n0             20 miles SE of Taos, NM     False  \n1                             Arizona     False  \n2                          Texas, USA     False  \n3           Orange County, California     False  \n4                       United States     False  \n...                               ...       ...  \n49995                 London, England     False  \n49996  Innovation Centre, Silverstone     False  \n49997                  Tampa, Florida     False  \n49998                  Tampa, Florida     False  \n49999                             NaN     False  \n\n[50000 rows x 11 columns]",
      "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>tlink</th>\n      <th>wlink</th>\n      <th>user</th>\n      <th>datetime</th>\n      <th>spreadfactor</th>\n      <th>hiringchance</th>\n      <th>source</th>\n      <th>text</th>\n      <th>hashtags</th>\n      <th>location</th>\n      <th>verified</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>https://twitter.com/SipapuNM/status/1211798864...</td>\n      <td>(https://t.co/imMnymMfwW, )</td>\n      <td>SipapuNM</td>\n      <td>2019-12-30 23:58:58+00:00</td>\n      <td>0.21500</td>\n      <td>NaN</td>\n      <td>Instagram</td>\n      <td>Looking for an exciting job where you can ski ...</td>\n      <td>NaN</td>\n      <td>20 miles SE of Taos, NM</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>https://twitter.com/LorettaOD1/status/12117973...</td>\n      <td>(https://t.co/CFAKKQHeFJ, )</td>\n      <td>LorettaOD1</td>\n      <td>2019-12-30 23:53:02+00:00</td>\n      <td>0.00960</td>\n      <td>NaN</td>\n      <td>Jobvite</td>\n      <td>Hail in Phoenix - no way!  New opportunity at ...</td>\n      <td>['job']</td>\n      <td>Arizona</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>https://twitter.com/guajardo_celina/status/121...</td>\n      <td>(https://t.co/XuSMG0eSgs, )</td>\n      <td>guajardo_celina</td>\n      <td>2019-12-30 23:46:41+00:00</td>\n      <td>0.00345</td>\n      <td>NaN</td>\n      <td>Jobvite</td>\n      <td>Rackspace is hiring! We are looking for Nation...</td>\n      <td>['becomearacker', 'Rackspace', 'recruiting', '...</td>\n      <td>Texas, USA</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>https://twitter.com/SteveEckert_OTD/status/121...</td>\n      <td>(https://t.co/3IGxFiCXUI, )</td>\n      <td>SteveEckert_OTD</td>\n      <td>2019-12-30 23:37:04+00:00</td>\n      <td>0.12675</td>\n      <td>NaN</td>\n      <td>ZipRecruiter Post Jobs</td>\n      <td>We are #hiring Administrative Assistant in Nan...</td>\n      <td>['hiring', 'jobs', 'Nanuet']</td>\n      <td>Orange County, California</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>https://twitter.com/HireLive/status/1211792689...</td>\n      <td>(https://t.co/XAianPE9mX, )</td>\n      <td>HireLive</td>\n      <td>2019-12-30 23:34:25+00:00</td>\n      <td>0.11170</td>\n      <td>NaN</td>\n      <td>ZipRecruiter Post Jobs</td>\n      <td>We are #hiring Family Service Counselor in Irv...</td>\n      <td>['hiring', 'jobs', 'Irvine']</td>\n      <td>United States</td>\n      <td>False</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    </tr>\n    <tr>\n      <th>49995</th>\n      <td>https://twitter.com/babelsblessing/status/1636...</td>\n      <td>(https://t.co/WG1UTWmsHZ, )</td>\n      <td>babelsblessing</td>\n      <td>2023-03-16 10:04:39+00:00</td>\n      <td>0.09800</td>\n      <td>NaN</td>\n      <td>Twitter for iPhone</td>\n      <td>We are hiring! 😍\\nIf you have experience in pr...</td>\n      <td>['projectcoordinator', 'london', 'jobs']</td>\n      <td>London, England</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49996</th>\n      <td>https://twitter.com/SSARecruit/status/16363065...</td>\n      <td>(https://t.co/En3UQHu7GO, )</td>\n      <td>SSARecruit</td>\n      <td>2023-03-16 10:01:07+00:00</td>\n      <td>0.63935</td>\n      <td>NaN</td>\n      <td>Buffer</td>\n      <td>A lovely review from one of our wonderful cand...</td>\n      <td>['SSADigital', 'Recruitment', 'Hiring', 'Review']</td>\n      <td>Innovation Centre, Silverstone</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49997</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>(https://t.co/r52DOaqMRS, )</td>\n      <td>StaffYourDealer</td>\n      <td>2023-03-16 09:55:14+00:00</td>\n      <td>0.12870</td>\n      <td>NaN</td>\n      <td>ZipRecruiter Post Jobs</td>\n      <td>We are #hiring Automotive Service Advisor Writ...</td>\n      <td>['hiring', 'jobs', 'Grayling']</td>\n      <td>Tampa, Florida</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49998</th>\n      <td>https://twitter.com/StaffYourDealer/status/163...</td>\n      <td>(https://t.co/FsVlBkNmmd, )</td>\n      <td>StaffYourDealer</td>\n      <td>2023-03-16 09:54:43+00:00</td>\n      <td>0.12870</td>\n      <td>NaN</td>\n      <td>ZipRecruiter Post Jobs</td>\n      <td>We are #hiring Automotive Sales Consultant in ...</td>\n      <td>['hiring', 'jobs', 'Grayling']</td>\n      <td>Tampa, Florida</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>49999</th>\n      <td>https://twitter.com/PragatiEmpower/status/1636...</td>\n      <td>(https://t.co/t0III7CMEM, )</td>\n      <td>PragatiEmpower</td>\n      <td>2023-03-16 09:54:42+00:00</td>\n      <td>0.14955</td>\n      <td>NaN</td>\n      <td>Twitter Web App</td>\n      <td>We Are Hiring!\\n\\nIf you think you fit in this...</td>\n      <td>['hiring', 'nqsf', 'recruitment', 'vocationalt...</td>\n      <td>NaN</td>\n      <td>False</td>\n    </tr>\n  </tbody>\n</table>\n<p>50000 rows × 11 columns</p>\n</div>"
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf[\"spreadfactor\"] = x_norm\n",
    "newdf[\"hiringchance\"] = 2*((y_norm * 100000) - 1740)\n",
    "newdf"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:46:30.083168983Z",
     "start_time": "2024-04-11T08:46:30.076148943Z"
    }
   },
   "id": "dc68fd57b3280ef5",
   "execution_count": 12
  },
  {
   "cell_type": "markdown",
   "source": [],
   "metadata": {
    "collapsed": false
   },
   "id": "e5ce0506dd188ca1"
  },
  {
   "cell_type": "code",
   "outputs": [
    {
     "data": {
      "text/plain": "                                                   tlink  \\\n40000  https://twitter.com/totalcaretwg/status/164553...   \n40001  https://twitter.com/ultabeautyjobs/status/1645...   \n40002  https://twitter.com/EEIHR/status/1645532189965...   \n40003  https://twitter.com/COHCareers/status/16455321...   \n40004  https://twitter.com/nidecsvprobe/status/164553...   \n...                                                  ...   \n9995   https://twitter.com/FayMRecruitment/status/120...   \n9996   https://twitter.com/ManpowerCoy/status/1204098...   \n9997   https://twitter.com/Recruitingplus1/status/120...   \n9998   https://twitter.com/SmithLatifal/status/120409...   \n9999   https://twitter.com/jgadison2020/status/120409...   \n\n                                                   wlink             user  \\\n40000                        (https://t.co/3X9RsvTtEx, )     totalcaretwg   \n40001                        (https://t.co/r7jNUPXHgu, )   ultabeautyjobs   \n40002                        (https://t.co/rT8RWlKkj3, )            EEIHR   \n40003                        (https://t.co/hOkFKtAbbK, )       COHCareers   \n40004                        (https://t.co/GMWLipb8QD, )     nidecsvprobe   \n...                                                  ...              ...   \n9995                         (https://t.co/lPkGoX2xwG, )  FayMRecruitment   \n9996                         (https://t.co/XlM6iFz5Fp, )      ManpowerCoy   \n9997                         (https://t.co/mwHtf5ebpx, )  Recruitingplus1   \n9998   (https://t.co/CWvvZgSHOG\"&gt;https://t.co/CWvv...     SmithLatifal   \n9999                         (https://t.co/a44O7o0GF8, )     jgadison2020   \n\n                        datetime  spreadfactor  hiringchance           source  \\\n40000  2023-04-10 21:00:55+00:00       0.00065           NaN       LaterMedia   \n40001  2023-04-10 21:00:45+00:00       0.06790           NaN    CareerArc App   \n40002  2023-04-10 21:00:21+00:00       0.10470           NaN   Hootsuite Inc.   \n40003  2023-04-10 21:00:16+00:00       0.25410           NaN   Hootsuite Inc.   \n40004  2023-04-10 20:58:34+00:00       0.01150           NaN  Twitter Web App   \n...                          ...           ...           ...              ...   \n9995   2019-12-09 18:01:05+00:00       0.25980           NaN   Hootsuite Inc.   \n9996   2019-12-09 18:00:22+00:00       0.03995           NaN  MightyRecruiter   \n9997   2019-12-09 18:00:21+00:00       0.00375           NaN  MightyRecruiter   \n9998   2019-12-09 18:00:21+00:00       0.02470           NaN  MightyRecruiter   \n9999   2019-12-09 18:00:20+00:00       0.00035           NaN  MightyRecruiter   \n\n                                                    text  \\\n40000  WE ARE HIRING! Licensed Practical Nurse (LPN) ...   \n40001  Looking to take your career to the next level ...   \n40002  When job seekers apply to online applications,...   \n40003  JOB OPENING! WE ARE HIRING! The HOUSTON INFORM...   \n40004  We are #hiring! If you are interested in any o...   \n...                                                  ...   \n9995   We are hiring! Get in touch today info@faymaye...   \n9996   We are hiring! Click the link below for job de...   \n9997   We are hiring! Click the link below for job de...   \n9998   We are hiring! Click the link below for job de...   \n9999   We are hiring! Click the link below for job de...   \n\n                                                hashtags           location  \\\n40000                                  ['nurse', 'jobs']                NaN   \n40001              ['beautywithoutlimits', 'LuxeBeauty']                NaN   \n40002                   ['employment', 'jobs', 'hiring']       Manassas, VA   \n40003                                                NaN        Houston, TX   \n40004   ['hiring', 'greatplacetowork', 'hiring', 'jobs']     Tempe, Arizona   \n...                                                  ...                ...   \n9995   ['job', 'jobs', 'hiring', 'wearehiring', 'newj...  Stafford, England   \n9996                                                 NaN     Fort Worth, TX   \n9997                                                 NaN     St Charles, MO   \n9998                                                 NaN     Houston Texas    \n9999                                                 NaN     Fort Worth, TX   \n\n       verified  \n40000     False  \n40001     False  \n40002     False  \n40003     False  \n40004     False  \n...         ...  \n9995      False  \n9996      False  \n9997      False  \n9998      False  \n9999      False  \n\n[50000 rows x 11 columns]",
      "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>tlink</th>\n      <th>wlink</th>\n      <th>user</th>\n      <th>datetime</th>\n      <th>spreadfactor</th>\n      <th>hiringchance</th>\n      <th>source</th>\n      <th>text</th>\n      <th>hashtags</th>\n      <th>location</th>\n      <th>verified</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>40000</th>\n      <td>https://twitter.com/totalcaretwg/status/164553...</td>\n      <td>(https://t.co/3X9RsvTtEx, )</td>\n      <td>totalcaretwg</td>\n      <td>2023-04-10 21:00:55+00:00</td>\n      <td>0.00065</td>\n      <td>NaN</td>\n      <td>LaterMedia</td>\n      <td>WE ARE HIRING! Licensed Practical Nurse (LPN) ...</td>\n      <td>['nurse', 'jobs']</td>\n      <td>NaN</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>40001</th>\n      <td>https://twitter.com/ultabeautyjobs/status/1645...</td>\n      <td>(https://t.co/r7jNUPXHgu, )</td>\n      <td>ultabeautyjobs</td>\n      <td>2023-04-10 21:00:45+00:00</td>\n      <td>0.06790</td>\n      <td>NaN</td>\n      <td>CareerArc App</td>\n      <td>Looking to take your career to the next level ...</td>\n      <td>['beautywithoutlimits', 'LuxeBeauty']</td>\n      <td>NaN</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>40002</th>\n      <td>https://twitter.com/EEIHR/status/1645532189965...</td>\n      <td>(https://t.co/rT8RWlKkj3, )</td>\n      <td>EEIHR</td>\n      <td>2023-04-10 21:00:21+00:00</td>\n      <td>0.10470</td>\n      <td>NaN</td>\n      <td>Hootsuite Inc.</td>\n      <td>When job seekers apply to online applications,...</td>\n      <td>['employment', 'jobs', 'hiring']</td>\n      <td>Manassas, VA</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>40003</th>\n      <td>https://twitter.com/COHCareers/status/16455321...</td>\n      <td>(https://t.co/hOkFKtAbbK, )</td>\n      <td>COHCareers</td>\n      <td>2023-04-10 21:00:16+00:00</td>\n      <td>0.25410</td>\n      <td>NaN</td>\n      <td>Hootsuite Inc.</td>\n      <td>JOB OPENING! WE ARE HIRING! The HOUSTON INFORM...</td>\n      <td>NaN</td>\n      <td>Houston, TX</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>40004</th>\n      <td>https://twitter.com/nidecsvprobe/status/164553...</td>\n      <td>(https://t.co/GMWLipb8QD, )</td>\n      <td>nidecsvprobe</td>\n      <td>2023-04-10 20:58:34+00:00</td>\n      <td>0.01150</td>\n      <td>NaN</td>\n      <td>Twitter Web App</td>\n      <td>We are #hiring! If you are interested in any o...</td>\n      <td>['hiring', 'greatplacetowork', 'hiring', 'jobs']</td>\n      <td>Tempe, Arizona</td>\n      <td>False</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    </tr>\n    <tr>\n      <th>9995</th>\n      <td>https://twitter.com/FayMRecruitment/status/120...</td>\n      <td>(https://t.co/lPkGoX2xwG, )</td>\n      <td>FayMRecruitment</td>\n      <td>2019-12-09 18:01:05+00:00</td>\n      <td>0.25980</td>\n      <td>NaN</td>\n      <td>Hootsuite Inc.</td>\n      <td>We are hiring! Get in touch today info@faymaye...</td>\n      <td>['job', 'jobs', 'hiring', 'wearehiring', 'newj...</td>\n      <td>Stafford, England</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>9996</th>\n      <td>https://twitter.com/ManpowerCoy/status/1204098...</td>\n      <td>(https://t.co/XlM6iFz5Fp, )</td>\n      <td>ManpowerCoy</td>\n      <td>2019-12-09 18:00:22+00:00</td>\n      <td>0.03995</td>\n      <td>NaN</td>\n      <td>MightyRecruiter</td>\n      <td>We are hiring! Click the link below for job de...</td>\n      <td>NaN</td>\n      <td>Fort Worth, TX</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>9997</th>\n      <td>https://twitter.com/Recruitingplus1/status/120...</td>\n      <td>(https://t.co/mwHtf5ebpx, )</td>\n      <td>Recruitingplus1</td>\n      <td>2019-12-09 18:00:21+00:00</td>\n      <td>0.00375</td>\n      <td>NaN</td>\n      <td>MightyRecruiter</td>\n      <td>We are hiring! Click the link below for job de...</td>\n      <td>NaN</td>\n      <td>St Charles, MO</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>9998</th>\n      <td>https://twitter.com/SmithLatifal/status/120409...</td>\n      <td>(https://t.co/CWvvZgSHOG\"&amp;gt;https://t.co/CWvv...</td>\n      <td>SmithLatifal</td>\n      <td>2019-12-09 18:00:21+00:00</td>\n      <td>0.02470</td>\n      <td>NaN</td>\n      <td>MightyRecruiter</td>\n      <td>We are hiring! Click the link below for job de...</td>\n      <td>NaN</td>\n      <td>Houston Texas</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>9999</th>\n      <td>https://twitter.com/jgadison2020/status/120409...</td>\n      <td>(https://t.co/a44O7o0GF8, )</td>\n      <td>jgadison2020</td>\n      <td>2019-12-09 18:00:20+00:00</td>\n      <td>0.00035</td>\n      <td>NaN</td>\n      <td>MightyRecruiter</td>\n      <td>We are hiring! Click the link below for job de...</td>\n      <td>NaN</td>\n      <td>Fort Worth, TX</td>\n      <td>False</td>\n    </tr>\n  </tbody>\n</table>\n<p>50000 rows × 11 columns</p>\n</div>"
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted_df = newdf.sort_values(by='datetime', ascending=False)\n",
    "sorted_df"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:46:30.158766356Z",
     "start_time": "2024-04-11T08:46:30.076930533Z"
    }
   },
   "id": "65f12544a92d4006",
   "execution_count": 13
  },
  {
   "cell_type": "code",
   "outputs": [],
   "source": [
    "sorted_df.to_csv(\"Finalized-Tweets.csv\", index=False)\n"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-04-11T08:46:31.455448349Z",
     "start_time": "2024-04-11T08:46:30.138441947Z"
    }
   },
   "id": "f5ea14743def4cc6",
   "execution_count": 14
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}