Initial EDA.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "episodes = pd.read_csv(\"episodes.csv\")\n",
    "podcasts = pd.read_csv(\"podcasts.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## cleaning\n",
    "____________________\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "episodes.drop(episodes[episodes[\"audio_length\"] < 1].index, inplace = True)\n",
    "episodes.drop(episodes[episodes[\"audio_length\"] > 10_800].index, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((855696, 7), (121175, 9))"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "episodes.shape, podcasts.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uuid</th>\n",
       "      <th>title</th>\n",
       "      <th>image</th>\n",
       "      <th>description</th>\n",
       "      <th>language</th>\n",
       "      <th>categories</th>\n",
       "      <th>website</th>\n",
       "      <th>author</th>\n",
       "      <th>itunes_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>8d62d3880db2425b890b986e58aca393</td>\n",
       "      <td>Ecommerce Conversations, by Practical Ecommerce</td>\n",
       "      <td>http://is4.mzstatic.com/image/thumb/Music6/v4/...</td>\n",
       "      <td>Listen in as the Practical Ecommerce editorial...</td>\n",
       "      <td>English</td>\n",
       "      <td>Technology</td>\n",
       "      <td>http://www.practicalecommerce.com</td>\n",
       "      <td>Practical Ecommerce</td>\n",
       "      <td>874457373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>cbbefd691915468c90f87ab2f00473f9</td>\n",
       "      <td>Eat Sleep Code Podcast</td>\n",
       "      <td>http://is4.mzstatic.com/image/thumb/Music71/v4...</td>\n",
       "      <td>On the show we’ll be talking to passionate peo...</td>\n",
       "      <td>English</td>\n",
       "      <td>Tech News | Technology</td>\n",
       "      <td>http://developer.telerik.com/</td>\n",
       "      <td>Telerik</td>\n",
       "      <td>1015556393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>73626ad1edb74dbb8112cd159bda86cf</td>\n",
       "      <td>SoundtrackAlley</td>\n",
       "      <td>http://is5.mzstatic.com/image/thumb/Music71/v4...</td>\n",
       "      <td>A podcast about soundtracks and movies from my...</td>\n",
       "      <td>English</td>\n",
       "      <td>Podcasting | Technology</td>\n",
       "      <td>https://soundtrackalley.podbean.com</td>\n",
       "      <td>Randy Andrews</td>\n",
       "      <td>1158188937</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               uuid  \\\n",
       "0  8d62d3880db2425b890b986e58aca393   \n",
       "1  cbbefd691915468c90f87ab2f00473f9   \n",
       "2  73626ad1edb74dbb8112cd159bda86cf   \n",
       "\n",
       "                                             title  \\\n",
       "0  Ecommerce Conversations, by Practical Ecommerce   \n",
       "1                           Eat Sleep Code Podcast   \n",
       "2                                  SoundtrackAlley   \n",
       "\n",
       "                                               image  \\\n",
       "0  http://is4.mzstatic.com/image/thumb/Music6/v4/...   \n",
       "1  http://is4.mzstatic.com/image/thumb/Music71/v4...   \n",
       "2  http://is5.mzstatic.com/image/thumb/Music71/v4...   \n",
       "\n",
       "                                         description language  \\\n",
       "0  Listen in as the Practical Ecommerce editorial...  English   \n",
       "1  On the show we’ll be talking to passionate peo...  English   \n",
       "2  A podcast about soundtracks and movies from my...  English   \n",
       "\n",
       "                categories                              website  \\\n",
       "0               Technology    http://www.practicalecommerce.com   \n",
       "1   Tech News | Technology        http://developer.telerik.com/   \n",
       "2  Podcasting | Technology  https://soundtrackalley.podbean.com   \n",
       "\n",
       "                author   itunes_id  \n",
       "0  Practical Ecommerce   874457373  \n",
       "1              Telerik  1015556393  \n",
       "2        Randy Andrews  1158188937  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "podcasts.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>audio</th>\n",
       "      <th>audio_length</th>\n",
       "      <th>description</th>\n",
       "      <th>pub_date</th>\n",
       "      <th>uuid</th>\n",
       "      <th>podcast_uuid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Piątek - 01 grudnia</td>\n",
       "      <td>https://cdneu.modlitwawdrodze.pl/prayers/MWD_2...</td>\n",
       "      <td>490</td>\n",
       "      <td>święci męczennicy jezuiccy Edmund Campion SJ, ...</td>\n",
       "      <td>2017-12-01 00:00:00+00</td>\n",
       "      <td>fd5d891411174c7ca953c1f54657c3eb</td>\n",
       "      <td>811c18cf575841b3bef4601978f17ca9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Sobota - 02 grudnia</td>\n",
       "      <td>https://cdneu.modlitwawdrodze.pl/prayers/MWD_2...</td>\n",
       "      <td>481</td>\n",
       "      <td>bł. Rafał Chyliński, prezbiter, Łk 21, 34-36</td>\n",
       "      <td>2017-12-02 00:00:00+00</td>\n",
       "      <td>5c28fa0a27b342cd92ff03c16a8019c2</td>\n",
       "      <td>811c18cf575841b3bef4601978f17ca9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Niedziela - 03 grudnia</td>\n",
       "      <td>https://cdneu.modlitwawdrodze.pl/prayers/MWD_2...</td>\n",
       "      <td>667</td>\n",
       "      <td>Pierwsza Niedziela Adwentu, Mk 13, 33-37</td>\n",
       "      <td>2017-12-03 00:00:00+00</td>\n",
       "      <td>efdc9f4f07fa4c4883f8848256066cec</td>\n",
       "      <td>811c18cf575841b3bef4601978f17ca9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    title                                              audio  \\\n",
       "0     Piątek - 01 grudnia  https://cdneu.modlitwawdrodze.pl/prayers/MWD_2...   \n",
       "1     Sobota - 02 grudnia  https://cdneu.modlitwawdrodze.pl/prayers/MWD_2...   \n",
       "2  Niedziela - 03 grudnia  https://cdneu.modlitwawdrodze.pl/prayers/MWD_2...   \n",
       "\n",
       "   audio_length                                        description  \\\n",
       "0           490  święci męczennicy jezuiccy Edmund Campion SJ, ...   \n",
       "1           481       bł. Rafał Chyliński, prezbiter, Łk 21, 34-36   \n",
       "2           667           Pierwsza Niedziela Adwentu, Mk 13, 33-37   \n",
       "\n",
       "                 pub_date                              uuid  \\\n",
       "0  2017-12-01 00:00:00+00  fd5d891411174c7ca953c1f54657c3eb   \n",
       "1  2017-12-02 00:00:00+00  5c28fa0a27b342cd92ff03c16a8019c2   \n",
       "2  2017-12-03 00:00:00+00  efdc9f4f07fa4c4883f8848256066cec   \n",
       "\n",
       "                       podcast_uuid  \n",
       "0  811c18cf575841b3bef4601978f17ca9  \n",
       "1  811c18cf575841b3bef4601978f17ca9  \n",
       "2  811c18cf575841b3bef4601978f17ca9  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "episodes.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# genre_counts = pd.DataFrame(podcasts[\"categories\"].value_counts().sort_index())\n",
    "\n",
    "# genre_counts.columns = [\"cat_count\"]\n",
    "# top_15_genres = genre_counts.sort_values(\"cat_count\", ascending=False).head(15)\n",
    "# plt.barh(top_15_genres.index, \n",
    "#          top_15_genres['cat_count'])"
   ]
  },
  {
   "attachments": {
    "image.png": {
     "image/png": "iVBORw0KGgoAAAANSUhEUgAAAhcAAAD8CAYAAADExYYgAAAgAElEQVR4Ae2dCfxuU9n3f+c9j+mYKjORJIkmU0U9jcqQklIpyZCekoReiTxPUo8MSRLiTSJjolSUEiqUOEhFIZoMGUORkryf7znXOtZ/n733ve/7f8/37/p8/va09tprffft7Gtfa+3rJ9lMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMYJIJzJjkzrvvk0tgqaWWenzVVVedXADuuQmYgAl0QOCqq666R9IyrU79j1YFfNwExpEAjsXs2bPHsWvukwmYgAn0jMCMGTP+0KTy/9OkkMuYgAmYgAmYgAmYQFMCdi6aknI5EzABEzABEzCBRgTsXDTC5EImYAImYAImYAJNCdi5aErK5UzABEzABEzABBoRsHPRCJMLmYAJmIAJmIAJNCVg56IpKZczARMwARMwARNoRMDORSNMLmQCJmACJmACJtCUgJ2LpqRczgRMwARMwARMoBEBJ9FqhMmFxo3AL297QKvuc97Qdev3B79u6NrkBpmACZhAuwQcuWiXmMubgAmYgAmYgAnUErBzUYun5weXk3SapFskXSXpp5K26vlVW19gaUkXS/qFpCskLVZzyt8Kx3aQdFRhX3HzRElbF3dKqjv3JyXlvcsETMAETGAICdi5GNxNQTTuHEk/lrSapPUkbSPpqYNr0rwr7xLtep6kN0r657wjg1vZaHCX9pVNwARMwATaIWDnoh1a3S37qnhoH5tViyDM52Mbyc5LJF0df+nh+gpJP5J0pqQbJR0saduIMPxS0jPifFTrzpZ0Zfy9JPa/XNLP4+8aSYtn10+rOBPJybl9Gs7F0yRdGBEQlqukC0jaOPpHH7bI9q8s6XxJN0jaP9ufR0g+HH0isnJAlFlUEpMorpX0K0lvy871qgmYgAmYQB8JeEJnH2EXLrV2OA2F3fM275L0GkmPSHqmpNMlrR9Hny/p2ZLuiyGV4yW9UNLuknaTtIekz0n6rKRL46H+vThnL0m7Sroshjuov2g3S9o3HuC581Msx/Yi4aikY0+R9K3YYHjkK5JOkrSTpCMjEsJhnCccHZwhhmBWj3Pox3MkPRzXx2HI5UtfGzwoR/SHa70sJIBxhNKMyCVTg7w0ARMwARPoLwE7F/3lXXe1oyW9NKIEG0haIOYuvEDSY5LWyE4mGnFHbOMIfD/WiVy8MtaJDKyVnbNERClwKg6XdKqkr0u6NSvD6kqS9pP0rIgE3B0REKIEtO/BQvm/S6KNyZg3kZygDSW9KQ6cLOnQVCgiL/+WdFM4SGvGsQsk3RvrtI9rFp0LHAyiLhjzQXC+iPIcJukQSefGdhSZt/gvSfzpsYcfmLfTKyZgAiZgAt0lYOeiuzzbqe06SW/OTiCawETK9CDdU9KdkohSMHyVRxj+kZ3HAzpts57uKefwcOfhnxvDKEQDNpd0eQxP/CYrwPAJQwtcmygAwxlMPP19iWORndZo9fGsVL7O7rSdlqlocZtoxUGSjksFsiXzVugXx3G4PpEdY/X/xZ9mzlqyWG+hqDdNwARMwAQ6JeA5F52Sm/55F0laWBKTJ5PNSiuSCOsTncBh2E7SzOxYk1Uerh/ICqboAsMQRDh4w8eRSRGDVJQIBdGPFcPBwMkhqsJXLe0aX3gwSRVjXghDNMneEk4T7WFCK3MsMIaCGFphuIXJpERacmN4hyGW9AULkZZlo70MpZwSEYx185O8bgImYAIm0D8C6S23f1f0lRIB3px5eDIvYm9JDD88JOkjUeCYGI7gIcycBI61Yx8MpwBngfvMVynvi/kYOA8MtVwv6buFSoliMCzCQ/zRcDBwEIh4MLmUCZhNjTacIIkJmPRvx+xEnAkmphIVoV0pMoMDwhAKczBwaFIkJ52K08R8Ez7bxZjo+c4o/+lwxmh37rRFUS9MwARMwAT6QYAQs80EJo7Agsuv/vgK2x8xdP12hs6huyVukAmYQEZgxowZ5GRK8+qyI1NXHbmYysNbE0LguSstqdlOtT0hd9vdNAET6DcBz7noN3FfzwRMwARMwATGnICdizG/we6eCZiACZiACfSbgIdF+k3c1xsKAsOqiprgeO5FIuGlCZjAKBJw5GIU79r4txnxNr6mKX4mm3r+JEnvTxtemoAJmIAJDBcBOxfDdT/cmrkE3h45MVKOjJwL+T7sXOREvG4CJmACQ0bAzsWQ3RA3Z05yLLKEvjtLwIVYG7k+yHtBAjBybpB8CwE2clusEHk82Ea07D/N0QRMwARMYHAEPOdicOx95XICJBZDFZVkXQizpUybSdDsdyF6hrhZyjr6fyPp14GRyTTPdFp+Fe81ARMwARPoGQFHLnqG1hV3SIAhkTPiXJZsY1dIwrEoM4TcyP75cUnPlfTXskIhWkbGz9kWLqsg5N0mYAIm0AUCjlx0AaKr6BqBpSS9KiTXmdDJ/AqW32mR/pzU5siuI7RG6nCGSpB6L5qFy4pEvG0CJmACPSDgyEUPoLrKjglsHU7B02LoY+WIViC7nhuRicWzHZS/S9IXJX0pG0rJinjVBEzABEygXwQcuegXaV+nCQGGQJismdvZIUJ2c7bz3lBLZfImwmssEUdDsAwhs3dlZb1qAiZgAibQZwJ2LvoM3JerJcBXIUU7UhJ/RXtHYcdJhW1vmoAJmIAJDIiAnYsBgfdlB0vAwmWD5e+rm4AJjDcBz7kY7/vr3pmACZiACZhA3wnYueg7cl/QBEzABEzABMabgIdFxvv+uncVBIZduKys2RYzK6PifSZgAsNIwJGLYbwrbpMJmIAJmIAJjDCB6TgX+0m6TtIvQuPhRV3iwBcDG7VZ1zMjgyNt+UHNuatK+nu09/rIqbBATfleHiJ19ebZBd4gaZ9sezqrP4w8EcU6yGB5W/Sfzze5Zju2UPBFw+Nt7ZxYUXZFSWdVHJvObvq//nQq8LkmYAImYAKdE+h0WGRDSVtEsqJ/SFpa0oKdN2PembQH54JcBT+Zt7f1Cg/lL0j6sqSntyhOvgQe7GR/vEDSWyWd2uKcVodp979aFSocpw08AMk+iX0r/mKzZ4vPSjpM0rMlXSJpWUn/zq5W15d1JOGMJU2P7LSOVm+XROIsmwmYgAmYwBgR6DRygQrlPZJwLDDWeVBgv5d0SEQS0INYPfaTRfHCiHSwXCX2nyjp8FC9/Kqk90naM96uUbd8SyRJujaUL+O0KYt/Snpq7KnSn5hygqTHoo0rxQGcDdJGo1NBBOS92Ql7hxonbUhJnng7/pSkH0naXdIykkj4xPn8oeyJIbiFo3RNLJ8Vjtgn4u0/RQF2kHRUnFPHipwP1HfLNB/Mvw6HCMcwvwfcu6dIOic4XC7peeGEnBKOBW1GlXS96P9VIRzG7wL7oCQiQ3BMOiEvj3vKubAgwyaRJCIo2MLhHKJ6yvFXxn64fD3EzG6SdGjsZ4FDiVYIEbQDsv1eNQETMAETGCCBTiMX35f0sVCuZBgCp4CHbLIH46FKpsQjIsrBgxO9B5Id7RSJkVDAxNaQtHE88AndE7ng7RrjYbNJhPOfFPuKC6IRRC94KJ1bPFixzcOMoRwcAwyJ7wckbSCJ8P9lkujnmpJoJ2UfjgdvnCLaw0MTQw6cqMCl4Th9L6IDvwndCyIb9BGH5M3Bj8jFB+J8HqLJ6ljxACcdNu0i2tHpsAL9IWJxd1w0vwefD5b0G60P7hvRip0l7RX3kwgGOh5bRh0Mk6BKyr3lXhBBwvlM94zzdg2ui0l6JHU2lhzDEB6jb7CnTRjXJmpCfTdIon1/ksTQHMqpOIY4rDhBODRV9l8hXiYLl1Uh8n4TMAETmD6BTp0LHv68tRJZ4A0T54IHCm/A2OnZkgcuxlDKm2Kdh1L+Bvq1cCzi8JQFD3nqPTPeYKccjKEZ5i7w8OGBxMPmp5JwOHi7RvgqN/bx9sw8DR7M6WH02ng4pTD9klEGh4DhFhwLjPqT0e9klFsrbUhaIt7OqQeHiuvRliZzPOpYEVHAKSAysFx2vaarRIXeGcqhOASJT34PcF5wgLCLJCEoRj9yIwKD7DlDSxgP+DtiHaYMNdFW/jDuIxEq9hOJuDX2pwXXxGnAcMj+kDkXOA44fhj9JrKDc8GQFg4Dv2OcLvin+xnFpywsXDYFhzdMwARMoDcEOnUuaA3DCgwN8Ed0YfvMuUgPLMrl63kv8v0P5QcK6wyT8JaN4iVOAW+xaEsk46GOKiYPm63ibf7YmMuQXyOVT3MueBjRdiY1EgGYIWm3CO+nsiw3relD3m6GmHAKmDCaGw/Mi6NtDANwzXYt70caiqIO2tyupTkXxfPyvpTVm7eBcynDcAR9Lhr3CpVS2P6PpLVjOOm8mMTKUAv3LY9elF0z1Zv3md8dv1siI0RDiDT9JX57RKNsJmACJmACAybQ6ZwL3lp5E0/GA583zWTpSwKWRBEw5glsE+vbxvBBbE5ZFBUviTT8LIYRmNuBUmZuDIUQmufNmjde5k18RhLzA+qMt2yiLftGIYYxdskiC4TkF41oCKH+WVGO+QhlRtQkDXFwHCYY7eILDSwf+ij2M4rMWTRllZ/TzXWcNe4RxgRbuDPUlRvDE8wzSc4FERmcCH5T3CMcKuaqMCzCMAj3ESeUOR3Mk2DoI7f8mrBnTg7XqDIiQzhERDSI4GxWVdD7TcAETMAE+kug08gFDwveyHlwMJfgt2ksO5rPnAUcAh40KF1iTPI7IdQrGeffMfYXF9+O4QocBiIJhPFxZHizJTzOpMrcCMvjSPA2zNAFEzqpm6EUhm3SnIL8nLROyJ45HpQ7PiYYXh3X4jzmHJwfjgIPRCaO8nXHR1MF2ZL+HR1hebjysCTqwvAPwyIfiiGGdAoPX5wbojEHpZ2xbMqqcFrXNmHCUBBDDDAlKlU0WDCExARTHCj6zPyaG+N+sI97RqTkfkmfjCE0Ig8MbaBmmiaAUvcxkog44YDwm8IRyyMWxevzO8CxJHrC5FaGXWwmYAImYAJDQKAuFN1p8/hahImKvO3aBkOAoRceztwLWwmBBZdf/fEVtscXGh1zhs7RuVduqQmMK4EZM2bwdWDLPEKdRi7GlZv7NSEErIo6ITfa3TQBExgIgV44F0xatA2WAENCDEXYTMAETMAETKDvBHoxLNL3TviCJtAugVEcFinro4dKyqh4nwmYQK8INB0W6fRrkV612/WagAmYgAmYgAmMOIHpOBfM+udLB9I3k4ApfarZFAlpvUlBzVcT3TDSaZM7oZvGZ5hVGT+rJkuiucJXDHzNwFcReRrx6bSN4aZ3tFkBX+3wRQxfYNCm1WrOpz+U4wsRsq2SqGoQxhdI788u3Ctxs+wSXjUBEzABE+gmgek4FySLIpcDWRr5LJHPLnNjyKWuftJt8xBJGhL5uZ2sk468ThG1kzrbPYdcD2SBfL2k50fW0E6SZhWvy9yYTpwLMliSB4KU2qTxzrOLFq/BNveCFNq0+b/LCrS5r5M5PUXnwuJmbUJ3cRMwARMYNIG6h387bUNdE4EyHoBEI8hZQL4IkimR54I3YiIcJFDCcARI90xeA5JeVYmGkQeBfBEpQkI+CsoyYZH6qJc8GBj7UuruV8ebOsfJrcEbPMbbOQJXtI1jKZFTmbhYnNLWAjEuHqgpg2jSwqAS2kd/YUUuCCIcWJ1gFxEh8n6QoAvBNPoPC/pMwiqE4dgm2pAnNYuq5zh9CLPh6JHFsukkTxKfJUE36iJdeLrWcXEP2E/2UlgSpSEHCUaODBws2owmSdW9JVcK56R7QV4TjH6mFO38NvhNTUfcLKr1wgRMwARMoF8EOnmzLLaNOsiOSLIpjOydJLEiKkFIG4cCHRIebjxwSEzFEAZv0qRvJjkV+hBlomFokZA5E0EsHlIMvRAt4cFHxATjTTc3HtY8yHEweIjzgCPzZkpqQP6NdaN9XB8xripxsbzeJutEBkglTrZSHpwMqaCzkiTNeVAidMbDk+EgHLI6wS6yXxJJoF6GaGhvckpIYva50OpA7h4+RSO5FOxJ0kXCrqaG05A0QZBmJ9MqKq+PhuNI9k6SYH0x0nyTuCzPXMo1cR6JblXd25SuncyfKLOSBA12tJN7mzKcwixZHSvKl4mbpXO9NAETMAET6BOB6UQuFom3ZpyDP0r6UrSZBysPCgzdB0LsZLsk6yKiVWhOFA3RMBRUeQsnsydCWbyJXxmOCm/DhPZJmc0Dk7kDPFx5CBbTUuPc8LDDscDIjplfE9EsjEQg6cFFNkmiBLwhk1GSqECnhrOCY8ObPs4AkZNkiK/haCAdTj+InPAQRsgNKwp2kX20aiiD6AKZQj8S8yOKmibcH5ws+sKDd4+4BhlGq/qHw3NXzF1B5RWjLzgL3AvuD9vwf3FElZLEfd5OnITUnqp7SzQFhViiLgxn4TC2EmKrY4Uzh4OKXkkSN4suzFvg6PB7nW1V1HlMvGICJmACXScwnchFmnNRbFQrAaxiebZ50JSJhnEMxwAhLB7AhMmJRDCfARl23mSZV4D2RzLqqrOUUjoJYFGW1NQ8WBE+w+GY7jwJhlz4o808fJOmSFH8i+269uYsi33i4Y8jBhuiOzg1KJgmwxnDqWPOAgqnPMC5HpEeHr5lxpwLrolTQnSJlOW0DwctabCk8xAlK/YnHcvbXXVvYYI2CY4LERGGrFoJj9WxSveVNuT3NrWJpVVRcxpeNwETMIEeEZhO5KJJk3j4MQxA2JuwPfMv+BKhaFWiYXyxwJs04XciIwxnUBftPjsUN9mXG2//OAgMOWDbVVwzDs9ZVImL5WWarDOPgOGLZEQMckE3vpCh7QyL8PaPMFdTwa6i0BnnE/1A24NIAcMnuREdITJClIKHPRNocc4oW+UUcD5OI1EOIkkMdRARYC7LslE5+7gvRE64t6iTYvmwSOyas6i6tzDn3uJY4NSkr1OK/czrasoqP8frJmACJmACfSYwnchFk6aiPMobL1EB3joJyX+z5MQq0TAe1B+OB9Df4oFH+BxRreQYFd+oCYsz54NhDvpHOJ+JlHVWJS5Wd07ZMfqIEiiTHnlI81BPUQvK40zgXBH+5+sa2tpUsIvhA4aWmDxJZIG3fCZa8nD+c0Qa8jYxxwXBMaIntIshA+ZKMP+ChzTKq1XGfWOuCJEhojp8OcJ8GZhzPfYz9MUwA8NM7MdReE1JhVX3liEyJqsyTMFwC04hxmRYRMgYomJeB2JwyZqySuW9NAETMAETGACBujDzAJozUpckjJ/mbDRpOA4BEzzPalLYZXpLwBk6e8vXtZuACYwngaYZOnsduRhPuu7VyBOwcNnI30J3wARMYIgJ2Lno/OakT1ub1pAPjzQ9x+VMwARMwARMYOQIpHkLI9fwIWhwu87FEDTZTTABEzABEzCB3hNw5KL3jH2FISTwy9se0Kr7nDeELeusSVZH7YybzzIBE+gNAUcuesN1HGpNwnR8ycFfWYbPOmG3ThlQ50bZyXxVw2exNhMwARMwgREh4MjFiNyoATSzKklar5uCc8Fnx+lT2VafEfe6Pa7fBEzABEygTQKOXLQJzMXnpFwnJ8WlktB+SUaKdtKdJyNPRfpUl8gDeTrI0ZFSnaMcS5I1pODJHkruD8oTqUCYjWgJQm15vSQlI78GdX1D0pPjYmRURcOGlOukfec8mwmYgAmYwIAI2LkYEPgRuGzSjknDIoiXkbiLbKk4BjzAl2/QDzKE7hdCdaRt3z3OwTlBnwSxsTMi+Ri5Q4hUoO+CI4GCbG6kfkdLhWykpFffPztIFA51W7KL5vuzIl41ARMwARPoBwEPi/SD8mheo2xYhAc+WimkFsdOiSydsVm6QP2WxGGo0WJJ4Oypkr4qaQVJqLomAbQoNt+CdOHooqT08eidkIU1WZkgXTqWlmQU5U8WLktIvDQBEzCB7hNw5KL7TMe9xipdElKT57+nJEJGFtiyc1C1PSrUbt/bQLSsFdckXFYlWsb5CJetz9/MWfgqNhMwARMwgV4QyB8GvajfdY4XAeZaIFSG8BqGEF0yhjSSiBzLJGiG8BnKtUtFwSRwlovFoYGSrEq4DG0U9FLSfIomgnSpTi9NwARMwAT6SMDORR9hj9ilinMuDg6hNYYVSBDBnIlc8RWVWhwH5mjsEhMr6fJ1kg6M4QwmdB4eHJioybAG8yrSkAmHEDPbKpvQmWPDCUHZlQmdDNEgC28zARMwARMYMgIWLhuyG+Lm9IfAuAiXJVpOopVIeGkCJtBLAhYu6yVd1z3yBCxcNvK30B0wARMYYgIeFhnim+OmmYAJmIAJmMAoErBzMYp3zW02ARMwARMwgSEm4DwXQ3xz3LTeERg34bJekPI8jl5QdZ0mMBkEHLmYjPvsXpqACZiACZhA3wjYuegb6rG5UFJL5bPSqwsKpu100mqn7dByWRMwARMYIQIeFhmhmzUkTc3Tgm8i6SBJL++gbVY77QCaTzEBEzCBUSDgyMUo3KXhbeMSkTWTFiKVfm7WVFJ77xDbJOC6PpJfHRb7crXTKlXTmZE068o4lzThGHokP45EW6ivkrWTsidKYhtRM5RVbSZgAiZgAgMg4MjFAKCP+CVT5k60Q3jII0xWZ2TtJOPmmqExgvhYmfFbRNV081A13VjSuyWR9nsDSQtJukzS90Pq/XuR+ROnYlZk7FxJ0nOi8rLrWLisjLz3mYAJmECXCdi56DLQCaguHxbZUBIy6OmBXtb9ByNt+PGRNjyPbuTly1RNXxvy6ltHQfRInimJSMYJkhaQdE5EMG6RtJokBNFIT44TUjSEy/jTzFlLlompFct72wRMwARMoAMCHhbpAJpPmUfgp5KWlrSMpCpVVPYTkUB75I2Szp939tSVMlVT0tPvFlEJtEQQQ8NpYEjkZZJuk3SypHfF8MzzJTHEsqsknBmbCZiACZjAAAg4cjEA6GN0SYY6GJa4N0TM1orhC4ZMXh3iZovFsMV3JF0u6bdt9J+hD0TQLpL0qKQ1wqHAocGx+KKkRUONlfr/GU7MzTH/oo1LuagJmIAJmEC3CNi56BbJyaknzbmgx0QWUCrl89Q/STozJl7eJOmaQLK4pG9KwuGgfDsTLYk+rBqfvHLu3RH9YPLoh8Ph+FtELphv8WVJKRq37+TcEvfUBEzABIaLAP9g20xg4giMmypqL26gM3T2gqrrNIHRJmBV1NG+f259jwlYFbXHgF29CZjARBNIIeSJhuDOm4AJmIAJmIAJdI+A51x0j6VrGiECFi4b/pvlYZnhv0duoQlUEXDkooqM95uACZiACZiACXREwM5Fe9iSaBcppr8tqSwLZLFGvmbAVpR0VqzXLfikskm9dXWkY++RdIOk6yS9P+0sWT4r8kP8XNKvU6KpknL5rp/kG4X1dIwvPd5RONbuJnkr1o+TEhv41PWn3Wu4vAmYgAmYQBcJ2LloD2bKTklGyvsiWVPTGm6XlDJN1p1D+uv76wo0PMaQ14GROpv28mCusiMlfTaSVT07slxWlU37N0or2ZKcF1g61g3nIqqcs0hs7FzkVLxuAiZgAkNGwM5F5zeE7JTkVkhG3oUksHVA2pktedAS8cDQwkg5Ib4q6WfZ2/nvI+sl5T4U53DeHnNPnZP3gegCCaSISJCxktwTZYaDsVRoelBvlaERcmt2EOEvDOExclSQVZMIyP6xn0WKyJBz4mJJp4VgWH4MwTJExYiIkN+C+hA0S0YqcM7HviBpdvSpjB9lEhvqfUbU++nI0rnl3Grm/PdUSW/Itr1qAiZgAibQRwJ2LjqDzRs6GSi/FaejgYHmBWmuSVO9XqSnrqqdkP5fQjfjk1G+WJY6dpT0IkkvlsQQxzpRiGsdLWntiHK8uXiyJByLX4T2BuJhdUbUgiyY3w0nIB+WoU/bRr/ekjlBeX2U2U8SGTpz20fSJXEu16gzzmf443kh4c6yyqiXLJywxqkj2RasMPRHiJzURWqiqBcmYAImYAK9IGDnoj2qKTsl6a55YF8Qp+Nc8EdWyqtDARQHoMpeKumMOEhUAiegaJT5hqSHIkqAsBdRAOx38dbO+lWRxXLukSf+e1C80X8m5ocQLXlrSJg/UWruGpktGQ75WkQSSNONCilGH+kvQ0K0gXYV7YpoU3F/O9u0DXYwxGkqOip1df1I0uqSlpX09kgBjqZJ0VBFJToy+7GHEVu1mYAJmIAJ9IKAP0Vtj2qac8HbMSF9BLKYr0CmUx7mxzWsrklm1LoySeSLyzHJtGxYZBNJn4uhBB66OA44KgwjlBlzQlAa5Q+HJymdFtVDi9vURb1NrErcDEGyvWJ+CBGdEyNdeJM6UxkEzIiwbCNpp7SzsLQqagGIN03ABEygFwQcueiMKq+9H4wHIrLfCGzxQEOkC2MuBg/0Krs0oggc5w39uSUFUf5ERZSIA+JcW8UQQ0nR0l1EAFALxQ6XhMYHEQEiHUXbNOTL2b98zNNAGAx7TURpcGBoz2Wxv8nir3HdVJY5Ewxl8LtbOYaROLZEOChwXU7SZumEimWxXorhkKR5KcxFsZmACZiACQyIgCMXnYPn4X1tvCnz1sywApM8MSY7vlPSXbFdXBwj6aQYDqEehkWKcXqGCHhgMuSAMa+AskwMbWI8aImk8KAl4sIQC0M1zH3YvVABQzpEOR6J/cxj+HOs4wjRP4YdmLTJsEJTo19EK+BEX46I4RMmjBIdoY8Yx+kbbb2lgQPDMA1ODnUwT4T23hmf0Z4TdXphAiZgAiYwIAJ1ofcBNWkiLsuEUCIePMz56uHCkBNHMnyYjK87mGT5gWFqVEVbiPDgtKxb4qjNd4qFy+ZDMnQ7nKFz6G6JG2QCsnDZcP8IeBDy+SYOBg7eLpKGzbEYboJTW7dxzBVh+KcYAVFPjUEAACAASURBVJpaMrYsXFaKxTtNwARMoCsEPCzSFYxtV8KcgZR1su2T+3gCQxn8Dbv9QNIqw95It88ETMAEJoWAJ3ROyp12P03ABEzABEygTwQcuegTaF9muAhYFXW47segWuN5HYMi7+uOOwFHLrp/h8k0yVcPfClB2msybHbDSJOdNDua1sfXIXxtQlsYOqgyvkDhixLae72kr2Sfplad06v9fKqKhkgy0niTkdNmAiZgAiYwIgQcuejujdpQ0hbxxQKJrpaWtGAXLsF9wrngE9ekONqkWh7KaHaQgZNEVXWW0mnzJQtZOcmYiUbHdIx2l2XKrKsT54L5KCl9NynWU5r1uvN8zARMwARMYEgIOHLR3RuBANg9klIGTdbJfImRQOqQiCQQTSBvBPa0+BSV6AKfpKaJiUyk5OsHvipB3Ox9oftBdIE04Oh8kOeBHBEk3CozvkB5ahwgZXgTI+Mn7UuibDgbZPVMomzvzSrZOz7/pA2IiWFIpH9KEim5yaexTKTj5nz+XhLl0CPBUSK/BUtk33HEPiHpbRFFYZmLndWxIlMq9ZAno4n6bDTDCxMwARMwgW4TcOSiu0RRKP2YpBtjGAKngIdssgcjKyWZM0koRZQDlVCGIUiqRZZPHpJkwsTWkMRnljzwPx6Ri8PiGDkdSPFNJs1caCwOz1kQjSB6wQOcdOVNbOEYykmJtt4dn3duEHojJK+in2tGOxn2eTiyeKb6ac/LY4PEWyTuIhkXjhPZTEk49psQdyOyQR9xSBBgg1+eWwPnIlkdKxw7dE9oF5GOs9JJXpqACZiACfSXgCMX3eXNsAVqpghk3R0Rh/zheHpcjiVDKBhLHsAYmTBzYTD0QHAsyoyHPNEN1FKJLhSNZFLMXUBJlcgD8zXIqcGbfVnytCRhTvbLP8Y8DeokeyfOEBETpOGRcGcuBw4Bwy04Fth9sWSBU5WMcjgFnM9Dn1TfpCJHn4X+EX3B+SA1eSurY0Vmzn/HnBFSiJeZhcvKqHifCZiACXSZgCMXXQYazgBDA/wRXdg+yxWRi37l63kr8v11gmAMkxA1eF08uJmrgGOQjIc6wyV/Cl0SHuzHxlyG/BqpfJpzQQSAtjORknNwRHaLiEMqyxI9krJ6OJa3GwcWp4AJo7l9PoZ80ExhQinXbNfy66ehKOooc57Yb+Gydgm7vAmYgAl0QMCRiw6g1ZzCvIFcap0H/h+y8swhwFgmHRLmCaDkiaHqyfBBmRXFuog0EElgGIG5HQiB5cZQyJYRIWAIgugF8uun5IVK1u+IoZR94xjDGGQQJZsoxlANQmoMjTCMQ7ZRDAn6MqNcnj4cJhiRiySOlkd3iv2M4nMWTVnl53jdBEzABEygzwTsXHQXOKqozJ3gc04maKJ4ylyJZAuFQ8B8hj1jJ+qqO0b57UpExdK5344IRJrQibOQBMCIUDCpMje++MCRuDyUUJmfwXUYSmGSZZ0xxIDTwMRRBNPoDyJjDGEghkbE6/yIbCBkRpuQTC8z+sccCnhQDxEX7NCQqWd4Jx/WYQIr3KgzOWNxyhwl2iasUnkvTcAETMAEBkCgKnw8gKaM/SX5WoSHLFEG24AJWLhswDdgSC7vJFpDciPcjJEhYOGykblVbuggCFi4bBDUfU0TMIFJIeAJnf2700xatJmACZiACZjA2BPwnIuxv8XuoAmYgAmYgAn0l4AjF/3l7asNCQELlw3JjRjTZngux5jeWHerMQFHLhqjckETMAETMAETMIEmBOxcNKE0uWXIxsknofz9OfJSpG0+bc1tD0nH5DtiHfE2Pi/lU1Q0S/hct8rIRprqZ8k8Fb6wISU6luuMxC4vTMAETMAEho2Ah0WG7Y4MV3vI+JmSXuXaJoiXkfiLBFvJ2P5w2siWJOAiD8f+klaUhJhalZHFM10vleETXnJp2EzABEzABEaEgCMXI3KjhqyZiIIhukZSMIwIA45DWXbRXJkVhdg65yKqm7JAar5MdI1kYMjJExVBLwWhtBMk/TpLtz6lIm+YgAmYgAn0h4Cdi/5wHrerENFgiAN9EYyoBWJludZHHBKaJaidpsycaX/ZcpFsWOQbZQUK+54s6VWR7ZQMpkkA7bklERBOtXBZAaA3TcAETKAXBOxc9ILqZNSJsmvSRGGZFF/z3q8kaT9JaK7sHE4Gx5l/gTpq0dKwCEMjCJq1MhwKHBrSoN8ZS5RRr4toSvF8hMuYw7H+zFlIm9hMwARMwAR6QcBzLnpBdTLqRH/kcElIuxNxQHukaC8JzRMe/Ki3XigJOXTmUTxYLNzBdlJCxaFI61TDtn/bHQD1KSZgAibQDQKOXHSD4mTW8beQSWeeQ1nUAipEKF4Z8zFwMBBrO1rSaZOJzL02ARMwgckg4Le7ybjPveolTsXXs+GR4nWQemdYhK9KHo2hC4ZQDo5Ix43FE7xtAiZgAiYw+gSsijr699A96ICAVVE7gOZTGhNwhs7GqFxwxAhYFXXEbpib218CVkXtL29fzQRMYLIIeM7FZN1v99YETMAETMAEek7Acy56jtgXGEYCFi4bxrviNvWDgIds+kHZ13Dkwr8BEzABEzABEzCBrhKwc9FVnB1XxhcVJH7i000Eu17UQU25wFfV6SSn2rzqYM3+10u6XtKvJB1YU45Dm4UWCGm4+VrksBblSR1OvVin7YvTvTABEzABExgGAh4WGfxd2DB0OkhGRSIoVEQX7KBZiHu1Evji4Y0T8p026z9C0saSfifp6TXnPkfSUZEwC8eC3xcpt5taJ+3jiyf+SJxlMwETMAETGAICjlwM/iasIOmeLMMk6wh8Ya+WdE2ktSZZVRIK20DSTyL7JRofi0vKBb4WDRGvK+P8LcNh+YSkt0V0hOVNkpaJa/Fb+G04N7Fr3iIXH8PBqLK9I7KBY4H9K5NhR2hs69jPgiRcueFQFduHEuteWSEiHEQ6+CMygsQ7mUFXlvRaST+N7a+1kHbPqvSqCZiACZhAtwnYueg20fbr+348HEkoxcMSdU9s4VD3xAlAiIsoAPLlPIQRCdtd0vMjooAmR24Ms1wkCSeEDJmflrSApI/FuUQIqOMUSdvGiUQmrg1HJ6+L3wgPcpybuqgF5xC5uCo/uY11HJhi++pOR6/kK5LWkfSQpP8OFkSAiOB8qO5kHzMBEzABE+gdATsXvWPbtGbe4NeL4YO746G/Q4h9ESVIWSxPkvSy2H+HJKISGBodRAhy4y1+n4hQ/DAclVXyArGOw/CuWN9J0pdLyuwW80FwbBAKI9LxQklEBwZpf5B0eTTgxZLWknRZ9Hl7SU8raZxVUUugeJcJmIAJdJuA51x0m2hn9T0WOh04Aih88nBkYmeZMb+gTNo8L0sZZM5vyHeWTBT9U6TkRracSaQpipGftomkQ6N9DFucF3LrRD6KxqRUHCUiIEXDAUrOLO1rMq8kP4f6iOYkI1qRjPoukPT2tKNiiSoqf5o5a8lWDCuq8G4TMAETMIFWBNI/9q3K+XjvCBDef2ZWPUMWvJUzb4G5BavHse0k/Sj2rxhDHhxivkXRSUTLg4gDD12MoQPsr1E+Nucsjo/hkTMl4eQUjTkf7wzHgDLM03hHOBnFsgy/fFTSGnGA31cankAJFccDYw4IwzRFK7aPcxjmwFhWDcsQwUCBNbGalbUhTvfCBEzABEygXwTsXPSLdPV1FpPEkAefevIpKuF9JjI+ImnHGH4gmsHXEMdKYm4C8zA+HxEC3tjzN3qu9Ml4eFMfkyDZxi6O+omKUAf2rZj8WDYkwnE+PcVJoR7mU6BuelwomxZ/P1xvj1BJZZ4G5zBhFftizCdhAipRkjzyEEXma9/Zkp4SURyGZdIQUSqflgwnMZSEkBptwNlYMx300gRMwARMoL8E0pttf6/qqw0TAT5N/ayk/xymRvW6LRYu6zVh1z+sBJyhc1jvzGi0y8Jlo3GfBt1KJn0SESibazHotvX0+hYu6yleV24CJjDhBIph7QnHMXHdPzi+qrh04nruDpuACZiACfSMgJ2LnqF1xSZgAiZgAiYwmQSKXxlMJgX3euIIWBV14m65O1wg4LkXBSDe7CoBRy66irMvlZGf4TPZlUiPzdclvTZSj58TeTj4PHW1mgvyCSlfuJDvggyky9eU5RDl0VTBSGuO8Rkun7wmayLMlsp6aQImYAImMEACdi4GCL/DSyNu9qbsYdxhNW2f9lZJD0QqcpJu3deiBtKOk56cVNzkvmhqG0XBonNBPR9sWonLmYAJmIAJDI6AnYvBse/0ymStJMvkniUVkJqb3BCkBuePxFIYUYQnRb6Ke7OU3yeHHsfakXWT/BfkiciTekUVc/JrrBR1/EXS/elAi+WPs+RWZNCkLeS/OKTivCRoxmRTPo+lTfQ1F2YjNwh5OaiL9pKNdGZosVA3+8v4VFzSu03ABEzABLpJwM5FN2n2r66j4/PRJQuX/FzkrECwjAcu2TcxNDdwNHAibslyWqDJQcKp90ni3CR5fmucly84jwybB+U7G6xvEQ97soriUBD14Dq08Y015/OZ7CVRljwcuf1PFkV5Xoi0USfOD+JpCL1VJQXL6/G6CZiACZhADwjYuegB1D5UiVgZiqDFYQKUTY+Kt30yby4R6b55SCN6xt8X4uHLg5ihDSIFSJUzdPGR+DS1qLK6SEQFcE54iJOFE/tOOCyxOWVBNlCiDrQBhwRnAu0UsmkSfTk12jPlpIYb9BMHKxmRFJwf5oGQuXTTEHRLx9PSwmWJhJcmYAIm0EMCdi56CLfHVR8h6d2SFs2uw/3cMByA9CaPXgdDEwwx8Jce8FtHZIDTT5P0Bkk4FeiSEF3IjUgATsHtEREhdTiS7wy1kLa8zJhzQRtQXWUIpZvZYKmrKDyGg8EcD/q3axa1ydvGcBITQ9efOasY9MmLed0ETMAETGA6BOxcTIfeYM8l6oCQGA5GMr7M+EDaiIc7m6if8jUGcyl4wydpFl+ZENHAeONn/5GhNcJQQ26IlaHVQeQCTRCuiUgZ0ZHiQz4/L1//WWiL0A7mRzD/AiG2KiuKmOXliv18cvSP3zNzThg2SYJn+XleNwETMAET6AMBOxd9gNzDS/BJavqEk8swTMKbOZMciSgwlyIZD/ck/IVTwbBIysxJJIKJkAxj4EQw5JIbUQFk4JkAymeox8Scj50lpa878vJl63dI2jfE0/hE9WpJ3ywrGPvoA8MnlC1OzvxfSTgUtJnjREnoD1EL+nBiXKumeh8yARMwARPoFYFuhqp71UbXawJdJ2Dhsq4jdYUjRsBJtEbshg1Jcy1cNiQ3ws0YTgIWLhvO++JWmYAJjAcBD4uMx310L0zABEzABExgaAjYuRiaW+GGmIAJmIAJmMB4ELBw2XjcR/eiTQIWLmsTmItPHAHPyZi4W97VDjty0VWcrswETMAETMAETMDOhX8D0yWA4ukZkm6Oz1/J2rnGdCtteH6uptrwFBczARMwARPoNQE7F70mPN718ynzNyK/xDMkrRVpxJcb7267dyZgAiZgAnUE7FzU0fGxVgRIXvWopGOzgiSxIjkXGTyTQilJujCUTcnKSWZREnqhfLptKLKiZIqDglWpuy4lieycJPI6Lksp/slIRx6n68AS3ZV0zEsTMAETMIEeE7Bz0WPAY149CqRXlfTxTZF6HK0PRMZwNFaIcuxDlwS9ku1iCOWFoQWyW5SpUnfdPxyXdSL1+CpR/kuRQZRNftPbhDBaHPbCBEzABEygnwT8tUg/aU/OtV4q6XRJj0m6M6IVqKKi5nqlJFKBY8zTIBKBEbkgEoLhkDDEkiypu6LqiuOCnSeJtOQYcy/ulYTTwZAMkQ22i4YqKn967OEHise8bQImYAIm0CUCdi66BHJCq7lOEuqqRatLK/+PrPC/JaVt1tPvkegD6q5F6XdOrRJKO17SDpKYYHpCdo18FVVU/jRz1pJV9eTlvW4CJmACJtABAQ+LdADNp8wjcJGkhSS9Z94eiQgFEQXmWaB+yvwJIg5XZGVarRZVT5Fux5COZ44GtlmIl8XmnImlm2ru9ZGNt5mACZiACQyIQHpTHNDlfdkRJ8Db/1aSjpC0j6RHYohiD0mLhWIpZfaW9OdQXG3SZdRdjw51V36jOBUovB4Qwy0oqjIx9I9ZZf8MxdX7YzgmO+RVEzABEzCBfhKoC1/3sx2+lglMlwBROJyOt0i6qVVlVkVtRcjHJ52AM3RO+i+gvP9WRS3n4r3jSYDJn+dGzo2WjgUIrIo6nj8E98oETGA4CHhYZDjug1sxPQLXS1ptelX4bBMwARMwgW4R8ITObpF0PSZgAiZgAiZgAnMIOHLhH8JEErAq6kTednd6Agh4rshw3GRHLobjPkxKK/hy5OSsszi3d8d8iWx341VyW+TJthqf6IImYAImYAK9I+DIRe/Yuub5CTwkiZThi0SCrNdIum3+Yo337Ny4pAuagAmYgAn0jYAjF31D7QsFge9Kel2svz3yViQ4H5e0V9oI4bNVJS0a6b6vjX1JCO2HktaP8iTQ4lNUylyY1eFVEzABEzCBPhOwc9Fn4L6czghhsYUlPU/SzxowwXG4XRKiZ0Q+zi+cQxbQL0p6c5Qh14XNBEzABExgQATsXAwI/ARf9heSiEYQtfhOQw6ImiFmdoik/5RUVB17cWTx/F3Ud19FvYiWzebPwmUVhLzbBEzABLpAwM5FFyC6irYJfEvSYYUhESr5V0impwqJbmA3SlovlFMPkvSx2J8WZJptIkSGaBnDKOvPnLVkOtdLEzABEzCBLhOwc9FloK6uEQFUSz8RzkJ+AtLp68YOlk+P9RUlPSzplHBKUpl07k8lvTwr/5R0wEsTMAETMIH+E/DXIv1n7itKt0r6XAmIsyW9S9LPJV0ZEQuKPVfSpyUhy/6opF0K5/I5K0MeX4/Ix12S+BLFZgImYAImMAACdi4GAH2CL4lSatH44oM/7O+SXhvr+YKIRpmM+iuyQnyFwp/NBEzABExgwATsXAz4BvjygyFg4bLBcPdVTcAEJoOA51xMxn12L03ABEzABEygbwTsXPQNtS9kAiZgAiZgApNBwMMik3Gf3csCAQuXFYB40wRMoJKAxdAq0VQecOSiEo0PmIAJmIAJmIAJdEKgiXOxvDQnZfPNkq6PrIprSGKm/rkNL0pOAzIsVtkbC+qWrcpX1cN+kiQdGQVo40Z1hUuOcc6JJfvZ9Vh8JvkrSd+W9KSKcvnuv8UGuRrOyg9UrJO1skm9FadP2f0eSTdIuk7S+6ccmbrxrPhig09Afy2JZFOt7Cc1BdIxMnG+o6Zck0O5fkhiA5+6/jSp12VMwARMwAR6RKCVc0Hmw2/Eg+cZ4QB8VNJybbRnZmRU/EHNOUXnggyMdeVrqpqT3vmDUaAT56Kubj6VfEHoW5Biete6woVjaGNsXdhXtrm5pPvLDrS5jyGvAyVtEO2tS7WNM/bZ6NuzJX2+wbXKnDbuNZaOdcO5iCrnLBIbOxc5Fa+bgAmYwJARaOVcvDKSFh2btZu320tim7wFvI3/RtKpknBGMPIS4CBcKgkRKSIB6cF6cERA0JggBTQPojdEkiTqxonJy1MPCZWIFvBGna7BGy1aE1dEsiU0J7AUUeHB9j5Je0a0geNoTywQ5ZaIdqbt2N14QVbIlbLSH4520q8Dsv1plfbQB2yWpDMlUfarId6V1D1ht3SU+1Ccw3l7xD7qIbqAUBcRie+HhHkcnrLAwVgqUmNTb5WtoLmJrdJxtDywHSR9M4TCiIDsH/tZpIgMvC+WdFqWcTMd417DnfvKfaC+o7I6iHxxPvaF0P2gT2X8KJPYUC+/E+oludbJkracW82c//Jb5DdlMwETMAETGACBVs4FCpRX1bRrnXjorSVpNUkvyco+IumlMaSSdpOWeStJa4ci5v9KIoSO1gQPZ6ICDL/kxsMovX0vImmL7CAPzxdGG/IHH0V4EOEUpTdyHCIckiT3vY0kMkKS8bFd4w391dFuziXx0zOjLfQBHYyX1VRKSP8vweCTUb5YnDp2lPQiSQhzMcQBb4xrHR0ciXKgBlo02OC8nCOpVTpsGF0USahwAvJhGfhuG/cGRzE5Qfn1KLNfYWiL4/uEIwoTrlFnnE/dKKWSyptllVEvvxPq5XdzfLCiPKIhOKxlkRoLl1UR9X4TMAET6CKBVs5Fq0sRNSCVM2mZeYvkrToZb+RFe1ASTgcPgzeFXkSxTHGb6Amy3LxNvyoeqKkM6Z4xHKD82rF7vkX+EOLB/eX5StTvwLmhn/fGA/uCKI5zwd81kq6WtGY4AFW15U4XUQmcgKJRhiGphyJKQF9TdIYIDO3AqvqOwBdv9J+J+SFES94ab/px6rwFHBgO+VpEEi6XtFAcpY/0lyEh2kC7isbvICmSFo813aZtsIMhzicOa1P7kaTVJS0baqs4jYigFc3CZUUi3jYBEzCBHhBo5VwQouYNusr+kR1gsiNvy8l4KBaNf/B5y+Uff+ZZnF8sUNhGFfOYGFJBX4KhgKSUSdF0/eK1C9XM27wsnBDejIk+pGGKeQVarKQ5F0+TtGA254KhGh7mvEnzx4PuSzV1paGdmiLzhn/KyqR+c6yq75tIulDSV8JJwXFgaIrhmDJjTgiCYgwvcJ+IWmFFtdHiNmXK7vXcs6f+t0r1FIGyvSIaRMTivMJ9nlpL+RaOFBGWTpzG8hq91wRMwARMoCMCrZwLQuW8wRKST8YQBQ/nTow5GoStCVkzh4AHMfZXSYvHer5IjsQ9kjg3zdvIy9Stl9XLw/b0DqIW+XUekMSkUR6IzNlA92KnaCPlmIvBW3SVMReFN3WMN3Qcp6L9OBwwIg6LxnBSmutSLFu2TQQAETDs8OBLRKBsmGvTbC4KXwcxT+O2OBcBMIZViNrgEOKgNbUif4aquOf87lYOR5O6mP+CgwJXJgtv1uICxXopzjydNC8Fp9hmAiZgAiYwIAKtnAveUpkjwQOGMW7+0f64JN5yOzEcCCbxMQxAKJvxfeyMGDvngchEvWTMJyBawZAIcweY2NmO8bko7WcIIQ0pMNnvyeFgtFNXsSxtvVYSczeYVMmERiZ50lYmuZY5S6kOojHLBIePxJIHa24MEfDAZMiBYSGGdLhmU0vOG/eMOnCA4Fc294EhHaI49IdyzGP4c1wIR4ioAAyJOM1u2oDoF9EK6uVe45gwfAIjJvPSR4zj9I22Ej1p5cAwTEMZ2syETuzOmOja7lBXnO6FCZiACZhAtwg0Cc9361rDUg/RD0L/21U0iK8X+KqBv14ZQzJEPJh/gjPF8AW5Q/7Zqwt2WC8MmGT5gQ7P7+dpRHhwWtaNCEjttRdcfvXHV9j+iNoyPmgCJmACEHCGzid+BzNmzCD6XTax/4lChTkSUw6M6Qb5Gwi5ky9hkMaDkM83cTBw8HYZQsdikHzavTYJ2oh4MPxTjACV1mVV1FIs3mkCJmACXSEwiZGLVuD46oR5AQzD2MaUwHrrrff47NntjPCMKQh3ywRMwATaIODIRRuwCkWZdMifbYwJWLhsjG+uu2YCJlBJoF9DPK0mdFY20AdMwARMwARMwARMoIxAE+fCYl1PkEuCXE/seWItHWNYZZjEuuqiMHxKS+r29KVI+nSVc1IK8id6OP8ak3qSSNz8R+cmNstZtCpfVke+z8JlOQ2vm4AJmMCQEmjiXKTEUSRVsljX/DdyVMW60F3hE2OSmnFvSVfezhwcEqYxaSGJxM1PZn7nolX5sjryfRYuy2l43QRMwASGlEAT5yJvusW65tIYB7Eu1G3ROCElO8ZXFifFOovdIg8Fn3eSzhwjxwkptMnrQTIyOJC3BCOxGrkw+CNnBXk+isJleXmcGqI9lGWJ7DvG56+kGSd7602SDo39LFJExcJlGRSvmoAJmMCwEWjHubBY19S7NypiXVNbPXeLBz9/RZG4vCxZUckZgVopwyfJSAdPnpB8uINjlEGCni9tSFhGxKtOuIzhGKIliLGhfPupdIGo422RuZQl2Txz61S4LK/D6yZgAiZgAj0i0MS5sFjXaIt1lf10GP4o0wjJy1aJwqFgi+NQNDJmkmeCYRJUVcnMWWekgUfvhPkeZA0lNXkykooRSSHJ2PWS0HKps6bCZVZFraPoYyZgAibQJQJNnIs058JiXVOhj7JYF0MhtH+1qV2aspXE0YrCaFX9Zqhi59AgQVU1DaVMqTTbQGqeRGLM93h9QagsXZvixetnVUxZbSJcZlXUKci8YQImYAK9IdDEuUhX5k3SYl2JRvWyKKrFPIFhFOtCxfXoEA2jN4iH8WbfqZHGnPkZh8RET5yLIou8biIXSRyt3VTrZfVauCyn63UTMAETGCCBdpwLmsnkO4t11d8wRNlGQayLuRREDhAzY2iCoYWH67tWexShtPRJK9Gu75YIl+UVMFETB4fhlPTFTX68bt3CZXV0fMwETMAEBkygnU8Pp9tUi3VNl+D85zcR6yJyQu6NcbcmLOYxsHDZPBReMQETmCAC083QOYzpvy3W1d0fcNtiXd29/FDV1jYLC5cN1f1zY0zABMaMAImQ+mWMk7eUae1XY2quw9g9f8NuP5C0SoNGToKueFMWDXC5iAmYgAmYwHQJtDvnYrrX8/n9JzAJzkX/qfqKJmACJmAClQTsXFSi8QETMAETMAETMIFOCNi56ISazzEBEzABEzABE6gkYOeiEo0PmIAJmIAJmIAJdELAzkUn1HyOCZiACZiACZhAJQE7F5VofMAETMAETMAETKATAnYuOqHmc0zABEzABEzABCoJ2LmoROMDJmACJmACJmACnRDoZ/rvTtrnc0ygVwRI6nZDryofgXqXlnTPCLSzF02c5L7D0/2f3N9+N+4/CunL9OJ/TNdpAuNAYPY4dGIafZjk/k9y3/nJuP/T+B9nDE7ty/33sMgY/FLcBRMwARMwARMYJgJ2LobpbrgtJmACJmACS8LKUgAABPhJREFUJjAGBJBBt5nApBK4alI7Hv2e5P5Pct+5/e7/ZP/PP+n3f7LvvntvAiZgAiZgAiZgAiZgAiZgAiZgAiZgAiYwYQQ2jU9QfytpnzHq+8qSLpb0a0nXSdo9+vYUSRdIuimWT479fIZ+pCQ4/ELSuhmL7aM857A+KsYw7zWSzo0GP13Sz6IvX5W0YOxfSBLb9J3jq2Yd3Df285nyJtn+YV99kqSzJP0mfgMbSpqke79n/O5/Jel0SQtLGuf7f4KkuyTR32TdvN/rSfpl/L/AvxNOW5Eoe2kCJQR4+NwsabV40Fwraa2ScqO4a4XMQVhc0o3Rt0MzJwpn6pDo3OaSvhv/aLw4HrIc4h+oW2KJI8J6ckiGncuHJJ2WORdnStomGn2spF1i/f2S2MY4jqOB8VvgN4HzwYOJ38qozEs7SdLO0Q+cKJyNSbn3K0n6naRFov/c9x0kjfP9f1n8/547F92831dIwkHFqeDfic2CrRcmYAIlBPif5XvZft5S+RtH+6ak10SUBscDY5kShx0n6e2xnwX7Oc4+jiUrlkv7h235VEkXSnpVOBf8o0iSsP+Ihub3nt8A2xjHKUf54u8hLxfFh3KxRDxci2+X6Z7S6HG+9zgXfwqHmPtJ5Iqo07jffyJuuXPRrfvNb4UIWLLivwlpf+3Sn6LW4vHBMSOQ/hFK3bpVEvvGzfhHZ52IRiwn6Y7oIMtlY72KRdX+YWd0hKS9Jf07GrqUpPsl/Su283ud95HjD0iifL6f0/Jzhrn/ROLulvTlGBY6XtKikibl3t8m6TBJf4zfOveTryEm5f6n32a37jf/H/DbT9bR/wd2LhI+LyeBQPHNjj4/PmYdX0zS2ZL2kPRgTd+qWFTtr6lq4Ie2iPHn/PO6un5UHavaP/AOtmgAb+vMmflCOJUPZUNhZadW9bNqf1kdw7SPYbstYyhrxXCsysL46f/1qn5W7R+mvnbSlqp+tbu/rWvbuWgLlwuPOAE8cCY+JiOUfnvaGIPlAuFYnCrp69GfOyMkzibhTiaBYVUsqvbHaUO5eImkN0j6vaQzYmiESAbzDtKwSH6v8z5yfElJ99UwGcpOZ42iP/wxORVjYifOxiTce/q7cQwLEb15NH77G03Q/Z9717t3v/kt8f9Lsvz/nbTPSxMwgYwADxImKDJZj0lvTN5bOzs+yqu8hXxFEg/V3D6dvcUyoZNJX9jrChM6mcCFMaGTyXG8DfLHOvtGxV6RTej8WmFCJxM5sV0LEzqZ+IfxW8gndPJbGZUJnZdIelb04+OSuO+Tcu9fFF+KzIq5M0xu3U3SuN//4pyLbt7vKyUx0Zt/V5jQyQRwmwmYQA0B/ifhSwq+BNivptyoHXppDPHwWenP44++MpeAiY58VsoyOQr8o3F0cOCTs/WzDu8Un6DxqeaO2f5RWM2dC+Yi4DTRDx40fAWC8Zki2+znOOWS8Zvgt8HkuLLQeio3bMsXhCAZ9/+ccAwn6d4fEJMQmeB4ctzrcb7/fG7LHCoiNUQa3t3l/9f59wCW/L9wVDgZw/abd3tMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMwARMoLsE/j8OeH/YrX8LRwAAAABJRU5ErkJggg=="
    }
   },
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![image.png](attachment:image.png)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(198838, 198838)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(episodes.shape[0] - len(set(episodes.title))), ( len(set(episodes.uuid)) - len(set(episodes.title)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2863, 2863)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(len(set(podcasts.uuid)) - len(set(podcasts.title))), ( len(set(podcasts.uuid)) - len(set(podcasts.title)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x2a3ce21e390>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYoAAAELCAYAAADHksFtAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzt3Xl8XHd97//XZzZtlrV7XyRvSexmN1kIhCxkYXWBpJhQ1kBuS1L6o/zam1wo5cJNb1Na6IUSaGiAkBvjBLPE0JCNNElJjGM7sRPbsR15V7zLsixrm+17/5gje6KMZo6kkUYav5+Phx46c873fPU9c+z5zHc536855xARERlIoNAFEBGRsU2BQkREslKgEBGRrBQoREQkKwUKERHJSoFCRESyUqAQEZGsFChERCQrBQoREckqVOgC5EN9fb1rbGwsdDFERMaVdevWHXHONeRKVxSBorGxkbVr1xa6GCIi44qZ7faTTk1PIiKSlQKFiIhkpUAhIiJZKVCIiEhWChQiIpKVr0BhZteb2VYzazaz2zMcLzGzB73jq82sMe3YHd7+rWZ2Xa48zezHZrbTzNZ7P+cN7xJFRGQ4cg6PNbMg8F3gGqAFWGNmK51zm9OS3Qy0OefmmdlS4C7gw2a2EFgKLAKmAU+a2QLvnGx5/rVzbkUerk9ERIbJT43iIqDZObfDORcFlgNL+qVZAtznba8ArjYz8/Yvd871Oud2As1efn7yFBGRMcBPoJgO7E173eLty5jGORcH2oG6LOfmyvNOM3vZzL5lZiU+yigiIiPEz5PZlmGf85lmoP2ZAlRfnncAB4AIcA/w34GvvalQZrcAtwDMmjUrU7nzatnqPRn333TxyP9tEZFC8lOjaAFmpr2eAewbKI2ZhYAq4GiWcwfM0zm336X0Aj8i1Uz1Js65e5xzi51zixsack5VIiIiQ+QnUKwB5ptZk5lFSHVOr+yXZiXwCW/7BuAp55zz9i/1RkU1AfOBF7LlaWZTvd8G/DGwcTgXKCIiw5Oz6ck5Fzez24DHgCDwQ+fcJjP7GrDWObcSuBe438yaSdUklnrnbjKzh4DNQBy41TmXAMiUp/cnHzCzBlLNVuuBP8vf5YqIyGBZ6ov/+LZ48WI30rPHqo9CRIqNma1zzi3OlU5PZouISFYKFCIikpUChYiIZKVAISIiWSlQiIhIVgoUIiKSlQKFiIhkpUAhIiJZKVCIiEhWChQiIpKVAoWIiGSlQCEiIlkpUIiISFYKFCIikpUChYiIZKVAMUyxRJJiWNNDRGQgChRDdLijl1+tf52zv/oYdz+9vdDFEREZMTmXQpU3293ayT3P7iAYMMLBAJv2tRe6SCIiI0aBYggOd/TigM9dOY8Xd7ex71hPoYskIjJi1PQ0BN2xBAA1ZWGmVpWyv727wCUSERk5ChRD0B1NEDCIhAJMrS7jUEcvsUSy0MUSERkRChRD0BVLUBYOYmZMqyrFOTjQruYnESlOChRD0B1NUBYJAjC1ugyA/QoUIlKkFCiGoNurUQBMqyoFUD+FiBQtBYohyFSj0MgnESlWChRDkF6jmFASorI0pBqFiBQtBYohSNUoTj2CMq2qTDUKESlaChSDlHSOnrQaxbLVe3A4Nu9rZ9nqPSxbvafAJRQRyS8FikHqjSVxQLnXRwFQXRbhWHescIUSERlBChSD1PdUdl+NAqCqPExXNKGH7kSkKClQDFJXNA5wctQTQFVZGIB21SpEpAgpUAxSxhqFAoWIFDEFikHqjnqB4g19FF6g6FKgEJHi4ytQmNn1ZrbVzJrN7PYMx0vM7EHv+Goza0w7doe3f6uZXTeIPL9jZieGdlkj52SNIi1QTPQChTq0RaQY5QwUZhYEvgu8C1gIfMTMFvZLdjPQ5pybB3wLuMs7dyGwFFgEXA/cbWbBXHma2WKgepjXNiJO1ijSmp7CwQAVkaCankSkKPmpUVwENDvndjjnosByYEm/NEuA+7ztFcDVZmbe/uXOuV7n3E6g2ctvwDy9IPIN4G+Gd2kjozuaIBxMrWyXrqo8THt3tEClEhEZOX4CxXRgb9rrFm9fxjTOuTjQDtRlOTdbnrcBK51z+/1dwujqSnvYLl1VWYRj6qMQkSLkJ1BYhn3OZ5pB7TezacCNwHdyFsrsFjNba2ZrDx8+nCt53qRPCJiuqiyspicRKUp+AkULMDPt9Qxg30BpzCwEVAFHs5w70P7zgXlAs5ntAsrNrDlToZxz9zjnFjvnFjc0NPi4jPzoHqhGURqiN54kGtdDdyJSXPwEijXAfDNrMrMIqc7plf3SrAQ+4W3fADzlnHPe/qXeqKgmYD7wwkB5Ouf+wzk3xTnX6JxrBLq8DvIxo/+EgH0qvZFPHT2qVYhIcXnzJ14/zrm4md0GPAYEgR865zaZ2deAtc65lcC9wP3et/+jpD748dI9BGwG4sCtzrkEQKY88395+dcdSzAtQ42isjT1Vh7viY92kURERlTOQAHgnHsEeKTfvq+kbfeQ6lvIdO6dwJ1+8syQZoKf8o2m7mjiDRMC9plYqhqFiBQnPZk9CPFkkmgiSalqFCJyGlGgGIS+h+0y1SjKwkFCAVONQkSKjgLFIGSaELCPmVFZGqJDNQoRKTIKFIOQaULAdJWlYY6rRiEiRUaBYhCy1SgAJpaG6OhWjUJEiosCxSBk66MA1ShEpDgpUAyCnxpFbzx5chU8EZFioEAxCF1ejaI0S40C4NDx3lErk4jISFOgGITuWILScICAZZrTECrLUs9SHOpQoBCR4qFAMQjd0cwTAvbpezr74PGe0SqSiMiIU6AYhIGmGO/T93S2ahQiUkwUKAahN56kJDRwoOh7OvuQahQiUkQUKAYhlkgSCQ78lvU9na2mJxEpJgoUgxBNJAmHsr9llaVhNT2JSFFRoBiEWDxJJJh5xFMf1ShEpNgoUAxCNJEknKXpCVIjn1SjEJFiokAxCLn6KMCb76knfnK6DxGR8U6Bwqekc8QSzlcfBcChDjU/iUhxUKDwKZ5wADlrFH1PZx/UNB4iUiQUKHyKJpIAOWsUejpbRIqNAoVPsXgqUOSqUVSXpwLFnqNdI14mEZHRoEDh08kaRY7hsSWhIJMqS9h5pHM0iiUiMuIUKHyK9tUocjQ9ATTVV7BLgUJEioQChU+xhL+mJ/ACRasChYgUBwUKn041PeV+yxrrKzhyIqplUUWkKChQ+BTrGx7ro+mpsa4CQM1PIlIUFCh86uuj8FOjaKpPBQp1aItIMVCg8Kmv6clPjWJ2XTkAu45oiKyIjH8KFD75fY4CoDQcZHp1mTq0RaQoKFD41FejCOV4jqJPY325mp5EpCgoUPgUiycJB42A+QwUdRoiKyLFQYHCJz9rUaRrqq/gWFeMts7oCJZKRGTk+frkM7PrzWyrmTWb2e0ZjpeY2YPe8dVm1ph27A5v/1Yzuy5XnmZ2r5ltMLOXzWyFmU0Y3iXmh5+1KNL1DZHdqVqFiIxzOT/5zCwIfBd4F7AQ+IiZLeyX7GagzTk3D/gWcJd37kJgKbAIuB6428yCOfL8gnPuXOfcOcAe4LZhXmNeRH2sRZGusV7PUohIcfDzyXcR0Oyc2+GciwLLgSX90iwB7vO2VwBXm5l5+5c753qdczuBZi+/AfN0zh0H8M4vA9xwLjBfUutl+w8Us2rLCZgChYiMf34++aYDe9Net3j7MqZxzsWBdqAuy7lZ8zSzHwEHgDOB7/go44gbbB9FJBRgRk05O1v1LIWIjG9+PvkyDfPp/y1/oDSD3Z/acO5TwDTgVeDDGQtldouZrTWztYcPH86UJK9iiSSRkL8RT33mNlTw2sGOESqRiMjo8BMoWoCZaa9nAPsGSmNmIaAKOJrl3Jx5OucSwIPAhzIVyjl3j3NusXNucUNDg4/LGJ5o3H+NYtnqPSxbvQcwth7o4MfP7fJei4iMP34++dYA882sycwipDqnV/ZLsxL4hLd9A/CUc855+5d6o6KagPnACwPlaSnz4GQfxfuALcO7xPwY7KgngBk1ZThgf3v3yBRKRGQUhHIlcM7Fzew24DEgCPzQObfJzL4GrHXOrQTuBe43s2ZSNYml3rmbzOwhYDMQB271agoMkGcAuM/MJpJqntoA/Hl+L3loovHkoEY9AUyvKQOgpa2b2d5wWRGR8SZnoABwzj0CPNJv31fStnuAGwc4907gTp95JoHL/JRptEWHUKOYWBpmYmmIljZ1aIvI+KUns31wzhFLuEGNeuozo6acljY1PYnI+KVA4UNPzP8U4/3NqCmjtTNKdzSR72KJiIwKBQofuqJxACI+Z45N19dP8fox1SpEZHxSoPChO5aqDQyl6Wl6tRco1E8hIuOUAoUPfc1GQ2l6Ko+EqK2I0KIahYiMUwoUPgynRgGpfgp1aIvIeKVA4UPXMGoUADOqy2jvjnG4ozefxRIRGRUKFD6cbHoaco2iHIANe4/lrUwiIqNFgcKH4TY9TasuI2Dw0t62fBZLRGRUKFD4MNymp0gowJSqUtarRiEi45AChQ+nahSDf46iz8yacjbsbSeRHBPrMImI+KZA4UP3yQfuhv52zawp50RvnO2HT+SrWCIio0KBwoe+pqfBzh6bbmZtqkN7/R41P4nI+KJA4UN3LEEoYARs6E1PdRMiTCwNqUNbRMYdX9OMn+66o4khj3jqEzDjvFk1vDTKNYpMK+vddPGsUS2DiIxvqlH40BVNDHnEU7rzZlaz7WAHnb3xPJRKRGR0KFD40B0bfo0C4PxZ1SQdvNzSnodSiYiMDgUKH7qjCSKhofdP9DlvRjWgB+9EZHxRoPAhH30UADUVEeY2VPDCzqN5KFV2iaTj+e1H+PWGfdz9dDMHj/eM+N8UkeKkQOFDVywxrGco0l06t441O48STyTzkt9A/unxrdz0g9Ws2XWU/e09/L75yIj+PREpXgoUPnRH43mpUQBcMqeOzmiCV14fuX6KRNKxYl0LV57RwJffs5DzZ1bzcssxemJajlVEBk+BwofuWH5GPUEqUACs2tGal/wyWbvrKIc7evnQhTOIhAJc1FRLLOE015SIDIkChQ/d0fw1PdVPKGHB5An8YcfI9VP8duMBSkIBrjxjEpBajnVqVSlrdh3FOc01JSKDowfufEh1Zg9/1FOfS+bUsWJdC7FEMm9NWn2SScdvN+7nijMaqChJ3V4z46KmWh5ev29crLSX6SFB0IOCIoWiGkUOzrlUZ3aemp4ALp1TR1c0wcst+W8KenFPGweP9/Lus6e+Yf+5M6oJB401u0Z+xJWIFBcFihx640mcG/qiRZlc7PVTjETz0yOvHCASCnDVmZPesL80HOTcGdVsaDlGR08s739XRIqXmp5y6B7mokWZ1FZEOHNKJau2t3LrlfPylq9zjkc37ufy+Q1UlobfdPwtjbWs3d3Gr9bv42OXzPadr+aLEjm9qUaRQ9cwl0EdyKVz61iz6+jJQJQPWw92sK+9h2sXTs54fEZNqlN72eo9OTu19x7t4i+Xv8Rnf7KWF3e35bWcIjK+KFDkcHLRojzWKACuOnMSvfFkXh+E+69tqbzevqA+43Ez4y2Ntby6//iA800lko7vPb2da771DE9sPsim19tZ8WILdz22hT2tnXkrq4iMHwoUOXT2pr5Jl+S5RnFxUx2VJSGe2Hwgb3k++9phFkyewNSqsgHTnDezmrJwMGNzUjyR5P//2QbuenQLl89v4Mm/egfP3X4Vf/6OuVSWhLhv1W4OaCoQkdOOAkUOnXmsUSxbvefkz4p1LTQ1VPAfL+/Pyzra3dEEq3ce5e3zG7KmKw0Hed+5U1m5YR+b9p2qVUTjST6//CV++dLr/PV1Z3DPxxczrboMM2NmbTmfvqyJcND40XM7aeuMDru8IjJ+KFDk0NWb/87sPmdNnUhnNMH6PMwmu3pnK9F4kssXZA8UAJ+7Yh7V5WFu+N4qfvPyPn69YR/v/9ff88grB/jye87K2MFeUxHhU5c1EUskWfbCHqLxkZ2rSkTGDl+ffmZ2vZltNbNmM7s9w/ESM3vQO77azBrTjt3h7d9qZtflytPMHvD2bzSzH5rZm4fvjKJ81ij6O2NyJUEzHt98cNh5/eDZHYQCxq4jnW+ouWTy/PZWPvnWRuonRLht2Uv8xU9fovVElLs/egGfefucAf/G5ImlfPD8Gbx+rJtvPblt2GUWkfEh5/BYMwsC3wWuAVqANWa20jm3OS3ZzUCbc26emS0F7gI+bGYLgaXAImAa8KSZLfDOGSjPB4A/9dIsAz4DfG+Y1zlkXd5on5JQMO95l4aDNDVU8MTmg9zxrrOGlddrh07QWF/he3RWZWmYz759Ds++doSGyhIWTZvIsa7YgMGlzx9Nr2Lx7Bq+/8x23j6/nrfOzdxxLiLFw8+nykVAs3Nuh3MuCiwHlvRLswS4z9teAVxtZubtX+6c63XO7QSavfwGzNM594jzAC8AM4Z3icPTt2xpvuZ66u+sKZXsONzJ9sMnhpzHvmPdHOroZf6kCYM6LxRMPZh39vQqAuZ/ipL3njONproKvvjQBk5oWVeRoufn0286sDftdYu3L2Ma51wcaAfqspybM0+vyeljwKM+yjhiukbggbt0Z02dCMATw2h+enbbYQDmT67MS5lyiYQCfOPGc9nf3sO3nlATlEix8/Ppl+mrZv9hOgOlGez+dHcDzzrn/itjocxuMbO1Zrb28OHDmZLkRWc0TiQUIBjI36SA6arLIyyaNnFYgeKxTQeoKQ8zubIkjyXL7sLZNXzkoln86LmdbBzBtTVEpPD8BIoWYGba6xnAvoHSmFkIqAKOZjk3a55m9ndAA/BXAxXKOXePc26xc25xQ0PukT5D1R1NUBHJf/9EumsWTubFPW0c7ugd9LkdPTGea25l0bQqbBDNR/lw+/VnUlsR4Uu/fCUvQ3xFZGzyEyjWAPPNrMnMIqQ6p1f2S7MS+IS3fQPwlNfHsBJY6o2KagLmk+p3GDBPM/sMcB3wEedcwcdgdvYmKI+M7JRY1yycjHPw1JbB1yqe3nqYaCLJQq8JazRVlYf58nsWsqGlnZ+t3Zv7BBEZl3IGCq/P4TbgMeBV4CHn3CYz+5qZvd9Ldi9QZ2bNpGoBt3vnbgIeAjaT6mu41TmXGChPL6/vA5OBVWa23sy+kqdrHZKuaJzyEa5RLJw6kenVZTyx+dCgz3100wHqJ0SYVVc+AiXLbcl507hgVjX//MS2vHZs98YS6igXGSN8fVV2zj0CPNJv31fStnuAGwc4907gTj95evvH1Iy2ndEE5SUjW6SfvrCXWbXlPLPtED9+bheRUMDX7Kw9sQRPbznE+8+bPqhRS/lkZnz5vQv54N3P82/PbOeL156Rl3wfWruXHUc6+dRbG5lVV5GXPEVkaPRkdg5dvfER76OA1OinWMLRfMj/MNnntx+hM5rgukWZZ4sdSekP9W3Z38E5M6r43tPb2Xds+CvoHe+OseVAB7FEkh89v0uTEYoUmAJFDp3Rke+jAGiqr6A0HGDz/uO+z3ls40EqS0Jj4qG36xZNAeCuR7cMO6/1e4/hgE9d1sSEkhA/en4Xx7o0v5RIoShQ5NAVjVNRMvI1imDAWDi1io372umN5V77oaMnxn+8sp9rF00ZsWc8BqOmPMLb59fz8Pp9rN7ROuR8nHOs29PGrNpy5jZMYOlbZtEbT7K7tSuPpRWRwSj8J8wYNxqjnvpc3FRLNJ5kvY+1tB9cs5cTvXE++dbGkS+YT+9YMInp1WV85eFNxBJDG7C2oaWdwx29XDirBoDJE0sIGBzq0PTmIoWiQJFDV3R0+ijg1Ap0L+w8mnUFukTS8ePnd3FRYy1nz6galbL5EQkF+Mr7FrL1YAc/WbV7SHmsWLeXUMBOXlcoGKC2ooRDQ3jGRETyY0yNMBprkklH1yiMeupjZlzUVMvD6/exfu8xzve+VadbtnoPm/a109LWzeXzG3JO4jfajnT0smDyBP7x0S30RBPUVEQAf2tsd0XjrFy/j0XTJlIaPhWcJ1WWcOi4AoVIoahGkUVPPNVXMFo1CoDzZlQTCQV4IEsAeK65lZryMAunjf5DdrmYGe8/NzVt1/I1ewb1xPb9q3ZzvCfOJXPq3rB/UmUJrZ29WgNDpEAUKLLoWwZ1tGoUACXhIOfNrObXG/ax68ibh4Vu2HuMXa2dXDKnrmDPTuRSWxHhgxfMYG9bN0++6u9p8xO9cb7/zHYuX9DA7H7PTUyaWELSwW4NkxUpCAWKLLq8RYtGs0YBcPn8BipKQtz0gz+w9+ip0T5Pbz3Ez9btpbGu4k3fuseas6dX8ZbGWp7ZdtjXpIH3Pb+Ltq4YX3jn/Dcdm1RZCqTW3BCR0adAkcXJGsUojXrqU1sR4f6bL+JEb5yb/v0P/Pi5nXzziW382f9dx+SJpXz80tm+FygqpPecPZWZNWX89IU93L9q14DpOnpi3PPsDq46c1LGfpn6CSUY8NpBBQqRQlBndhZ9NYrySJCjo9zqsWhaFffffDEfu3c1X/11ajHBs6ZO5I/Pm/aGjt6xLBIKcPPb5rB8zR7+9uFNrN/bzrWLJnP+zGqSDtq7Yzy+6QDL1+ylvTvGF965YMB8qsvDNA9jcScRGToFiiw6vUWLRuOBu0zOnVnNH/7H1XRHE0wsCxMOBsbcKKdcIqEAH714NjuOnGDZ6j38/MWWN6V527x6/tcH/ijrUN9JlaW8drBjJIsqIgNQoMiiq7evRjH6b9N4CwjZBAPG/EmVfOndZ/H6sW5eP9ZNKBDgyjMbOHdGNY31uSf9mzSxhNU7jxJPJAmNg2Y3kWKiQJHFyRpFAQJFMQoFA8yuqzg5qmnJef1X1B3YpMpSovEke9u6afIRWEQkf/TVLIuTfRQFanqSUyZ5y7wOZnZdEckPfVXOom/Uk2oUI2MwzWsNXqB47VAH1ywc/WnVRU5nqlFk0R2NYwalYb1NhVYaDjJlYinNGiIrMur0CZhFZzRBRSSEjdEnoE83TfUV7NLT2SKjToEii9FYL1v8a6yvYJfWpRAZdQoUWXT2JqgYxXmeJLvGunKOdkZp744VuigipxUFiixUoxhb+p630OSAIqNLgSKLzt6ERjyNIX3PT+zMMKuuiIwcBYosuqJxylSjGDNm1ZYDaP1skVGmQJFFZzRRsHme5M1Kw0GmVZVmXKdDREaOAkUWXb3xgszzJAObXVfBTvVRiIwqBYosUs9RqEYxljTWV6jpSWSUKVBk0R1NjOoyqJKbhsiKjD4FigFE40miiaRqFGOMhsiKjD4FigF0RwuzDKpkpyGyIqNPgWIAnd4U4xr1NLZoiKzI6FOgGMCp9bJVoxhLNERWZPQpUAzg5FoUqlGMORoiKzK6FCgG0KkaxZilIbIio8tXoDCz681sq5k1m9ntGY6XmNmD3vHVZtaYduwOb/9WM7suV55mdpu3z5lZ/fAub+i6evs6s1WjGGvmNlRwtDPK4Y7eQhdF5LSQM1CYWRD4LvAuYCHwETNb2C/ZzUCbc24e8C3gLu/chcBSYBFwPXC3mQVz5Pkc8E5g9zCvbVhUoxi7zp1ZDcD6vccKXBKR04OfGsVFQLNzbodzLgosB5b0S7MEuM/bXgFcball4ZYAy51zvc65nUCzl9+AeTrnXnLO7RrmdQ1bV1R9FGPV2dOrCAWMF/e0FbooIqcFP4FiOrA37XWLty9jGudcHGgH6rKc6yfPgursVY1irCoNB1k0bSIv7lagEBkNfgJFpgWjnc80g93vm5ndYmZrzWzt4cOHB3OqL6ceuFONYiw6f1YNL7e0E08kC10UkaLnJ1C0ADPTXs8A9g2UxsxCQBVwNMu5fvLMyjl3j3NusXNucUNDw2BO9eV4T4zScIBwUAPDxqILZtfQHUuw5UBHoYsiUvT8fAquAeabWZOZRUh1Tq/sl2Yl8Alv+wbgKeec8/Yv9UZFNQHzgRd85llQrZ1R6ipKCl0MGcAFs1Id2uqnEBl5ORvgnXNxM7sNeAwIAj90zm0ys68Ba51zK4F7gfvNrJlUTWKpd+4mM3sI2AzEgVudcwlIDYPtn6e3//PA3wBTgJfN7BHn3GfyetU+tJ6IUj8hMtp/VrJYtnrPyW3nHJUlIV7c3cbHL20sXKFETgO+emqdc48Aj/Tb95W07R7gxgHOvRO400+e3v5vA9/2U66R1NrZy6TK0kIXQwZgZsysLefFPRoiKzLS1AA/gNYTUeoqVKMYy2bVlrPnaBdHTujBO5GRpECRgXMuFSgmqI9iLOubSVbDZEVGlgJFBh29caKJpPooxrjpNWVUlob4zcv7C10UkaKmQJFB64koAHUKFGNaOBjgxgtn8sgr+zl0vKfQxREpWgoUGbR6bd4aHjv2ffzS2SSc44G0EVEikl8KFBkcUY1i3Gisr+CKBQ08sHoP0bie0hYZCQoUGbR2pmoU9erMHhc+8dZGjpzo5ZFX1FchMhIUKDLo66OoKVeNYjy4fH4Dc+or+P4z2+mNJwpdHJGio0CRQeuJXqrKwkRCenvGg0DAuOPdZ7HlQAd//x+vFro4IkVHc2hncKQzqv6JcSJ9Wo+3zavnvlW76Y0n+YcPnVPAUokUF31lzqD1RC/1GvE07ly3aAqzasv5xUuva/U7kTxSoMgg9VS2ahTjTTBgLH3LTCoiQZbes4rfvXqw0EUSKQoKFBm0qulp3Kouj/Bn75jLgsmVfPYna7n39ztJzXgvIkOlQNFPPJGkrUtrUYxnlaVhfvrZS7jqzMl8/Teb+dSP13C4QxMHigyVAkU/bV0xnEPzPI1zD6/fx5VnNPC+c6by+9eOcMU/Pc3fPbyx0MUSGZc06qmfvoftNHPs+GdmXDq3nqaGCTy0Zi/3rdqNmXH7u86kNKy10EX8Uo2in5MTAmotiqIxZWIpf37FXN46t44fP7+L6//lWZ5rPlLoYomMGwoU/fQtgqPO7OISDgZ47znTWPaZiwH46L+v5vM/fYldRzoLXDKRsU+Bop9TNQo1PRWjXa1dfOqyJq48YxK/3bifq/75aW7/+ctsP3yi0EUTGbPUR9FPa2cvwYBRVRYudFFkhISDAa5ZOJlL5tTy9LbD/OLF11m+Zi/vWNDATRfP4oozGigJqQ81opn6AAAQlklEQVRDpI8CRT+tJ6LUVkQIBKzQRZERVlka5n3nTOOKBQ2s2XWU1TuO8sy2w5SGA5w9vYovXnsGFzXW6t+CnPYUKPo5ciKqjuzTTGVpmKvOnMw7Fkyi+dAJNrQcY8Pedpbe8wemVZVyzcLJXHHmJC6dU+d7tFQi6TBQkJGioEDRz9HOXq1DcZoKBowzplRyxpRKovEkm/cf5+WWYyx7YQ/3rdpNOGjMqZ/ATRfPYv7kCcyuqyBgcKwrxp6jXTzwh93sbeumrSvK8e4YkVCAt82r57J59Xz4LTMpj4yf/27LMqwYeNPFswpQEhkLxs+/3FHS2hllZm15oYshBRYJBThvZjXnzawmlkiy80gnWw50sPXAcf5u5aaM5wTNmFpdSmNdBVVlYbqicZoPneDJVw/xg2d38OX3LuRdfzQFM9UyZHxRoEjT2Rvn9bZu3nvO1EIXRcaQcDDAgsmVLJhciTtnKu3dMY6ciNLa2YthlEWCVJWGmFpdRjj45oGEO4908usN+/jcAy8yt6GC954zjS9cs6AAV+JPR0+Mp7YcpLM3wYyaMhrrKqhRc+xpTYEizdrdbcSTjoub6gpdFBmjzIzq8gjV5RHmMcHXOU31Fdx65Txe2NnKE68e5DtPvUZ7d4yb39Y0pmqvyaTjZ+v28o3HtnHkRC/hoLFqR6qv5QPnT1fT02lMgSLNqu2thIPG4saaQhdFikwwkJpO5OwZ1Ty+6QD3/2E3P1m1i3eeNZnrFk3h0rl1TKsuK1j5Xj/WzV//bAPPb2/lwtk13HjhDKbXlHHoeC+/3bifX7z0OgumVPLfLp+jprPTkAJFmlU7Wjl3RvW46nSU8WVCSYgPXjCDq86cxOqdR3mu+QiPb06tm1FZGuKPplUxd1IFcxsmMKdhAnMbKphWVTZio6cOd/SyYl0Ld/9nM0nn+N8fPJulb5nJT1/YC8CUqlI+dulsVqxr4R9+u4XWE73c8a6zNJrrNKNPRE9HT4yNr7fzuSvmFroochqoLo9w3aIpXLNwMgeP97DjcCf727tpaevipb1t9MSSJ9OWhgPMbZjAmVMmcuaUSmbXlTOjppz6ygiVJWFKw4Gc3/KdcxzvibPvWDe7W7t4df9xNrQc4/evHSGedLxtXj1//4GzmVX35qawUCDAnyyeyfkzq/nBf+2ktTPKXR86J2N/jBQnBQrPml1HSSQdl85R/4SMnoAZU6vKmFp1qtnJOceJ3jiHT/RypCPK4Y4eDnX08vjmA/z8xZY35REMGBWRIJWlYULBNwYM51KDNI51x0gkTy3gZED9hBIunVPHhY01TKos5ffNR6B54HJ+9f2LqJ9Qwj8/sY1Dx3v53x88e0z1sYw3HT0xWk9E+dnaFqrKw0woOfVxPNb6gxQoPKu2txIJBrhgtvonpLDMjMrSMJWlYebUv/FYVzTO0c4obV0xOnvj9MaT9MYSqd/xBMkMi/lNmVhKaThARUmI6vIINeVhJlWWEgkNrkZgZvzF1fOZNLGE//nrzbzzm89w65Xz+NNLZlOrUVG+xRJJvv/0dr791GvEEqkbFgkGuPqsSbx1bj3BMdisp0DhWbWjlfNmVWudAhnTyiMhyiMhZhTg+0z6Q3i3XTmPRzYe4JtPbONfntzGxU11XDavjvmTK5nbUEFdRQlVZWH1ZfSz7WAHX3xoA6+83s57zpnK1WdOYt3uNtbtbuO3Gw/w4p42/mTxzEIX8018BQozux74P0AQ+Hfn3D/0O14C/AS4EGgFPuyc2+UduwO4GUgAn3fOPZYtTzNrApYDtcCLwMecc9HhXWZ27V0xNu07zuevmj+Sf0akaFSXR7jpolnsb+/GOXh00wH+6fFtb0gTDBg15WFqyiPUVkSomxChpjxCXUXqdU1FhLqKkjccG2wtZ7xIJB0/+K8dfPPxbUwoDXH3Ry/g3WenntfqiSVZNK2KV/cf51frX+d7T29nUmUJf3rJ7DEzwixnoDCzIPBd4BqgBVhjZiudc5vTkt0MtDnn5pnZUuAu4MNmthBYCiwCpgFPmlnfk0YD5XkX8C3n3HIz+76X9/fycbGZxBNJ7npsC87BZfPqc58gIif19a18+rImemOJVL/KiSidvXE6o3G6ehN0RuMnO+wTztHWFcVlaCIDqCwJUTshQlVZmNJQkJJwgLJwkNJw0PsdoDQcJBgwQgEjGAgQClraa6MkFCQSChAJBSjp+x0MUBIOEAkG37jf+x0JBQiY4Rw4XOq3g6RzOFJ9OqGgEQoECBi+PsCTSceeo108tukAv3zpdbYc6GDRtIksOW86x7pib5om5aypE5lZW86KdXv524c38cgrB/jitQtY3Fg7zLs0fH5qFBcBzc65HQBmthxYAqQHiiXAV73tFcC/WuqdXAIsd871AjvNrNnLj0x5mtmrwFXATV6a+7x8RyRQtHfFuHXZi/y++Qi3XD6Ht+j5CZEhKwkHmVGTGpGVTdI5uqIJOnvjJ393RuPe79TrnliCjp44sUSSeMIRTSSJJ5LEEo5YIolzkBgo2oyC8MngFPACyBtf98QSHDkRPTmA4JwZVXx48UzOmVGVNchMKAnx8UsbSTrHt3/3Gjd8fxUXN9VypTcpZWNdBRPLQqNe0/ATKKYDe9NetwAXD5TGORc3s3agztv/h37nTve2M+VZBxxzzsUzpM8r5xyf/claXtrbxjduOIcbx2C7oEgxCpgxoST0hlE+Q5V0jmTSkfS+/SeSqZ940hFPJFO/k454MhVwMh5LJEl4eZilag/GqVqD2anaRepvnNpOJh0Jl16OVD7BgHHWlIlMLAtzxuTKQU2BEjDjTy+ZzQ0XzuD+VbtPPsPSJxIMUFkaIuDVopZ99hKa6iuG/V5m4+dOZQpd/UP5QGkG2p+pITJb+jcXyuwW4Bbv5Qkz25opnR9/8ve+ktUDxbbQcrFdU7FdD+iaxoO8X89HB5F2zv8Y1p+a7SeRn0DRAqR/3Z4B7BsgTYuZhYAq4GiOczPtPwJUm1nIq1Vk+lsAOOfuAe7xUf68MLO1zrnFo/X3RkOxXVOxXQ/omsaDYrueTPwMMVgDzDezJjOLkOqcXtkvzUrgE972DcBTzjnn7V9qZiXeaKb5wAsD5emd859eHnh5Pjz0yxMRkeHKWaPw+hxuAx4jNZT1h865TWb2NWCtc24lcC9wv9dZfZTUBz9euodIdXzHgVudcwmATHl6f/K/A8vN7H8BL3l5i4hIgZgr4MiB8cTMbvGau4pGsV1TsV0P6JrGg2K7nkwUKEREJKvifAxSRETyRoEiBzO73sy2mlmzmd1e6PJkY2Yzzew/zexVM9tkZn/p7a81syfM7DXvd42338zs2961vWxmF6Tl9Qkv/Wtm9omB/uZoMLOgmb1kZr/xXjeZ2WqvbA96AyLwBk086F3PajNrTMvjDm//VjO7rjBXcrIs1Wa2wsy2ePfq0iK4R1/w/s1tNLOfmlnpeLtPZvZDMztkZhvT9uXtvpjZhWb2infOt83GyPwcfjjn9DPAD6mO9u3AHCACbAAWFrpcWco7FbjA264EtgELgX8Ebvf23w7c5W2/G/gtqedXLgFWe/trgR3e7xpvu6aA1/VXwDLgN97rh4Cl3vb3gT/3tj8HfN/bXgo86G0v9O5dCdDk3dNgAa/nPuAz3nYEqB7P94jUQ7E7gbK0+/PJ8XafgMuBC4CNafvydl9Ijfi81Dvnt8C7CvVvcNDvTaELMJZ/vJv6WNrrO4A7Cl2uQZT/YVLzaW0Fpnr7pgJbve1/Az6Sln6rd/wjwL+l7X9DulG+hhnA70hN7fIb7z/ZESDU/x6RGkV3qbcd8tJZ//uWnq4A1zPR+1C1fvvH8z3qm5mh1nvffwNcNx7vE9DYL1Dk5b54x7ak7X9DurH+o6an7DJNXzIiU4rkm1edPx9YDUx2zu0H8H5P8pINdH1j6br/BfgboG/Jt2zTvLxhKhkgfSqZsXI9c4DDwI+85rR/N7MKxvE9cs69DvwTsAfYT+p9X8f4vk998nVfpnvb/fePCwoU2fmeUmQsMbMJwM+B/885dzxb0gz7BjWVykgys/cCh5xz69J3Z0jqchwbE9fjCZFq3viec+58oJNUk8ZAxvw1ee32S0g1F00DKoB3ZUg6nu5TLoO9hvF0bW+iQJGdn+lLxhQzC5MKEg84537h7T5oZlO941OBQ97+ga5vrFz3ZcD7zWwXqTVKriJVw6i21FQx/ct2stzmfyqZ0dYCtDjnVnuvV5AKHOP1HgG8E9jpnDvsnIsBvwDeyvi+T33ydV9avO3++8cFBYrs/ExfMmZ4oyjuBV51zn0z7VD6FCvp06KsBD7ujeC4BGj3qtePAdeaWY33bfFab9+ocs7d4Zyb4ZxrJPXeP+Wc+ygDT/My2KlkRp1z7gCw18zO8HZdTWrmgnF5jzx7gEvMrNz7N9h3TeP2PqXJy33xjnWY2SXee/RxxtP0RIXuJBnrP6RGN2wjNQLjS4UuT46yvo1UdfZlYL33825S7b+/A17zftd66Y3UAlLbgVeAxWl5fRpo9n4+NQau7QpOjXqaQ+oDpBn4GVDi7S/1Xjd7x+eknf8l7zq3UuDRJsB5wFrvPv2K1OiYcX2PgP8JbAE2AveTGrk0ru4T8FNSfSwxUjWAm/N5X4DF3vuzHfhX+g1oGMs/ejJbRESyUtOTiIhkpUAhIiJZKVCIiEhWChQiIpKVAoWIiGSlQCEiIlkpUIhkYWYnvN/TzGzFEM6/wrzp0fNcrj82s4Vpr582s8X5/jsioEAh4otzbp9z7obcKUfNH5OalltkxClQSNEzs1+Z2TpvYZ1bvH0n0o7fYGY/9rabzGyVma0xs6+npWnsW9DGW5TnR94iNC+Z2ZU+y1HhLY6zxjtvibf/k2b2CzN71Fvs5h/TzrnZzLZ5NYYfmNm/mtlbgfcD3zCz9WY210t+o5m94KV/+/DeNZFTQrmTiIx7n3bOHTWzMmCNmf08S9r/Q2pm15+Y2a0DpLkVwDl3tpmdCTxuZguccz05yvElUvMafdrMqoEXzOxJ79h5pKaF7wW2mtl3gATwt6QmDewAngI2OOeeN7OVpKY0WQHgLZYWcs5dZGbvBv6O1GR9IsOmGoWcDj5vZhuAP5Ca2XN+lrSXkZrzB1JzFmXytr5jzrktwG5ggY9yXAvcbmbrgadJzXk0yzv2O+dcuxdsNgOzgYuAZ5xzR11qVtaf5ci/b7bgdaQW4BHJC9UopKiZ2RWkvllf6pzrMrOnSX1Ap09yVtrvtFwToA11rWMDPuSc29qvjBeTqkn0SZD6vznYv9OXR9/5InmhGoUUuyqgzQsSZ5Ja3xhS6wycZWYB4ANp6Z8jNaU5wEcHyPPZvmNmtoBUrWDrAGnTPQb8hTfNNGZ2fo70LwDv8KasDgEfSjvWQWpddJERp0Ahxe5RIGRmLwNfJ9X8BKlV5X5Dqt1/f1r6vwRuNbM1pIJMJncDQTN7BXgQ+KRzrneAtOm+DoSBl72O8a9nS+xSS4z+PanlbJ8k1STV7h1eDvy11yk+d4AsRPJC04yLjGFmNsE5d8KrUfwS+KFz7peFLpecXlSjEBnbvup1fm8EdpJa6EhkVKlGIZIHZnYdcFe/3Tudcx/IlF5kPFGgEBGRrNT0JCIiWSlQiIhIVgoUIiKSlQKFiIhkpUAhIiJZ/T8QJT6ne9wqVQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.distplot(episodes[\"audio_length\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "689       https://play.podtrac.com/npr-500005/npr.mc.tri...\n",
       "735       http://arkiv.radio24syv.dk/19476792/20163851/f...\n",
       "736       http://arkiv.radio24syv.dk/19476789/20163479/f...\n",
       "1142      https://play.podtrac.com/npr-500005/npr.mc.tri...\n",
       "1263      http://arkiv.radio24syv.dk/19476789/20164154/b...\n",
       "                                ...                        \n",
       "876853    https://grani-vremeni.podster.fm/3804/download...\n",
       "876854    https://grani-vremeni.podster.fm/3803/download...\n",
       "876855    https://grani-vremeni.podster.fm/3802/download...\n",
       "877079    http://sverigesradio.se/topsy/ljudfil/itunes/6...\n",
       "879801    http://rf.proxycast.org/1380821118264287232/18...\n",
       "Name: audio, Length: 3304, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "episodes[episodes[\"audio_length\"]== 300][\"audio\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "episodes[\"length_first_dig\"] = episodes[\"audio_length\"].map(lambda x: int(str(x)[0]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<matplotlib.lines.Line2D at 0x2a396275400>]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAD8CAYAAACb4nSYAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzt3Xt0VfWd9/H3N3eSQMgNCEkg3LyAIJAjKlhba7VqLWg1FjudOrNmLafP03a0dq3n6TztM7Z2ZlZnOtOx89Q1U1c7MzpjSwXvreOlrbaigiQQ7kUCckm45UKAEHL/Pn+cjQYazAES9sk5n9daWck5Z++TDyz47LN/+7f3NndHRESSQ0rYAURE5MJR6YuIJBGVvohIElHpi4gkEZW+iEgSUemLiCQRlb6ISBJR6YuIJBGVvohIEkkLO8DpioqKvKKiIuwYIiIjSk1NTZO7Fw+2XNyVfkVFBdXV1WHHEBEZUcxsdyzLaXhHRCSJqPRFRJKISl9EJImo9EVEkohKX0Qkiaj0RUSSiEpfRCSJxN08/XPV3dvHP7yyjYl5o5iQl0VJXhYleaMozMkgJcXCjiciEhcSpvSb27r4t5Xv0d176j1/M1JTGJ+XScmYYGMwNouSMVlMyBvFxLFZTMjLoignUxsGEUkKCVP6E/Ky2Padm2k+3sWBIx3sO3KCA0c62H+kg/1HTrD/SAe1e1t5aVMHXb19p6ybnmqMHxPdO5iQN4qJeVnB3sKoYI8hi6JcbRhEZORLmNIHSEkxikdnUjw6k9lleQMu09fntLQHG4bWExw4GmwYWqMbhg31rby8uYOunlM3DGkpH2wYSsZGNwYTxmQFewvRDUVhbiap2jCISBxLqNKPRUqKUZSbSVFuJpeVDrxhcHdajncFewkdHAj2FE7uNWyMYcPQ/7jCxLGjuO6SYjLTUi/EH1FE5IySrvRjYWYU5mZSOMiG4XB7d3ToqLWD/UeDjUNrdOOwed9RXt1ykM5gw3DL7Ak88rn5mGlPQETCo9I/R2ZGQU4GBTkZzJp45g1Da3s3//HWLn7w6+0sr6nnrkj5BU4qIvIBzdMfRmZGfk4Gf3H9DK6aWsC3nt/MrqbjYccSkSQWU+mb2U1mts3M6szs6wO8/oCZbTGzDWb2azOb3O+1XjOrDb6eH8rwI0VqivH9u+aSnprCfcvW0X3a7CERkQtl0NI3s1TgEeBmYCZwt5nNPG2xdUDE3ecAK4C/7/faCXefG3wtHqLcI87EsaP429tns77+CD/41faw44hIkorlk/4CoM7dd7p7F7AMWNJ/AXd/zd3bg4ergLKhjZkYPjWnhKrKMh55vY7VO5vDjiMiSSiW0i8F9vZ7XB88dyZ/Bvx3v8dZZlZtZqvM7LZzyJhQvrV4FpMLsvnqz2s5cqI77DgikmRiKf2B5hj6AM9hZp8HIsD3+j09yd0jwOeAh81s2gDr3RtsGKobGxtjiDRy5WSm8fDSeRw61sk3ntmI+4B/lSIiwyKW0q8H+s8zLAP2nb6QmX0C+Aaw2N07Tz7v7vuC7zuB14F5p6/r7o+6e8TdI8XFg97MfcSbWz6Wr95wEb/YsJ+n1zaEHUdEkkgspb8GmGFmU8wsA1gKnDILx8zmAT8iWviH+j2fb2aZwc9FwCJgy1CFH8m++NFpLJhSwF89t4ndzZrGKSIXxqCl7+49wJeBl4GtwJPuvtnMHjKzk7NxvgfkAstPm5p5KVBtZuuB14DvurtKn+g0zn/67FxSUoz7ltVqGqeIXBAWb2PKkUjEq6urw45xwbywfh9f+dk6/uLj03ngxovDjiMiI5SZ1QTHTz+UzsgN2acvn8gd88v44Wt1rNnVEnYcEUlwKv048O0lsyjLz+b+ZZrGKSLDS6UfB3Iz03h46VwOHO3gr57bFHYcEUlgKv04MX9SPvddP4Pnavfx7DpN4xSR4aHSjyNfum46V1Tk881nN7G3pX3wFUREzpJKP46cvBqnAff/vJYeTeMUkSGm0o8z5QXZ/PXtl1Gz+zA/fK0u7DgikmBU+nFoydxSbp9Xyj//ejs1uzWNU0SGjko/Tj20ZBal+aO4/+e1HOvQNE4RGRoq/Tg1Oiudhz87l4bDJ3jwuc1hxxGRBKHSj2OVkwv4ysdn8PS6Bp6r1TROETl/Kv0495WPT2f+pLF88xlN4xSR86fSj3NpqSn8YOk8HHjgSU3jFJHzo9IfAcoLsvnObbNYs+sw//L6jrDjiMgIptIfIW6bW8riyyfy8K+3s3bP4bDjiMgIpdIfIcyM79x2GRPGZHH/slraOnvCjiQiI5BKfwTJG5XOw0vnUn+4XdM4ReScqPRHmCsqCvjyddN5am09L6z/g/vTi4h8KJX+CPSV62cwt3ws33hmIw2tJ8KOIyIjiEp/BEpPTeEHS+fS2+d89ee19PbF132ORSR+qfRHqMmFOXx7yWW8814L//pbTeMUkdio9EewO+aXcuucEv7p1XdZv7c17DgiMgKo9EcwM+NvbpvNuNGZ3LdsHcc1jVNEBqHSH+HystP5p8/OZXdLO99+QdM4ReTDqfQTwJVTC/mfH5vGk9X1vLhxf9hxRCSOqfQTxP2fuIjLy/L4y6c3sk/TOEXkDFT6CSI9NYWHl86ju7ePB57UNE4RGZhKP4FMKcrhW5+exaqdLTz6u51hxxGROKTSTzBVkTJumT2Bf3xlGxvrj4QdR0TijEo/wZgZf3v7bIqDaZztXZrGKSIfUOknoLHZGfzjXZfzXvNxvvOLLWHHEZE4otJPUAunFfHn107jZ+/s5aVNB8KOIyJxQqWfwB644SJml+bx9ac3cOBIR9hxRCQOqPQTWEZaCg8vnUtndx9fW15Ln6ZxiiS9mErfzG4ys21mVmdmXx/g9QfMbIuZbTCzX5vZ5H6v3WNm24Ove4YyvAxuWnEuD356Jm/WNfPjlZrGKZLsBi19M0sFHgFuBmYCd5vZzNMWWwdE3H0OsAL4+2DdAuBB4EpgAfCgmeUPXXyJxWevKOeTs8bzvZe3salB0zhFklksn/QXAHXuvtPdu4BlwJL+C7j7a+7eHjxcBZQFP38SeNXdW9z9MPAqcNPQRJdYmRnf/cwcCnIyuG/ZOk509YYdSURCEkvplwJ7+z2uD547kz8D/vts1jWze82s2syqGxsbY4gkZys/J4Pv3zWXnU3H+etfahqnSLKKpfRtgOcGPCJoZp8HIsD3zmZdd3/U3SPuHikuLo4hkpyLRdOLuPcjU3li9R5e2axpnCLJKJbSrwfK+z0uA/advpCZfQL4BrDY3TvPZl25cL5248XMmjiG//3UBg4d1TROkWQTS+mvAWaY2RQzywCWAs/3X8DM5gE/Ilr4h/q99DJwo5nlBwdwbwyek5BkpKXwg6XzONHdy9eWr9c0TpEkM2jpu3sP8GWiZb0VeNLdN5vZQ2a2OFjse0AusNzMas3s+WDdFuA7RDcca4CHguckRNPH5fJ/b53JG9ubWLZm7+AriEjCMPf4+qQXiUS8uro67BgJz91Z/MM36elz/vu+j4QdR0TOk5nVuHtksOV0Rm6SMjPuipSxdf9Rzd0XSSIq/SS2+PJSMtJSWF6tIR6RZKHST2J52el8ctYEnlu/j84enbAlkgxU+kmuqrKM1vZufrXl0OALi8iIp9JPcoumF1GSl8XyGg3xiCQDlX6SS00x7phfxu/ebdQ190WSgEpfuLOyjD6Hp9bWhx1FRIaZSl+oKMphwZQCVtTUE2/nbYjI0FLpCxA9oPte03Fqdh8OO4qIDCOVvgBwy+wSsjNSWV6tIR6RRKbSFwByMtP41OwSfrFhH+1dPWHHEZFhotKX91VFyjne1cuLG3WtfZFEpdKX911RkU9FYbYuyyCSwFT68j4zoypSzur3WtjT3D74CiIy4qj05RSfmV9KisEKnaErkpBU+nKKkrxRXDOjmBU19fTqrloiCUelL3+gqrKMfUc6eGtHU9hRRGSIqfTlD9wwczx5o9I1Z18kAan05Q9kpaeyZO5EXt58gCMnusOOIyJDSKUvA6qqLKezp48X1u8LO4qIDCGVvgzostIxXDJhNMtrNMQjkkhU+jIgM+POyjLW723l3YPHwo4jIkNEpS9ndPu8UtJSTGfoiiQQlb6cUWFuJtdfOo5n1jXQ3dsXdhwRGQIqfflQVZXlNLV18fq2xrCjiMgQUOnLh/rYxcUU5WZqiEckQaj05UOlpabwmfml/Ob3h2hq6ww7joicJ5W+DKqqsoyePufZdQ1hRxGR86TSl0HNGD+aueVjWV6tG6eLjHQqfYlJVaSMbQePsbHhSNhRROQ8qPQlJp++fCKZaSm6CJvICKfSl5iMyUrnpssm8FxtAx3dvWHHEZFzpNKXmFVVlnO0o4dXthwMO4qInKOYSt/MbjKzbWZWZ2ZfH+D1a81srZn1mNmdp73Wa2a1wdfzQxVcLryF0wopHTtKc/ZFRrBBS9/MUoFHgJuBmcDdZjbztMX2AH8C/HSAtzjh7nODr8XnmVdClJJi3FFZxsq6Jva1ngg7joicg1g+6S8A6tx9p7t3AcuAJf0XcPdd7r4B0AVaElxVZRnu8PRaHdAVGYliKf1SoP/+fH3wXKyyzKzazFaZ2W0DLWBm9wbLVDc26hov8ay8IJurphawvEZz9kVGolhK3wZ47mz+t09y9wjwOeBhM5v2B2/m/qi7R9w9UlxcfBZvLWGoqixnd3M777zXEnYUETlLsZR+PVDe73EZEPM99Nx9X/B9J/A6MO8s8kkcunn2BHIz03RXLZERKJbSXwPMMLMpZpYBLAVimoVjZvlmlhn8XAQsAraca1iJD9kZadw6p4QXN+7neGdP2HFE5CwMWvru3gN8GXgZ2Ao86e6bzewhM1sMYGZXmFk9UAX8yMw2B6tfClSb2XrgNeC77q7STwBVkTLau3r55cb9YUcRkbNg8XYwLhKJeHV1ddgxZBDuzvXf/y2FORks/+LCsOOIJD0zqwmOn34onZEr5+TkjdPX7DrMe03Hw44jIjFS6cs5u2N+GSkGK2p0hq7ISKHSl3M2fkwWH72omKdqGujti69hQhEZmEpfzktVpJwDRztYWdcUdhQRiYFKX87L9ZeOY2x2Ok/qImwiI4JKX85LZloqt80t5dXNB2lt7wo7jogMQqUv560qUkZXbx/Pr4/5RG0RCYlKX87brIl5zCwZo1spiowAKn0ZElWRMjY2HGHr/qNhRxGRD6HSlyGxZG4p6ammT/sicU6lL0OiICeDT1w6nmdrG+jq0b10ROKVSl+GzF2RclqOd/Gb3x8KO4qInIFKX4bMR2YUMW50pi7LIBLHVPoyZNJSU/jM/DJe29bIoWMdYccRkQGo9GVIVUXK6O1znlnbEHYUERmASl+G1LTiXOZPGqsbp4vEKZW+DLm7IuXUHWqjdm9r2FFE5DQqfRlyn5pTQlZ6im6cLhKHVPoy5EZnpXPLZSW8ULuPE129YccRkX5U+jIs7oyUcayzh5c3Hwg7ioj0o9KXYXHVlELK8kexXHP2ReKKSl+GRUpK9Mbpb+1opv5we9hxRCSg0pdhc2dlGQBP1WjOvki8UOnLsCnLz2bhtEJWrN1Ln26cLhIXVPoyrKoqy9nbcoJV7zWHHUVEUOnLMPvkrAmMzkxjha6zLxIXVPoyrEZlpHLr5RN5cdN+jnV0hx1HJOmp9GXY3RUpo6O7j19u2B92FJGkp9KXYTe3fCzTx+XqsgwicUClL8POzKiqLKNm92HqDrWFHUckqan05YK4fX4pqSnGCn3aFwmVSl8uiHGjs/jYRcU8vbaenl7dOF0kLCp9uWCqIuUcOtbJG9ubwo4ikrRiKn0zu8nMtplZnZl9fYDXrzWztWbWY2Z3nvbaPWa2Pfi6Z6iCy8jz8UvGUZCToYuwiYRo0NI3s1TgEeBmYCZwt5nNPG2xPcCfAD89bd0C4EHgSmAB8KCZ5Z9/bBmJMtJSuG1uKa9uOUjL8a6w44gkpVg+6S8A6tx9p7t3AcuAJf0XcPdd7r4BOH2w9pPAq+7e4u6HgVeBm4Ygt4xQVZEyunud52p1ETaRMMRS+qVA//3x+uC5WJzPupKALi0Zw2WlY1iuyzKIhCKW0rcBnov1kokxrWtm95pZtZlVNzY2xvjWMlLdFSlny/6jbN53JOwoIkknltKvB8r7PS4D9sX4/jGt6+6PunvE3SPFxcUxvrWMVIsvn0hGaoo+7YuEIJbSXwPMMLMpZpYBLAWej/H9XwZuNLP84ADujcFzksTGZmdww6zxPFvbQGePbpwuciENWvru3gN8mWhZbwWedPfNZvaQmS0GMLMrzKweqAJ+ZGabg3VbgO8Q3XCsAR4KnpMkV1VZRmt7N7/eeijsKCJJxdzj645GkUjEq6urw44hw6y3z1n03d9waclo/v1PF4QdR2TEM7Mad48MtpzOyJVQpKYYd1SW8tt3Gzl4tCPsOCJJQ6Uvobmzspw+h6fXas6+yIWi0pfQTCnK4YqKfJZX7yXehhlFEpVKX0JVVVnOzqbjrN1zOOwoIklBpS+humVOCaPSUzVnX+QCUelLqHIz0/jUnBJ+sWE/7V09YccRSXgqfQldVWUZbZ09vLTpQNhRRBKeSl9Ct2BKAZMLs3myWtfZFxluKn0JnZlx5/wyVu1sYU9ze9hxRBKaSl/iwh2VZZjBirU6oCsynFT6Ehcmjh3FNdOLeKqmnr4+zdkXGS4qfYkbVZFyGlpP8PbO5rCjiCQslb7EjRtnjmdMVpoO6IoMI5W+xI2s9FQWz53IS5sOcOREd9hxRBKSSl/iSlVlOZ09ffzdS7+n8Vhn2HFEEk5a2AFE+ptTlsft80r56eo9LK/ey6dml/CFhRXMKx+L2UC3XBaRs6GbqEhc2tHYxn++vZsVNfW0dfYwpyyPL1xdwa1zSshKTw07nkjcifUmKip9iWttnT08s7aex97eTd2hNgpyMlh6RTl/dNVkSseOCjueSNxQ6UtCcXfe3tHMY2/v4tUtBwG4YeZ47llYwdVTCzX0I0kv1tLXmL6MCGbGwulFLJxeRP3hdp5YvYdl7+zh5c0HmTEuly8srOAz80rJydQ/aZEPo0/6MmJ1dPfywvp9PPb2LjY1HGV0Zhp3VJbxhasnM7U4N+x4IheUhnckabg76/a28thbu3hx4366e51rLyrmnqsn87GLx5GaoqEfSXwqfUlKh451sOydvTyxejcHj3YyqSCbP75qMndFysnLTg87nsiwUelLUuvu7ePlzQd4/K3dvLOrhaz0FG6fV8oXrq7g0pIxYccTGXIqfZHAln1HefztXTxb20BHdx8LKgq4Z2EFN84aT3qqTkqXxKDSFzlNa3sXy6vreXzVLva2nGD8mEz+6MrJ3L1gEsWjM8OOJ3JeVPoiZ9Db57y+7RCPvb2b373bSHqq6XIPMuJpnr7IGaSmGNdfOp7rLx3PzsY2Hg8u9/Bs7T5d7kESnj7pixBc7mFdA4+/tYvth9rIz05n6YJJfF6Xe5ARQsM7IufgjJd7uLqCq6fpcg8SvzS8I3IO+l/uoaH1BP+1avcpl3tYNL2I4tGZFOVmUJSbGf0KHmemaThI4p8+6YsMoqO7l19s2M8Tq3dTd7CNY509Ay43Jist2ABkUpzbb8MwOnjcb2Oh4wUy1PRJX2SIZKWncmdlGXdWlgHRjUBTWydNbV00HesMfu6k8Vj0uca2TrYeOErTsU6Odgy8gRidmXbKRqA42FgUndxYnNxQ5GYyKkMbCBk6MZW+md0E/ABIBX7s7t897fVM4HGgEmgGPuvuu8ysAtgKbAsWXeXuXxya6CLhyEpPpSw/m7L87EGX7ezppbmtK9ggdL6/sej/+N2Dx3hrR/MZ7wuck5F66kZhdL+hpdxMikdnML14tC4zITEZtPTNLBV4BLgBqAfWmNnz7r6l32J/Bhx29+lmthT4O+CzwWs73H3uEOcWGREy01KZOHYUE2OYAdTV00fz8U6ajnVF9xze33v4YK9iR2Mbq9/r5HD7qRuIFIPLSvNYOK2Ia6YXEanI1xCSDCiWT/oLgDp33wlgZsuAJUD/0l8CfCv4eQXwQ9M0B5GzkpGWQkneKEryBt9AdPf20dzW9f6wUu3eVt7a0cSP39jJv/52BxlpKVROymfR9EIWTi9iTmkeabrkhBBb6ZcCe/s9rgeuPNMy7t5jZkeAwuC1KWa2DjgKfNPd3zi/yCKSnprChLwsJuRlAXDdJeP46g0X0dbZw5r3Wnizrok3dzTzD6+8C6+8y+jMNK6cWsii6YUsml7EjHG5mn6apGIp/YH+ZZw+5edMy+wHJrl7s5lVAs+a2Sx3P3rKymb3AvcCTJo0KYZIIjKQ3Mw0rrtkHNddMg6AprZO3t7RzFs7mnizrplfbY2ee1A8OpNF06J7AYumF+kEtCQSS+nXA+X9HpcB+86wTL2ZpQF5QItH54N2Arh7jZntAC4CTpmT6e6PAo9CdMrmOfw5RGQARbmZfPryiXz68okA7G1pf38vYGVdE8/WRv8rVxRmsyjYAFw9tZD8nIwwY8swiqX01wAzzGwK0AAsBT532jLPA/cAbwN3Ar9xdzezYqLl32tmU4EZwM4hSy8iZ6W8IJulCyaxdMEk3J1tB4+xcnsTb+1o5tl1DTyxeg9mMLNkzPsbgSsq8snO0OzuRBHTyVlmdgvwMNEpm//m7n9jZg8B1e7+vJllAf8JzANagKXuvtPM7gAeAnqAXuBBd3/hw36XTs4SCUd3bx8b6lt5sy66F7Buz2G6e530VGPepHwWTSti0fRCLi8fq/sQxCFde0dEzkt7Vw9rdh3mrbom3tzRxOZ9R3GPnjdw5dRCFk6LHhS+ePxoUnQf4tDpjFwROS/ZGWl89KJiPnpRMQCHj3fx9s5m3qyLDgf95veHACjMyYgeEA42AuUFg5+0JuHRJ30ROScNrSeiG4DgwHDjsU4AygtGBUNBRSycVkhhru5KdiFoeEdELhh3p+5QGyvrolNDV+9sfv/CdDNLxvCRGdGNwIIpBTpTeJio9EUkND29fWxsOMKbdU28sb2JtcFB4Yy0FK6oyGfR9CI+Mr2YWRPH6HjAEFHpi0jcON7Zwzu7Wli5vYmV25vYdvAYAGOz01k0rYhrZkSvGaTjAedOB3JFJG7kZKZx3cXjuO7i6JnCh4518GZdEyu3N7OyrpFfbtwPwOTCbK6ZHt0ALJxWpCuHDgN90heRULk7OxrbeCPYC1i1s5njXb2kGMwuzeOa4HhA5eR83Z3sQ2h4R0RGpO7ePmr3tkaHguqaqN3bSm+fMyo9lQVTCqJ7AjOKuGTCaF00rh+VvogkhKMd3aze2cLK7Y28UdfEzsbjABTlZrAoGAq6ZkZRTJekTmQa0xeRhDAmK50bZo7nhpnjAdjXeiKYGhr9ei64aNy04hw+MqOYRdOLuGpqAaOzdDxgIPqkLyIjVl/fBxeNe6OuiXfea6aju4/UFGNe+djo1NAZRUlxvSAN74hI0uns6aVm92FWbo/uBWxoOIJ79D4DV0394HjAtOLEu4mMhndEJOlkpqWycFp0uidAa3sXb+9o5o266MygX209dMryZtE7QJlZ8B2M6JMpwc+nL0O/xyl26rqcsnx0/ZPLvP/7Bnrf4OeZE/P4f3fPG9a/I5W+iCSssdkZ3Dy7hJtnlwCwp7mdN3c0sf9IB7jjgDs4Hnz/4DEOff6Hz58cHPFg/dOX4eR79Vu+r997er91vf9jh0kFw38wWqUvIkljUmE2kwqT+5asiX1kQ0RETqHSFxFJIip9EZEkotIXEUkiKn0RkSSi0hcRSSIqfRGRJKLSFxFJInF37R0zawR2n8dbFAFNQxRnKCnX2VGus6NcZycRc0129+LBFoq70j9fZlYdy0WHLjTlOjvKdXaU6+wkcy4N74iIJBGVvohIEknE0n807ABnoFxnR7nOjnKdnaTNlXBj+iIicmaJ+ElfRETOIGFK38z+zcwOmdmmsLOcZGblZvaamW01s81mdl/YmQDMLMvM3jGz9UGub4edqT8zSzWzdWb2i7CznGRmu8xso5nVmlnc3M/TzMaa2Qoz+33w7+zqsDMBmNnFwd/Vya+jZnZ/HOT6avBvfpOZ/czMssLOBGBm9wWZNg/331PCDO+Y2bVAG/C4u18Wdh4AMysBStx9rZmNBmqA29x9S8i5DMhx9zYzSwdWAve5+6owc51kZg8AEWCMu98adh6Ilj4Qcfe4mtttZo8Bb7j7j80sA8h299awc/VnZqlAA3Clu5/POTjnm6OU6L/1me5+wsyeBF509/8IK1OQ6zJgGbAA6AJeAv6Hu28fjt+XMJ/03f13QEvYOfpz9/3uvjb4+RiwFSgNNxV4VFvwMD34ioutv5mVAZ8Cfhx2lnhnZmOAa4GfALh7V7wVfuB6YEeYhd9PGjDKzNKAbGBfyHkALgVWuXu7u/cAvwVuH65fljClH+/MrAKYB6wON0lUMIRSCxwCXnX3uMgFPAz8L6Av7CCnceAVM6sxs3vDDhOYCjQC/x4Mh/3YzHLCDjWApcDPwg7h7g3APwB7gP3AEXd/JdxUAGwCrjWzQjPLBm4Byofrl6n0LwAzywWeAu5396Nh5wFw9153nwuUAQuCXcxQmdmtwCF3rwk7ywAWuft84GbgS8FwYtjSgPnAv7j7POA48PVwI50qGHJaDCyPgyz5wBJgCjARyDGzz4ebCtx9K/B3wKtEh3bWAz3D9ftU+sMsGDN/CnjC3Z8OO8/pguGA14GbQo4CsAhYHIyfLwM+bmb/FW6kKHffF3w/BDxDdPw1bPVAfb+9tBVENwLx5GZgrbsfDDsI8AngPXdvdPdu4GlgYciZAHD3n7j7fHe/lugw9bCM54NKf1gFB0x/Amx19++HneckMys2s7HBz6OI/mf4fbipwN3/0t3L3L2C6JDAb9w99E9iZpYTHIgnGD65kegueajc/QCw18wuDp66Hgh1ksAA7iYOhnYCe4CrzCw7+L95PdHjbKEzs3HB90nAZxjGv7O04XrjC83MfgZ8DCgys3rgQXf/SbipWAT8MbAxGD8H+D/u/mKImQBKgMeCWRUpwJPuHjfTI+PQeOCZaE+QBvzU3V8KN9L7vgI8EQyj7AQlkdmwAAAAZklEQVT+NOQ87wvGp28A/jzsLADuvtrMVgBriQ6frCN+zsx9yswKgW7gS+5+eLh+UcJM2RQRkcFpeEdEJImo9EVEkohKX0Qkiaj0RUSSiEpfRCSJqPRFRJKISl9EJImo9EVEksj/B2KRx+wXT50KAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.plot(episodes[\"length_first_dig\"].value_counts(normalize=True))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "podcasts[\"multi_categories\"] = podcasts[\"categories\"].str.contains(\"|\", regex=False).astype(\"int64\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Kids & Family',\n",
       " 'Health',\n",
       " 'Society & Culture',\n",
       " 'Technology',\n",
       " 'Science & Medicine',\n",
       " 'Government & Organizations',\n",
       " 'Religion & Spirituality',\n",
       " 'Business',\n",
       " 'Arts',\n",
       " 'Games & Hobbies',\n",
       " 'Sports & Recreation',\n",
       " 'Music',\n",
       " 'Education',\n",
       " 'Comedy',\n",
       " 'TV & Film',\n",
       " 'News & Politics']"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres = list(set(podcasts[podcasts[\"multi_categories\"] == 0][\"categories\"]))\n",
    "genres"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "left_out_genre = []\n",
    "for pod in podcasts[\"categories\"]:\n",
    "    count = 0\n",
    "    for genre in genres:\n",
    "        if not genre in pod:\n",
    "            count += 1\n",
    "    if count == len(genres):\n",
    "        left_out_genre.append(pod)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "left_out_genre"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## EDA (11/30)\n",
    "________________"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "metadata": {},
   "outputs": [],
   "source": [
    "podcasts = pd.read_csv(\"Cleaned data/clean_podcasts.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>episode_title</th>\n",
       "      <th>audio</th>\n",
       "      <th>text</th>\n",
       "      <th>audio_length</th>\n",
       "      <th>podcast_title</th>\n",
       "      <th>News &amp; Politics_genre</th>\n",
       "      <th>Sports &amp; Recreation_genre</th>\n",
       "      <th>Government &amp; Organizations_genre</th>\n",
       "      <th>Comedy_genre</th>\n",
       "      <th>Arts_genre</th>\n",
       "      <th>...</th>\n",
       "      <th>Games &amp; Hobbies_genre</th>\n",
       "      <th>TV &amp; Film_genre</th>\n",
       "      <th>Society &amp; Culture_genre</th>\n",
       "      <th>Technology_genre</th>\n",
       "      <th>Health_genre</th>\n",
       "      <th>Science &amp; Medicine_genre</th>\n",
       "      <th>Kids &amp; Family_genre</th>\n",
       "      <th>Business_genre</th>\n",
       "      <th>Religion &amp; Spirituality_genre</th>\n",
       "      <th>Education_genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Introduction to Luke</td>\n",
       "      <td>http://www.wgcr.net/images/TimelessTruths/TTT-...</td>\n",
       "      <td>luke 1:1 4</td>\n",
       "      <td>1691</td>\n",
       "      <td>Teaching Timeless Truths</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          episode_title                                              audio  \\\n",
       "0  Introduction to Luke  http://www.wgcr.net/images/TimelessTruths/TTT-...   \n",
       "\n",
       "          text  audio_length             podcast_title  News & Politics_genre  \\\n",
       "0  luke 1:1 4           1691  Teaching Timeless Truths                      0   \n",
       "\n",
       "   Sports & Recreation_genre  Government & Organizations_genre  Comedy_genre  \\\n",
       "0                          0                                 0             0   \n",
       "\n",
       "   Arts_genre  ...  Games & Hobbies_genre  TV & Film_genre  \\\n",
       "0           0  ...                      0                0   \n",
       "\n",
       "   Society & Culture_genre  Technology_genre  Health_genre  \\\n",
       "0                        0                 0             0   \n",
       "\n",
       "   Science & Medicine_genre  Kids & Family_genre  Business_genre  \\\n",
       "0                         0                    0               0   \n",
       "\n",
       "   Religion & Spirituality_genre  Education_genre  \n",
       "0                              1                0  \n",
       "\n",
       "[1 rows x 21 columns]"
      ]
     },
     "execution_count": 169,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "podcasts.head(1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### How many podcasts have more than three genres?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {},
   "outputs": [],
   "source": [
    "genres = [genre for genre in podcasts.columns if \"_genre\" in genre]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 171,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "16"
      ]
     },
     "execution_count": 171,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(genres)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "metadata": {},
   "outputs": [],
   "source": [
    "podcasts[\"total_genres\"] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "metadata": {},
   "outputs": [],
   "source": [
    "for genre in genres:\n",
    "    podcasts[\"total_genres\"] += podcasts[genre]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "247\n"
     ]
    }
   ],
   "source": [
    "# number of episodes that have more than 5 genres\n",
    "print(len(podcasts[podcasts[\"total_genres\"] > 5]['podcast_title']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 175,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "41\n"
     ]
    }
   ],
   "source": [
    "# the number of podcasts that have more than 5 genres\n",
    "print(len(set(podcasts[podcasts[\"total_genres\"] > 5]['podcast_title'])))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.0004170381176216333"
      ]
     },
     "execution_count": 176,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# this is less than half a percent of the data. I think that it is justifiably dropped\n",
    "\n",
    "drop = len(podcasts[podcasts[\"total_genres\"] > 5]['podcast_title'])\n",
    "\n",
    "drop/ len(podcasts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {},
   "outputs": [],
   "source": [
    "podcasts.drop(podcasts[podcasts[\"total_genres\"] > 5].index, inplace=True)\n",
    "podcasts.reset_index(drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 178,
   "metadata": {},
   "outputs": [],
   "source": [
    "podcasts[\"text_lengths\"] = [len(s) for s in podcasts[\"text\"]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### How many podcasts have lengthy enough descriptions?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "metadata": {},
   "outputs": [],
   "source": [
    "long_pods = podcasts[\"text_lengths\"] > 100000\n",
    "\n",
    "podcasts.drop(podcasts[long_pods].index, inplace = True)\n",
    "podcasts.reset_index(drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>episode_title</th>\n",
       "      <th>audio</th>\n",
       "      <th>text</th>\n",
       "      <th>audio_length</th>\n",
       "      <th>podcast_title</th>\n",
       "      <th>News &amp; Politics_genre</th>\n",
       "      <th>Sports &amp; Recreation_genre</th>\n",
       "      <th>Government &amp; Organizations_genre</th>\n",
       "      <th>Comedy_genre</th>\n",
       "      <th>Arts_genre</th>\n",
       "      <th>...</th>\n",
       "      <th>Society &amp; Culture_genre</th>\n",
       "      <th>Technology_genre</th>\n",
       "      <th>Health_genre</th>\n",
       "      <th>Science &amp; Medicine_genre</th>\n",
       "      <th>Kids &amp; Family_genre</th>\n",
       "      <th>Business_genre</th>\n",
       "      <th>Religion &amp; Spirituality_genre</th>\n",
       "      <th>Education_genre</th>\n",
       "      <th>total_genres</th>\n",
       "      <th>text_lengths</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>5866</td>\n",
       "      <td>Sugar Industry False PR and Facts</td>\n",
       "      <td>http://www.ddsradio.com/wp-content/uploads/201...</td>\n",
       "      <td>dr shoup</td>\n",
       "      <td>2706</td>\n",
       "      <td>Dr. Shoup Radio</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5867</td>\n",
       "      <td>Sex Trafficking Across America</td>\n",
       "      <td>http://www.ddsradio.com/wp-content/uploads/201...</td>\n",
       "      <td>dr shoup</td>\n",
       "      <td>2702</td>\n",
       "      <td>Dr. Shoup Radio</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5868</td>\n",
       "      <td>Beware of Improper Dental Implants</td>\n",
       "      <td>http://www.ddsradio.com/wp-content/uploads/201...</td>\n",
       "      <td>dr shoup</td>\n",
       "      <td>2708</td>\n",
       "      <td>Dr. Shoup Radio</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5869</td>\n",
       "      <td>Bad Snoring and Apnea Leads to Heart Failure</td>\n",
       "      <td>http://www.ddsradio.com/wp-content/uploads/201...</td>\n",
       "      <td>dr shoup</td>\n",
       "      <td>2646</td>\n",
       "      <td>Dr. Shoup Radio</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20983</td>\n",
       "      <td>Hoch Hurricane Pump Up</td>\n",
       "      <td>http://www.podtrac.com/pts/redirect.mp3/omnyst...</td>\n",
       "      <td>&lt;p&gt;enjoy&lt; p&gt;</td>\n",
       "      <td>734</td>\n",
       "      <td>560 WQAM</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>591593</td>\n",
       "      <td>Rockhouse - Show #169</td>\n",
       "      <td>http://www.oldies104.net/podcast/media/rockhou...</td>\n",
       "      <td>12 21 2017</td>\n",
       "      <td>11261</td>\n",
       "      <td>Rockhouse on Oldies 104</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>591594</td>\n",
       "      <td>Rockhouse - Show #168</td>\n",
       "      <td>http://www.oldies104.net/podcast/media/rockhou...</td>\n",
       "      <td>12 14 2017</td>\n",
       "      <td>10655</td>\n",
       "      <td>Rockhouse on Oldies 104</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>591595</td>\n",
       "      <td>Rockhouse - Show #167</td>\n",
       "      <td>http://www.oldies104.net/podcast/media/rockhou...</td>\n",
       "      <td>12 7 2017</td>\n",
       "      <td>11132</td>\n",
       "      <td>Rockhouse on Oldies 104</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>591806</td>\n",
       "      <td>Braising</td>\n",
       "      <td>http://dts.podtrac.com/redirect.mp3/feed.audio...</td>\n",
       "      <td>braising</td>\n",
       "      <td>2911</td>\n",
       "      <td>Foreman and Wolf on Food and Wine on WYPR</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>591807</td>\n",
       "      <td>Openings</td>\n",
       "      <td>http://dts.podtrac.com/redirect.mp3/feed.audio...</td>\n",
       "      <td>openings</td>\n",
       "      <td>2909</td>\n",
       "      <td>Foreman and Wolf on Food and Wine on WYPR</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3556 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       episode_title  \\\n",
       "5866               Sugar Industry False PR and Facts   \n",
       "5867                  Sex Trafficking Across America   \n",
       "5868              Beware of Improper Dental Implants   \n",
       "5869    Bad Snoring and Apnea Leads to Heart Failure   \n",
       "20983                         Hoch Hurricane Pump Up   \n",
       "...                                              ...   \n",
       "591593                         Rockhouse - Show #169   \n",
       "591594                         Rockhouse - Show #168   \n",
       "591595                         Rockhouse - Show #167   \n",
       "591806                                      Braising   \n",
       "591807                                      Openings   \n",
       "\n",
       "                                                    audio          text  \\\n",
       "5866    http://www.ddsradio.com/wp-content/uploads/201...      dr shoup   \n",
       "5867    http://www.ddsradio.com/wp-content/uploads/201...      dr shoup   \n",
       "5868    http://www.ddsradio.com/wp-content/uploads/201...      dr shoup   \n",
       "5869    http://www.ddsradio.com/wp-content/uploads/201...      dr shoup   \n",
       "20983   http://www.podtrac.com/pts/redirect.mp3/omnyst...  <p>enjoy< p>   \n",
       "...                                                   ...           ...   \n",
       "591593  http://www.oldies104.net/podcast/media/rockhou...    12 21 2017   \n",
       "591594  http://www.oldies104.net/podcast/media/rockhou...    12 14 2017   \n",
       "591595  http://www.oldies104.net/podcast/media/rockhou...     12 7 2017   \n",
       "591806  http://dts.podtrac.com/redirect.mp3/feed.audio...      braising   \n",
       "591807  http://dts.podtrac.com/redirect.mp3/feed.audio...      openings   \n",
       "\n",
       "        audio_length                              podcast_title  \\\n",
       "5866            2706                            Dr. Shoup Radio   \n",
       "5867            2702                            Dr. Shoup Radio   \n",
       "5868            2708                            Dr. Shoup Radio   \n",
       "5869            2646                            Dr. Shoup Radio   \n",
       "20983            734                                   560 WQAM   \n",
       "...              ...                                        ...   \n",
       "591593         11261                    Rockhouse on Oldies 104   \n",
       "591594         10655                    Rockhouse on Oldies 104   \n",
       "591595         11132                    Rockhouse on Oldies 104   \n",
       "591806          2911  Foreman and Wolf on Food and Wine on WYPR   \n",
       "591807          2909  Foreman and Wolf on Food and Wine on WYPR   \n",
       "\n",
       "        News & Politics_genre  Sports & Recreation_genre  \\\n",
       "5866                        0                          0   \n",
       "5867                        0                          0   \n",
       "5868                        0                          0   \n",
       "5869                        0                          0   \n",
       "20983                       0                          1   \n",
       "...                       ...                        ...   \n",
       "591593                      0                          0   \n",
       "591594                      0                          0   \n",
       "591595                      0                          0   \n",
       "591806                      0                          0   \n",
       "591807                      0                          0   \n",
       "\n",
       "        Government & Organizations_genre  Comedy_genre  Arts_genre  ...  \\\n",
       "5866                                   0             0           0  ...   \n",
       "5867                                   0             0           0  ...   \n",
       "5868                                   0             0           0  ...   \n",
       "5869                                   0             0           0  ...   \n",
       "20983                                  0             0           0  ...   \n",
       "...                                  ...           ...         ...  ...   \n",
       "591593                                 0             0           1  ...   \n",
       "591594                                 0             0           1  ...   \n",
       "591595                                 0             0           1  ...   \n",
       "591806                                 0             0           1  ...   \n",
       "591807                                 0             0           1  ...   \n",
       "\n",
       "        Society & Culture_genre  Technology_genre  Health_genre  \\\n",
       "5866                          0                 0             1   \n",
       "5867                          0                 0             1   \n",
       "5868                          0                 0             1   \n",
       "5869                          0                 0             1   \n",
       "20983                         0                 0             0   \n",
       "...                         ...               ...           ...   \n",
       "591593                        1                 0             0   \n",
       "591594                        1                 0             0   \n",
       "591595                        1                 0             0   \n",
       "591806                        1                 0             0   \n",
       "591807                        1                 0             0   \n",
       "\n",
       "        Science & Medicine_genre  Kids & Family_genre  Business_genre  \\\n",
       "5866                           0                    0               0   \n",
       "5867                           0                    0               0   \n",
       "5868                           0                    0               0   \n",
       "5869                           0                    0               0   \n",
       "20983                          0                    0               0   \n",
       "...                          ...                  ...             ...   \n",
       "591593                         0                    0               0   \n",
       "591594                         0                    0               0   \n",
       "591595                         0                    0               0   \n",
       "591806                         0                    0               0   \n",
       "591807                         0                    0               0   \n",
       "\n",
       "        Religion & Spirituality_genre  Education_genre  total_genres  \\\n",
       "5866                                0                0             1   \n",
       "5867                                0                0             1   \n",
       "5868                                0                0             1   \n",
       "5869                                0                0             1   \n",
       "20983                               0                0             1   \n",
       "...                               ...              ...           ...   \n",
       "591593                              0                0             3   \n",
       "591594                              0                0             3   \n",
       "591595                              0                0             3   \n",
       "591806                              0                0             2   \n",
       "591807                              0                0             2   \n",
       "\n",
       "        text_lengths  \n",
       "5866               8  \n",
       "5867               8  \n",
       "5868               8  \n",
       "5869               8  \n",
       "20983             12  \n",
       "...              ...  \n",
       "591593            10  \n",
       "591594            10  \n",
       "591595             9  \n",
       "591806             8  \n",
       "591807             8  \n",
       "\n",
       "[3556 rows x 23 columns]"
      ]
     },
     "execution_count": 187,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "podcasts[(podcasts[\"text_lengths\"] < 15) & (podcasts[\"Religion & Spirituality_genre\"] ==0)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 203,
   "metadata": {},
   "outputs": [],
   "source": [
    "cleaning_test = podcasts[(podcasts[\"text\"].str.contains(\">\"))&(podcasts[\"text\"].str.contains(\"<\")) & (podcasts[\"text_lengths\"] < 15)]\n",
    "cleaning_test = cleaning_test[[\"episode_title\", \"text\", \"podcast_title\" ]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "metadata": {},
   "outputs": [],
   "source": [
    "cleaning_test = cleaning_test[[\"episode_title\", \"text\", \"podcast_title\" ]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "metadata": {},
   "outputs": [],
   "source": [
    "example = cleaning_test[\"text\"][20983]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>episode_title</th>\n",
       "      <th>audio</th>\n",
       "      <th>text</th>\n",
       "      <th>audio_length</th>\n",
       "      <th>podcast_title</th>\n",
       "      <th>News &amp; Politics_genre</th>\n",
       "      <th>Sports &amp; Recreation_genre</th>\n",
       "      <th>Government &amp; Organizations_genre</th>\n",
       "      <th>Comedy_genre</th>\n",
       "      <th>Arts_genre</th>\n",
       "      <th>...</th>\n",
       "      <th>Society &amp; Culture_genre</th>\n",
       "      <th>Technology_genre</th>\n",
       "      <th>Health_genre</th>\n",
       "      <th>Science &amp; Medicine_genre</th>\n",
       "      <th>Kids &amp; Family_genre</th>\n",
       "      <th>Business_genre</th>\n",
       "      <th>Religion &amp; Spirituality_genre</th>\n",
       "      <th>Education_genre</th>\n",
       "      <th>total_genres</th>\n",
       "      <th>text_lengths</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Introduction to Luke</td>\n",
       "      <td>http://www.wgcr.net/images/TimelessTruths/TTT-...</td>\n",
       "      <td>luke 1:1 4</td>\n",
       "      <td>1691</td>\n",
       "      <td>Teaching Timeless Truths</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Hear Ye, Hear Ye!</td>\n",
       "      <td>http://www.wgcr.net/images/TimelessTruths/TTT-...</td>\n",
       "      <td>luke 14:5 1:25</td>\n",
       "      <td>1689</td>\n",
       "      <td>Teaching Timeless Truths</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>How Should A King Come</td>\n",
       "      <td>http://www.wgcr.net/images/TimelessTruths/TTT-...</td>\n",
       "      <td>luke 1:26 80</td>\n",
       "      <td>1688</td>\n",
       "      <td>Teaching Timeless Truths</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>The Birthday of a King</td>\n",
       "      <td>http://www.wgcr.net/images/TimelessTruths/TTT-...</td>\n",
       "      <td>luke 2</td>\n",
       "      <td>1688</td>\n",
       "      <td>Teaching Timeless Truths</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>The Birthday of a King</td>\n",
       "      <td>http://www.wgcr.net/images/TimelessTruths/TTT-...</td>\n",
       "      <td>luke 2:1 24</td>\n",
       "      <td>1688</td>\n",
       "      <td>Teaching Timeless Truths</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>592018</td>\n",
       "      <td>FR 17 - 51 - Report From Nigeria - Elijah Brow...</td>\n",
       "      <td>http://feeds.soundcloud.com/stream/359259245-f...</td>\n",
       "      <td>fr 17  51  report from nigeria  elijah brown  ...</td>\n",
       "      <td>872</td>\n",
       "      <td>Freedom's Ring Podcast</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>592019</td>\n",
       "      <td>FR 17 - 52 - Relitigate The Civil War - Greg H...</td>\n",
       "      <td>http://feeds.soundcloud.com/stream/359259239-f...</td>\n",
       "      <td>fr 17  52  relitigate the civil war  greg hami...</td>\n",
       "      <td>872</td>\n",
       "      <td>Freedom's Ring Podcast</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>592020</td>\n",
       "      <td>FR 17 - 53 - Aid For Persecuted Religious Mino...</td>\n",
       "      <td>http://feeds.soundcloud.com/stream/359259236-f...</td>\n",
       "      <td>fr 17  53  aid for persecuted religious minori...</td>\n",
       "      <td>872</td>\n",
       "      <td>Freedom's Ring Podcast</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>592021</td>\n",
       "      <td>FR 18 - 01 - Update On Syria - Elijah Brown - ...</td>\n",
       "      <td>http://feeds.soundcloud.com/stream/359259233-f...</td>\n",
       "      <td>fr 18  01  update on syria  elijah brown  rel ...</td>\n",
       "      <td>872</td>\n",
       "      <td>Freedom's Ring Podcast</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>592022</td>\n",
       "      <td>FR 18 - 02 - The Real Meaning Of No Establishm...</td>\n",
       "      <td>http://feeds.soundcloud.com/stream/359259227-f...</td>\n",
       "      <td>fr 18  02  the real meaning of no establishmen...</td>\n",
       "      <td>872</td>\n",
       "      <td>Freedom's Ring Podcast</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>592023 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            episode_title  \\\n",
       "0                                    Introduction to Luke   \n",
       "1                                       Hear Ye, Hear Ye!   \n",
       "2                                  How Should A King Come   \n",
       "3                                  The Birthday of a King   \n",
       "4                                  The Birthday of a King   \n",
       "...                                                   ...   \n",
       "592018  FR 17 - 51 - Report From Nigeria - Elijah Brow...   \n",
       "592019  FR 17 - 52 - Relitigate The Civil War - Greg H...   \n",
       "592020  FR 17 - 53 - Aid For Persecuted Religious Mino...   \n",
       "592021  FR 18 - 01 - Update On Syria - Elijah Brown - ...   \n",
       "592022  FR 18 - 02 - The Real Meaning Of No Establishm...   \n",
       "\n",
       "                                                    audio  \\\n",
       "0       http://www.wgcr.net/images/TimelessTruths/TTT-...   \n",
       "1       http://www.wgcr.net/images/TimelessTruths/TTT-...   \n",
       "2       http://www.wgcr.net/images/TimelessTruths/TTT-...   \n",
       "3       http://www.wgcr.net/images/TimelessTruths/TTT-...   \n",
       "4       http://www.wgcr.net/images/TimelessTruths/TTT-...   \n",
       "...                                                   ...   \n",
       "592018  http://feeds.soundcloud.com/stream/359259245-f...   \n",
       "592019  http://feeds.soundcloud.com/stream/359259239-f...   \n",
       "592020  http://feeds.soundcloud.com/stream/359259236-f...   \n",
       "592021  http://feeds.soundcloud.com/stream/359259233-f...   \n",
       "592022  http://feeds.soundcloud.com/stream/359259227-f...   \n",
       "\n",
       "                                                     text  audio_length  \\\n",
       "0                                             luke 1:1 4           1691   \n",
       "1                                         luke 14:5 1:25           1689   \n",
       "2                                           luke 1:26 80           1688   \n",
       "3                                                 luke 2           1688   \n",
       "4                                            luke 2:1 24           1688   \n",
       "...                                                   ...           ...   \n",
       "592018  fr 17  51  report from nigeria  elijah brown  ...           872   \n",
       "592019  fr 17  52  relitigate the civil war  greg hami...           872   \n",
       "592020  fr 17  53  aid for persecuted religious minori...           872   \n",
       "592021  fr 18  01  update on syria  elijah brown  rel ...           872   \n",
       "592022  fr 18  02  the real meaning of no establishmen...           872   \n",
       "\n",
       "                   podcast_title  News & Politics_genre  \\\n",
       "0       Teaching Timeless Truths                      0   \n",
       "1       Teaching Timeless Truths                      0   \n",
       "2       Teaching Timeless Truths                      0   \n",
       "3       Teaching Timeless Truths                      0   \n",
       "4       Teaching Timeless Truths                      0   \n",
       "...                          ...                    ...   \n",
       "592018    Freedom's Ring Podcast                      0   \n",
       "592019    Freedom's Ring Podcast                      0   \n",
       "592020    Freedom's Ring Podcast                      0   \n",
       "592021    Freedom's Ring Podcast                      0   \n",
       "592022    Freedom's Ring Podcast                      0   \n",
       "\n",
       "        Sports & Recreation_genre  Government & Organizations_genre  \\\n",
       "0                               0                                 0   \n",
       "1                               0                                 0   \n",
       "2                               0                                 0   \n",
       "3                               0                                 0   \n",
       "4                               0                                 0   \n",
       "...                           ...                               ...   \n",
       "592018                          0                                 0   \n",
       "592019                          0                                 0   \n",
       "592020                          0                                 0   \n",
       "592021                          0                                 0   \n",
       "592022                          0                                 0   \n",
       "\n",
       "        Comedy_genre  Arts_genre  ...  Society & Culture_genre  \\\n",
       "0                  0           0  ...                        0   \n",
       "1                  0           0  ...                        0   \n",
       "2                  0           0  ...                        0   \n",
       "3                  0           0  ...                        0   \n",
       "4                  0           0  ...                        0   \n",
       "...              ...         ...  ...                      ...   \n",
       "592018             0           0  ...                        0   \n",
       "592019             0           0  ...                        0   \n",
       "592020             0           0  ...                        0   \n",
       "592021             0           0  ...                        0   \n",
       "592022             0           0  ...                        0   \n",
       "\n",
       "        Technology_genre  Health_genre  Science & Medicine_genre  \\\n",
       "0                      0             0                         0   \n",
       "1                      0             0                         0   \n",
       "2                      0             0                         0   \n",
       "3                      0             0                         0   \n",
       "4                      0             0                         0   \n",
       "...                  ...           ...                       ...   \n",
       "592018                 0             0                         0   \n",
       "592019                 0             0                         0   \n",
       "592020                 0             0                         0   \n",
       "592021                 0             0                         0   \n",
       "592022                 0             0                         0   \n",
       "\n",
       "        Kids & Family_genre  Business_genre  Religion & Spirituality_genre  \\\n",
       "0                         0               0                              1   \n",
       "1                         0               0                              1   \n",
       "2                         0               0                              1   \n",
       "3                         0               0                              1   \n",
       "4                         0               0                              1   \n",
       "...                     ...             ...                            ...   \n",
       "592018                    0               0                              1   \n",
       "592019                    0               0                              1   \n",
       "592020                    0               0                              1   \n",
       "592021                    0               0                              1   \n",
       "592022                    0               0                              1   \n",
       "\n",
       "        Education_genre  total_genres  text_lengths  \n",
       "0                     0             1            11  \n",
       "1                     0             1            15  \n",
       "2                     0             1            13  \n",
       "3                     0             1             7  \n",
       "4                     0             1            12  \n",
       "...                 ...           ...           ...  \n",
       "592018                0             1            89  \n",
       "592019                0             1            95  \n",
       "592020                0             1           106  \n",
       "592021                0             1            85  \n",
       "592022                0             1           107  \n",
       "\n",
       "[592023 rows x 23 columns]"
      ]
     },
     "execution_count": 229,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "podcasts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Owner\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    }
   ],
   "source": [
    "import re\n",
    "for i, text in zip(podcasts.index, podcasts[\"text\"]):\n",
    "    podcasts[\"text\"][i] = re.sub(\"<[^>]*>\", \"\", text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 228,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "603\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>episode_title</th>\n",
       "      <th>text</th>\n",
       "      <th>podcast_title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>56187</td>\n",
       "      <td>Cattle Current Podcast-December 01</td>\n",
       "      <td></td>\n",
       "      <td>Cattle Current Market Update with Wes Ishmael</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>56188</td>\n",
       "      <td>Cattle Current Podcast-December 4</td>\n",
       "      <td></td>\n",
       "      <td>Cattle Current Market Update with Wes Ishmael</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>56189</td>\n",
       "      <td>Cattle Current Podcast-December 5</td>\n",
       "      <td></td>\n",
       "      <td>Cattle Current Market Update with Wes Ishmael</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>56190</td>\n",
       "      <td>Cattle Current Podcast-December 6</td>\n",
       "      <td></td>\n",
       "      <td>Cattle Current Market Update with Wes Ishmael</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>56191</td>\n",
       "      <td>Cattle Current Podcast-December 7</td>\n",
       "      <td></td>\n",
       "      <td>Cattle Current Market Update with Wes Ishmael</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>585408</td>\n",
       "      <td>The Joy of Christmas</td>\n",
       "      <td></td>\n",
       "      <td>Bear Cove Baptist Sermons</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>586754</td>\n",
       "      <td>GPS Training Podcast – Episode 4 - GPS Trainin...</td>\n",
       "      <td></td>\n",
       "      <td>GPS Training Podcast</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>586862</td>\n",
       "      <td>Ep. 7 - Christmas Time! with The Man Who Inven...</td>\n",
       "      <td></td>\n",
       "      <td>Buddymeister Scores! - Your Podcast about the ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>590188</td>\n",
       "      <td>Dec 24 - \"Jesus Messiah\"</td>\n",
       "      <td></td>\n",
       "      <td>KAC Baptist Church Podcast</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>590190</td>\n",
       "      <td>Dec 10 - The Second Commandment</td>\n",
       "      <td></td>\n",
       "      <td>KAC Baptist Church Podcast</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>309 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            episode_title text  \\\n",
       "56187                  Cattle Current Podcast-December 01        \n",
       "56188                   Cattle Current Podcast-December 4        \n",
       "56189                   Cattle Current Podcast-December 5        \n",
       "56190                   Cattle Current Podcast-December 6        \n",
       "56191                   Cattle Current Podcast-December 7        \n",
       "...                                                   ...  ...   \n",
       "585408                               The Joy of Christmas        \n",
       "586754  GPS Training Podcast – Episode 4 - GPS Trainin...        \n",
       "586862  Ep. 7 - Christmas Time! with The Man Who Inven...        \n",
       "590188                           Dec 24 - \"Jesus Messiah\"        \n",
       "590190                    Dec 10 - The Second Commandment        \n",
       "\n",
       "                                            podcast_title  \n",
       "56187       Cattle Current Market Update with Wes Ishmael  \n",
       "56188       Cattle Current Market Update with Wes Ishmael  \n",
       "56189       Cattle Current Market Update with Wes Ishmael  \n",
       "56190       Cattle Current Market Update with Wes Ishmael  \n",
       "56191       Cattle Current Market Update with Wes Ishmael  \n",
       "...                                                   ...  \n",
       "585408                          Bear Cove Baptist Sermons  \n",
       "586754                               GPS Training Podcast  \n",
       "586862  Buddymeister Scores! - Your Podcast about the ...  \n",
       "590188                         KAC Baptist Church Podcast  \n",
       "590190                         KAC Baptist Church Podcast  \n",
       "\n",
       "[309 rows x 3 columns]"
      ]
     },
     "execution_count": 228,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(cleaning_test.shape[0])\n",
    "cleaning_test[cleaning_test[\"text\"] == \"\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pause and return to clean descriptions with HTML tags through regex\n",
    "#  - What is the word count of the podcast description?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### How many of each type of genre do I have? normalized!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "genre_dist = {genre: np.mean(podcasts[genre]) for genre in genres}\n",
    "genre_dist = pd.DataFrame(genre_dist.values(), index=genre_dist.keys(), columns=[\"genre_percentage\"])\n",
    "genre_dist.sort_values(\"genre_percentage\", inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "genre_dist.index = genre_dist.index.str.replace(\"_genre\", \"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "colors = {'Kids & Family': \"maroon\", \n",
    " 'Science & Medicine': \"maroon\", \n",
    " 'Government & Organizations': \"m\",\n",
    " 'Games & Hobbies': \"navy\", \n",
    " 'Technology': \"navy\", \n",
    " 'Health': \"navy\", \n",
    " 'Arts': \"forestgreen\", \n",
    " 'Education': \"forestgreen\", \n",
    " 'Music': \"forestgreen\",\n",
    " 'TV & Film': \"gold\", \n",
    " 'Business': \"gold\", \n",
    " 'Comedy': \"gold\", \n",
    " 'Society & Culture': \"darkorange\",\n",
    " 'Sports & Recreation': \"darkorange\", \n",
    " 'News & Politics': \"darkorange\", \n",
    " 'Religion & Spirituality': \"firebrick\"}\n",
    "plt.figure(figsize=(5,8))\n",
    "plt.title(\"Genre Distribution\")\n",
    "plt.barh(genre_dist.index, genre_dist[\"genre_percentage\"], color=colors.values())\n",
    "\n",
    "plt.show();"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}