breaking_bad.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.chrome.options import Options\n",
    "import pandas as pd\n",
    "import time\n",
    "\n",
    "\n",
    "options = Options()\n",
    "options.headless = True\n",
    "\n",
    "# Download page\n",
    "browser = webdriver.Chrome(options=options)\n",
    "browser.get('https://breakingbad.fandom.com/wiki/Pilot')\n",
    "soup = BeautifulSoup(browser.page_source, 'html.parser')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "# U.S. viewers: 1.41 million\n"
     ]
    }
   ],
   "source": [
    "# Get number of live viewers\n",
    "def get_viewers_count(soup):\n",
    "    selectors = soup.find_all('h3', {'class': 'pi-data-label'})\n",
    "    for selector in selectors:\n",
    "        if selector.get_text() == 'U.S. Viewers':\n",
    "            return selector.findNextSibling('div').get_text()\n",
    "            \n",
    "num_viewers = get_viewers_count(soup)\n",
    "print('# U.S. viewers:', num_viewers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "# featured music: 15\n"
     ]
    }
   ],
   "source": [
    "\"\"\" Get the number of featured music \"\"\"\n",
    "def get_featured_music_count(soup):\n",
    "    selector = soup.find('span', {'id': 'Featured_Music'})\n",
    "    if selector is None:\n",
    "        return 0\n",
    "    selector = selector.parent.next_sibling.next_sibling\n",
    "    return len(selector.find_all('li'))\n",
    "\n",
    "num_featured_music = get_featured_music_count(soup)\n",
    "print('# featured music:', num_featured_music)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "# references: 2\n"
     ]
    }
   ],
   "source": [
    "\n",
    "def get_ref_count(soup):\n",
    "    selector = soup.find('span', {'id': 'Cultural_references'})\n",
    "    if selector is None:\n",
    "        return 0\n",
    "    selector = selector.parent.findNext('ul')\n",
    "    return len(selector.find_all('li'))\n",
    "\n",
    "num_refs = get_ref_count(soup)\n",
    "print('# references:', num_refs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "In the desert outside of Albuquerque, New Mexico, a man wearing nothing but his underwear and a gas mask erratically drives an RV down a desolate highway. In the passenger seat, another man is passed out, also wearing a gas mask. In the back of the RV are two bodies. After crashing the RV in a ditch, the drivers climbs out, dons a shirt handing from the side view mirror, and retrieves a video camera and gun from the vehicle. Recording a message on the camera, the man identifies himself as Walter White and bids a cryptic farewell to his wife and son as sirens are heard in the distance. Walt then walks onto the road and awaits the apparent approach of police, gun in hand. Three weeks earlier, on his 50th birthday, Walt wakes up before dawn and exercises while contemplating of a plaque on his wall commemorating his contributions to research that won a Nobel Prize. At breakfast, his pregnant wife, Skyler, hands him a plate of eggs topped by veggie bacon spelling out \"50\". They banter with their handicapped son, Walt Jr., who complains about the veggie bacon. Afterwards, Walt drops off Junior at J. P. Wynne High School, where Walt also works as a chemistry teacher. In class, Walt explains to his apathetic students how he regards chemistry as the study of change as well as matter. After school, Walt performs his second job at a car wash, where he finds himself washing the convertible of a disrespectful student. Returning home, Walt discovers that Skyler has organized a surprise birthday party for him. Among the guests is Walts gregarious brother-in-law, Hank Schrader, a DEA agent. Coincidentally, Hank is the subject of a local news report covering a methamphetamine lab bust. Walt is impressed with the amount of money recovered from the dealers, and Hank discloses that he confiscated $700,000. Hank then invites Walt to accompany him on another bust. Meanwhile, in the living room, Skyler talks to her sister Marie, Hanks wife, about her pregnancy. The following day, Walt steals boxes full of chemistry equipment from his high school, while Jesse arranges to buy a used RV so that will be used as the duos mobile meth lab. Upon driving into the desert, Walt strips down to his underwear (so as not to contaminate his clothes with chemical odors) and cooks his first batch of crystal methamphetamine. Jesse is astonished with the chemical purity of the product Walt has produced. Emilio ties up Jesse, then joins Krazy-8 in watching Walt cook. As Walt prepares the ingredients, Emilio absent-mindedly throws a cigarette out the window, thereby starting a brush fire. Inside, Walt mixes chemicals that produce a deadly vapor before he dashes out of the RV. Krazy-8 and Emilio begin firing bullets through the door of the RV over Walts head, but are eventually overcome by the fumes. Walt unties Jesse, puts a gas mask on him, and props him in the passenger seat before making his attempt to escape in the opening scene.\n"
     ]
    }
   ],
   "source": [
    "def get_plot(soup):\n",
    "\n",
    "    plot = []\n",
    "\n",
    "    \"\"\" Extract text from Summary \"\"\"\n",
    "    selector = soup.find('span', {'id': 'Teaser'})\n",
    "    txt = selector.parent.findNextSibling('p', {'class': None}).get_text()\n",
    "    plot.append(txt)\n",
    "\n",
    "    \"\"\" Extract text from each 'Act' \"\"\"\n",
    "    selectors = soup.find_all('span', {'id': lambda x: x and x.startswith('Act_')})\n",
    "    for selector in selectors:\n",
    "        txt = selector.parent.findNextSibling('p').get_text()\n",
    "        plot.append(txt)\n",
    "\n",
    "    # Clean up special characters\n",
    "    for i, txt in enumerate(plot):\n",
    "        txt = txt.replace(u'\\xa0', u' ').replace('\\n', '').replace(\"\\'\", '')\n",
    "        plot[i] = txt\n",
    "        \n",
    "    plot = (' ').join(plot)\n",
    "        \n",
    "    return plot\n",
    "\n",
    "plot = get_plot(soup)\n",
    "print(plot)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get list of URLs for each season"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Season 1: https://breakingbad.fandom.com/wiki/Season_1_(Breaking_Bad)\n",
      "Season 2: https://breakingbad.fandom.com/wiki/Season_2_(Breaking_Bad)\n",
      "Season 3: https://breakingbad.fandom.com/wiki/Season_3_(Breaking_Bad)\n",
      "Season 4: https://breakingbad.fandom.com/wiki/Season_4_(Breaking_Bad)\n"
     ]
    }
   ],
   "source": [
    "# Easier to hard code this\n",
    "\n",
    "def get_season_urls():\n",
    "    seasonUrls = [f'https://breakingbad.fandom.com/wiki/Season_{i+1}_(Breaking_Bad)' for i in range(4)]\n",
    "    return seasonUrls\n",
    "    \n",
    "\n",
    "seasonUrls = get_season_urls()\n",
    "for i, url in enumerate(seasonUrls):\n",
    "        print(f'Season {i+1}: {url}')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get list of URLs for each episodes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Episode 1: https://breakingbad.fandom.com/wiki/Pilot\n",
      "Episode 2: https://breakingbad.fandom.com/wiki/Cat%27s_in_the_Bag...\n",
      "Episode 3: https://breakingbad.fandom.com/wiki/...and_the_Bag%27s_in_the_River\n",
      "Episode 4: https://breakingbad.fandom.com/wiki/Cancer_Man\n",
      "Episode 5: https://breakingbad.fandom.com/wiki/Gray_Matter\n",
      "Episode 6: https://breakingbad.fandom.com/wiki/Crazy_Handful_of_Nothin%27\n",
      "Episode 7: https://breakingbad.fandom.com/wiki/A_No-Rough-Stuff-Type_Deal\n"
     ]
    }
   ],
   "source": [
    "# Get list of episodes\n",
    "def get_episode_urls(url):\n",
    "    baseUrl = 'https://breakingbad.fandom.com'\n",
    "    \n",
    "    # Download page\n",
    "    browser = webdriver.Chrome(options=options)\n",
    "    browser.get(url)\n",
    "    soup = BeautifulSoup(browser.page_source, 'html.parser')\n",
    "    \n",
    "    # Extract episode URLs\n",
    "    episodeUrls = []\n",
    "    selector = soup.find('div', {'data-source': 'episodes'})\n",
    "    for link in selector.find_all('a'):\n",
    "        url = f'{baseUrl}{link[\"href\"]}'\n",
    "        episodeUrls.append(url)\n",
    "    return episodeUrls\n",
    "        \n",
    "episodeUrls = get_episode_urls('https://breakingbad.fandom.com/wiki/Season_1_(Breaking_Bad)')\n",
    "\n",
    "for i, url in enumerate(episodeUrls):\n",
    "    print(f'Episode {i+1}: {url}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Extracting episode 1: https://breakingbad.fandom.com/wiki/Pilot\n",
      "Extracting episode 2: https://breakingbad.fandom.com/wiki/Cat%27s_in_the_Bag...\n",
      "Extracting episode 3: https://breakingbad.fandom.com/wiki/...and_the_Bag%27s_in_the_River\n",
      "Extracting episode 4: https://breakingbad.fandom.com/wiki/Cancer_Man\n",
      "Extracting episode 5: https://breakingbad.fandom.com/wiki/Gray_Matter\n",
      "Extracting episode 6: https://breakingbad.fandom.com/wiki/Crazy_Handful_of_Nothin%27\n",
      "Extracting episode 7: https://breakingbad.fandom.com/wiki/A_No-Rough-Stuff-Type_Deal\n"
     ]
    }
   ],
   "source": [
    "def extract_episode_data(url, season_number, episode_number):\n",
    "    # Download page\n",
    "    browser = webdriver.Chrome(options=options)\n",
    "    browser.get(url)\n",
    "    soup = BeautifulSoup(browser.page_source, 'html.parser')\n",
    "    \n",
    "    # Extract data\n",
    "    data = {}\n",
    "    data['season'] = season_number + 1\n",
    "    data['episode'] = episode_number + 1\n",
    "    data['live_viewership'] = get_viewers_count(soup)\n",
    "    data['featured_music'] = get_featured_music_count(soup)\n",
    "    data['media/cultural_refs'] = get_ref_count(soup)\n",
    "    data['plot'] = get_plot(soup)\n",
    "    \n",
    "    return data\n",
    "\n",
    "\n",
    "data = {}\n",
    "season_number = 0    # hard-coded for testing purpose\n",
    "for i, url in enumerate(episodeUrls):\n",
    "    print(f'Extracting episode {i+1}: {url}')\n",
    "    data[i+1] = extract_episode_data(url, season_number, i)\n",
    "    time.sleep(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>season</th>\n",
       "      <th>episode</th>\n",
       "      <th>live_viewership</th>\n",
       "      <th>featured_music</th>\n",
       "      <th>media/cultural_refs</th>\n",
       "      <th>plot</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.41 million</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>In the desert outside of Albuquerque, New Mexi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1.49 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt finishes having rough sex with Skyler and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1.08 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>As Walt and Jesse are scrubbing up the dissolv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.09 million</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>Hank puts his DEA team on notice that \"new pla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.97 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Donning a jacket and tie, Jesse interviews for...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1.07 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>As he surveys the RV, Walt gives Jesse a stern...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1.50 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>At the high school, Walt and Skyler attend a P...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   season  episode live_viewership  featured_music  media/cultural_refs  \\\n",
       "1       1        1    1.41 million              15                    2   \n",
       "2       1        2    1.49 million               6                    0   \n",
       "3       1        3    1.08 million               4                    0   \n",
       "4       1        4    1.09 million               7                    2   \n",
       "5       1        5    0.97 million               8                    0   \n",
       "6       1        6    1.07 million               8                    0   \n",
       "7       1        7    1.50 million               6                    0   \n",
       "\n",
       "                                                plot  \n",
       "1  In the desert outside of Albuquerque, New Mexi...  \n",
       "2  Walt finishes having rough sex with Skyler and...  \n",
       "3  As Walt and Jesse are scrubbing up the dissolv...  \n",
       "4  Hank puts his DEA team on notice that \"new pla...  \n",
       "5  Donning a jacket and tie, Jesse interviews for...  \n",
       "6  As he surveys the RV, Walt gives Jesse a stern...  \n",
       "7  At the high school, Walt and Skyler attend a P...  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame.from_dict(data, orient='index')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Extract data for every episode in every season"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Season 1, Episode 1: https://breakingbad.fandom.com/wiki/Pilot\n",
      "Season 1, Episode 2: https://breakingbad.fandom.com/wiki/Cat%27s_in_the_Bag...\n",
      "Season 1, Episode 3: https://breakingbad.fandom.com/wiki/...and_the_Bag%27s_in_the_River\n",
      "Season 1, Episode 4: https://breakingbad.fandom.com/wiki/Cancer_Man\n",
      "Season 1, Episode 5: https://breakingbad.fandom.com/wiki/Gray_Matter\n",
      "Season 1, Episode 6: https://breakingbad.fandom.com/wiki/Crazy_Handful_of_Nothin%27\n",
      "Season 1, Episode 7: https://breakingbad.fandom.com/wiki/A_No-Rough-Stuff-Type_Deal\n",
      "Season 2, Episode 1: https://breakingbad.fandom.com/wiki/Seven_Thirty-Seven\n",
      "Season 2, Episode 2: https://breakingbad.fandom.com/wiki/Grilled\n",
      "Season 2, Episode 3: https://breakingbad.fandom.com/wiki/Bit_by_a_Dead_Bee\n",
      "Season 2, Episode 4: https://breakingbad.fandom.com/wiki/Down\n",
      "Season 2, Episode 5: https://breakingbad.fandom.com/wiki/Breakage\n",
      "Season 2, Episode 6: https://breakingbad.fandom.com/wiki/Peekaboo\n",
      "Season 2, Episode 7: https://breakingbad.fandom.com/wiki/Negro_y_Azul\n",
      "Season 2, Episode 8: https://breakingbad.fandom.com/wiki/Better_Call_Saul_(episode)\n",
      "Season 2, Episode 9: https://breakingbad.fandom.com/wiki/4_Days_Out\n",
      "Season 2, Episode 10: https://breakingbad.fandom.com/wiki/Over\n",
      "Season 2, Episode 11: https://breakingbad.fandom.com/wiki/Mandala\n",
      "Season 2, Episode 12: https://breakingbad.fandom.com/wiki/Phoenix\n",
      "Season 2, Episode 13: https://breakingbad.fandom.com/wiki/ABQ\n",
      "Season 3, Episode 1: https://breakingbad.fandom.com/wiki/No_M%C3%A1s\n",
      "Season 3, Episode 2: https://breakingbad.fandom.com/wiki/Caballo_Sin_Nombre\n",
      "Season 3, Episode 3: https://breakingbad.fandom.com/wiki/I.F.T.\n",
      "Season 3, Episode 4: https://breakingbad.fandom.com/wiki/Green_Light\n",
      "Season 3, Episode 5: https://breakingbad.fandom.com/wiki/M%C3%A1s\n",
      "Season 3, Episode 6: https://breakingbad.fandom.com/wiki/Sunset\n",
      "Season 3, Episode 7: https://breakingbad.fandom.com/wiki/One_Minute\n",
      "Season 3, Episode 8: https://breakingbad.fandom.com/wiki/I_See_You\n",
      "Season 3, Episode 9: https://breakingbad.fandom.com/wiki/Kafkaesque\n",
      "Season 3, Episode 10: https://breakingbad.fandom.com/wiki/Fly\n",
      "Season 3, Episode 11: https://breakingbad.fandom.com/wiki/Abiqui%C3%BA\n",
      "Season 3, Episode 12: https://breakingbad.fandom.com/wiki/Half_Measures\n",
      "Season 3, Episode 13: https://breakingbad.fandom.com/wiki/Full_Measure\n",
      "Season 4, Episode 1: https://breakingbad.fandom.com/wiki/Box_Cutter\n",
      "Season 4, Episode 2: https://breakingbad.fandom.com/wiki/Thirty-Eight_Snub\n",
      "Season 4, Episode 3: https://breakingbad.fandom.com/wiki/Open_House\n",
      "Season 4, Episode 4: https://breakingbad.fandom.com/wiki/Bullet_Points\n",
      "Season 4, Episode 5: https://breakingbad.fandom.com/wiki/Shotgun\n",
      "Season 4, Episode 6: https://breakingbad.fandom.com/wiki/Cornered\n",
      "Season 4, Episode 7: https://breakingbad.fandom.com/wiki/Problem_Dog\n",
      "Season 4, Episode 8: https://breakingbad.fandom.com/wiki/Hermanos\n",
      "Season 4, Episode 9: https://breakingbad.fandom.com/wiki/Bug\n",
      "Season 4, Episode 10: https://breakingbad.fandom.com/wiki/Salud\n",
      "Season 4, Episode 11: https://breakingbad.fandom.com/wiki/Crawl_Space\n",
      "Season 4, Episode 12: https://breakingbad.fandom.com/wiki/End_Times\n",
      "Season 4, Episode 13: https://breakingbad.fandom.com/wiki/Face_Off\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>season</th>\n",
       "      <th>episode</th>\n",
       "      <th>live_viewership</th>\n",
       "      <th>featured_music</th>\n",
       "      <th>media/cultural_refs</th>\n",
       "      <th>plot</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.41 million</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>In the desert outside of Albuquerque, New Mexi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1.49 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt finishes having rough sex with Skyler and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1.08 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>As Walt and Jesse are scrubbing up the dissolv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.09 million</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>Hank puts his DEA team on notice that \"new pla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.97 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Donning a jacket and tie, Jesse interviews for...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1.07 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>As he surveys the RV, Walt gives Jesse a stern...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1.50 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>At the high school, Walt and Skyler attend a P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.66 million</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>The episode opens on black and white shots of ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.60 million</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Out in the desert, Jesses car is riddled with ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1.13 million</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>After burying Tucos gun in the desert, Walt an...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>1.29 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Continuing the eerie scene first depicted in t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>1.21 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Two men carrying small bundles swim across a m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>1.41 million</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>As he waits alone on a sidewalk, Jesse crouche...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>N/A</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>A narcocorrido band called Los Cuates de Sinal...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>1.04 million</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>Badger is sitting at a bus stop when a thin gu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>N/A</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt undergoes tests to see if his cancer trea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>N/A</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>The episode opens on the pink teddy bear previ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>N/A</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Casually sipping a fountain drink, Combo is st...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>N/A</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Having successfully delivered his thirty-eight...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>1.50 million</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>We return to the flashforward from previous ep...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1.95 million</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>In a remote village in Mexico, men and women c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.55 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt drives to work, listening to to the song ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1.33 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flashback sequence, Hanks DEA informant, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.46 miilion</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>At a desert gas station, Jesse fills up the RV...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>1.61 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flashback to the pilot, Walt hands Jesse ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1.64 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>On a Native American reservation outside of Al...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>1.52 million</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flashback to 1980s Mexico, two young boys...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>1.78 million</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>A heavily-bruised Jesse is wheeled out of the ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>1.61 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>A television commercial for Los Pollos Hermano...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>1.20 million</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Over disjointed, extreme closeups of a common ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>1.32 million</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flashback, Jesse and Jane visit the Georg...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>1.19 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>The episode opens to a musical montage sequenc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>3</td>\n",
       "      <td>13</td>\n",
       "      <td>1.56 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Sixteen years previously, a realtor shows a yo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2.58 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flashback, Gale Boetticher excitedly unpa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1.97 million</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>In a motel room, Walter White purchases a thir...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1.71 million</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Walter White arrives at the superlab and hears...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1.83 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Mike Ehrmantraut huddles inside a Los Pollos H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>1.75 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walter White races through busy Albuquerque st...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>1.67 milion</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Reminiscent of the teaser of \"Bullet Points,\" ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>1.91 million</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>At home, on a massive TV screen, playing the f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>1.98 million</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flashback to the same previously seen hos...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>1.89 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flash-forward, we hear heavy breathing an...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>1.80 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Jesse Pinkman, Mike Ehrmantraut, and Gustavo F...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>1.55 million</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Doctors and nurses hastily prepare medical equ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "      <td>1.73 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Walter White and Skyler White frantically pack...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>1.90 million</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>After Gustavo Fring turns from his car and lea...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    season  episode live_viewership  featured_music  media/cultural_refs  \\\n",
       "0        1        1    1.41 million              15                    2   \n",
       "1        1        2    1.49 million               6                    0   \n",
       "2        1        3    1.08 million               4                    0   \n",
       "3        1        4    1.09 million               7                    2   \n",
       "4        1        5    0.97 million               8                    0   \n",
       "5        1        6    1.07 million               8                    0   \n",
       "6        1        7    1.50 million               6                    0   \n",
       "7        2        1    1.66 million               3                    0   \n",
       "8        2        2    1.60 million               2                    0   \n",
       "9        2        3    1.13 million               2                    0   \n",
       "10       2        4    1.29 million               5                    0   \n",
       "11       2        5    1.21 million               4                    0   \n",
       "12       2        6    1.41 million               1                    0   \n",
       "13       2        7             N/A               3                    0   \n",
       "14       2        8    1.04 million               9                    0   \n",
       "15       2        9             N/A               3                    0   \n",
       "16       2       10             N/A               9                    0   \n",
       "17       2       11             N/A               4                    0   \n",
       "18       2       12             N/A               5                    0   \n",
       "19       2       13    1.50 million               3                    0   \n",
       "20       3        1    1.95 million               1                    0   \n",
       "21       3        2    1.55 million               6                    0   \n",
       "22       3        3    1.33 million               5                    0   \n",
       "23       3        4    1.46 miilion               4                    0   \n",
       "24       3        5    1.61 million               4                    0   \n",
       "25       3        6    1.64 million               4                    0   \n",
       "26       3        7    1.52 million               3                    0   \n",
       "27       3        8    1.78 million               2                    0   \n",
       "28       3        9    1.61 million               4                    0   \n",
       "29       3       10    1.20 million               2                    0   \n",
       "30       3       11    1.32 million               7                    0   \n",
       "31       3       12    1.19 million               4                    0   \n",
       "32       3       13    1.56 million               6                    0   \n",
       "33       4        1    2.58 million               5                    0   \n",
       "34       4        2    1.97 million               9                    0   \n",
       "35       4        3    1.71 million               2                    0   \n",
       "36       4        4    1.83 million               6                    0   \n",
       "37       4        5    1.75 million               6                    0   \n",
       "38       4        6     1.67 milion               4                    0   \n",
       "39       4        7    1.91 million               3                    0   \n",
       "40       4        8    1.98 million               3                    0   \n",
       "41       4        9    1.89 million               4                    0   \n",
       "42       4       10    1.80 million               4                    0   \n",
       "43       4       11    1.55 million               1                    0   \n",
       "44       4       12    1.73 million               5                    0   \n",
       "45       4       13    1.90 million               9                    0   \n",
       "\n",
       "                                                 plot  \n",
       "0   In the desert outside of Albuquerque, New Mexi...  \n",
       "1   Walt finishes having rough sex with Skyler and...  \n",
       "2   As Walt and Jesse are scrubbing up the dissolv...  \n",
       "3   Hank puts his DEA team on notice that \"new pla...  \n",
       "4   Donning a jacket and tie, Jesse interviews for...  \n",
       "5   As he surveys the RV, Walt gives Jesse a stern...  \n",
       "6   At the high school, Walt and Skyler attend a P...  \n",
       "7   The episode opens on black and white shots of ...  \n",
       "8   Out in the desert, Jesses car is riddled with ...  \n",
       "9   After burying Tucos gun in the desert, Walt an...  \n",
       "10  Continuing the eerie scene first depicted in t...  \n",
       "11  Two men carrying small bundles swim across a m...  \n",
       "12  As he waits alone on a sidewalk, Jesse crouche...  \n",
       "13  A narcocorrido band called Los Cuates de Sinal...  \n",
       "14  Badger is sitting at a bus stop when a thin gu...  \n",
       "15  Walt undergoes tests to see if his cancer trea...  \n",
       "16  The episode opens on the pink teddy bear previ...  \n",
       "17  Casually sipping a fountain drink, Combo is st...  \n",
       "18  Having successfully delivered his thirty-eight...  \n",
       "19  We return to the flashforward from previous ep...  \n",
       "20  In a remote village in Mexico, men and women c...  \n",
       "21  Walt drives to work, listening to to the song ...  \n",
       "22  In a flashback sequence, Hanks DEA informant, ...  \n",
       "23  At a desert gas station, Jesse fills up the RV...  \n",
       "24  In a flashback to the pilot, Walt hands Jesse ...  \n",
       "25  On a Native American reservation outside of Al...  \n",
       "26  In a flashback to 1980s Mexico, two young boys...  \n",
       "27  A heavily-bruised Jesse is wheeled out of the ...  \n",
       "28  A television commercial for Los Pollos Hermano...  \n",
       "29  Over disjointed, extreme closeups of a common ...  \n",
       "30  In a flashback, Jesse and Jane visit the Georg...  \n",
       "31  The episode opens to a musical montage sequenc...  \n",
       "32  Sixteen years previously, a realtor shows a yo...  \n",
       "33  In a flashback, Gale Boetticher excitedly unpa...  \n",
       "34  In a motel room, Walter White purchases a thir...  \n",
       "35  Walter White arrives at the superlab and hears...  \n",
       "36  Mike Ehrmantraut huddles inside a Los Pollos H...  \n",
       "37  Walter White races through busy Albuquerque st...  \n",
       "38  Reminiscent of the teaser of \"Bullet Points,\" ...  \n",
       "39  At home, on a massive TV screen, playing the f...  \n",
       "40  In a flashback to the same previously seen hos...  \n",
       "41  In a flash-forward, we hear heavy breathing an...  \n",
       "42  Jesse Pinkman, Mike Ehrmantraut, and Gustavo F...  \n",
       "43  Doctors and nurses hastily prepare medical equ...  \n",
       "44  Walter White and Skyler White frantically pack...  \n",
       "45  After Gustavo Fring turns from his car and lea...  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_s1_to_4 = []\n",
    "for season, seasonUrl in enumerate(get_season_urls()):\n",
    "    for episode, episodeUrl in enumerate(get_episode_urls(seasonUrl)):\n",
    "        print(f'Season {season+1}, Episode {episode+1}: {episodeUrl}')\n",
    "        d = extract_episode_data(episodeUrl, season, episode)\n",
    "        data_s1_to_4.append(d)\n",
    "        time.sleep(1)\n",
    "        \n",
    "df_s1_to_4 = pd.DataFrame(data_s1_to_4)\n",
    "df_s1_to_4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Extracting episode 1: https://breakingbad.fandom.com/wiki/Live_Free_or_Die\n",
      "Extracting episode 2: https://breakingbad.fandom.com/wiki/Madrigal\n",
      "Extracting episode 3: https://breakingbad.fandom.com/wiki/Hazard_Pay\n",
      "Extracting episode 4: https://breakingbad.fandom.com/wiki/Fifty-One\n",
      "Extracting episode 5: https://breakingbad.fandom.com/wiki/Dead_Freight\n",
      "Extracting episode 6: https://breakingbad.fandom.com/wiki/Buyout\n",
      "Extracting episode 7: https://breakingbad.fandom.com/wiki/Say_My_Name\n",
      "Extracting episode 8: https://breakingbad.fandom.com/wiki/Gliding_Over_All\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>season</th>\n",
       "      <th>episode</th>\n",
       "      <th>live_viewership</th>\n",
       "      <th>featured_music</th>\n",
       "      <th>media/cultural_refs</th>\n",
       "      <th>plot</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2.93 million</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>At a counter in a Dennys restaurant, a man ser...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>2.29 million</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>At a test kitchen in Germany, Madrigal Electro...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>2.20 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Posing as a paralegal, Mike Ehrmantraut visits...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>2.29 million</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>At an auto shop, a mechanic goes over some rec...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>2.48 million</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>A young boy, Drew Sharp, rides through the des...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>2.81 million</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>At the Vamonos Pest headquarters, Mike Ehrmant...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>2.98 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>In the middle of the desert, Walter White addr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>2.78 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt, in deep thought, is observing a fly at V...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   season  episode live_viewership  featured_music  media/cultural_refs  \\\n",
       "0       5        1    2.93 million               3                    0   \n",
       "1       5        2    2.29 million               3                    0   \n",
       "2       5        3    2.20 million               6                    0   \n",
       "3       5        4    2.29 million               3                    0   \n",
       "4       5        5    2.48 million               1                    0   \n",
       "5       5        6    2.81 million               3                    0   \n",
       "6       5        7    2.98 million               5                    0   \n",
       "7       5        8    2.78 million               6                    0   \n",
       "\n",
       "                                                plot  \n",
       "0  At a counter in a Dennys restaurant, a man ser...  \n",
       "1  At a test kitchen in Germany, Madrigal Electro...  \n",
       "2  Posing as a paralegal, Mike Ehrmantraut visits...  \n",
       "3  At an auto shop, a mechanic goes over some rec...  \n",
       "4  A young boy, Drew Sharp, rides through the des...  \n",
       "5  At the Vamonos Pest headquarters, Mike Ehrmant...  \n",
       "6  In the middle of the desert, Walter White addr...  \n",
       "7  Walt, in deep thought, is observing a fly at V...  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "episodeUrls = get_episode_urls('https://breakingbad.fandom.com/wiki/Season_5A_(Breaking_Bad)')\n",
    "    \n",
    "def extract_episode_data_5(url, episode_number):\n",
    "    # Download page\n",
    "    browser = webdriver.Chrome(options=options)\n",
    "    browser.get(url)\n",
    "    soup = BeautifulSoup(browser.page_source, 'html.parser')\n",
    "    \n",
    "    # Extract data\n",
    "    data = {}\n",
    "    data['season'] = 5\n",
    "    data['episode'] = episode_number + 1\n",
    "    data['live_viewership'] = get_viewers_count(soup)\n",
    "    data['featured_music'] = get_featured_music_count(soup)\n",
    "    data['media/cultural_refs'] = get_ref_count(soup)\n",
    "    data['plot'] = get_plot(soup)\n",
    "    \n",
    "    return data\n",
    "\n",
    "data_5A = []\n",
    "for i, url in enumerate(episodeUrls):\n",
    "    print(f'Extracting episode {i+1}: {url}')\n",
    "    data_5A.append(extract_episode_data_5(url, i))\n",
    "    time.sleep(1)\n",
    "    \n",
    "df_5A = pd.DataFrame(data_5A)\n",
    "df_5A"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Extracting episode 9: https://breakingbad.fandom.com/wiki/Blood_Money\n",
      "Extracting episode 10: https://breakingbad.fandom.com/wiki/Buried\n",
      "Extracting episode 11: https://breakingbad.fandom.com/wiki/Confessions\n",
      "Extracting episode 12: https://breakingbad.fandom.com/wiki/Rabid_Dog\n",
      "Extracting episode 13: https://breakingbad.fandom.com/wiki/To%27hajiilee\n",
      "Extracting episode 14: https://breakingbad.fandom.com/wiki/Ozymandias\n",
      "Extracting episode 15: https://breakingbad.fandom.com/wiki/Granite_State\n",
      "Extracting episode 16: https://breakingbad.fandom.com/wiki/Felina\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>season</th>\n",
       "      <th>episode</th>\n",
       "      <th>live_viewership</th>\n",
       "      <th>featured_music</th>\n",
       "      <th>media/cultural_refs</th>\n",
       "      <th>plot</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>5.92 million</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>Following the purchase of the M60 (\"Live Free ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>4.77 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>An elderly man leaves his house in the still d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>4.85 million</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>Outside a diner in Arizona, Todd Alquist leave...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>4.41 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Walter White parks his car down the street fro...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>5.11 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Jack, Kenny and Lydia Rodarte-Quayle observe t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>6.37 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flashback from Walter White and Jesse Pin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>6.58 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Just as seen at the end of the previous episod...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>10.28 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>With police searching for him in New Hampshire...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   season  episode live_viewership  featured_music  media/cultural_refs  \\\n",
       "0       5        9    5.92 million               7                    0   \n",
       "1       5       10    4.77 million               4                    0   \n",
       "2       5       11    4.85 million              10                    0   \n",
       "3       5       12    4.41 million               5                    0   \n",
       "4       5       13    5.11 million               8                    0   \n",
       "5       5       14    6.37 million               5                    0   \n",
       "6       5       15    6.58 million               5                    0   \n",
       "7       5       16   10.28 million               8                    0   \n",
       "\n",
       "                                                plot  \n",
       "0  Following the purchase of the M60 (\"Live Free ...  \n",
       "1  An elderly man leaves his house in the still d...  \n",
       "2  Outside a diner in Arizona, Todd Alquist leave...  \n",
       "3  Walter White parks his car down the street fro...  \n",
       "4  Jack, Kenny and Lydia Rodarte-Quayle observe t...  \n",
       "5  In a flashback from Walter White and Jesse Pin...  \n",
       "6  Just as seen at the end of the previous episod...  \n",
       "7  With police searching for him in New Hampshire...  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "episodeUrls = get_episode_urls('https://breakingbad.fandom.com/wiki/Season_5B_(Breaking_Bad)')\n",
    "    \n",
    "def extract_episode_data_5B(url, episode_number):\n",
    "    # Download page\n",
    "    browser = webdriver.Chrome(options=options)\n",
    "    browser.get(url)\n",
    "    soup = BeautifulSoup(browser.page_source, 'html.parser')\n",
    "    \n",
    "    # Extract data\n",
    "    data = {}\n",
    "    data['season'] = 5\n",
    "    data['episode'] = episode_number + 9\n",
    "    data['live_viewership'] = get_viewers_count(soup)\n",
    "    data['featured_music'] = get_featured_music_count(soup)\n",
    "    data['media/cultural_refs'] = get_ref_count(soup)\n",
    "    data['plot'] = get_plot(soup)\n",
    "    \n",
    "    return data\n",
    "\n",
    "data_5B = []\n",
    "for i, url in enumerate(episodeUrls):\n",
    "    print(f'Extracting episode {i+9}: {url}')\n",
    "    data_5B.append(extract_episode_data_5B(url, i))\n",
    "    time.sleep(3)\n",
    "    \n",
    "df_5B = pd.DataFrame(data_5B)\n",
    "df_5B"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>season</th>\n",
       "      <th>episode</th>\n",
       "      <th>live_viewership</th>\n",
       "      <th>featured_music</th>\n",
       "      <th>media/cultural_refs</th>\n",
       "      <th>plot</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.41 million</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>In the desert outside of Albuquerque, New Mexi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1.49 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt finishes having rough sex with Skyler and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1.08 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>As Walt and Jesse are scrubbing up the dissolv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.09 million</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>Hank puts his DEA team on notice that \"new pla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.97 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Donning a jacket and tie, Jesse interviews for...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>4.41 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Walter White parks his car down the street fro...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>5.11 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Jack, Kenny and Lydia Rodarte-Quayle observe t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>6.37 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flashback from Walter White and Jesse Pin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>6.58 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Just as seen at the end of the previous episod...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>10.28 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>With police searching for him in New Hampshire...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    season  episode live_viewership  featured_music  media/cultural_refs  \\\n",
       "0        1        1    1.41 million              15                    2   \n",
       "1        1        2    1.49 million               6                    0   \n",
       "2        1        3    1.08 million               4                    0   \n",
       "3        1        4    1.09 million               7                    2   \n",
       "4        1        5    0.97 million               8                    0   \n",
       "..     ...      ...             ...             ...                  ...   \n",
       "57       5       12    4.41 million               5                    0   \n",
       "58       5       13    5.11 million               8                    0   \n",
       "59       5       14    6.37 million               5                    0   \n",
       "60       5       15    6.58 million               5                    0   \n",
       "61       5       16   10.28 million               8                    0   \n",
       "\n",
       "                                                 plot  \n",
       "0   In the desert outside of Albuquerque, New Mexi...  \n",
       "1   Walt finishes having rough sex with Skyler and...  \n",
       "2   As Walt and Jesse are scrubbing up the dissolv...  \n",
       "3   Hank puts his DEA team on notice that \"new pla...  \n",
       "4   Donning a jacket and tie, Jesse interviews for...  \n",
       "..                                                ...  \n",
       "57  Walter White parks his car down the street fro...  \n",
       "58  Jack, Kenny and Lydia Rodarte-Quayle observe t...  \n",
       "59  In a flashback from Walter White and Jesse Pin...  \n",
       "60  Just as seen at the end of the previous episod...  \n",
       "61  With police searching for him in New Hampshire...  \n",
       "\n",
       "[62 rows x 6 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.concat([df_s1_to_4,df_5A, df_5B]).reset_index(drop=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('breaking_bad.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD4CAYAAAD1jb0+AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAABCLklEQVR4nO29e3Bc93Xn+f31+4FuNEiAABogBT0B6kVIpmI7tmPZlm1ZlkmldnfWmSSjmXhLU5vUjGdnMo69rvUmm92d1O4km6lKJjPaxPFs4nEmUWxRlmVLsmNbsceWTEkkxQdAySJNEg2AAMhGdwP97t/+ce/v9u3u++y+/bjN86ligehuAL8L3P7ec8/vnPNlnHMQBEEQ7sPT7wUQBEEQ7UECThAE4VJIwAmCIFwKCThBEIRLIQEnCIJwKb5e/rDx8XE+NzfXyx9JEAThel599dVNzvlE8+M9FfC5uTkcP368lz+SIAjC9TDGfqb1OKVQCIIgXAoJOEEQhEshAScIgnApJOAEQRAuhQScIAjCpZCAEwRBuBQScIIgCJfiCgH/zrl1/PvvvdXvZRAEQQwUrhDwl85v4MmX3u73MgiCIAYKVwh4KOBFvlTt9zIIgiAGClcIeNjvRbFSQ61G7kEEQRAC1wg4ABQqFIUTBEEIXCHgkYAk4JRGIQiCqOMKAQ/JEXi+TAJOEAQhcIWAh+UIvEACThAEoeAOARcReKnW55UQBEEMDu4ScIrACYIgFFwh4KEACThBEEQzrhDwegql0ueVEARBDA6mAs4Y+yJj7Cpj7LTGc7/JGOOMsfHuLE+CUigEQRCtWInAvwTg4eYHGWP7AXwYwCWH19RCOECbmARBEM2YCjjn/CUA1zSe+n8AfAZA1/vbqQ6cIAiilbZy4IyxIwBWOOcnLbz2CcbYccbY8Y2NjXZ+XL2VngScIAhCwbaAM8YiAD4P4AtWXs85f5JzfphzfnhiYsLujwMA+L0MXg+jVnqCIAgV7UTgtwK4GcBJxthFALMAXmOMTTm5MDWMMYT9XkqhEARBqPDZ/QLO+RsA9onPZRE/zDnfdHBdLYRIwAmCIBqwUkb4FQA/AjDPGLvCGPtU95fVSjjgQYFSKARBEAqmETjn/JdMnp9zbDUGUAqFIAiiEVd0YgIk4ARBEM24RsBDfvLFJAiCUOMaAQ8HvFQHThAEocI1Ah4JUAqFIAhCjWsEnMoICYIgGnGNgIf9XhpmRRAEocJVAk45cIIgiDruEXA5B85514cfEgRBuALXCHjI70W1xlGqUhqFIAgCcJGAKyNlKQ9OEAQBwE0CTsbGBEEQDbhHwMmVhyAIogHXCLhiq0bt9ARBEABcJOCUQiEIgmjEPQJOvpgEQRANuE7AKYVCEAQh4R4BD0hLpRQKQRCEhGsEPERVKARBEA24RsApB04QBNGIFVPjLzLGrjLGTqse+78ZY0uMsVOMsa8xxhJdXSVUVSiUAycIggBgLQL/EoCHmx57EcDdnPN7AZwH8DmH19VCyEcpFIIgCDWmAs45fwnAtabHXuCcV+RPfwxgtgtra8DjYQj6PCTgBEEQMk7kwH8NwDcd+D6mRAJeFCiFQhAEAaBDAWeMfR5ABcCXDV7zBGPsOGPs+MbGRic/TnLloQicIAgCQAcCzhh7HMCjAH6ZG7gscM6f5Jwf5pwfnpiYaPfHAQBCAS/yZRonSxAEAQC+dr6IMfYwgN8C8H7O+a6zS9JH8sWkCJwgCAKwVkb4FQA/AjDPGLvCGPsUgD8CEAPwImPsBGPsP3R5nQBECqVi/kKCIIgbANMInHP+SxoP/1kX1mJKOODFTpEEnCAIAnBRJyYgtdNTDpwgCELCVQIe9nuplZ4gCELGdQJOm5gEQRAS7hLwANWBEwRBCFwl4CFq5CEIglBwlYCH/V6UKjVUa7p9QwRBEDcM7hJw2ZWHNjIJgiDcJuDkykMQBKHgKgEPkbExQRCEgqsEXLjyUAqFIAjCbQJOKRSCIAgFdwo4pVAIgiDcJeChAEXgBEEQAlcJeIRy4ARBEAquEnDKgRMEQdRxpYDvUg6cIAjCXQKu5MBJwAmCINwl4CICpxw4QRCEywTc7/XA52GUAycIgoDLBBwQpg5kq0YQBGHFlf6LjLGrjLHTqsf2MMZeZIy9KX8c6+4y64TI1IEgCAKAtQj8SwAebnrsswC+wzm/HcB35M97AvliEgRBSJgKOOf8JQDXmh4+CuA/yf//TwAec3ZZ+pAvJkEQTpEplPGL//6HeOtqtt9LaYt2c+CTnPNVAJA/7tN7IWPsCcbYccbY8Y2NjTZ/XB1KoRAE4RRvb+zg9UtpvHYp3e+ltEXXNzE5509yzg9zzg9PTEx0/P3Cfg8JOEEQjpAtlAEA6d1Sn1fSHu0K+DpjbBoA5I9XnVuSMZQDJwjCKbKFCgAgvVvu80rao10BfwbA4/L/HwdwzJnlmBMOUA6cIAhnUCLw/JAKOGPsKwB+BGCeMXaFMfYpAL8H4MOMsTcBfFj+vCeE/JQDJwjCGUQEvu3SCNxn9gLO+S/pPPUhh9diCUqhEAThFBmRQsnfWDnwvkFlhARBOEV9E9OdEbj7BFwuI+Sc93spBEG4nBt1E7NvhPxe1DhQqtI8FIIgOkNE4NvDuok5aCi2ajTQiiCIDhEReK5YQdmFQaHrBFxx5SlX+rwSgiDcjhBwwJ1RuPsEnFx5CIJwiGyhDJ+HAXBnN6brBDxExsYEQThEplBBMhEG4M6NTNcJONmq1fmrVy7h//vRRdPX/eWPf4a/+PHPur+gG5x/89w5fP985wPbBo1ajeMzT53E6ZXtfi/FUTjnyBbK2L+HBLxn1FMo7ttwcJqnXr2C//KTy6av+5tXr+Cp4+avI9qnVuP40x9cwAtn1vq9FMe5mi3ir49fwXeXejbyqCcUKzWUqxz7xyIA3NlOb9qJOWiEKYWikC1ULP0esoUyqjWqm+8m6bz0O94pDt/m+mauCADIDtmxZeQSwv17ZAF3YQ7cdQJOOfA62ULZooBXUKrQHUs3ESKXKw7feakIeMF9EaoRogIlmQjBw9xZheI6AQ8rdeDD90axi4jAOedgjBm8roxipYZqjcPr0X8d0T5C5IYxAt/KSZFppjBcxyYEPB7yYzTspxx4L6AUikStxpErVVCpcRTK+tF1uVpDoVwD50DGhRGGW9iURW6nNFwiB6gj8OE6NnFHEQv5kYgEXJkDJwF3KblSBWIcjNGtrfpN58YT1C1sZkUKZbhEDhj+FEo87JMjcPflwF0n4EGftOQbvZFHLcxGt7bqN50bT1C3sLUz/CmU4Y7A/a7MgbtOwD0ehpDfc8PXgauFmSLw/rOZlVMoQ7iJuTHkEXgs5EMi7Md1FwY4rhNwQJ4JfsMLeEXz/81kVG86t7qOuAFlE7NUGbpRx5tDGoFnChUwBowEfFIO3IXvD/cK+A2fQlFH4EYpFFUE7sIIwy1s7ki/W86B3SE7N7fki9NuqYqKCyf26ZHJlzES8MHjYUhE/MgWKq47PlcKeChAEXgmr86B60cO6soTSqF0D7GJCQxXHrxW49jaKSljnIdpkzZbqCAWkiqpE2E/APeVSnYk4Iyx/4kxdoYxdpox9hXGWMiphRlBvpj2c+Ae5s5ZD26Ac46tnSImYkEAwyVy23KH6c3jUQCNgYPbyRbKiIUk4U5EAgDcd5fatoAzxmYA/HMAhznndwPwAvikUwszgnLgjZGClRTKVDzkyl12N7BTqqJQruEmuSV7mDYyRW5/Tgj4EG1kqiPw0Ygk5G67S+20E9MHIMwYKwOIAEh1viRzwgFvR1HO95avag6BemBuD37tvTd3srSekS1U4PcyhP1eEwEvI+z3YjwWdF104RZE+uSmvVEc/9n1oWrmERUot8gCPkwbmdliGRMj0l2TSKHobfQXK1X82+eX8esP3oaxaMDWz7l8bRe/++xZ/LMP3o57Zkc7W3QTbUfgnPMVAP8WwCUAqwC2OecvNL+OMfYEY+w4Y+z4xoYzozY73cT8vW8u4QdvbeKnGznl3ysXruH3X1hGzSVDn8TtXyzkN4yKRJQxGvbjOqVQuoKoAZ/bKyLw4RE5UQN+syLgw3MOSe+NphRKXjvIef1SGv/v31/A37UxkfHC5g5eOLuOQsX5O7O2I3DG2BiAowBuBpAG8DeMsV/hnP+l+nWc8ycBPAkAhw8fdkQdw4H2c+BLaxksrWXxvx29C//o3XPK4//55Uv4n7/2BlbSeWU62SAjhNk0Ai+WpTrXSABXrud7uMIbhw25BvyALODDlANvTqEMVQSusYmpt0+USucbPtphRf4aYRzhJJ1sYj4E4ALnfINzXgbwVQA/78yyjOkkB37sRApeD8Mj90w3PL4wHQMALK1lO15fL5AicB/iIb/pJmYs5EfCpa3CbkARub2SyA1bDtzrYcrM7GGJwIWZg4jA41YFfNu+gKfSeXgYMClvcjtJJwJ+CcC7GGMRJo3C+xCAc84sy5hQmymUWo3jmRMpvO/2cYyPNP4y75iUBHx5LePIGrtNtlBBLOhHLOQzaeSpIB6utwq7JUXkJkSa4cCe4Uyh7IkGMCoL3LBE4MLMQUTgXg9DPOTTDXJW0oWGj3ZYSecxFQ/B53W+aruTHPjLAJ4C8BqAN+Tv9aRD6zJESqHYL7h/9dJ1rKTzOLqYbHluJOjD/j1hnHNNBC7d/pkJuIjUR8N+1PjwDeUfBDZzRSQifkXkhi2FsjcaQMDnQcjvGZrzR+wbicgbgOFEwk5SKKl0HjNjzqdPgA7rwDnn/yvnfIFzfjfn/Fc550Xzr+qcsN+LUrVmu2vq2IkVhPwefOTOKc3n5yfjWHaNgNc3Mc1SKHE5Bw5QO3032NqRRM7jYYgEvEMVgW/mSkp9u9m55ibqs8Dr24CJiP5McJHHXrmetz0qIZUudCX/Dbi0E1MxNrbhMlOu1vCNU6v48J1TiAa1924PTsdwYXMHxS7sFjtNcwSud1IJoVc2aXR22Yn22cyWlJRcNOgbqjLCzVxRObZYyOe6TkU91IOsBKNhv2YEzjlHKp1HwOtBvly11RBXq3GsbudJwNWEFGNj60L7929u4PpuGY9ppE8E81MxVGscb13NdbzGbiLMHOJhKQLXM3UoVSQzh1jQh0TEeJOGaB+1yEUD3qGxVeOcKykUQETgwyHgYsSE2MQEgLFIANsaOfDtfBm7pSoO7ZdquFdspFE2ckWUq5wEXI0SgduoRHn69RQSET/ed/uE7msWpuRKlNXBTqNki5KZQ1yOwAHtDrn6vGOVgLus08wNSAIuiVw06BuaFMqu3GE6LqdQ4iHf0KVQYs0pFI33hxDsw3N7ANjLg4uvnUl0Z8qIqwXcainhTrGCF8+u4+P3TCPg0z/kub1RBHweLK8PuICrhDmuVAdoCbg4Sf0YDYscOKVQnKRYqSJTqDSkUIZlE1OUR6pTKMMSgavNHASJsHalVkquPHlgbkz+3LqAp7pYAw64VcAD9lx5Xjy7jny5iqOLM4av83k9uG1iZOBrwdXCXI/AW99Y6ihj1KTOlWgPUUK4Vxa5kSGKwIWA75XvLmLB4dvEbMiBRwLgvLVUUojw3TOjCPg8SG1bLyVMKRE4CbhCyGYEfuzECmYSYRy+acz0tQvTsYGvBVeffGIXXSsyUkcZAZ8HI0EfpVAcRgj4MKZQhJHDxJBG4MLMQaC30Z9K5xHweTAeDWImEcaKjY7mVLogFxv4zV/cBq4UcDsplK1cES+9uYlPHErC42Gmr1+YimE9U8T1ncFNNaiFWZwYWpFRpinKGHWpbdQgU49SRQTuxc6QGDq0ROAhP3ZLVZRdZnqgRaZQUcwcBHob/SvpPJKjIXg8TBJwmznwbkXfgFsFXK5CKVh4ozz3xiqqNa7ZvKPF/FQcwGC31Ksj8JiFCDyuDOzxUx24ihfPruN8h/sdQuQmlCqU4YnAlfRQtB6BA0DOBVF4tcbxpR9e0B2hrJ6DIhAC3hzkrKgacZKJkO0ceLfy34BbBdxGBP7yhWuYSYRxcDpu6XuLSpRBTqOoNzGNIvDmPJ/eLvuNym/97Sn88Xff6uh7iDTDeKyeQtktVYdiZMFmrojRsF/Z+DcKFgaN7y5dxW9//Syee2NV83n1HBSBstHf9B5JpfNIjgoBD+Nqtmi5V2QlnUeySxUowA0g4Kl0HjfttT5dcF8siETEP9CVKBmli8yPaMALD9OLwKXHRpSJawEaaCVTq3Gkd0tttUar2cwVEfZ7EZFzqSNyk9gwNPNs5opK+gSoV2y4wdTh2EnJmkDv72sUgatTKKVKDVezRSWKFh/Xt82bzneKFaR3yxSBN2OnkcduDooxhoWp2MCnUPxehqDPA8YYRoLam0vZQhmRgBd+eYjOqDzQipBq6WsctjaktNjKFZXoG4DS5TsMEwk3c6WGoW9GG+aDRK5YwYtn1wDoN92IMctqtCq11jMFcF6vIhEfreTBV7e7W4ECuFTAlQjcRMCbr55WWZiSZqIM6m2wuP2ThkBC19ShOcqQRsqWbc9yGEbEXsBaptCRE3mzyEWDw2P+u5krKrl9AIY9B4PEi2fXlA5kvQt0Vp7SqcbvFZVa9bvU5lne4qOVOzcxuZAEvAm/1wOfh5mmUJqvnlaZn4pht1QdWAOEZmHWK++Sogz1tDWp7X5YqiQ6QbxJaxxYz7Y/g01qNa+LnJJCGQYBzzanUNwRgT/9egoziTAeXNinO79bK4UCtG701xtxpDz29Kj00UoE3u0mHsClAg5IlShmAt6uE8a8aKkf0I3MbKGsVJYA0DV1aI3A3em83Q3SGm/SdpCm9WmlUAZb5MwoVWoNHaYADDfMB4XNXBE/eGsTRxaTmB0LY227gGrTnTTnHJl86yYm0LrR3yzCIb8X4yNBS+dMKp2H18OwrwtGDgL3Crjf3Fat+epplXnF3GEw8+AZjQg8k28VjOaTdJQGWilovUntUq1xXNtpjMCj8mam21MowufTbRH4N07Vy4aTiTDKVa6UegoK5RoqNa4dgTdt9K+kCxgfCSjNg4A018RKBL5yvXtGDgL3CnjA3JWn3VuYaNCHA3siWBrQShRh0iCIhXzIFq3lwIHWMqkbke3d1jynXdK7JdR4vQsTqOfA3V6FspkVHab1i5PfO/imDsdOrGBhKoaFqbgyQKr576s1B0Uw2hSBr2jUcScTYYs58O6WEAJuFnALvphaV0+rzE/FsLQ6qCmUSsPJpzfmMyObOQjGoiKFQgJ+Xf4dxIK+tiPweg14aw7c7SNlN3caB1kJBtnU4dLWLl67lMYRuWlPb8OxXoarFYG35sBFDbhAEvCCaTFAqotzwAWuFfCQ34u8ia1aJ11QC1MxXNzatTWytlfobWI2n1DNzQoiAqd2eukiFg14cWBvRJk2Zxel1VydQhmSHPhmVgh4oOHxQTZ1eObkCgDgyCFjAVc3wjUjcuCcc8XIQSsCNzN2qNY41rYLXa1AAVws4GG/17SVfkXj6mmVQTV3qNY4csXGCDwe9qNa4w13JKVKDcWKVEqlfh1AKRRAqkJJRAJI2hxOpEZpo1dtYkYCXjDmfgHf2mlNoQCDa+rAOcfTJ1J4YG4Ms2NS415cntbZ/PdVT/NsJhEOoFrjyBYripFDcxrESi34ZpeNHAQdCThjLMEYe4oxtsQYO8cYe7dTCzPDrApF7+pplQV5JsqgbWSKzbF4UwQONG4uaUUZIb8XYb+XqlAg1YGPhv2YsZjP1EJJoahEjjGGaMD9M8E3s1KHabP94KCaOpxdzeCtq7mWkdHS8KnGOyytUbICsdG/vVtWmTE0aogVAdf7WqfpNAL/dwC+xTlfAHAIwLnOl2QNsxy43tXTKnN7Iwj4PANXSqglzFrlXXpRhpFx641EOl9GIuJHMhFCtlhpqz18M1eEz8MaSjoBaSNz1+058KY2eoFU8TR458+xEyn4PAyP3DPd8LjWhqPRJmZC1Y0pUmutKRRJU4wu/CLq73YEru3uawHGWBzALwD4xwDAOS8B6FloF/IbV6F0egX0eT24fd/gmTtoCbOWqYNelKFn3NopZ1LbCPm9uHVixPHv3Q3SuyXMT8Ua8qTxKe2ZzT+5eA2zY2FMN6XjtmSRax5THA36kDOoQnnp/AZ+utGYmvMwhofvnsJkvLtVC1bZ2im1pE8AYepg7+7i++c3cPimMV0z8U6p1TieOZHCL9wxgT3RxotOMhHCa5euNzxmFIEnIvJGf74+J0dMIhTsiQYQ9HkMBbzdEma7dPIbvQXABoA/Z4wdAvAqgE9zznfUL2KMPQHgCQA4cOBABz+ukXjYh+u7JdRqXHPOt7h6Nv/y7XDHZAwvv73V9td3A62TT2tGhV6U0a2Rsr/1t6dQqwHPffp9jn/vbrCdLyMRCSgX+FQ6r6TN1NRqHP/kz3+Cd92yB3/6+AMNz23mSg0bmAIjVx7OOZ74i+OaJtQXNnfw20fuaudwHGcjW8SsxnvHrqnDeqaAx7/4Cr7w6J34tffe7OQSFV6+cA1rmQI+98hCy3PJRBjp3TJ2ihXlAqJl5iBQD7RakY0c9jZdFBhjcupNf/M7lc531chB0EkKxQfgfgB/wjm/D8AOgM82v4hz/iTn/DDn/PDEhL6hsF1u3ye1u+vloZxoY50dC2M9W+xoVobTaAmzVgpFKZUKN01cCwdaHEecYDNbwtnVDN4c0Np5NZxzpHfLSMg5cAAteVLB5eu7yBUr+N7yRovJhzTIqlXAjWaCZ/IVFMo1/OZH7sCJL3xY+XdofwLnBqhstXnGiyAW8iNftm7qcPnarvTx+q6j61PzzMkVRAJefPjOyZbnxN93VdVSr2XmIKi78pSVQXhi5pCapImxw0q6+xUoQGcCfgXAFc75y/LnT0ES9J5Qb3fXFoyUztXTDslEGNUa72hWhtNoReBGm5jN+dlu5cDFReHYiZTj39tpdkpVVGociYgf4yNB+L1M93b43Kp0flVqHN88vdbwnCRyreeXZGysnd7bkCtX9u+JIBEJKP/unI5jaS07EIPGanKHqZaAi4DAqqmDELlOx/bqUaxU8Y1Tq/jInZPKSF81SY0LtNYgK0F9E7MkF0Fop0DMNr9TXXbiEbQt4JzzNQCXGWPz8kMfAnDWkVVZYN7EeOGKwdXTKnYmj/UK+5uYTTlwVZ2rUxTKVSUlcOzkykCIkBGiCicRlvLX06P6pYTLa1kwBhzYE8HTJ1aUxznn2Mhpi9xI0KsbgW9p1I4DUt/Bdr6M9Uz/g4Xrcoep9iamONesCbhIM7Rba2/G95c3kClUcPQ+bcPyGY33cKbQOkpWEPR5EQl45U1M/TJkM2OHXjTxAJ1XofwzAF9mjJ0CsAjg/+x4RRYZCfowOxbGOYMIvNMNhBkLu829Rm3mIBCmDup5KKKqYiTYmkIpVWqaOdh2EXXl9x1I4PK1PF6/nHbse3cDcQcioi0jm6zl9QwO7Ingv3vHLF65cE15Xa5YQalS043A9QS82cFHMEgD1PRqwAH1hrm1u7hUlyPwYydT2BMN4L23jWs+vy8WhNfDGi7QzaMomkmE/djIFQ1HUQttWdNwqO+FkYOgIwHnnJ+Q89v3cs4f45xfN/8q5xBzu7UwunpaJWmh3rPXZAplBLyehvEAdVOHxgg8EvC2DNJRNmkczIMLQfzkA/sR8Hlw7PUVk6/oL2K9It9pNNtiaS2LhamY0p79jOz0olUDLpBSKDoR+I5+BA4MRt9BvQtTX8CtR+DS73Vrp+R4V3O2UMa3z67j0XunFdOSZnxeD6bijRfo5lEUzYxGAlhazRqOojaqBe9VBQrg4k5MQDrpL2zutNzGCCOHTipQACAS8GEs4h+oCFxvjnFzh5xelDEmjFt3nMuDi5TE7FgEDx3ch2dPrQ7Uxm8z4uIlSsZmE2FNY4dCuYqLmzuYn4rjpr1R3HcgoeT4m93o1UQDPhQrNc3fwWa2CA9DS7lbIhLAVDw0EAIu8vRadxdxmyNlV9J5iCym04HQC2fWUazUTA3Lk03TA/XeQ4JE2I+35DJPPQ2pp1dbI/BeNfEALhdwvXZ3YeTgxC1M0qRcqNfoC7ivpQ5cc9pauF7n6hSirnw07MfRxRls7ZTwg7c2Hfv+TqNE4JF6BK5l7PDmeg41Xo+Ojx5K4txqBufXs0ouWzuFIk8k1NjI3MiVsCcagFejAmJ+KqabEuwlWwZ3F3Yj8JV0XhnP7HQg9PSJFcyOhXH/gTHD1yUT4QZjB9MUSsSvzBDX05CpUf30ql4DUDdwtYCLN9bSauNJ7+QVsJNZGd1Ay00baDV1MHIcAeBoLfi2ShAfnJ9APOTDMwNcjbKtuuAA+pvVIh8t8tMfvzcJr4fh2IkVbBiInDKRUKOZZ6vJwUfNwlQMP72as1yi1y02c0V4PUz5/aixY+qQKZSRLVTwwNweAM4K+Ea2iB++tYmji0nTQoVkom7swDk3TaGI9whQd+BpJuT3YiKmbewgjBx60ZTlagG/eTyKgNfT4iDvpJVRJ7MyuoFRBN6aQtF2HAHgaDemmG44Fgkg6PPikXum8fyZNUum0/0gvVtCyF/fR9AT8OW1LII+D+b2RgEAE7Eg3nPbOI6dSCl54uZUCGA8kXCzyQRZzfxUDKVqDRc3dzSf7xWSTVxrhylgLwJflSPR+29KgDH9Wvt2ePZUCjUOPLaoXX2iRm3sYGTmIBB3qWajqPVqwVNpychB6y7LaVwt4D6vB7dptLuLiFnv6mmHTmZldAO927942N9g6qAbgYednwmezpfh9zJEAtLJfmQxiZ1SFd8+t+7Yz3CS9G4ZY5G6iIrNpmYP1KW1LO6YjDW8EY8eSuLK9TxePLuOsYhfc/OsPhNcS8C1uzeB+gC1fo9v2NJp4gHsmTqIC+KBPVFMxvQrfdrh2IkUDk7HcbucnjFiVrXhaDQHRaBOrRkxo1O9JBqAeoGrBRyQbjuba8FT2/m2jRyaGbRacL3bv+YIvNnMQRDyexDweRyvQhkNB5Rb2XfevBdT8RCOnRjMapR0vtyQHtDbrF5ayyrpE8FH755C0OfB2dWM5gYmUI/AtQZabenUjgPArfui8HpY30sJ9QZZCayaOqhTmUalmna5uLmDE5fTeMxk81KgVJNdzxuaOQiU6iSTKrbkqBSBN/c99MKJR+B+AZ+OYT1TbGhzXkkXHNtA0GoE6CdmKRRxMumlUBhjLa4jnbKdLzXkDb0ehk8cmtZsPx8EtnfLDesFWksJt3JFbOaKyj6LYCTow0Nyy7bWBiZQ38RsjsDzpSp2SlXdFErQ58Ut49G+V6Js5kqY0LnIAPoerM2k0nn4PAwTsaBlGzIrPHMyBcaATxyyKuD1DUcjMweB1Qg8mQijUK4p7k5A3cihFxuYwBAI+LzGbaeTbaxmszLssJkrdlRKpWXmIIiF6qYOWmYOavTa6Ve387iasX+cYq6ImqOLM6jUOJ47vWr7+3WbdL6kpJIEzcOJhIhqDbgSeVe9CHxEJwcuSg/HdVIogGzl10cB55xbisCtpBRX0nlMJ6Rc8MyY9Put1Trr0pWMG1bwc3N7LItkTDZ2kARc38xBIMpLzaJo8fO/9voKnj+zhufPrOGrr11BpdZ9IweB6wV8oamlvlMjh2bErAwnKlG+cOw0Pvnkj9o+ibXMHATqzSVlDorOvAetgVacczz+xVfwL//6pO11pTUi2ruScdw6EcWx1wevGkVrvc0Roijna06hAMD775jAvlgQt45HNb+/solZ0hFwnQgckM7nK9fzluusnSZXrKBYqemmeQBh6mAtAhdpiJlEGKVqTfHabJeLW7t4e2MHj1qMvgXC2CFjIQKfHQvD62G4c7r14q3mtn3S6OTfffYs/ulfvIp/+hev4l8/darhuW7TnQG9PWRfLIhExK9UotSNHJwRcDErw4nbv7c3dnD5Wh6vXrqulFbZwej2T13e5fN4dF8HSC3kYkqc4Ewqg/PrOaxniuCc25ohs50v42DTyc4Yw2OLM/j9F887ekHtFM65lANvEvCZRFjZrI6H/Fhey2BvNIAJjWmDAZ8HL/7L9yOss8eit4lp1L0pEBH/+fUs3nGT/XOkU4xqwAXxkLXmtlS6gHfeLB2DEPJUuoB9sfbzw2Ji4+JswtbXiQt0VmMURTOzYxH85PMPaVYYqblt3whe+tcfaCgeACSzmZt1Lu5O4/oInDGGBdVtZ33jxLlNBKc2YMT3aHdzz+jkE2K9na+oogy9CNzf4osp1tTOQKX0bqklogXQ0n4+CBTKNZQqtZYUSvNm9bLGBqaa0bAfAZ/22yfo88DrYS0plC2D7k2B2ZTNblPvMDVKoZhH4JVqDWuZei7YqWKApbUsPAy4fdJehJtMhJDatpYDB7TLQ7U4sDeCu5KjDf9umRjpaIieHVwv4EB9JkqtxrtiZeTEBky2UEamUIHXw/CNU6ttNWsIKyvtRp76sHojxxEAGIsGGpzpqzWOZ06msE+ONu1UQZQqNeyUqi05cAAt7eeDgDju1hSKdMFfuZ5HtcaxvJ7VzH9bQfLF9LZ0YtZd7PXFYXYsjJGgr28bmUqax2QT00zAr2aLqKpywU4VAyyvZTA3HrVdYTaTiCC9KwUnjEnjDoaBoRDw+SnJ3OHK9byjTTyCGZ1ZGXYQG2RHDiVxfbeMv39zw/b3MBJm9ZhPsyhjNOxHoVxThgu9fGEL65ki/vmHbgdgb6CSiOS1InCgsf18EGgeZCVQC8yla7solGstFSh2GNEYaLWZKyEW9BmKD2MMd0z2z8pPpHm0UkcCK6YOzQOd4mEfogFvx/NQluXhYnYR61hey2IkqG3m4EaGRsABKXJMbRcQ7NDIoZkZnVkZdhAn9Ccf2I9ExI+n29jcE7k2vTJCQBJwrZGzapR2ell8nzmRQjTgxX9z/yym4iFb4rEtb4aORrR/3+r280Egray38XczPhJEwOvBSrqgbIgbpVDMiGiMlN3UcfBpZmE6jqXVTF/mqosI3CiFIM41I1MHIdTClo0x1vGd7G6pgp9d28X8pP07I3GBXlrLGua/3cZwCPhkfRSnkQ1Su6gbAdpFnNBz41E8cs80Xjy7rjszWg+jEij1JqZZCkXdjVmsVPHcG6v46F1TCAe8tsvY9CJagbr9fBCMHkT9+1jTBcfjYZiW9zqWZBOHOyx0+emhNVJ2M1fUrR1XszAVQ6ZQwVobJZ2dspWT9jP0xrMC1kwdxPmuNoIWpYTtcn49B86l3g+7iPfwZq5omv92E0Mh4NGgDwf2RLC0lu1KxYMTGzCpdB5+L8PESBCPLc4gX67ixbP2Ws2NhFmYOqhTKM1mDoK6cWsJ35MdTcSG48K0vYFK13UEUc1ji1L7ebM7eD9IG6R8knK10dJqFnN7owgH2u/k1XLl2TJoo1cjApJ+pFHEHBQjrJg6pNJ5JCL+Bid6Mx9JM8SdUTspFGHsAJhvYLqJoRBwQDRAZBxx4mlG2eDqUMCnRkPweBgO3zSG5Kj9VnMtMweB2tRBz8xBMKoybj12YgV7VY4mCzYHKqV1NgXVfOSuKYT8nrbSRk5Tv2NoFSlxi7+8nlVEtF0kY+PWTUyjGnCB2Dztx0bmpkGrv8DKQKtUutDSij6TCOPaTqntIWdLa1lEAl7sH4vY/lph7AAYN/G4jaERcGHuYGSD1C5OGDusqJoaPB6GI4szeOnNTaW0zApmg+iFqYOVeceANLzp2+eu4tF7pxWxF/lFq3OpldGsBgI+EvThoYOT+MYb7VXfOEk6X0LAJw1kamYmEcJapoCLWzsd5b+B1k3MclVquTYTR0D6XU6PhrDUB5f6rVzJNE9vxdRB605YaWnfbu99tLSaxe2TsbY3IMXPpwh8AFmYiqPG4ZiRQzOdbsCk0oWG9v6ji0lUaxzPvWG91dxcwCVTB/N5x1IU+Nc/uYxSpdZgCCsGKumZRTeT3i3D62G6bfuCo4szuDYARg/bctu/1h6JMHbgHDjYRp5VTTToa+jEFDNhjGrA1fSrpX4jV8S4xRSKWQ68uRej3sxj/33EuVza2cGdkXj/kYCrYIx5GWOvM8aedWJB7aKOmGa7IODNszLsIJoa1PZMB6fjmJ+M4WkbNdJ6A6oE8bBfSaEYnaTRgBc+D8PyehYH9kRw3/6E8pzdgUrpfAmjOoKo5v13TGA07O+7X6ZWG71A/feZb7MGXBAN+hqmEQqbsgkLm5jSz4/hpxu9NXcoVqrIFioWUijGEbgwcmi2I+tkL2kjV8S1nVJbG5jNP59SKI18GsA5B75PR8ztjSidcd2KwLVGR1qhualBcGQxiVd/dr2lrV0PM2EWMyrMhJ4xpoiYlqPJwnTccvSnNchKi4DPg0fumcYLZ9exq+FU0yu0BlkJxN8n5PfgwB77eVY1I0EvSlWp6xOo11dbjcAXpmIoVzku9NDcQWmjN0mhmEXger0YU6MheNo0dlg2mE1jlSRF4I0wxmYBfBzAnzqznPbxeT24XR4gM+WAkUMzM4kwcsVKg++kVfRO6COH7LWam+W2YyHJ1CGrMwtcjdjI1DKEtTNQaVtjrogejy0msVuq4j+/fAmnV7ZN/7W72ZUplHUd0NO7+usVt/jNJg7t0OzKs2Whw1GNshfRZh58bbvQ8vs8t5pRvB61sNIpCkimDmG/V7cKRe9893s9mIy3N5bCaDqkVWaGMALv9FL0hwA+A6CzhKFD3DubQHq37IiRQzPq2z8tr0Aj9Oaz7N8Twf0HEnjh7Dp+4wO3mX4fSZj1f7aY0+z3MtOTdHo0jEjAh9v2tf7pRAWGlYFK6d2ypdpmAHhgbg9mEmH879+wdsP28Xum8ce/fL+l16r5b//kv+Ldt+zF7xy9u+W57XwZ9+j8/cIBL5KjIdwzM2r7ZzYTVQ20GosGVC3q1n5Xt+6T7AJPXt7GUQu2YWq2d8v44O9/D7saF8D/5dE78an33qz5dVYjcMC4nV5E2Fojndv1mD23msVELGh5RokWYsDUVA+8KntF2wLOGHsUwFXO+auMsQcNXvcEgCcA4MCBA+3+OEt89mML+PUHb+3K91YPhW+evGeGVlOD4OB0HN88vWbp+2TyxqkR6U1Vhs/rMY3Af/8fHIJejKkeqGQq4PmS5dGZHg/Dl/+Hd1pqq3/mZAovnFnHtkHErEWmUMb59ZzuoKnrOoO3BH/1xLtt/Tw9RppGym7lpOoXvdr8ZoI+L37hjgl8440UPv/xg7buCL55ehW7pSp+97G7MakS49/8m5N462pO9+vqefrOBFzd89BMMhHGqStp0+/fzPJ6pqPRBoDURPfNT7+v4xLRQaKTCPw9AI4wxh4BEAIQZ4z9Jef8V9Qv4pw/CeBJADh8+HBXW/FGw37b0bFVOhnGo9XUIEiqamONGkeqNY6dUtU0hVLj0oApszyfkWO2nYFKkp2a9d/53HgUcxZGbU6NhvDsqVV868wq/vsHrF/4xZrPr+dQqdYaauEL5SoK5ZpShaPFgb2d5b4FzSmUjVwREyNBWx3CRxeT+Pa5dbx8YQs/f+u45a87diKFW8aj+JV3Hmj4eQf+7k3D83dLydObR7lGpg7qnodmkokQnj8tGTtYLQes1jjeXM/hH737JkuvN8Ju8DXotJ0D55x/jnM+yzmfA/BJAH/XLN7DhJiVcaUtAW9tahAoFwaT2ticSXt883Od5PkYY5bK2CrVGrKFimFE2y73zIzilvGo7eYfseZSpYaLW42bw2aDt5xkRLFVk9IYm7mSJWFU89DBSUQDXjxjo1JpbbuAH1/YwtHFmZaLxYxJKexmrohIwIuIhUl9ZhG4niNWO8YOF7d2UKzUOq4MGkaGpg6829RnZdjfQU+l8y0lVQKrpVUi2jHOgftV/+9se2N+KmY6UEls6Bq10bcLYwxHFpP48YUtrG1b/52r69eb7yCMujCdRoigehPT6gamIBzw4qN3TeG5N1ZRrFjb0P36yRQ4r89iVyN6GfT+pmZWamriBsbGKQNPWrWxg1WWVsUG5vCkPpzCEQHnnH+Pc/6oE99rkEm26cyzYhCRqHPrRpgNqGp+rtOddisDlfRmazvF0cUZcC6JklWW17I4NDuq2Yxkpe3fKZpdeawOsmrm6H0zyBQq+N6ytfHDT59YwaHZUU1HmJlEGDulqq4h8VauZPkioxeBKz0Puue7/VTk8loGHtY7mzI3QRG4DdrpxhRNDXrzWSbjcm2syc581sRlB2j0yuw4ArcwUElEtN3ad7h5PIpDs6M4dtJa8w/nHEtrWdwzO4q5vZGWcQBikFW31qtGnQPnnEuDrGxG4ADwnlv3YnwkYGluzltXsziTyuhWrShTNXXOYStzUAR6Ar6u0/MgEHeidt5HS2vZtkwcbgRIwG0wkwhhPVOw1R1nZjAhamPNmhusReDOpVCsDFQSs8CNNgU75cjiDE6vZAyrJwSp7QKyhQrmp+KKS5MaMUq2FxF4VM6B7xQr2M6XUalx2ykUQOpvePTeJL597qppXf6xEyl4GPDooWnN580FvGT5LkHP1MHsfI+HfBgJ+nDFRinh8noWByn/rQkJuA3ErIx1G3OarTgEmW0uAcZmDgL1c50OrRcDlYwE3GwWuBN84t5peBjwjIUIVD1udGEqhkvXdhtGuqZ7cMERBH1e+L0MuWLVdg14M0cWkyhVaviWQbkp5xzHTqTwntvGdU2DjdJ11RrHtR17ETjQauqQ0ul5EEjGDtabeXaKFVy6ttvxcLFhhQTcBuL2z04jglFTgyCZCJtWoRiZOQicjMABaSPTqBMw3YOIdl88hJ+/dRxPWzCEWFK1W4s3vLrmPL1bhs8j+VX2gqjsymPFjd6I+/YncGBPxLBj9/XLaVy6tqt092oxHg0i4PNoiuf13RJq3Poa9UwdViwELFbOd8H59Sw476yFfpghAbdB0mLJnxqjpgb1911NS7WxelhJoQhTB0DfzMEOZgOV0vkyGOt+a/LRxSQuXdvFictpw9ctr2UxkwgjHvIrKSB1Dj+dlwZZ9coxPBqQJhJaMQo2gjGGo4tJ/PCtTVzNat/9HXt9BQGfBw/fPaX7fTwehuRoSDOFYqcGHNA3dUil8xiL+A1LEZM2BsPVW+hJwLUgAbdBOyVQqXQe06Nhw6aFmUTItDbWyMxBIEwdjMwc7HBwKm44UGl7t4R4yN/x3BAzPnr3FAI+j6m7/dJqVonUZsfCiAS8DSmgbZtNR50yIiJw2UvVbh24mqOLSdQ48OzJ1vHDlWoNz55axUMH95leTPU24u1eZPQGWhmVEArsGDt0YuJwI0ACboNwwIs90YAtZ56V6+YOQfXSKv0LQ7ZQQTxsHlXHw37HTFvVLfVaiIi228RDfjx0cB+ePZVCReduoFSp4acbOWXNHg9TXJrq6y11pWZdj2jQi51iFVs7JXhYZ/Xyt+2L4a5kXLMa5QdvbWJrp2RpZope9Gs3T69n6iCd7+YCDli7k11ey+KODkwchh0ScJvY2YABtJ1JWr+neW7dbA6KIBbyOzYu89aJEfg8TNcZxuooWSc4cmgGm7kSfvjTLc3n397MoVLjDbfaC1MxLK9lldz59Z3eXHAEwth4M1fEnmiw4zuVo4tJnLyyjTeubOP6Tkn599XXVhAP+fDg/ITp90gmwljPtlZS2c3TCwFfyxQa1mLUhaleA2BeSiiVhXY+A2WYGZ7BuD1iJhHGkiwKZrlUs6YGgZUTejtvPEpWsDcaQMkhE4CAz4NbJvTNHdL5MkZ7FNF+YGEC8ZAPx15fwfvvaBUqrXGj85MxfOWVy7iaLWIyHsJ2vtzTWRgjQR/Wtgu2yvOMOHJoBv/mm0v4xB/9oOW5Tz6wH0Gf+ebsTCIEzqWW+/2qmeebuSJ8HmY5xSQGfn3h2Bl84diZhudmdbqOBeKO9PI1YwHfyBZxfbdMG5gGkIDb5L23jeP5M+tYWsuaisF6toiaBYu30bAfsaDPMDXz9sYO3nHTmOn6fvvIXW2ZTugxPxXHaz/TdpPf3i1hzqHhT2YEfV587O5pPHsqpTn4a2ktC7+X4ZaJegfivGojczIeQtpkEqHT1KtQ7LfRazE1GsIXH38AP9tq3JPweBg+drd27XczMwnp77WSzjcI+JbcRm91g3c07Md//NV3YLXpnPV6PYaVMIC0lxT2e/HmVeNZO0sOmDgMOyTgNvn4vUn8ztfP4ukTK6YCbqUGXGDU5ZkplLGSzuOX32U+lc/pduOFqRi+fjKFTKHckltP53uXQgGAo/cl8V+OX8Z3ltbx6L2NIrG0msGtEyPwqzZvxa338loG775lL3ZK1Z6uVxgbe3NF3HTAmQvdBxb2dfT1erXgmzba6AUfvUu/4sUIj4fhDjm9ZYQTJg7DDuXAbbInGsD7bh/H10+kDMv+APOmBjXJREh3U+d8H0upxM883/Rmq9a47MbTu03Bd968F5PxoOaEwuW1bEukNhYNYDIexNJatqeTCAXRoBc7pSo2s+210XcDvXSdU3cJVlmYjCmpSD2W1rLY16GJw7BDAt4Gj903g9R2AT+5eM3wdaJd2HoErl2Fck65lex9JKJXiZItlMF5d7swm/F6GI4cSuL7568qg6kAaX8gtV3QjNTmp+JYWs0qbf+9vOBEAj5Uaxz5crWn4mhEyO/F3migZXTDVhvjbjthfiqGazslxURCi6W1DKVPTCABb4OHDk4i7PfimMmUPCtNDQJh7KBl+Lu8lkEs5EOyC16fZswkwohpmDv0ogtTi6OLMyhXOZ57o95WLrotte5QFqZieGsjp1RZ9DqFIuilOJrRnK7jnCuGE72int7STqNUqjW8eTVHFSgmkIC3QTTow0fumsRzb6wqruNaWCkhFMwY1IIvr2UxPxnrWQehGmHu0CLgfUhJAMBdyThumYg21EOLMketaG1hKoZSpaZ0cfZ6E1PQS3E0o7kUNlesoFSp9TwCB/QF/OLWLkpk4mAKCXibHF1MIr1bxkvn9ec0W+lKE+jlJsWI1IXp/kUi81MxnFtrNHcQKYzRHpgjqGGM4bHFGbxy8Zryu1payyIW8mFa4w5FCMXLb0v1470wcxAIVx6g/Tb6bjCTiGBFZezQ6ayWdtg7EsRELIhzq9oCTi301iABb5P33T6BsYjfMI1ipalBoDcnWT0itV8sTMWQLVSwqnLG6cemoODIoWSD0cPymjRuVOsO5bZ9I/B6GH5yUSqFdMKw2CrRgU2hhLBbqip/w05ntbTLwlQMy+vaTWJLaxl4PYxMHEwgAW8Tv9eDj987jRfPrimuK2oyhTKyRX0jh2YmY0F4WKuAq0ek9ot5jdngvRglq8fceBSL+xM4Jk8oXF5vrUARBH1e3DIelcr5PKzB9KLbDKqAi6BC9B1s5Tqf1dIO85MxvLmeQ1WjmmtpLYu5vREycTCBBLwDHlucQaFcw4tnW+c0r9ioQAGkwf1TGsYOovrjjsn+plDUawG678ZjxtHFJM6uZvD98xvyHYr+70c8Nxru3SRCoL6JGQv5LHVJ9orm2Tsbcgql13n6+akYipUaLm61DktbXstS/bcFSMA74P4DY5hJhDWn5Nlp4hEkE2GspBud1MWI1H4JJSAJX3I01DIYKhb0OTL1sB0evTcJDwP+r28tAzC+QxHP9fpuQUTgg7SBCbTut4gIvNf11qIRbqkpDy5MHCj/bU7b7z7G2H7G2HcZY+cYY2cYY592cmFuwOOR5jT//ZubSh5RIN4cszYFvLkKRatBpR80V6Js75aRiPbvojIRC+I9t43jrFyBcodhBC4JRS/z3wAwIpePDtIGJiDNy1EbO2zmihiL+Ht+Mb5t3wg8DC3m06IsdBDO+0Gnk79YBcC/4pwfBPAuAL/BGLvTmWW5h6OLM6jWOJ57o3FO80q6AL+X2XrzJhNhrG7nlQ7PUqWGt67mBuJEXpiON5g7SG30/c3rivGpwsRBj/5F4FLaZJDy34AUeMwkwkoOfDNrv43eCUJ+L+bGoy1NYkvUQm+Ztnd0OOerAFbl/2cZY+cAzAA469DaXMG87L/4O18/i9/75pLyeLFSw0zC2MihmZlECOUqx2auiH3xkOaI1H6xMBVDucrx9sYO5qdiPR8MpcVH75rE57/mMf39zI5JzUi9nAUOSPsaYb8XE7HBisABqRJF2cS04YXpNAtTMZxeaYzAl2UTB7OphoRDw6wYY3MA7gPwssZzTwB4AgAOHDAfxuRG/o9fvFvTcPadN++19X3UruH74nVD4UGIwOsbmRlZwMu28vvdIBby44/+4f2a9d9qGGP4w08uYrYPri5/8A8O9XSErVWSo2G89KbUw7CZK+GuZH/WuDAVx3NvrGGnWFH2DJbWMmTiYJGOBZwxNgLgbwH8C855S1En5/xJAE8CwOHDh52bczpAvOOmPXjHTXs6/j71WvAC7jugGpE63v9a2FvGZXOHtSyOonduPGZ8+M5JS6/70EFrr3Oaj91jbcxrr0kmwriaLaJUqfV8kJUatfn0fQfGpLLQtayhtydRp6NdC8aYH5J4f5lz/lVnlnTjUo/ApUoUMSI14Ot/sVDA58Ft+0awvJZFrcalFEqfc+BE+8wkwuAcuHRtB9lCxRHDiXZonolyVZg49LFs1k10UoXCAPwZgHOc8z9wbkk3LvGQZOwgKlEGpQJFICpRcqUKarw/XZiEM4hg4dSVbQD9q5TZPxZBJOBVNi6X+jh50410Etq9B8CvAvggY+yE/O8Rh9Z1w5KUqwPEiNRBE/CVdB6XtqQ7hH7WphOdIdJ1/RZwj4fh9sm6+fQgdB67iU6qUH4AgHYZHEZMihO1sAcHKBIRb6pXLkhz0BM9ruognENs/J66kgbQ31LHg1MxPH9mTRncNhkPYoxMHCzR/+Qq0YCY1TyIfoCiLvflC/JkP0qhuJaQ34vxkQDOpKSIt5/NRvNTMVzfLWMjW5TThoMTtAw6JOADRjIRxvXdMl6/dF13RGq/mB4NIRby1SNwSqG4mmQijKI8z77fAg4Ap1PbZOJgExLwAUM0L3x/eQMLU/0xcdCDMYYFOVoCKIXidpKj0rkWDXgRDvRv2Ja4s3v+9Lpk4kAVKJYhAR8wRHXA1k5poNInAvWaaBPT3YiNzPE+d4ruiQYwEQviudPSOIpBPO8HFRLwAUPd3TiIsyDEmqIB70DUpxPtI861vQOwYShMQ8jEwR70DhwwhLEDMJilVMpgKEqfuJ4Z2WxkEKYlivPq5vEomTjYgAR8wBDGDoDxiNR+IdZE6RP3IyLwfqdQgHrjDqVP7NE7fynCMslEGIwxwxGp/SIe8vfdYIJwBkXABySFAgALtIFpCxLwAeR/fPBWTZ/NQeEzD88j1kNvSaI77I0G8JsfuQMP393/gVsHp+P49QdvxS/eP9PvpbgKxnnvBgQePnyYHz9+vGc/jyAIYhhgjL3KOT/c/DjlwAmCIFwKCThBEIRLIQEnCIJwKSTgBEEQLoUEnCAIwqWQgBMEQbgUEnCCIAiXQgJOEAThUnrayMMY2wDwsza/fBzApoPL6Rd0HIMFHcdgQcehzU2c84nmB3sq4J3AGDuu1YnkNug4Bgs6jsGCjsMelEIhCIJwKSTgBEEQLsVNAv5kvxfgEHQcgwUdx2BBx2ED1+TACYIgiEbcFIETBEEQKkjACYIgXIorBJwx9jBjbJkx9hZj7LP9Xo9VGGNfZIxdZYydVj22hzH2ImPsTfnjWD/XaAZjbD9j7LuMsXOMsTOMsU/Lj7vtOEKMsVcYYyfl4/gd+XFXHYeAMeZljL3OGHtW/tx1x8EYu8gYe4MxdoIxdlx+zI3HkWCMPcUYW5LfJ+/u1XEMvIAzxrwA/hjAxwDcCeCXGGN39ndVlvkSgIebHvssgO9wzm8H8B3580GmAuBfcc4PAngXgN+Qf/9uO44igA9yzg8BWATwMGPsXXDfcQg+DeCc6nO3HscHOOeLqpppNx7HvwPwLc75AoBDkP4uvTkOzvlA/wPwbgDPqz7/HIDP9XtdNtY/B+C06vNlANPy/6cBLPd7jTaP5xiAD7v5OABEALwG4J1uPA4As7IofBDAs/JjbjyOiwDGmx5z1XEAiAO4ALkgpNfHMfAROIAZAJdVn1+RH3Mrk5zzVQCQP+7r83oswxibA3AfgJfhwuOQ0w4nAFwF8CLn3JXHAeAPAXwGQE31mBuPgwN4gTH2KmPsCfkxtx3HLQA2APy5nNL6U8ZYFD06DjcIONN4jGofewxjbATA3wL4F5zzTL/X0w6c8yrnfBFSBPtzjLG7+7wk2zDGHgVwlXP+ar/X4gDv4ZzfDyk9+huMsV/o94LawAfgfgB/wjm/D8AOepj2cYOAXwGwX/X5LIBUn9biBOuMsWkAkD9e7fN6TGGM+SGJ95c551+VH3bdcQg452kA34O0P+G243gPgCOMsYsA/grABxljfwn3HQc45yn541UAXwPwc3DfcVwBcEW+mwOApyAJek+Oww0C/hMAtzPGbmaMBQB8EsAzfV5TJzwD4HH5/49DyikPLIwxBuDPAJzjnP+B6im3HccEYywh/z8M4CEAS3DZcXDOP8c5n+Wcz0F6L/wd5/xX4LLjYIxFGWMx8X8AHwFwGi47Ds75GoDLjLF5+aEPATiLXh1HvzcBLG4UPALgPICfAvh8v9djY91fAbAKoAzpSv0pAHshbUC9KX/c0+91mhzDeyGlrE4BOCH/e8SFx3EvgNfl4zgN4Avy4646jqZjehD1TUxXHQek3PFJ+d8Z8b5223HIa14EcFw+t54GMNar46BWeoIgCJfihhQKQRAEoQEJOEEQhEshAScIgnApJOAEQRAuhQScIAjCpZCAEwRBuBQScIIgCJfy/wPtNqDoTzAGOAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.featured_music.plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "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>season</th>\n",
       "      <th>episode</th>\n",
       "      <th>live_viewership</th>\n",
       "      <th>featured_music</th>\n",
       "      <th>media/cultural_refs</th>\n",
       "      <th>plot</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.41 million</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>In the desert outside of Albuquerque, New Mexi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1.49 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt finishes having rough sex with Skyler and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1.08 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>As Walt and Jesse are scrubbing up the dissolv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.09 million</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>Hank puts his DEA team on notice that \"new pla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.97 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Donning a jacket and tie, Jesse interviews for...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>4.41 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Walter White parks his car down the street fro...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>5.11 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Jack, Kenny and Lydia Rodarte-Quayle observe t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>6.37 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>In a flashback from Walter White and Jesse Pin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>6.58 million</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Just as seen at the end of the previous episod...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>10.28 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>With police searching for him in New Hampshire...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    season  episode live_viewership  featured_music  media/cultural_refs  \\\n",
       "0        1        1    1.41 million              15                    2   \n",
       "1        1        2    1.49 million               6                    0   \n",
       "2        1        3    1.08 million               4                    0   \n",
       "3        1        4    1.09 million               7                    2   \n",
       "4        1        5    0.97 million               8                    0   \n",
       "..     ...      ...             ...             ...                  ...   \n",
       "57       5       12    4.41 million               5                    0   \n",
       "58       5       13    5.11 million               8                    0   \n",
       "59       5       14    6.37 million               5                    0   \n",
       "60       5       15    6.58 million               5                    0   \n",
       "61       5       16   10.28 million               8                    0   \n",
       "\n",
       "                                                 plot  \n",
       "0   In the desert outside of Albuquerque, New Mexi...  \n",
       "1   Walt finishes having rough sex with Skyler and...  \n",
       "2   As Walt and Jesse are scrubbing up the dissolv...  \n",
       "3   Hank puts his DEA team on notice that \"new pla...  \n",
       "4   Donning a jacket and tie, Jesse interviews for...  \n",
       "..                                                ...  \n",
       "57  Walter White parks his car down the street fro...  \n",
       "58  Jack, Kenny and Lydia Rodarte-Quayle observe t...  \n",
       "59  In a flashback from Walter White and Jesse Pin...  \n",
       "60  Just as seen at the end of the previous episod...  \n",
       "61  With police searching for him in New Hampshire...  \n",
       "\n",
       "[62 rows x 6 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "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>season</th>\n",
       "      <th>episode</th>\n",
       "      <th>live_viewership</th>\n",
       "      <th>featured_music</th>\n",
       "      <th>media/cultural_refs</th>\n",
       "      <th>plot</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.41 million</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>In the desert outside of Albuquerque, New Mexi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1.49 million</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt finishes having rough sex with Skyler and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1.08 million</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>As Walt and Jesse are scrubbing up the dissolv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.09 million</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>Hank puts his DEA team on notice that \"new pla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.97 million</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Donning a jacket and tie, Jesse interviews for...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   season  episode live_viewership  featured_music  media/cultural_refs  \\\n",
       "0       1        1    1.41 million              15                    2   \n",
       "1       1        2    1.49 million               6                    0   \n",
       "2       1        3    1.08 million               4                    0   \n",
       "3       1        4    1.09 million               7                    2   \n",
       "4       1        5    0.97 million               8                    0   \n",
       "\n",
       "                                                plot  \n",
       "0  In the desert outside of Albuquerque, New Mexi...  \n",
       "1  Walt finishes having rough sex with Skyler and...  \n",
       "2  As Walt and Jesse are scrubbing up the dissolv...  \n",
       "3  Hank puts his DEA team on notice that \"new pla...  \n",
       "4  Donning a jacket and tie, Jesse interviews for...  "
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df[ df['live_viewership'] != 'N/A' ]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['1.41 million',\n",
       " '1.49 million',\n",
       " '1.08 million',\n",
       " '1.09 million',\n",
       " '0.97 million',\n",
       " '1.07 million',\n",
       " '1.50 million',\n",
       " '1.66 million',\n",
       " '1.60 million',\n",
       " '1.13 million',\n",
       " '1.29 million',\n",
       " '1.21 million',\n",
       " '1.41 million',\n",
       " 'N/A',\n",
       " '1.04 million',\n",
       " 'N/A',\n",
       " 'N/A',\n",
       " 'N/A',\n",
       " 'N/A',\n",
       " '1.50 million',\n",
       " '1.95 million',\n",
       " '1.55 million',\n",
       " '1.33 million',\n",
       " '1.46 miilion',\n",
       " '1.61 million',\n",
       " '1.64 million',\n",
       " '1.52 million',\n",
       " '1.78 million',\n",
       " '1.61 million',\n",
       " '1.20 million',\n",
       " '1.32 million',\n",
       " '1.19 million',\n",
       " '1.56 million',\n",
       " '2.58 million',\n",
       " '1.97 million',\n",
       " '1.71 million',\n",
       " '1.83 million',\n",
       " '1.75 million',\n",
       " '1.67 milion',\n",
       " '1.91 million',\n",
       " '1.98 million',\n",
       " '1.89 million',\n",
       " '1.80 million',\n",
       " '1.55 million',\n",
       " '1.73 million',\n",
       " '1.90 million',\n",
       " '2.93 million',\n",
       " '2.29 million',\n",
       " '2.20 million',\n",
       " '2.29 million',\n",
       " '2.48 million',\n",
       " '2.81 million',\n",
       " '2.98 million',\n",
       " '2.78 million',\n",
       " '5.92 million',\n",
       " '4.77 million',\n",
       " '4.85 million',\n",
       " '4.41 million',\n",
       " '5.11 million',\n",
       " '6.37 million',\n",
       " '6.58 million',\n",
       " '10.28 million']"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['live_viewership'].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['live_viewership']= df['live_viewership'].apply(lambda x: x.replace('million', '').replace('miilion', '').replace('milion', '')).apply(float) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "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>season</th>\n",
       "      <th>episode</th>\n",
       "      <th>live_viewership</th>\n",
       "      <th>featured_music</th>\n",
       "      <th>media/cultural_refs</th>\n",
       "      <th>plot</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.41</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>In the desert outside of Albuquerque, New Mexi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1.49</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt finishes having rough sex with Skyler and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1.08</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>As Walt and Jesse are scrubbing up the dissolv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.09</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>Hank puts his DEA team on notice that \"new pla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.97</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Donning a jacket and tie, Jesse interviews for...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   season  episode  live_viewership  featured_music  media/cultural_refs  \\\n",
       "0       1        1             1.41              15                    2   \n",
       "1       1        2             1.49               6                    0   \n",
       "2       1        3             1.08               4                    0   \n",
       "3       1        4             1.09               7                    2   \n",
       "4       1        5             0.97               8                    0   \n",
       "\n",
       "                                                plot  \n",
       "0  In the desert outside of Albuquerque, New Mexi...  \n",
       "1  Walt finishes having rough sex with Skyler and...  \n",
       "2  As Walt and Jesse are scrubbing up the dissolv...  \n",
       "3  Hank puts his DEA team on notice that \"new pla...  \n",
       "4  Donning a jacket and tie, Jesse interviews for...  "
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD4CAYAAADiry33AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAcxklEQVR4nO3de4xc53nf8e9vzsxsKlmJL6RlVRdTRdk0SmvKwoKRIcOW7FigBLtEgPxBIrUDwwahQEKcNkght4CMtn8aCFrHignCYVUjkYQilmwipSW5bmo5EZRwqdASqYvN0Eq1oByurVSK7ZizM/P0jzmzOzucy5nZWe6el78PMNiZc867e17LeubR816OIgIzM0tXZbNvwMzMNpYDvZlZ4hzozcwS50BvZpY4B3ozs8RVN/sGBtm2bVvs2LFjs2/DzKw0jh8//oOI2D7o3JYM9Dt27GBhYWGzb8PMrDQk/c2wcy7dmJklzoHezCxxDvRmZolzoDczS5wDvZlZ4sYGeknXSvpTSS9IOiXpUwOukaTPSTot6VlJN/Wc2yPppfzcvbPugJmZjVYko28Cvx0RvwDcDNwt6Ya+a+4AduavA8AXACRlwP35+RuA/QPampnZBhob6CPi1Yh4Jn//98ALwNV9l+0FvhQdTwNvlnQVsBs4HRFnIqIBPJxfuyE+943v8s3vLE3V9n89/7d8//WfzviOzMw230Q1ekk7gHcDf9F36mrglZ7Pi/mxYccH/e4DkhYkLSwtTResD37zr/mz707eNiK46w+P8+Bf/t+p/q6Z2VZWONBLehPwZeC3IuKN/tMDmsSI4xcejDgUEfMRMb99+8BVvGPVsgqNZnvidsutoNkOfrrcmurvmpltZYW2QJBUoxPk/ygiHhlwySJwbc/na4CzQH3I8Q1Rr1ZotCZ/YtZyq/PlMM2XhJnZVldk1o2APwBeiIjfHXLZEeBj+eybm4HXI+JV4BiwU9L1kurAvvzaDVGfMqPvtmm0HOjNLD1FMvpbgI8Cz0k6kR/798B1ABFxEDgK3AmcBn4CfDw/15R0D/A4kAGHI+LULDvQq5ZpJTufRLfNsjN6M0vQ2EAfEX/G4Fp77zUB3D3k3FE6XwQbrl6dLqM/74zezBKW1MrYWlZZX0bvQG9mCUoq0HcGY6eo0Xsw1swSllSgn3p6ZbMzU2eaGTtmZltdUoF+buqMvjN/vtH0PHozS09SgX7aGn0jz+iXndGbWYKSCvT1rLJShpmEa/RmlrKkAn1tytJNd/68Z92YWYqSCvRTr4x1Rm9mCUsr0Fc1XUbf8oIpM0tXWoF+6sFYl27MLF1JBfpp59G7dGNmKUsr0Fen3AJhJaP39EozS09Sgb5Tugna7ckCtjN6M0tZWoG+2unOcnuygN3N5ButNp2NOM3M0pFWoM863Zk0Mz/fc73LN2aWmqQCfS3rbJs/abDuret75o2ZpabIowQPSzon6eSQ878j6UT+OimpJemt+bmXJT2Xn1uY9c33q1czYPKMvvd61+nNLDVFMvoHgD3DTkbEZyPixoi4Efg08M2IeK3nktvy8/PrutMCVjP6SWv0zujNLF1jA31EPAm8Nu663H7goXXd0Tp0B2MnXeHam8Wfd0ZvZomZWY1e0mV0Mv8v9xwO4AlJxyUdGNP+gKQFSQtLS0tT3cO0g7ENZ/RmlrBZDsZ+BPjzvrLNLRFxE3AHcLek9w1rHBGHImI+Iua3b98+1Q2sTK9cR0bv/W7MLDWzDPT76CvbRMTZ/Oc54FFg9wz/3gVqU2b0a2r0U+xnb2a2lc0k0Ev6OeD9wFd7jl0u6Yrue+B2YODMnVmZtkbfOx3TGb2ZpaY67gJJDwG3AtskLQKfAWoAEXEwv+xXgCci4sc9Ta8EHpXU/TsPRsRjs7v1C02b0Xt6pZmlbGygj4j9Ba55gM40zN5jZ4Bd097YNLqDsZMumGq02p2HlrTaHow1s+QktTJ2pXQzRUZ/+dx0i63MzLa6pAL9ehZMXT5XnaqtmdlWl1SgX09G/6Y80Hsw1sxSk1agz6addbOa0bt0Y2apSSvQryOjv6ye1+id0ZtZYpIK9LVsypWxrVgp3Sw7ozezxCQV6KfP6FurpRtn9GaWmKQCfbUy7aybnozeT5gys8QkFeglUa9WaEyxYKpbo/c2xWaWmqQCPXRm3kxSumm1g1Y7qFcr1DJ5Hr2ZJSe9QF+tTBSsu9fWq5WJvyTMzMoguUBfyzRRsO4OvtazCrUJvyTMzMogwUA/YUbfXJvRO9CbWWqSC/T1aoXzEwTrbkZfyyrUsooHY80sOekF+qwy0aKn7hOl6lmFuWrF0yvNLDnpBfpqZaJFT41WC4BatZPRN5qtjbo1M7NNMTbQSzos6ZykgY8BlHSrpNclnchf9/Wc2yPpJUmnJd07yxsfZtIafaMno687ozezBBXJ6B8A9oy55lsRcWP++k8AkjLgfuAO4AZgv6Qb1nOzRUw6RXJl1k1VE8/YMTMrg7GBPiKeBF6b4nfvBk5HxJmIaAAPA3un+D0TqU24Mna5bzDWe92YWWpmVaN/j6RvS/qapF/Mj10NvNJzzWJ+bCBJByQtSFpYWlqa+kYmzuibq/Po61UvmDKz9Mwi0D8DvDMidgG/B3wlP64B1w5NtSPiUETMR8T89u3bp76ZenWybQxWpld6Hr2ZJWrdgT4i3oiIH+XvjwI1SdvoZPDX9lx6DXB2vX9vHGf0ZmZrrTvQS3qHJOXvd+e/84fAMWCnpOsl1YF9wJH1/r1xJl4Z27PXzaRtzczKoDruAkkPAbcC2yQtAp8BagARcRD4VeA3JDWBfwD2RUQATUn3AI8DGXA4Ik5tSC96TLqpmTN6M0vd2EAfEfvHnP888Pkh544CR6e7telMuo3Bck+NvjPrxvPozSwtSa6MnWwwtn8LBGf0ZpaW9AL9OgZjvWDKzFKUXKCvZRXa0XlyVBFrHjzijN7MEpRcoK9XO10qmpl3r6tlopZVaLaDdsEvCTOzMkgu0NeyzjqtolsZLLfaVATVfNbNJG3NzMoguUA/N0VGX8s6beqZA72ZpSe5QN8N2kVr7Y1WeyXAr7T1gKyZJSS5QD9Njb7bxqUbM0tRcoF+0ox+ubVaulnN6D0Ya2bpSC7Qd7PyoqtjB2f0fpygmaUjvUA/cUYfKzN16t0ZO87ozSwh6QX6ajfQFwvW55tt6tVsTVvX6M0sJckF+m6dvehg7HKrvZLJT1rfNzMrgwQDfSdoF55e2Vujn/BLwsysDJIL9JMOxq6ZdePSjZklaGygl3RY0jlJJ4ec/zVJz+avpyTt6jn3sqTnJJ2QtDDLGx9m8sHYCzN6L5gys5QUyegfAPaMOP894P0R8S7gPwOH+s7fFhE3RsT8dLc4mUkXTJ3v3QLBGb2ZJajIE6aelLRjxPmnej4+Tech4JtmmgVTF2yB4EBvZgmZdY3+E8DXej4H8ISk45IOjGoo6YCkBUkLS0tLU9/ApFl5ozVgwZRLN2aWkLEZfVGSbqMT6N/bc/iWiDgr6e3A1yW9GBFPDmofEYfIyz7z8/NTr1iaeHplc3XB1OoWx14wZWbpmElGL+ldwBeBvRHxw+7xiDib/zwHPArsnsXfG2VuHRn9XNZZOOWM3sxSsu5AL+k64BHgoxHxnZ7jl0u6ovseuB0YOHNnlibdmGy52Tu9crI5+GZmZTC2dCPpIeBWYJukReAzQA0gIg4C9wFvA35fEkAzn2FzJfBofqwKPBgRj21AH9bIKiKrqPDGZOcHTK90Rm9mKSky62b/mPOfBD454PgZYNeFLTZeLVOhvW4iYs2sm6wiJGf0ZpaW5FbGQiczL5KVN9tBxGomL6lwWzOzskgz0FcrhQZju5l7d+sDyL8knNGbWUKSDPS1rFJoG4Nu5t7N6CH/knBGb2YJSTLQF83oGwMy+lpWcY3ezJKSZKAvGqy7A7ZzfRl90YeWmJmVQZKBvuiAavea7vx56MzYcenGzFKSZKCvVSuFtjFYGYzN1pZuPBhrZilJMtDPZRUazfELpgYNxs55MNbMEpNkoK9Viy2Y8mCsmV0Kkgz0k9bo+wdjndGbWUqSDPTFZ904ozez9CUZ6Itm5cMWTBV9sLiZWRmkGegLzpwZNOum7ozezBKTZqAvmNF3M/d6ta9G70BvZglJMtBPujK2vmYevQo/tMTMrAwSDvQFplc6ozezS8DYQC/psKRzkgY+BlAdn5N0WtKzkm7qObdH0kv5uXtneeOjFC3drNboe7dAKLbzpZlZWRTJ6B8A9ow4fwewM38dAL4AICkD7s/P3wDsl3TDem62qHomGq02EaOz+m6gd0ZvZikbG+gj4kngtRGX7AW+FB1PA2+WdBWwGzgdEWciogE8nF+74bqBe1z5pjsY2z/rpsiXhJlZWcyiRn818ErP58X82LDjA0k6IGlB0sLS0tK6bqgbuMcNyK5k9H2bmkVAq+1Ab2ZpmEWg14BjMeL4QBFxKCLmI2J++/bt67qhbkY/rk7faLapVkSlsnqrK21dvjGzRFRn8DsWgWt7Pl8DnAXqQ45vuEky+t6yzZq2zej0wMys5GaR0R8BPpbPvrkZeD0iXgWOATslXS+pDuzLr91w3ax83FYGjWZ7zUDsmrat8dscm5mVwdiMXtJDwK3ANkmLwGeAGkBEHASOAncCp4GfAB/PzzUl3QM8DmTA4Yg4tQF9uEC9YEbfaMUFGX09n2rpxwmaWSrGBvqI2D/mfAB3Dzl3lM4XwUVVtM7eaLaZG5LRe6tiM0tFsitjgbFbGXRq9GvHjIvW983MyiLJQL+a0Y+usw+s0WfO6M0sLUkG+m6W3iiU0ffNuvH0SjNLTJKBfiUrHzsYe2FGP+eM3swSk2ag726BUGB65bCM3jV6M0tFkoG+6IBqo9Ves/1Bb1tn9GaWiiQDfdHplcsDSjdF5+CbmZVFmoG+YFa+3IwLplfWq/lArhdMmVki0gz0RRdMtdrUq9natlnns0s3ZpaKJAP96oKpIoOxfQumqt0tEBzozSwNSQb6STL6C7ZA8GCsmSUmyUBfK7gx2agFU87ozSwVSQb6blZeaJviC3avLNbWzKwskgz0kqhlKvbgEU+vNLPEJRnoIX/I94isvN0OlltxQUZfqYhqRa7Rm1kykg30tWplZFa+3M4fDF698H+CWja6rZlZmRQK9JL2SHpJ0mlJ9w44/zuSTuSvk5Jakt6an3tZ0nP5uYVZd2CY2piMvnuuP6OHTvB3Rm9mqSjyKMEMuB/4EJ0HgR+TdCQinu9eExGfBT6bX/8R4N9ExGs9v+a2iPjBTO98jHpWGTm9sjsjp38efedYxStjzSwZRTL63cDpiDgTEQ3gYWDviOv3Aw/N4ubWo16tjJxe2c3Y+wdjofPcWGf0ZpaKIoH+auCVns+L+bELSLoM2AN8uedwAE9IOi7pwLA/IumApAVJC0tLSwVua7TOYOzwJ0x1a/DDSjeu0ZtZKooE+gtrG53gPchHgD/vK9vcEhE3AXcAd0t636CGEXEoIuYjYn779u0Fbmu0WlWjM/qWB2PN7NJQJNAvAtf2fL4GODvk2n30lW0i4mz+8xzwKJ1S0IYbN73Sg7FmdqkoEuiPATslXS+pTieYH+m/SNLPAe8Hvtpz7HJJV3TfA7cDJ2dx4+PUxg7Gtleum7StmVmZjJ11ExFNSfcAjwMZcDgiTkm6Kz9/ML/0V4AnIuLHPc2vBB6V1P1bD0bEY7PswDD1aoW//2lz6PmVjH7QYKwzejNLyNhADxARR4GjfccO9n1+AHig79gZYNe67nBK9TF19saIjL6eVfhJY/iXhJlZmSS7MnZcVj42o3fpxswSkWygHzdzpjsjZ9BgbC0Ty00vmDKzNCQb6NeX0WfO6M0sGckG+nHbGKzOuhm0BYJXxppZOpIN9J1tDIavjB2V0c+5Rm9mCUk30I/b62bEFgheGWtmKUk20I9b9LSyqdmwBVMu3ZhZIpIN9PVqhVY7aLUHZ/XLI/a68aZmZpaSZAN9bcyzX8dl9MutoD3kS8LMrEySDfRzeaY+rHwzatZNt233cYNmZmWWbKBfyeiH1Nob+YPB8314+tp2jo0azDUzK4tkA319TEbfaLYH1udhdSaOB2TNLAXJBvrVjH74YOygsg2sPl7QA7JmloJkA/1qRj940ZQzejO7VKQb6PNsvTEyox8S6MeUfczMyqRQoJe0R9JLkk5LunfA+VslvS7pRP66r2jbjdIN4sOC9fmWM3ozuzSMffCIpAy4H/gQnefHHpN0JCKe77v0WxHx4Snbzlx9TJ19udkeuP0BjJ+Db2ZWJkUy+t3A6Yg4ExEN4GFgb8Hfv56261Ibk5U3RpRuuoOxzujNLAVFAv3VwCs9nxfzY/3eI+nbkr4m6RcnbIukA5IWJC0sLS0VuK3RxtXZl4uUbpzRm1kCigT6QXMQ+0c4nwHeGRG7gN8DvjJB287BiEMRMR8R89u3by9wW6ONq7M3msOnV9arWrnGzKzsigT6ReDans/XAGd7L4iINyLiR/n7o0BN0rYibTfKuBp9oxXUq9ngtlmWt/XKWDMrvyKB/hiwU9L1kurAPuBI7wWS3qF8LwFJu/Pf+8MibTfK2Bp9s70yBfOCts7ozSwhY2fdRERT0j3A40AGHI6IU5Luys8fBH4V+A1JTeAfgH0REcDAthvUlzXGzropUKP3rBszS8HYQA8r5ZijfccO9rz/PPD5om0vhm79fdhzY0ctmBo3B9/MrEySXRk7l9fZR5duBnd/ztMrzSwhyQb6bp19VOmmNqR04wVTZpaSZAP9uOmV50dk9HVn9GaWkGQDfVYR0nSDsc7ozSwlyQZ6SdSyylQ1+pWBXGf0ZpaAZAM9wFxWGThzptUO2jH4weDQ+ZKoZ5WhM3bMzMok6UBfqw7O6LvHugO2A9tmckZvZklIOtDXs8rAOns3yx9WuoHOgKxr9GaWgqQDfa06OCvvHhs2GAuMrO+bmZVJ0oG+k9FfWGdfdkZvZpeQpAN9LatwflSNflSgzyqcd6A3swQkHejnhmTlKxn9iNJNvVph2aUbM0tA0oG+NmYwdlRGP6ytmVnZJB3o62OmV86Nyei9e6WZpSDpQD8sK+8O0I7O6MVy0wumzKz8kg709erowdjRNfrMg7FmloRCgV7SHkkvSTot6d4B539N0rP56ylJu3rOvSzpOUknJC3M8ubHGbZganmlRj98ZWw9kwdjzSwJY58wJSkD7gc+ROdh38ckHYmI53su+x7w/oj4O0l3AIeAX+o5f1tE/GCG911ILdPAOvv5Qhm9a/RmloYiGf1u4HREnImIBvAwsLf3goh4KiL+Lv/4NHDNbG9zOp0pktMtmPKsGzNLRZFAfzXwSs/nxfzYMJ8AvtbzOYAnJB2XdGBYI0kHJC1IWlhaWipwW+PVhuxeWWTBlLdAMLNUFHk4+KBC9sDpKJJuoxPo39tz+JaIOCvp7cDXJb0YEU9e8AsjDtEp+TA/Pz+T6S7DFj0VXjDljN7MElAko18Eru35fA1wtv8iSe8CvgjsjYgfdo9HxNn85zngUTqloIti2DYGRRZM1Ydsn2BmVjZFAv0xYKek6yXVgX3Akd4LJF0HPAJ8NCK+03P8cklXdN8DtwMnZ3Xz43Sz8oi1/4FQbHqlM3ozS8PY0k1ENCXdAzwOZMDhiDgl6a78/EHgPuBtwO9LAmhGxDxwJfBofqwKPBgRj21ITwaoZRUioNmONVMpi+xH7wePmFkqitToiYijwNG+Ywd73n8S+OSAdmeAXf3HL5Zuxr7caq8p03Rn4ozM6LOMdnQeO5hVhs+3NzPb6pJeGdsN7v2ZeaPVoiJGBvDuYwad1ZtZ2SUd6LsZe/8Uy+VWjMzmYbWs40VTZlZ2aQf6vC7f/5SpRrM9csYNrC37mJmVWdqBvjqsdNMeuUUx9GT0Lt2YWcklHei7WXt/Vr5cIKMf1tbMrGwuiUA/KKMfG+iH/NeAmVnZJB3ohw/Gtj0Ya2aXjLQD/bCMvtBgrKdXmlka0g70Q2bONApNr8zytn6coJmVW9KBfmiNvtlamXo5vK0zejNLQ9KBvj5s1k2RjN7z6M0sEWkH+rzO3r/dcJEaffe8tyo2s7JLO9APqbMvt9ojd64EVhZUOaM3s7JLOtAP25is0WyvzJMf2tYrY80sEUkH+mE1+karzZz3ujGzS0TSgb42JFj3708/sK23QDCzRBQK9JL2SHpJ0mlJ9w44L0mfy88/K+mmom03Un3IgGqjWWBlbNWDsWaWhrGBXlIG3A/cAdwA7Jd0Q99ldwA789cB4AsTtN0wQzc1a8X4lbErbb1gyszKrcijBHcDp/PHAiLpYWAv8HzPNXuBL0XnKdxPS3qzpKuAHQXabpisIrKK+O9Pvcz/fPbVleM/Ot9cGagdprtg6ovfOsMjzyxu6H2amQG85bI6/+Ou98z89xYJ9FcDr/R8XgR+qcA1VxdsC4CkA3T+a4DrrruuwG0V86kP7uTF77+x5tg/e8cVfPhf/uOR7apZhd/8wD/l9NKPZnYvZmaj/OzP1Dbk9xYJ9INS3/56xrBrirTtHIw4BBwCmJ+fn1m95Dc/uHPqtv/29p+f1W2YmW2aIoF+Ebi25/M1wNmC19QLtDUzsw1UZNbNMWCnpOsl1YF9wJG+a44AH8tn39wMvB4RrxZsa2ZmG2hsRh8RTUn3AI8DGXA4Ik5Juis/fxA4CtwJnAZ+Anx8VNsN6YmZmQ2kzkSZrWV+fj4WFhY2+zbMzEpD0vGImB90LumVsWZm5kBvZpY8B3ozs8Q50JuZJW5LDsZKWgL+Zsrm24AfzPB2Nov7sXWk0AdwP7aaWffjnRGxfdCJLRno10PSwrCR5zJxP7aOFPoA7sdWczH74dKNmVniHOjNzBKXYqA/tNk3MCPux9aRQh/A/dhqLlo/kqvRm5nZWilm9GZm1sOB3swscckE+s18CPl6SDos6Zykkz3H3irp65K+m/98y2beYxGSrpX0p5JekHRK0qfy46Xqi6SfkfSXkr6d9+M/5sdL1Q/oPLNZ0l9J+pP8c+n6ACDpZUnPSTohaSE/Vrq+5I9Y/WNJL+b/nrznYvUjiUC/2Q8hX6cHgD19x+4FvhERO4Fv5J+3uibw2xHxC8DNwN35P4Oy9eU88IGI2AXcCOzJn7FQtn4AfAp4oedzGfvQdVtE3Ngz77yMffmvwGMR8c+BXXT+2VycfkRE6V/Ae4DHez5/Gvj0Zt/XBPe/AzjZ8/kl4Kr8/VXAS5t9j1P06avAh8rcF+Ay4Bk6zzkuVT/oPM3tG8AHgD/Jj5WqDz19eRnY1nesVH0Bfhb4HvkEmIvdjyQyeoY/nLysrozOE7rIf759k+9nIpJ2AO8G/oIS9iUveZwAzgFfj4gy9uO/AP8OaPccK1sfugJ4QtJxSQfyY2Xryz8BloD/lpfTvijpci5SP1IJ9IUfQm4bS9KbgC8DvxURb2z2/UwjIloRcSOdrHi3pH+xybc0EUkfBs5FxPHNvpcZuSUibqJTmr1b0vs2+4amUAVuAr4QEe8GfsxFLDelEuiLPMC8TP5W0lUA+c9zm3w/hUiq0QnyfxQRj+SHS9kXgIj4f8D/oTOGUqZ+3AL8K0kvAw8DH5D0h5SrDysi4mz+8xzwKLCb8vVlEVjM/+sQ4I/pBP6L0o9UAn1qDyE/Avx6/v7X6dS7tzRJAv4AeCEifrfnVKn6Imm7pDfn7/8R8MvAi5SoHxHx6Yi4JiJ20Pl34X9HxL+mRH3oknS5pCu674HbgZOUrC8R8X3gFUk/nx/6IPA8F6sfmz1IMcPBjjuB7wB/DfyHzb6fCe77IeBVYJnOt/4ngLfRGUj7bv7zrZt9nwX68V465bJngRP5686y9QV4F/BXeT9OAvflx0vVj57+3MrqYGzp+kCntv3t/HWq++92SftyI7CQ/3/rK8BbLlY/vAWCmVniUindmJnZEA70ZmaJc6A3M0ucA72ZWeIc6M3MEudAb2aWOAd6M7PE/X9AkIOk+5XgyQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df['media/cultural_refs'].plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('breaking_bad.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "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>Unnamed: 0</th>\n",
       "      <th>season</th>\n",
       "      <th>episode</th>\n",
       "      <th>live_viewership</th>\n",
       "      <th>featured_music</th>\n",
       "      <th>media/cultural_refs</th>\n",
       "      <th>plot</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.41</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>In the desert outside of Albuquerque, New Mexi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1.49</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>Walt finishes having rough sex with Skyler and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1.08</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>As Walt and Jesse are scrubbing up the dissolv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.09</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>Hank puts his DEA team on notice that \"new pla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.97</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>Donning a jacket and tie, Jesse interviews for...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  season  episode  live_viewership  featured_music  \\\n",
       "0           0       1        1             1.41              15   \n",
       "1           1       1        2             1.49               6   \n",
       "2           2       1        3             1.08               4   \n",
       "3           3       1        4             1.09               7   \n",
       "4           4       1        5             0.97               8   \n",
       "\n",
       "   media/cultural_refs                                               plot  \n",
       "0                    2  In the desert outside of Albuquerque, New Mexi...  \n",
       "1                    0  Walt finishes having rough sex with Skyler and...  \n",
       "2                    0  As Walt and Jesse are scrubbing up the dissolv...  \n",
       "3                    2  Hank puts his DEA team on notice that \"new pla...  \n",
       "4                    0  Donning a jacket and tie, Jesse interviews for...  "
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('breaking_bad.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}