ct-1db-1kw-2kw.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1bc8c529-972d-4709-af79-5ca95bfe76bd",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "9f649f49-7e41-4084-a44f-54cb61d24b66",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 10000 entries, 0 to 9999\n",
      "Data columns (total 41 columns):\n",
      " #   Column                                                                                                            Non-Null Count  Dtype  \n",
      "---  ------                                                                                                            --------------  -----  \n",
      " 0   Page Name                                                                                                         10000 non-null  object \n",
      " 1   User Name                                                                                                         9618 non-null   object \n",
      " 2   Facebook Id                                                                                                       10000 non-null  int64  \n",
      " 3   Page Category                                                                                                     10000 non-null  object \n",
      " 4   Page Admin Top Country                                                                                            10000 non-null  object \n",
      " 5   Page Description                                                                                                  9964 non-null   object \n",
      " 6   Page Created                                                                                                      10000 non-null  object \n",
      " 7   Likes at Posting                                                                                                  9919 non-null   float64\n",
      " 8   Followers at Posting                                                                                              9919 non-null   float64\n",
      " 9   Post Created                                                                                                      10000 non-null  object \n",
      " 10  Post Created Date                                                                                                 10000 non-null  object \n",
      " 11  Post Created Time                                                                                                 10000 non-null  object \n",
      " 12  Type                                                                                                              10000 non-null  object \n",
      " 13  Total Interactions                                                                                                10000 non-null  object \n",
      " 14  Likes                                                                                                             10000 non-null  int64  \n",
      " 15  Comments                                                                                                          10000 non-null  int64  \n",
      " 16  Shares                                                                                                            10000 non-null  int64  \n",
      " 17  Love                                                                                                              10000 non-null  int64  \n",
      " 18  Wow                                                                                                               10000 non-null  int64  \n",
      " 19  Haha                                                                                                              10000 non-null  int64  \n",
      " 20  Sad                                                                                                               10000 non-null  int64  \n",
      " 21  Angry                                                                                                             10000 non-null  int64  \n",
      " 22  Care                                                                                                              10000 non-null  int64  \n",
      " 23  Video Share Status                                                                                                1315 non-null   object \n",
      " 24  Is Video Owner?                                                                                                   10000 non-null  object \n",
      " 25  Post Views                                                                                                        10000 non-null  int64  \n",
      " 26  Total Views                                                                                                       10000 non-null  int64  \n",
      " 27  Total Views For All Crossposts                                                                                    10000 non-null  int64  \n",
      " 28  Video Length                                                                                                      1315 non-null   object \n",
      " 29  URL                                                                                                               10000 non-null  object \n",
      " 30  Message                                                                                                           9510 non-null   object \n",
      " 31  Link                                                                                                              9387 non-null   object \n",
      " 32  Final Link                                                                                                        2747 non-null   object \n",
      " 33  Image Text                                                                                                        688 non-null    object \n",
      " 34  Link Text                                                                                                         6543 non-null   object \n",
      " 35  Description                                                                                                       4610 non-null   object \n",
      " 36  Sponsor Id                                                                                                        2 non-null      float64\n",
      " 37  Sponsor Name                                                                                                      2 non-null      object \n",
      " 38  Sponsor Category                                                                                                  2 non-null      object \n",
      " 39  Total Interactions (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )  10000 non-null  object \n",
      " 40  Overperforming Score                                                                                              10000 non-null  float64\n",
      "dtypes: float64(4), int64(13), object(24)\n",
      "memory usage: 3.1+ MB\n"
     ]
    }
   ],
   "source": [
    "df = pd.read_csv(\"elections-us.csv\")\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "dfb6e279-5eb4-49af-bb4d-f17121bc9e05",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convert object-type columns to string, except integer columns\n",
    "for col in df.columns:\n",
    "    if df[col].dtype == 'object':\n",
    "        df[col] = df[col].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "9280e18c-5b96-42ee-ac9b-b4a5766ef402",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The keyword 'Trump' appears 1500 times in the 'Message' column.\n",
      "The breakdown by page is:\n",
      "Page Name\n",
      "Informed Citizens United                 42\n",
      "The Hill                                 41\n",
      "The Western Journal                      40\n",
      "Voz Media                                34\n",
      "Right Side Broadcasting                  31\n",
      "                                         ..\n",
      "Brenna Bird for Attorney General          1\n",
      "Joe Walsh                                 1\n",
      "The Love Life Of An Asian Guy             1\n",
      "Rocks and Cows of Minnesota               1\n",
      "Harris County Democratic Party - HCDP     1\n",
      "Name: count, Length: 497, dtype: int64\n",
      "\n",
      "Top 5 most shared posts that mention the keyword:\n",
      "           Page Name                                                URL  \\\n",
      "22  Occupy Democrats  https://www.facebook.com/100066647494924/posts...   \n",
      "1   Occupy Democrats  https://www.facebook.com/100066647494924/posts...   \n",
      "4           Fox News  https://www.facebook.com/100059396147148/posts...   \n",
      "18  Occupy Democrats  https://www.facebook.com/100066647494924/posts...   \n",
      "6   Occupy Democrats  https://www.facebook.com/100066647494924/posts...   \n",
      "\n",
      "    Shares  \n",
      "22    4427  \n",
      "1     4041  \n",
      "4     2436  \n",
      "18    2330  \n",
      "6     1854  \n"
     ]
    }
   ],
   "source": [
    "# Define the keyword to search for\n",
    "keyword = \"Trump\"\n",
    "\n",
    "# Count the occurrences of the keyword in the \"Message\" column\n",
    "keyword_counts = df[df['Message'].str.contains(keyword, case=False)]['Page Name'].value_counts()\n",
    "\n",
    "# Print the keyword occurrences\n",
    "print(f\"The keyword '{keyword}' appears {keyword_counts.sum()} times in the 'Message' column.\")\n",
    "print(f\"The breakdown by page is:\\n{keyword_counts}\")\n",
    "\n",
    "# Get the top 5 most shared posts that mention the keyword\n",
    "top_shared_posts = (\n",
    "    df[df['Message'].str.contains(keyword, case=False)]\n",
    "    .sort_values(by='Shares', ascending=False)\n",
    "    .head(5)\n",
    "    [['Page Name', 'URL', 'Shares']]\n",
    ")\n",
    "\n",
    "print(\"\\nTop 5 most shared posts that mention the keyword:\")\n",
    "print(top_shared_posts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "be3aed3d-9576-4efb-8a36-223a85d87b44",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The keyword 'Trump' appears 1500 times in the 'Message' column.\n",
      "The keyword 'Biden' appears 1002 times in the 'Message' column.\n",
      "The breakdown by page is:\n",
      "Trump occurrences:\n",
      "Page Name\n",
      "Informed Citizens United                 42\n",
      "The Hill                                 41\n",
      "The Western Journal                      40\n",
      "Voz Media                                34\n",
      "Right Side Broadcasting                  31\n",
      "                                         ..\n",
      "Brenna Bird for Attorney General          1\n",
      "Joe Walsh                                 1\n",
      "The Love Life Of An Asian Guy             1\n",
      "Rocks and Cows of Minnesota               1\n",
      "Harris County Democratic Party - HCDP     1\n",
      "Name: count, Length: 497, dtype: int64\n",
      "Biden occurrences:\n",
      "Page Name\n",
      "The Western Journal                      47\n",
      "Informed Citizens United                 31\n",
      "Laguna Beach Democratic Club             30\n",
      "The Hill                                 29\n",
      "Voz Media                                29\n",
      "                                         ..\n",
      "Rank the Vote                             1\n",
      "Tallahassee Democrat                      1\n",
      "Anthony Brian Logan - ABL                 1\n",
      "Marlin Stutzman                           1\n",
      "Harris County Democratic Party - HCDP     1\n",
      "Name: count, Length: 370, dtype: int64\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZcAAAGrCAYAAAAM3trbAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjkuMCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy80BEi2AAAACXBIWXMAAA9hAAAPYQGoP6dpAABD8klEQVR4nO3dd3gUVeM98DO72bRN7wQICUkIvQYQJBQB6SIiKE1pFiwIvqL4VcHyU7Fhx4KvAq+ACChICyrSUUAgQAQCCS2BkN777s7vj5XVkAABNntnZ8/neXggu7M7JxByMnNn7pVkWZZBRERkRRrRAYiISH1YLkREZHUsFyIisjqWCxERWR3LhYiIrI7lQkREVsdyISIiq2O5EBGR1bFciIjI6lgupEqSJOHll18WHYPIYbFcVGTRokWQJAl//vlntccLCgrQpUsXuLq6Ij4+XlA65crJycGsWbMQExMDV1dX+Pn5YcCAAVi/fr3oaER2y0l0AKpfhYWFuPPOO3HkyBH8+OOPGDhwoOhIipKUlIS+ffsiKysLkyZNQmxsLPLz87F06VIMGzYMzzzzDN555x3RMYnsDstFxYqKijBgwAAkJCTghx9+wKBBg0RHspqSkhLo9fpbeo+qqirce++9yMvLw44dO9C1a1fLczNnzsS4cePw7rvvIjY2Fvfdd9+tRraqq33+siyjvLwcbm5uAlIR/YOnxVSquLgYAwcOxMGDB7F69WoMGTKk2vMXLlzA5MmTERwcDBcXF7Rq1Qpff/11tdfr9Xo89dRTNd47LS0NWq0Wb775JvLz86HVavHRRx9Zns/OzoZGo4G/vz/+Pen2tGnTEBISUu29Vq5ciU6dOsHNzQ0BAQEYP348Lly4UG2biRMnwsPDAykpKRg8eDA8PT0xbtw4AEBFRQVmzpyJwMBAeHp64q677kJaWlqd/o5Wr16NxMREzJ49u1qxAIBWq8UXX3wBHx+fGmM35eXlePnll9GsWTO4urqiQYMGuOeee5CSkmLZxmQy4cMPP0SbNm3g6uqKwMBADBw40HLK8uzZs5AkCYsWLaqR68rxopdffhmSJOHYsWMYO3YsfH190aNHDwBAeHg4hg4dis2bNyM2NhZubm744osvAAD5+fmYMWMGGjduDBcXF0RFReGtt96CyWSyvPflHO+++y6+/PJLREZGwsXFBZ07d8b+/ftrZDtx4gRGjx6NwMBAuLm5ISYmBi+88EK1ba73tXXZxx9/jFatWsHd3R2+vr6IjY3FsmXLavmXInvEIxcVKikpwaBBg7B//36sWrUKQ4cOrfZ8RkYGbrvtNkiShCeeeAKBgYHYtGkTpkyZgsLCQsyYMQMeHh4YMWIEVqxYgfnz50Or1Vpev3z5csiyjHHjxsHHxwetW7fGjh07MH36dADArl27IEkScnNzcezYMbRq1QoAsHPnTsTFxVneZ9GiRZg0aRI6d+6MN998ExkZGfjwww+xe/duHDp0CD4+PpZtDQYDBgwYgB49euDdd9+Fu7s7AGDq1Kn49ttvMXbsWHTv3h2//fZbjSK9mnXr1gEAHnjggVqf9/b2xvDhw7F48WIkJycjKioKRqMRQ4cOxZYtW3D//ffjqaeeQlFREX755RckJiYiMjISADBlyhQsWrQIgwYNwtSpU2EwGLBz50788ccfiI2NrVO+K40aNQrR0dF44403qpV2UlISxowZg0ceeQQPPfQQYmJiUFpail69euHChQt45JFHEBYWhj179uD5559Heno6Pvjgg2rvvWzZMhQVFeGRRx6BJEl4++23cc899+D06dPQ6XQAgCNHjiAuLg46nQ4PP/wwwsPDkZKSgnXr1uH1118HULevLQBYuHAhpk+fjnvvvRdPPfUUysvLceTIEezduxdjx469qb8fUhiZVOObb76RAchNmjSRdTqdvGbNmlq3mzJlitygQQM5Ozu72uP333+/7O3tLZeWlsqyLMubN2+WAcibNm2qtl3btm3lXr16WT5+/PHH5eDgYMvHTz/9tNyzZ085KChI/uyzz2RZluWcnBxZkiT5ww8/lGVZlisrK+WgoCC5devWcllZmeW169evlwHIc+bMsTz24IMPygDk2bNnV8uRkJAgA5Afe+yxao+PHTtWBiDPnTv3Wn9dcvv27WVvb+9rbjN//nwZgPzTTz/JsizLX3/9tQxAnj9/fo1tTSaTLMuy/Ntvv8kA5OnTp191mzNnzsgA5G+++abGNldmnzt3rgxAHjNmTI1tmzRpIgOQ4+Pjqz3+2muvyXq9Xj558mS1x2fPni1rtVr5/Pnz1XL4+/vLubm5lu3Wrl0rA5DXrVtneaxnz56yp6enfO7cuVo/J1mu+9fW8OHD5VatWtX4fEg9eFpMhTIyMuDq6orGjRvXeE6WZaxevRrDhg2DLMvIzs62/BowYAAKCgpw8OBBAEC/fv0QGhqKpUuXWl6fmJiII0eOYPz48ZbH4uLikJGRgaSkJADmI5SePXsiLi4OO3fuBGA+mpFl2XLk8ueffyIzMxOPPfYYXF1dLe81ZMgQNG/eHBs2bKiRfdq0adU+3rhxIwBYjpguu/zT8fUUFRXB09Pzmttcfr6wsBCA+VRaQEAAnnzyyRrbSpJk2UaSJMydO/eq29yMRx99tNbHIyIiMGDAgGqPrVy5EnFxcfD19a32b9yvXz8YjUbs2LGj2vb33XcffH19LR9f/nc6ffo0ACArKws7duzA5MmTERYWVuvndCNfWz4+PkhLS6v11BupA8tFhb744gs4Oztj4MCBlm/4l2VlZSE/Px9ffvklAgMDq/2aNGkSACAzMxMAoNFoMG7cOKxZswalpaUAgKVLl8LV1RWjRo2yvOflb0Q7d+5ESUkJDh06hLi4OPTs2dNSLjt37oSXlxfatWsHADh37hwAICYmpkb+5s2bW56/zMnJCY0aNar22Llz56DRaCynoi6r7T1r4+npiaKiomtuc/n5yyWTkpKCmJgYODld/YxySkoKQkND4efnV6ccdRUREVHnx0+dOoX4+Pga/8b9+vUD8M+/8WVXFsblosnLywPwT8m0bt36qvlu5Gvrueeeg4eHB7p06YLo6Gg8/vjj2L1793X/Dsh+cMxFhVq2bImNGzeib9++6N+/P3bv3m05irk8mDt+/Hg8+OCDtb6+bdu2lj8/8MADeOedd7BmzRqMGTMGy5Ytw9ChQ+Ht7W3ZJjQ0FBEREdixYwfCw8MhyzK6deuGwMBAPPXUUzh37hx27tyJ7t27Q6O5uZ9nXFxcbvq1V9OiRQskJCTg/PnzNb65XnbkyBEA5r9Ta7raEYzRaLzqa652BVhtj5tMJvTv3x/PPvtsra9p1qxZtY//Pab2b/INrIJ+I19bLVq0QFJSEtavX4/4+HisXr0aCxYswJw5c/DKK6/UeZ+kXCwXlerSpQvWrFmDIUOGoH///ti5c6flp0hPT08YjUbLT7HX0rp1a3To0AFLly5Fo0aNcP78eXz88cc1touLi8OOHTsQERGB9u3bw9PTE+3atYO3tzfi4+Nx8ODBat80mjRpAsA8GH3HHXdUe6+kpCTL89fSpEkTmEwmy9HEv19fF0OHDsXy5cuxZMkSvPjiizWeLywsxNq1a9G8eXNERUUBACIjI7F3715UVVVZBrqvFBkZic2bNyM3N/eqRy+Xjwzy8/OrPX7lEdvNioyMRHFxcZ3+jeuiadOmAMynRa/mRr+29Ho97rvvPtx3332orKzEPffcg9dffx3PP/98tVOlZJ94WkzF+vbti+XLlyM5ORkDBw5EYWEhtFotRo4cabkM90pZWVk1HpswYQJ+/vlnfPDBB/D396/1fpm4uDicPXsWK1assJwm02g06N69O+bPn4+qqqpqV4rFxsYiKCgIn3/+OSoqKiyPb9q0CcePH6/TFV+Xc/z7MmgANa6Eupp7770XLVu2xLx582rMamAymTBt2jTk5eVVGzsZOXIksrOz8cknn9R4v8s/5Y8cORKyLNf6E/jlbby8vBAQEFBj7GPBggV1yn49o0ePxu+//47NmzfXeC4/Px8Gg+GG3i8wMBA9e/bE119/jfPnz1d77vLndCNfWzk5OdWec3Z2RsuWLSHLMqqqqm4oGykTj1xUbsSIEVi4cCEmT56Mu+66C/Hx8Zg3bx62bt2Krl274qGHHkLLli2Rm5uLgwcP4tdff0Vubm619xg7diyeffZZ/Pjjj5g2bVqtP7FfLo6kpCS88cYblsd79uyJTZs2We6duEyn0+Gtt97CpEmT0KtXL4wZM8ZyKXJ4eDhmzpx53c+tffv2GDNmDBYsWICCggJ0794dW7ZsQXJycp3+bpydnbFq1Sr07dsXPXr0qHaH/rJly3Dw4EH85z//wf333295zQMPPIAlS5bg6aefxr59+xAXF4eSkhL8+uuveOyxxzB8+HD06dMHEyZMwEcffYRTp05h4MCBMJlM2LlzJ/r06YMnnngCgPky6nnz5mHq1KmIjY3Fjh07cPLkyTplv55Zs2bhp59+wtChQzFx4kR06tQJJSUlOHr0KFatWoWzZ88iICDght7zo48+Qo8ePdCxY0c8/PDDiIiIwNmzZ7FhwwYkJCQAQJ2/tu68806EhITg9ttvR3BwMI4fP45PPvkEQ4YMue5FFmQnxFykRvXh8qXI+/fvr/Hcu+++KwOQhw4dKldVVckZGRny448/Ljdu3FjW6XRySEiI3LdvX/nLL7+s9b0HDx4sA5D37Nlz1f0HBQXJAOSMjAzLY7t27ZIByHFxcbW+ZsWKFXKHDh1kFxcX2c/PTx43bpyclpZWbZsHH3xQ1uv1tb6+rKxMnj59uuzv7y/r9Xp52LBhcmpqap0uRb4sMzNTfvrpp+WoqCjZxcVF9vHxkfv162e5/PhKpaWl8gsvvCBHRERY/u7uvfdeOSUlxbKNwWCQ33nnHbl58+ays7OzHBgYKA8aNEg+cOBAtfeZMmWK7O3tLXt6esqjR4+WMzMzr3opclZWVo0sTZo0kYcMGVJrzqKiIvn555+Xo6KiZGdnZzkgIEDu3r27/O6778qVlZWyLP9zKfI777xT4/W1/R0mJibKI0aMkH18fGRXV1c5JiZGfumll6ptU5evrS+++ELu2bOn7O/vL7u4uMiRkZHyrFmz5IKCglo/F7I/kizfwIgdOawRI0bg6NGjdT4qICLHxjEXuq709HRs2LABEyZMEB2FiOwEx1zoqs6cOYPdu3fjq6++gk6nwyOPPCI6EhHZCR650FVt374dEyZMwJkzZ7B48eIak04SEV0Nx1yIiMjqeORCRERWx3IhIiKrY7kQEZHVsVyIiMjqWC5ERGR1LBcFkiTpmr+uXNOdiEhpeBOlAqWnp1v+vGLFCsyZM6faNPIeHh6WP8uyDKPReM3Fq4iIbI1HLgoUEhJi+eXt7Q1JkiwfnzhxAp6enti0aRM6deoEFxcX7Nq1CxMnTsTdd99d7X1mzJiB3r17Wz7u3bs3nnzyScyYMQO+vr4IDg7GwoULUVJSgkmTJsHT0xNRUVHYtGmT5TXbtm2DJEnYsGED2rZtC1dXV9x2223XXNeDiIjlYqdmz56NefPm4fjx49VWjryexYsXIyAgAPv27cOTTz6JadOmYdSoUejevTsOHjyIO++8ExMmTLAsa3zZrFmz8N5772H//v0IDAzEsGHDuO4GEV0Vy8VOvfrqq+jfvz8iIyNvaK32du3a4cUXX0R0dLRlxb+AgAA89NBDiI6Oxpw5c5CTk2NZ3veyuXPnon///mjTpg0WL16MjIwM/Pjjj9b+tIhIJVgudio2NvamXvfvoxytVgt/f3+0adPG8lhwcDAAIDMzs9rrunXrZvmzn58fYmJicPz48ZvKQETqx3KxU3q9vtrHGo0GV04TV9tpqytXkZQkqdpjkiQBMC/zS0R0s1guKhEYGFjtKjMAlqVnreGPP/6w/DkvLw8nT55EixYtrPb+RKQuLBeVuOOOO/Dnn39iyZIlOHXqFObOnWvVK7peffVVbNmyBYmJiZg4cSICAgJqXJ1GRHQZy0UlBgwYgJdeegnPPvssOnfujKKiIjzwwANWe/958+bhqaeeQqdOnXDp0iWsW7cOzs7OVnt/IlIXrudC17Rt2zb06dMHeXl58PHxER2HiOwEj1yIiMjqWC5ERGR1PC1GRERWx9kOyeEYjCbklVYhr7QSeSWVyCutRG5JFQrLq1BlMMFgkmEwmWAwyqgyyjCaTKgyyTAYzY8ZZRk6rQbuzlq46bRw1WnNf3b+15915l/e7joEeboiwMPZcg8RkSNguZCqlFYacC6nFOdySnE+twTnckqRUViOnBJzkeSWVKKowgBbH687aSQEeLgg2MsFgZ6uCPZyQdDl371c0MDbDeH+erg5a20bjKie8LQY2Z0KgxFJl4qQklVsLpGcUpzLNRdKdnGF6Hg3TZKAEC9XRAToERGgR2SgB6KDPRAT7IkgL1fR8YhuCMuFFK2s0ohj6YX462IBjqYVIPFiIU5lFMFgcqwvWx93HZoFeaJZiAfaNfJBhzBfRAbqeaqNFIvlQopRZTThSFoBDqfmI/FCARIvFiAlqwRGByuSuvJx16FdIx90DPNFhzAftA/zgZer7vovJLIBlgsJYzLJOJZeiD0p2diTkoP9Z3JRUmkUHctuaSQgMtADHcN80bGJD26PCkAjX3fRschBsVzIppIzi81lkpyDP87kIL+UC47Vp8hAPXrHBKFXs0B0beoHFydeMEC2wXKhelVaacD2pCz8cjwDu5OzkVFovwPu9s5Np8VtTf3QOyYIvWMC0cRff/0XEd0klgtZXU5xBX45loGfj5kLpcLAtWGUKNzfHb1jgjC4TQN0DvflxQFkVSwXsors4grEJ17CxqPp2Hsml4PwdibU2xVD24XirnahaN3QW3QcUgGWC9204goD1h++iJ8OX2ShqEjTQD3u+rtomgZ6iI5DdorlQjfswLlcfLcvFRuOpqOUV3epWuuGXrirXSiGtQtFA2830XHIjrBcqE5ySyqx+kAaVvyZiuTMYtFxyMa0Ggl9YoIwoVsT9IwO4PgMXRfLha7KZJKxMzkbK/afx6/HMlFp5MA8AREBeozrGoZRnRrD2503bVLtWC5UQ2F5FZbtPY///X4OF/LLRMchhXLVaXBXu1A80C2cFwFQDSwXsrhUUI7/7jqN7/aloqjCIDoO2ZH2jX0w4bYmGNYuFM5OXIOQWC4EIOlSEb7YkYJ1hy+iysgvB7p5IV6ueLhnU4ztGgZXHWcDcGQsFwf2e0oOvtyRgm0ns2y+vgmpW4CHM6bGNcWE25pA78JloxwRy8UBxSem47NtKTicViA6Cqmcj7sOk7pHYOLt4fB24+C/I2G5OJDdydl4K/4EjrBUyMY8XZ3wQLcmmNKjKfz0zqLjkA2wXBzA0bQCvBV/AruSs0VHIQfn7qzFA93C8VifSK49o3IsFxU7nVWMd39OwqbESxxTIUXx1ztjRr9ojOkSBictry5TI5aLCmUUluODX09i5Z9pDrccMNmXqCAP/N/g5rijebDoKGRlLBcVKa004OPfkvHN7jMor+Ld9GQ/ekQF4IUhLdCigZfoKGQlLBeViE9Mx6vrjuFiQbnoKEQ3RSMBozo1xn/ubIYgL1fRcegWsVzs3PmcUsz9KRFbk7JERyGyCndnLR7vE4WHezaFjuMxdovlYqcqDEZ8vu00FmxL5kqPpErNQzwxb2RbtG/sIzoK3QSWix3adSobc9Ym4nR2iegoRPVKIwETu0fgmQHN4O7MO/3tCcvFjmQWluPV9cew/ki66ChENtXI1w2vj2iDXs0CRUehOmK52ImfDl/ES2sSUVBWJToKkTAjOjTEnKEt4cu7/BWP5aJwBaVVeHFtItYdvig6CpEi+Oud8dLQlri7Q0PRUegaWC4KtutUNp5ZeRiXCnl5MdGV7mwZjLdGtuVRjEKxXBSovMqIeZtOYPHvZzltC9E1BHu54L1R7dEjOkB0FLoCy0VhjqYVYOb3CUjOLBYdhcguSBIw5fYIPDuwOVfBVBCWi0KYTDIWbEvGh1tOcTVIopvQKtQLn47tiPAAvegoBJaLIuSVVGL6d4ew8xSnxCe6FR4uTnh9RGsMb8/BftFYLoIdTSvAo98ewIX8MtFRiFTjvtjGeGV4K7jqtKKjOCyWi0Df70/FS2sTOX0LUT1oHuKJhQ/EorGfu+goDonlIkClwYS5P/2F5fvOi45CpGp+emcsGNcRtzX1Fx3F4bBcbCy9oAyPfnsQh1PzRUchcgg6rYSX72qFcV2biI7iUFguNrQnORtPLj+EnJJK0VGIHM6E25pg7rCWXFbZRlguNvK/38/i5XXHYOSyw0TCdI/0x4JxHeHjzrv66xvLpZ7Jsoy34pPw+fYU0VGICECYnzv++2AsooM9RUdRNZZLPao0mPDsqsNYk8BJJ4mUxMPFCR/e3x59WwSLjqJaLJd6UlRehUf+dwB7UnJERyGiWmg1Et68pw1GxzYWHUWVWC714FJBOSZ+sw8nLhWJjkJE1yBJwAuDW2BqXFPRUVSH5WJlJzOKMPHrfbhYwGnyiezFY70j8ezA5qJjqArLxYr+OJ2Dh5f8icJyg+goRHSDxnUNw2vDW0OjkURHUQWWi5VsOZ6BaUsPopJTuRDZraFtG+D9+9pDx3thbhnLxQriEy/hyeUHOVU+kQr0bBaIL8Z3gpszJ728FSyXW7T+yEXM+C4BBt4cSaQaHcN88M2kLvB204mOYrdYLrdgbcIFPP39Yd51T6RC7Rr7YOnUrvBwcRIdxS7xxOJN+unwRRYLkYodTs3H5EX7UVZpFB3FLrFcbsKGI+mYuSKBxUKkcvvO5OLh//2JCgML5kaxXG5QfGI6nvruEIuFyEHsPJWNx749iCojrwS9ESyXG7D1RCaeXH6Ig/dEDmbLiUzM+I5nK24Ey6WOElLz8dhSXm5M5Kg2HE3HrJWHwWug6oblUgdnskswZdF+lFXxvCuRI/vh0AW8sCZRdAy7wHK5jqyiCjz49T6uHklEAIBle89j3qYTomMoHsvlGkoqDJi8aD/O55aKjkJECvL59hR8t++86BiKxnK5iiqjCdOWHsTRCwWioxCRAr20NhG7k7NFx1AslstVPLf6CHaczBIdg4gUqsooY9q3B5CcyXWbasNyqcXb8Sfww8ELomMQkcIVlhswedGfyCmuEB1FcVguV/j+z1Qs2JYiOgYR2YnzuaV4+H8HeBf/FVgu/3IkLR8v8jJDIrpBB87lYdbKI7wH5l9YLn/LKa7Ao/87wMW+iOim/HT4It7/5aToGIrBcgFgNMl4cvkhrntPRLfko9+SsfFouugYisByAfBW/AnsSckRHYOIVOC5VUdwNrtEdAzhHL5c1h+5iC93nBYdg4hUoqjCgMeXHUS5g08X5dDlcjKjCM+uOiI6BhGpzF8XC/Hq+mOiYwjlsOt3FpZX4ZH/HUApV5mrN4aibORvW4Sy0wcgGyrg5NMA/oNnwKVBNABAlmUU7FqK4sObYaoogUvDFvC78zHo/Bpe832LDq5Hwd4fYCzJg3NQBPz6PQKX0BjL87lbFqIkcQsknSt8ej0Ij1Z9LM+VnNiFksQtCLp3bv180kR/W7b3PLpG+GF4+2t/PauVwx65PPP9YZzhedF6YywvxqVvnwU0Tgga9TIaTFkA3zumQOPqYdmmcO9qFB5YB78BjyNkwnuQdK7I/H4OZMPVJwktOb4Dub99BZ/bx6DBxA/hHBSBzO/nwFiSDwAoTd6LkuPbETT6Nfj2noTc+I9hLDVP4WOqKEH+jiXwu3NavX7uRJf93w9HkZxZLDqGEA5ZLiv2n8fPxzJEx1C1wj9WwckrAAFDZsAlNAY6nxC4RXSEzrcBAPNRS9Gfa+Hd7T64R98G56AIBAx9GobiXJSe/P3q77t/DTzbDYBH2/5wDgiD34DHIelcUHz0FwBAVU4qXBu3gUuDaOhb9oLk7A5DgfnfOm/rN/DsMBhOXkH1/xdABKCk0ojHlx5EmQOeIXG4cjmXU4JX1zn2uVBbKEveC+eQaGSteROpH4/DxW+moygh3vK8oSADxpI8uIW3tzymcdHDJTQGFRdrn85cNlah8lIyXJv88xpJ0sA1vD0qLphf4xwYgcpLyTCWF6PiUrL5dJxvKMrT/kJlRgo8Ow2rl8+X6GqSMorw0lrHuznbocZcjCYZM1ckoMQBf4qwtar8S6g6tBFene9GcLfRqEg/hbwtX0LS6uDRpi+MxXkAAI3ep9rrtO4+llNcVzKWFgKyCdpaXlOVkwYAcGvaCfpWvXFp8UxITs4IGDITGp0LcjcvgP+QmSg6tBFFB9dD6+YFvwFPwDmwibU/daIaVh1Iw+1R/hjRoZHoKDbjUOXy6dZkHDyfLzqGY5BluIREwbfXgwAA5+BIVGWfQ1HCRni06Vuvu/bpMQ4+PcZZPs7ftQyu4e0habQo+H0FQid/irLkfcjZMB8NJn5Yr1mILpu79i90jwxAsJer6Cg24TCnxQ6n5uOjLadEx3AYWg9f6ALCqj2m828MY2GW5XkAMF1xlGIsza9xZGJ5T3cvQNLUOLIxv8a31tdU5aSi5NhW+MSNR/n5o3Bt1Bpad2+4N49DZUYKTBVcCI5so7DcgOd/OCo6hs04RLmUVRoxc0UCDCZOKmcrLg1boio3rdpjVbkXLIPpTt7B0Op9UX4uwfK8qaIUFReT4BLavNb3lLQ6OIdEofzcYctjsmxC+dnDcGlY8zWyLCNn86fwvWMqNM5ugGyCbDL8vbO/f5c5lxzZzm8nMrHqQNr1N1QBhyiX1zcew2ledmxTXp2Ho+JiEgp+/x5VeRdRcmwbig/Hw6PjEACAJEnwjB2Ogj0rUHpqLyqzziJ7w3w4efjBvVk3y/tkfPd/KDyw7l/vezeKDm9G8dEtqMpORe7mBZCryuHRpl+NDMWHN0Pr5gX3qK4AAJeGLVB+7ggqLpxA4f610PmHVbs0msgWXl33Fy45wDyGkqzyOaK3nsjEpEX7RcdwSKXJ+5C/fTGq8i7CyTsYXp3vhmf7gZbnL99EWXQ4HqbyErg2alnjJsq0zybDo03famMohQfWoXDf5Zsom9a4iRIAjCV5SF/yH4SMfwdOnv6Wx/N3L0fRnz9B4+6NgCEza7yOyBb6xATim0ldRMeoV6oul9JKA/q9t52zHROR4rxzb1uMim0sOka9UfVpsQ9+PcViISJFenX9MVWfHlNtuZy4VIivd50RHYOIqFZF5QY8/4N6J85VZbnIsowXfkzk1WFEpGhbk7Kw7vBF0THqhSrLZcX+VBw4lyc6BhHRdb258bgq5x5TXbnkllRiXnztc1MRESnNxYJyLNiWLDqG1amuXN7YeBz5pVWiYxAR1dmXO04jNVdds0Woqlz2ns7B6oOOcfcrEalHhcGE11S2cqVqysVokvHS2kSo964dIlKzn49lYOepLNExrEY15bJifypOZjjmim9EpA6vrDsGg1Ed892polzKq4z4cMtJ0TGIiG5JcmYxFu05KzqGVaiiXP676wwyCitExyAiumUfbjmF7GL7/35m9+WSX1qJz7eniI5BRGQVReUGfPir/a89Zffl8slvySgqN4iOQURkNd/tP2/3lybbdblcyC/Dkj/OiY5BRGRVVUYZH9j50Ytdl8v8n0+i0qCOKyuIiP5tTcIFJGfa7xWwdlsuSZeK8OMh3jBJROpkNMl4/xf7vQrWbsvlnc0nwEmPiUjNNiamI+lSkegYN8Uuy+V4eiF+PZ4pOgYRUb2SZeCj3+xz7MUuy+ULXnpMRA5i09F0nMywv6MXuyuXtLxSrD+SLjoGEZFNmGTgoy32d/Rid+Xy1c4zXGGSiBzKxqPpOJNdIjrGDbGrcskrqcSK/amiYxAR2ZRJBhbtPiM6xg2xq3JZ/PtZlFWpbzlQIqLrWXUgDYXl9rMQot2US1mlEYtVMlsoEdGNKqk0YsU++zlzYzflsmL/eeRx+WIicmCLfz8Lo52MOdtFuRiMJizcaV/nG4mIrC0trww//3VJdIw6sYty+eVYBi7kl4mOQUQk3De7z4qOUCd2US7LeYUYEREAYN/ZXCReKBAd47oUXy5peaXYdSpLdAwiIsX4epfyhwkUXy7f70/lBJVERP+y/kg6MovKRce4JkWXi9EkY+UBTqtPRPRvlUYTfjx4QXSMa1J0uWw/mYn0AmW3MxGRCD+wXG7ecju6YYiIyJaSMooUPbCv2HLJLCzH1hNcs4WI6GpWH1TusIFiy2XlgTTOfkxEdA3rDl+EwWgSHaNWiiwXWZY5+zER0XVkF1di+0ll3qqhyHI5eD4f53NLRccgIlI8pQ7sK7Jc1h+5KDoCEZFd+OV4BgrKlDepr+LKRZZlbDpqHxOzERGJVmkwKfIHcsWVy/6zebhUyHtbiIjqas0h5Z0aU1y5bFBgAxMRKdmBc3nIKa4QHaMaRZWLLMuIt5O1CoiIlMIkA78p7L5ARZVLQmo+MgqV1b5ERPbg1+MZoiNUo6hy2fyXsv5yiIjsxc5T2agwGEXHsFBUudjL8p1EREpTWmnEnpQc0TEsFFMuyZlFOJ1dIjoGEZHd+vWYcs7+KKZctp/MFh2BiMiuKWlQXzHlsieZ5UJEdCvSC8oVMw2/IsrFYDRh75lc0TGIiOzeLwo5NaaIcjmclo/iCoPoGEREdm9bkjJOjSmiXHYnK+cKByIie5Z4sRAlCvhhXRHlsovjLUREVmE0yThwLk90DPHlUlZpRML5fNExiIhUY/9Z8WPYwstl39lcVCp0mU4iInukhAukhJfLbp4SIyKyqsOp+ag0iP2hXXi57ElhuRARWVOFwYQjaflCMwgtl/IqI06kF4mMQESkSqJPjQktl2PphTCYZJERiIhUSfSgvtByOZqmjGkKiIjU5sC5PJgE/vAutlwUMgcOEZHaFJUbkJQhbtiBRy5ERCp17GKhsH0LK5eySiOSs4pF7Z6ISPVOXHLAcjmWXgAjB/OJiOrNiUsOeFqMp8SIiOqXQ5bLEQ7mExHVq6yiCuQUVwjZt7ByUcpqaUREaibq6EVIuRhNMs5kl4jYNRGRQzmeLmZQX0i5XMgrQ5WRg/lERPUtyZGOXM7m8KiFiMgWHOq02DmWCxGRTZzMKBIyDYygI5dSEbslInI4FQYTsgRcMcYjFyIilUvLK7P5PnnkQkSkchfzHaBcTCYZ53NZLkREtuIQ5ZJeWC58bWciIkdywRHK5RxvniQisimHOHK5WFBu610SETm0C/m2/75r83LJLREziRoRkaO6kGf7cW6bl0tOSaWtd0lE5NAKyw0orjDYdJ+2P3IpZrkQEdmarcddbF4ueaUsFyIiW8u28V36PC1GROQAisrVflqM5UJEZHPqLxeOuRAR2VxReZVN92fTcqk0mFBk4ysWiIhI5UcuHMwnIhJD1Ucu+aW2/eSIiMissEzFRy4VBqMtd0dERH8rqlDxkUuV0fZLbRIRkcrHXKqMnGqfiEiEQpYLERFZW6ma5xYz8LQYEZEQRtm2339te58Lj1yIiIQwmVRcLjwtRkQkho27hafFiIgcgdHG7eJky53xtBjZs5lhp9HF5ZzoGEQ3RXL1AnCHzfZn03LhkQvZI1+dAd+H/4To1FWioxDdPJ8wAHNstjublouTVrLl7ohu2eDAbHzg9DGcU0+JjkJ0azQ2/XZv23Jx1WltuTuiW/J51F4MSP8cktG2K/gR1QvJtt9/bVoubiwXsgOR7mX4PngJ/NO2i45CZD3qPnKx+dpkRDdkWuOzeKb0A2jTM0VHIbIujYqPXHhajJRKrzVhedPNaJP6LSTwwhNSIcm2P9zztBg5vJ5++fjc/TO4px4VHYWo/midbbo7nhYjh/Z208MYlfUJpOwS0VGI6pebr013Z9NycXHikQspQwPXSqxquAINL2wSHYXINvQBNt2dbU+LObNcSLyxDdLxquF9OF1IEx2FyHbc/W26Ow7ok8PQaWQsjtyObmn/hSRzyW1yMO5+Nt2dTctF76yFk0aCwdbTc5LDa+9VjCU+C+GVul90FCIx3G17WsymI+ySJMHfw7ZXLBD9X/hJ/KB5Fl6ZLBZyYGo+LQYAgZ4uyCjkdBpU/3x1BqwMX4uo1NWioxCJp/ZyCfJ0BVBo692SgxkamI352o/gnJosOgqRMqj5ajEACPRwsfUuyYFIkozPI/fhTk44SVSd6o9cvFguVD+i9WX4LogTThLVIGkBVx+b7lLImAuRtU1rfBazSt6HJj1LdBQi5XHzATQqnlsMAIJYLmRF5gkn49EmdSknnCS6GhtfhgzwyIXsWE+/fHzhvgBuqYmioxApm43HWwBhV4sR3Zq3Iw9jVCYnnCSqE89gm+9SyJGLJAEyz2DQTWjoWoGVDVcg9EK86ChE9iOgmc13afM58F11WoR48eiFbty4Bhex3fMlFgvRjRJQLjY/cgGAcH890gvKReya7JBOI2NJ5HbcxgkniW6OIxy5AEBEoF7EbskOdfQuxsFG76Nb6pcsFqKbIWmAgGib71bIkUuEP8uFru/F8CRMyfsAUmaB6ChE9su7MaBzs/luxZRLAMuFrs5PV4VV4WvRNPUH0VGI7J+AU2KAoHKJCvIQsVuyA8OCsvCe5iM4p6aIjkKkDoExQnYrpFzC/NzhqtOgvMokYvekQJIk44vIveif/jkkY6XoOETq4UhHLhqNhKYBHjiWzqn3CWimL8PyoMXwT9shOgqR+ggqFyFXiwFAdDBPjRHwROOziHd5Dv7pLBaieuFIp8UAoFmwp6hdkwLotSZ813QTWqcu44STRPXFPQBw9xOya2Hl0qaht6hdk2C9/PPwuetnnHCSqL4JOiUGCCyX9mE+nGPMAb3bNAEjsz6FVMIJJ4nqXaADlouXqw5NA/RIyeI3GUfACSeJBGjQXtiuhQ3oA0CHMF+RuycbmRB6Ads9X2SxENlak9uF7VpoubRv7CNy91TPdBoZ30X/hlfzZsOp6ILoOESORR/omKfFAKBDmI/I3VM96uhdhMXeC+GZ+qfoKESOKew2obsXWi7NQ7zgptOirIqz3arJSxEnMDn3Q044SSSSwFNigOBy0WoktGnkjX1nckXGICvxd67CyrA1aJr2o+goRNSku9DdCx1zAYAOHHdRhWFBWfjd71UWC5ESuHgBwW2ERhB65AJw3MXeSZKMLyP/QL/0LzjhJJFSNO4KaMQeOwgvl64R/tBIgIk3U9qdZvoyfBe0CH5pO0VHIaJ/a9JNdALxp8V89c5o08hHdAy6QU+GnUG8y3PwS2exECmO4MF8QAFHLgDQKzoAh1PzRcegOtBrTVjRdBNaccJJImVycgVCO4pOIf7IBQB6xQSKjkB10NsvD3+GvInWqUtZLERK1TAWcHIWnUIZRy7tG/vCy9UJheUG0VHoKuZHHsKIzE8hlZaKjkJE1yL4EuTLFHHkotVIuD0qQHQMqkUj1wr8EbkI91x4B1IVi4VI8SLiRCcAoJByAYBezXhqTGkeCL2IbZ4vIuTCz6KjEFFduPsrYjAfUMhpMQDoyXJRDJ1GxreRW9El7RtIMqfmIbIbMYMBjVZ0CgAKKpdQHzdEB3ngVGax6CgOraN3EZZ4fwmP1AOioxDRjWp5t+gEFoo5LQbw1JhocyKOYzVmwSOTxUJkd1y9gaa9RKewUFS5DGgdIjqCQ/J3rsLW6O8xOf01SBWFouMQ0c1oNgjQ6kSnsFBUucQ28UWot6voGA7l7uBM/O73CiJS14iOQkS3ouVw0QmqUVS5SJKEoe1CRcdwCJIk47/Rv+P94mfhnH9adBwiuhXOHkDkHaJTVKOocgGAYW1ZLvWtuUcpDjT5DH1TP+ZMxkRqEH0noFPWWR/FlUubRt6ICNCLjqFaT4WdxkbdbPhd2iU6ChFZi8JOiQEKLBcAGNq2gegIqqN3MmJj9DrMzHwRmrJs0XGIyFqc3IDo/qJT1KDIcrmL4y5WdYd/Hg4Ev4mWqctFRyEia4vqCzgr72yPIsslOtgTMcGeomOowvzIQ/hv5Sy45hwTHYWI6oOCbpz8N0WWCwAMa8dTY7eCE04SOQAnN6DZANEpaqXYcrmrXUNIkugU9mliaBq2e7zACSeJ1K71SMDVS3SKWilmbrErhfm7o3ukP3Yn54iOYjdcNCb8L3IrOqd9A0k2iY5DRPWty1TRCa5KsUcuADC+axPREexGrHcRDjScjy6p/2WxEDmC0I5AaAfRKa5K0eXSv2Uwgr1cRMdQvLkRx7ESs+CRdVB0FCKylc7KPWoBFF4uTloN7u8cJjqGYgU6V2Fb1ApM4oSTRI7Fzdc83qJgii4XABjTJQxOGo7sX+nu4Ezs8X0F4WlrRUchIlvrMF5x071cSfHlEuLtir4tgkTHUAxJkvF19B68XzQLugJOOEnkeCQgdoroENel+HIBgPG3cWAfME84ebDJAtyR+gkkU5XoOEQkQlRfwC9CdIrrsoty6REVgHB/d9ExhJrx94STvpd2i45CRCIpfCD/MrsoF0mSMM5BL0u+POHkDE44SUTeYUC0Mu/Iv5JdlAsAjI5tDA8Xxd7zWS/u8M/DgaA3OOEkEZnFTgQ09vFt2z5SAvB212HcbY5zWfIHUQfx34pn4Jp7XHQUIlICrTPQ8UHRKerMbsoFAKb2aAoXJ7uKfMPC3MrxR9NvcHfau5AMZaLjEJFStBkN6ANEp6gzu/pOHejpgvs7NxYdo95MDE3DVv2LCLn4i+goRKQkGieg1yzRKW6IXZULADzSKxI6rbpuqnTRmLAy+lfMzZsNbfFF0XGISGnajwN8w0WnuCF2Vy6hPm64p0Mj0TGspotPIQ40fA+dU7/mhJNEVJPWGehpX0ctgB2WCwBM6x0JrQqmhHk54jhWyLPgkXVIdBQiUqoOEwAf+xsOsMtyCQ/QY0gb+12pMtC5CtujvsPE9NcgVRSJjkNESuXkCvR8RnSKm2KX5QIAj/eJssuVKu8JzsQe35fRJO0n0VGISOk6TQS8QkWnuCl2Wy4xIZ4Y0DJEdIw6M084uRvvFc2CruCM6DhEpHRObkCPp0WnuGl2Wy4A8OzAGLuYjr+FZcLJTznhJBHVTecpgGew6BQ3za7LpWmgB8Z2VfZd+zPDTmOD7jlOOElEdefsAfSYKTrFLbHrcgGAGf2awdNVeXOOeToZsCn6JzyV+SI0ZTmi4xCRPenykF3djV8buy8XP70zHusdJTpGNX39c7E/6A20SP1OdBQisjcuXkD36aJT3DK7LxcAmHR7OBr6uImOAQD4MPIAvqqYBdfcE6KjEJE9uu0xwN1PdIpbpopycdVp8ezAGKEZwtzKsbfp1xh+4T1OOElEN8enCdBjhugUVqGKcgGAu9qFol0jbyH7ntwwFVv1LyD44q9C9k9EKjH4HUCnjLMwt0o15SJJEl4Y0tKm+3TRmLCq2a94Kfd5aIvTbbpvIlKZ5kOBZvaxymRdqKZcAKBLhB8GtrLNjZWXJ5yMPc8JJ4noFun0wKC3RKewKlWVCwDMvatlvS+H/FrEX5xwkoisp/dswFs9s70DKiyXBt5u9Ta4H+RinnByQvrrnHCSiKwjqJX5CjGVUV25AMD4rk3QMczHqu85MjgDu33mcsJJIrIiCRg6H9Aq70bwW6XKctFoJMwb2dYqK1ZKkoxvonfj3aJnoSs4e+vhiIgu6zAOCLtNdIp6ocpyAYBmwZ54tFfkLb1HK88SHGryKfpwwkmygnm7KiC9UogZ8eWWx8oNMh7fUAb/t4vg8UYhRn5fiozia18gIssy5mwtR4P3iuD2eiH6LSnBqRyj5fkKg4wJP5bB681CNPu4GL+eNlR7/Tu7K/DkRt6LJZybH9D/NdEp6o1qywUAnrgjCk0D9Tf12v+EpWCd02z4XNpj5VTkiPZfMOKLA5VoG1z9v9zM+HKsO2nAylFu2D5Rj4tFMu75/trf+N/eXYmP9lbi8yGu2DtVD72zhAHflqLcIAMAvjxQhQMXjfh9ih4Pd9Jh7OoyyLL5uTN5Jiw8WIXX+7rWzydKddf/FVXciX81qi4XFyct3hzR5oYWFfN0MiA+ei2ezHyJE06SVRRXyhj3QxkWDnODr+s/X4wF5TL+e6gK8we44o4IJ3QK1eKb4a7Yk2rEH2mGWt9LlmV8sLcSL/Z0wfDmOrQN1mLJ3W64WCRjzQnza45nG3FXjBNaBWnxeGdnZJXKyC41l8u0DWV4q58LvFyUv1SFqjXual6+WMVUXS4A0LWpP+6Lrdv60/0DzBNONk9dUc+pyJE8vrEcQ6Kd0K9p9UHbA+lGVJlQ7fHmAVqEeUv4PdV45dsAAM7ky7hULFd7jberhK6NtJbXtAvWYtd5I8qqZGxOMaCBh4QAdwlLj1TB1UnCiBa6evgsqc60zsDQ92GXS+neAPVdolCL5we3wPaTWUgvKL/qNh9HHcDQS59CKr76NkQ36rvEKhxMN2L/QzVPz14qluGsBXxcq3+TCdZLuFQs1/p+l/4ejwnW1/KaEvNzkzvocCTDiJYLihHgLuH7UW7IKwfmbCvHtgf1ePG3cnyXWIVIPw2+vssNDb1U/zOmsvSdAwS3Ep2i3jlEuXi76fDeqHYY99+9kK/4PxvuVo7vGyxFUNoWMeFItVILTHgqvhy/THCHq5PtfkrVaSV8OqT6/FST1pZhehdnHLpkxJoTBhx+1ANv767A9PhyrB7tbrNsDi+iF9DtCdEpbMJhfmTpHhWAh+KaVntsSsNUbNG/gKCLLBayvgPpRmSWyOj4RQmcXi2E06uF2H7OiI/2VsLp1UIE6yVUGoH88uo/8WSUyAjxqL2MQjw0lm1qvEZf+3/nrWcM+CvTiCe6OGPbWSMGRztB7yxhdCsdtp2t/fQb1QM3X2DE56o/HXaZQxy5XPbMnTHYdSobKRn5WBb5KzqmLeG8YFRv+kY44ei06qfDJq0tQ/MALZ673RmNvTTQaYAtpw0Y2dI8DpKUbcT5AhndGmtrfc8IHwkhHhK2nDagfYh5m8IKGXvTjJgW61xj+3KDjMc3lmPpPW7QaiQYTbAcvVeZAKOp9tNvVA+GfQh4hYpOYTMOVS7OThp8NKY9gn+4F56pf4iOQyrn6SKhdVD1ktDrJPi7/fP4lA46PP1zOfzcJHi5SHhyUzm6NdLitkb/GuT/pBhv9nXBiBY6SJKEGV2d8f92ViDaX4MIHw1e2lqBUE8Jdzev+d/5te0VGBzthA4NzPu7PUyLWb+UY1IHHT7ZV4nbwxzqW4A47ccDLYeLTmFTDveVFRXkCXQeA6xjuZB47w90hWZzOUZ+X4oKIzAg0gkLhlS/ByUpx4SCin+OMJ693RklVTIeXleO/HIZPcK0iB9fc1wnMdOI748ZkPDIP0dP97Z0wrazToj7pgQx/hosG8nxlnrnH626GY/rQpLlK4e4HcSqKUDiKtEpiEjNnFyBqVuAkNaik9icwwzo1zDsA8Cv6XU3IyK6aQPnOWSxAI5cLi6ewKhFgNZFdBIiUqPW9wKxk0SnEMZxywUAGrQD7lTvxHFEJIhfpPnsiANz7HIBgK6PAG1GiU5BRGrh5GY+K+LiKTqJUCwXABj+qXkiOSKiWyKZb5Rs0FZ0EOFYLgDg5ALcvwzwaSI6CRHZs35zgVZ3i06hCCyXy/QBwLiVgIu36CREZI86PgD0mCk6hWKwXP4tMAYYvQjQONy9pUR0KyJ6AUPeF51CUVguV4q8Axj8rugURGQvAmKA0UsALX8o/TeWS21iJznMtNhEdAv0gcC47wE3H9FJFIflcjX9XwNiBotOQURK5eQK3L8c8A0XnUSRWC5Xo9EAI78CQnhJIRFd6e9Ljht3Fh1EsVgu1+KsB8auADwbiE5CRErS9yWg1QjRKRSN5XI9XqHAmO8AXc010InIAXUYD8T9R3QKxWO51EVoe/M9MCwYIsfWbCAw9APRKewCy6Wuwm83XxXCgiFyTM0GAaP/B2h1opPYBZbLjQjv8XfBcPU+IofSbJD5XhYnZ9FJ7AbL5UaF9wDGsmCIHEbMYBbLTWC53IyIOPNVZCwYInWLGQyMWsxiuQksl5sV0dN8FZmTm+gkRFQfYobwiOUWsFxuRdNewFgWDJHqxAwBRi/m4P0tYLncqqa9gTHLWTBEatF8KIvFClgu1hDZBxizzDzXEBHZr+ZDzUsUs1huGcvFWiLvMB/B8D4YIvvEYrEqSZZlWXQIVUk/DCy7DyhKF52EiOqq44PAkPlck8WKWC71oeCCuWAyjopOQkTXImmAfq8At08XnUR1WC71paIYWDUJOPWz6CREVBudO3DPQqDFUNFJVInlUp9MRmDTc8D+haKTENG/eTYwj5GGdhCdRLVYLrbw+wLg5xcA2SQ6CRGFtAHGrAC8G4pOomosF1s5sRFYPRWoKhGdhMhxNRsIjPwv4OIhOonqsVxs6WKCeaC/+JLoJESOp+s0YMAb5iXMqd6xXGytIO3vK8kSRSchcgySFhj0FtDlIdFJHArLRYSKImD1Q8DJTaKTEKmbs6f5xsjofqKTOByWi0h/fAb8MgcwVopOQqQ+DdoB934D+EeKTuKQWC6ipR8GVk0GcpJFJyFSCQno9jjQdy6nyxeI5aIEFcXAxlnA4WWikxDZN30QMOIzIIqnwURjuSjJke+B9U8DlUWikxDZn6h+wN2fAR5BopMQWC7Kk5MCrJ4CXDwkOgmRfdA6A33nAN2eACRJdBr6G8tFiYxVwK8vA79/CoD/PERX5RcJ3Ps1ENpedBK6AstFyU79AqyZBpRkiU5CpDztxwGD3ubd9grFclG6ogxgzaNAym+ikxApg4sXMPR9oM29opPQNbBc7MWR74HNLwAlmaKTEIkTM8R8t71PY9FJ6DpYLvakLB/Y8gpwYBFnWCbH4hMGDHoHiBkoOgnVEcvFHqX9CayfAVziSpekclpnoPuTQM9ZgM5NdBq6ASwXe2UyAnu/ALa+wftiSJ3C48zr2gc2E52EbgLLxd4VXjSvdnn8J9FJiKxDHwQMeB1oO1p0EroFLBe1OPkzsPEZIP+c6CREN0fSALFTgL4vAa7eotPQLWK5qElVGbD9bWDPx4CpSnQaoroL7WC+vJhr2qsGy0WN8s4C294CjqwAZKPoNERX5x0G9HwG6DCBK0SqDMtFzbJPAdvmAX/9wEuXSVm8GgJxTwMdHuC0+CrFcnEEGceAbW8Ax9eDc5WRUB4h5lLpNBFwchGdhuoRy8WRpB8GfnsdOLVZdBJyNPpAoMdMIHYy71dxECwXR5S6H9j6/4DT20QnIbVz9we6Twe6PAw4u4tOQzbEcnFkZ3cDv/0/4Pwe0UlIbdx8zeurdH2UsxY7KJYLAae3m+/2PxnPq8vo1niEAJ2nmEvF1Ut0GhKI5UL/yE8F/vwaOLgEKM0WnYbsSXicuVSaDwO0TqLTkAKwXKgmQwXw1xpg/0Igbb/oNKRULt5Au/vNpRIYIzoNKQzLha7tYgKw/yvg6CrAUCY6DSlBSBvzNC1tRwPOetFpSKFYLlQ3ZXnAoaXmosk7IzoN2ZrWBWh1N9B5KtC4i+g0ZAdYLnRjZBlI3gIc+AY49QtgrBCdiOqTbzjQaZJ5eha9v+g0ZEdYLnTzyguAExuAxNXme2ZMBtGJyBq8GpmPUlrdAzTqJDoN2SmWC1lHaS5wbK25aM7t4SXN9sYzFGg5HGh9D9CoMyBJohORnWO5kPWV5AAnN5nnMju9FTCUi05EtfGPBpoPBmKGmMdRWChkRSwXql+VJeYxmhMbzHOaleWJTuS4JI35qCRmMNB8CBAQLToRqRjLhWzHZAIyjppPm53bDZz7nTdr1idJAwS3AsK6A026AU16AB6BolORg2C5kFhZSX8XzR7zr8ILohPZL60L0LAjENYNaNLdfKqLywWTICwXUpa8s/86stkD5J4WnUi5XLyAxl2BsNvMZdKwE9dIIcVguZCyFWUAFw+aj3CyT/7ze0Wh6GQ2JAHejc1jJAHNgMBmQMNYILg1lwYmxWK5kH0qTAeyk4Csk3///nfpFGeITnbznNwA/6h/SuTy7/5RXAuF7A7LhdSlLN9cMtkngaJ082XRpdlAaQ5Qkm2+H6c028aXR0vmsQ93f8Dd7+/f/c1rnng1/KdIfMJ4OTCpBsuFHFNFsblwSv8unJK/C6gsFzBdvgH07/8alv8iV36Mfz7WaP8pDje/6kXi5mt+nsiBsFyIiMjqOBpIRLfk7NmzkCQJCQkJV91m27ZtkCQJ+fn5NstFYrFciOiaJk6cCEmSLL/8/f0xcOBAHDlyBADQuHFjpKeno3Xr1oKTkpKwXIjougYOHIj09HSkp6djy5YtcHJywtChQwEAWq0WISEhcHLi8sb0D5YLEV2Xi4sLQkJCEBISgvbt22P27NlITU1FVlZWrafFNm7ciGbNmsHNzQ19+vTB2bNna7znrl27EBcXBzc3NzRu3BjTp09HSUmJ5fnw8HC88cYbmDx5Mjw9PREWFoYvv/zSBp8tWQPLhYhuSHFxMb799ltERUXB37/mAmKpqam45557MGzYMCQkJGDq1KmYPXt2tW1SUlIwcOBAjBw5EkeOHMGKFSuwa9cuPPHEE9W2e++99xAbG4tDhw7hsccew7Rp05CUlFSvnx9ZiUxEdA0PPvigrNVqZb1eL+v1ehmA3KBBA/nAgQOyLMvymTNnZADyoUOHZFmW5eeff15u2bJltfd47rnnZAByXl6eLMuyPGXKFPnhhx+uts3OnTtljUYjl5WVybIsy02aNJHHjx9ved5kMslBQUHyZ599Vk+fKVkTj1yI6Lr69OmDhIQEJCQkYN++fRgwYAAGDRqEc+fO1dj2+PHj6Nq1a7XHunXrVu3jw4cPY9GiRfDw8LD8GjBgAEwmE86cOWPZrm3btpY/S5KEkJAQZGZmWvmzo/rAETgiui69Xo+oqCjLx1999RW8vb2xcOFCTJ069Ybfr7i4GI888gimT59e47mwsDDLn3U6XbXnJEmCyWS64f2R7bFciOiGSZIEjUaDsrKyGs+1aNECP/30U7XH/vjjj2ofd+zYEceOHatWWKQuPC1GRNdVUVGBS5cu4dKlSzh+/DiefPJJFBcXY9iwYTW2ffTRR3Hq1CnMmjULSUlJWLZsGRYtWlRtm+eeew579uzBE088gYSEBJw6dQpr166tMaBP9ovlQkTXFR8fjwYNGqBBgwbo2rUr9u/fj5UrV6J37941tg0LC8Pq1auxZs0atGvXDp9//jneeOONatu0bdsW27dvx8mTJxEXF4cOHTpgzpw5CA0NtdFnRPWNc4sREZHV8ciFiIisjuVCRERWx3IhIiKrY7kQEZHVsVyIiMjqWC5ERGR1LBciIrI6lgsREVkdy4WIiKyO5UJERFbHciEiIqtjuRARkdWxXIiIyOr+P2mujr+4DqaCAAAAAElFTkSuQmCC",
      "text/plain": [
       "<Figure size 500x500 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Define the keywords to search for\n",
    "keyword1 = \"Trump\"\n",
    "keyword2 = \"Biden\"\n",
    "\n",
    "# Count the occurrences of the keywords in the \"Message\" column\n",
    "keyword1_counts = df[df['Message'].str.contains(keyword1, case=False)]['Page Name'].value_counts()\n",
    "keyword2_counts = df[df['Message'].str.contains(keyword2, case=False)]['Page Name'].value_counts()\n",
    "\n",
    "# Print the keyword occurrences\n",
    "print(f\"The keyword '{keyword1}' appears {keyword1_counts.sum()} times in the 'Message' column.\")\n",
    "print(f\"The keyword '{keyword2}' appears {keyword2_counts.sum()} times in the 'Message' column.\")\n",
    "print(f\"The breakdown by page is:\")\n",
    "print(f\"{keyword1} occurrences:\\n{keyword1_counts}\")\n",
    "print(f\"{keyword2} occurrences:\\n{keyword2_counts}\")\n",
    "\n",
    "# Plot the keyword occurrences as a pie chart\n",
    "labels = [keyword1, keyword2]\n",
    "sizes = [keyword1_counts.sum(), keyword2_counts.sum()]\n",
    "\n",
    "plt.figure(figsize=(5, 5))\n",
    "plt.pie(sizes, labels=labels, autopct='%1.1f%%')\n",
    "plt.title('Keyword Occurrences')\n",
    "plt.axis('equal')  # Equal aspect ratio ensures that pie is circular.\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8d55b8ee-6019-40e4-8fbb-c36a1923634b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.8"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}