Parse star wars episodes.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<!DOCTYPE html>\n",
      "<!--[if lt IE 7]> <html class=\"no-js lt-ie9 lt-ie8 lt-ie7\" lang=\"en-US\"> <![endif]-->\n",
      "<!--[if IE 7]>    <html class=\"no-js lt-ie9 lt-ie8\" lang=\"en-US\"> <![endif]-->\n",
      "<!--[if IE 8]>    <html class=\"no-js lt-ie9\" lang=\"en-US\"> <![endif]-->\n",
      "<!--[if gt IE 8]><!-->\n",
      "<html lang=\"en-US\">\n",
      " <!--<![endif]-->\n",
      " <head>\n",
      "  <meta charset=\"utf-8\"/>\n",
      "  <!-- Google Chrome Frame for IE -->\n",
      "  <meta content=\"IE=edge,chrome=1\" http-equiv=\"X-UA-Compatible\"/>\n",
      "  <!-- mobile meta -->\n",
      "  <meta content=\"True\" name=\"HandheldFriendly\"/>\n",
      "  <meta content=\"320\" name=\"MobileOptimized\"/>\n",
      "  <meta content=\"width=device-width, initial-scale=1.0\" name=\"viewport\"/>\n",
      "  <!-- icons & favicons -->\n",
      "  <meta content=\"Star Wars\" name=\"apple-mobile-web-app-title\"/>\n",
      "  <link href=\"/apple-touch-icon.png\" rel=\"apple-touch-icon\"/>\n",
      "  <link href=\"/apple-touch-icon.png\" rel=\"icon\" sizes=\"196x196\"/>\n",
      "  <link href=\"//a.dilcdn.com/sw/favicon-44660648232d.ico\" rel=\"shortcut icon\"/>\n",
      "  <me\n"
     ]
    }
   ],
   "source": [
    "# Documentation: https://www.crummy.com/software/BeautifulSoup/bs4/doc/\n",
    "\n",
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "\n",
    "page = requests.get(\"https://www.starwars.com/news/star-wars-the-clone-wars-chronological-episodeorder/\")\n",
    "\n",
    "soup = BeautifulSoup(page.content)\n",
    "\n",
    "# Print the first 950 chars of the page.\n",
    "print(soup.prettify()[:950])\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Star Wars: The Clone Wars Chronological Episode Order | StarWars.com\n"
     ]
    }
   ],
   "source": [
    "\n",
    "print(soup.title.string)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "216 : 2 - 16\n",
      "Cat and Mouse\n",
      "https://www.starwars.com/tv-shows/clone-wars/cat-and-mouse-episode-guide\n",
      " \n",
      "116 : 1 - 16\n",
      "Hidden Enemy\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-hidden-enemy-episode-guide\n",
      " \n",
      "301 : 3 - 1\n",
      "Clone Cadets\n",
      "https://www.starwars.com/tv-shows/clone-wars/clone-cadets-episode-guide\n",
      " \n",
      "303 : 3 - 3\n",
      "Supply Lines\n",
      "https://www.starwars.com/tv-shows/clone-wars/supply-lines-episode-guide\n",
      " \n",
      "101 : 1 - 1\n",
      "Ambush\n",
      "https://www.starwars.com/tv-shows/clone-wars/ambush-episode-guide\n",
      " \n",
      "102 : 1 - 2\n",
      "Rising Malevolence\n",
      "https://www.starwars.com/tv-shows/clone-wars/rising-malevolence-episode-guide\n",
      " \n",
      "103 : 1 - 3\n",
      "Shadow of Malevolence\n",
      "https://www.starwars.com/tv-shows/clone-wars/shadow-of-malevolence-episode-guide\n",
      " \n",
      "104 : 1 - 4\n",
      "Destroy Malevolence\n",
      "https://www.starwars.com/tv-shows/clone-wars/destroy-malevolence-episode-guide\n",
      " \n",
      "105 : 1 - 5\n",
      "Rookies\n",
      "https://www.starwars.com/tv-shows/clone-wars/rookies-episode-guide\n",
      " \n",
      "106 : 1 - 6\n",
      "Downfall of a Droid\n",
      "https://www.starwars.com/tv-shows/clone-wars/downfall-of-a-droid-episode-guide\n",
      " \n",
      "107 : 1 - 7\n",
      "Duel of the Droids\n",
      "https://www.starwars.com/tv-shows/clone-wars/duel-of-the-droids-episode-guide\n",
      " \n",
      "108 : 1 - 8\n",
      "Bombad Jedi\n",
      "https://www.starwars.com/tv-shows/clone-wars/bombad-jedi-episode-guide\n",
      " \n",
      "109 : 1 - 9\n",
      "Cloak of Darkness\n",
      "https://www.starwars.com/tv-shows/clone-wars/cloak-of-darkness-episode-guide\n",
      " \n",
      "110 : 1 - 10\n",
      "Lair of Grievous\n",
      "https://www.starwars.com/tv-shows/clone-wars/lair-of-grievous-episode-guide\n",
      " \n",
      "111 : 1 - 11\n",
      "Dooku Captured\n",
      "https://www.starwars.com/tv-shows/clone-wars/dooku-captured-episode-guide\n",
      " \n",
      "112 : 1 - 12\n",
      "The Gungan General\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-gungan-general-episode-guide\n",
      " \n",
      "113 : 1 - 13\n",
      "Jedi Crash\n",
      "https://www.starwars.com/tv-shows/clone-wars/jedi-crash-episode-guide\n",
      " \n",
      "114 : 1 - 14\n",
      "Defenders of Peace\n",
      "https://www.starwars.com/tv-shows/clone-wars/defenders-of-peace-episode-guide\n",
      " \n",
      "115 : 1 - 15\n",
      "Trespass\n",
      "https://www.starwars.com/tv-shows/clone-wars/trespass-episode-guide\n",
      " \n",
      "117 : 1 - 17\n",
      "Blue Shadow Virus\n",
      "https://www.starwars.com/tv-shows/clone-wars/blue-shadow-virus-episode-guide\n",
      " \n",
      "118 : 1 - 18\n",
      "Mystery of a Thousand Moons\n",
      "https://www.starwars.com/tv-shows/clone-wars/mystery-of-a-thousand-moons-episode-guide\n",
      " \n",
      "119 : 1 - 19\n",
      "Storm over Ryloth\n",
      "https://www.starwars.com/tv-shows/clone-wars/storm-over-ryloth-episode-guide\n",
      " \n",
      "120 : 1 - 20\n",
      "Innocents of Ryloth\n",
      "https://www.starwars.com/tv-shows/clone-wars/innocents-of-ryloth-episode-guide\n",
      " \n",
      "121 : 1 - 21\n",
      "Liberty on Ryloth\n",
      "https://www.starwars.com/tv-shows/clone-wars/liberty-on-ryloth-episode-guide\n",
      " \n",
      "201 : 2 - 1\n",
      "Holocron Heist\n",
      "https://www.starwars.com/tv-shows/clone-wars/holocron-heist-episode-guide\n",
      " \n",
      "202 : 2 - 2\n",
      "Cargo of Doom\n",
      "https://www.starwars.com/tv-shows/clone-wars/cargo-of-doom-episode-guide\n",
      " \n",
      "203 : 2 - 3\n",
      "Children of the Force\n",
      "https://www.starwars.com/tv-shows/clone-wars/children-of-the-force-episode-guide\n",
      " \n",
      "217 : 2 - 17\n",
      "Bounty Hunters\n",
      "https://www.starwars.com/tv-shows/clone-wars/bounty-hunters-episode-guide\n",
      " \n",
      "218 : 2 - 18\n",
      "The Zillo Beast\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-zillo-beast-episode-guide\n",
      " \n",
      "219 : 2 - 19\n",
      "The Zillo Beast Strikes Back\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-zillo-beast-strikes-back-episode-guide\n",
      " \n",
      "204 : 2 - 4\n",
      "Senate Spy\n",
      "https://www.starwars.com/tv-shows/clone-wars/senate-spy-episode-guide\n",
      " \n",
      "205 : 2 - 5\n",
      "Landing at Point Rain\n",
      "https://www.starwars.com/tv-shows/clone-wars/landing-at-point-rain-episode-guide\n",
      " \n",
      "206 : 2 - 6\n",
      "Weapons Factory\n",
      "https://www.starwars.com/tv-shows/clone-wars/weapons-factory-episode-guide\n",
      " \n",
      "207 : 2 - 7\n",
      "Legacy of Terror\n",
      "https://www.starwars.com/tv-shows/clone-wars/legacy-of-terror-episode-guide\n",
      " \n",
      "208 : 2 - 8\n",
      "Brain Invaders\n",
      "https://www.starwars.com/tv-shows/clone-wars/brain-invaders-episode-guide\n",
      " \n",
      "209 : 2 - 9\n",
      "Grievous Intrigue\n",
      "https://www.starwars.com/tv-shows/clone-wars/grievous-intrigue-episode-guide\n",
      " \n",
      "210 : 2 - 10\n",
      "The Deserter\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-deserter-episode-guide\n",
      " \n",
      "211 : 2 - 11\n",
      "Lightsaber Lost\n",
      "https://www.starwars.com/tv-shows/clone-wars/lightsaber-lost-episode-guide\n",
      " \n",
      "212 : 2 - 12\n",
      "The Mandalore Plot\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-mandalore-plot-episode-guide\n",
      " \n",
      "213 : 2 - 13\n",
      "Voyage of Temptation\n",
      "https://www.starwars.com/tv-shows/clone-wars/voyage-of-temptation-episode-guide\n",
      " \n",
      "214 : 2 - 14\n",
      "Duchess of Mandalore\n",
      "https://www.starwars.com/tv-shows/clone-wars/duchess-of-mandalore-episode-guide\n",
      " \n",
      "220 : 2 - 20\n",
      "Death Trap\n",
      "https://www.starwars.com/series/clone-wars/death-trap-episode-guide\n",
      " \n",
      "221 : 2 - 21\n",
      "R2 Come Home\n",
      "https://www.starwars.com/tv-shows/clone-wars/r2-come-home-episode-guide\n",
      " \n",
      "222 : 2 - 22\n",
      "Lethal Trackdown\n",
      "https://www.starwars.com/tv-shows/clone-wars/lethal-trackdown-episode-guide\n",
      " \n",
      "305 : 3 - 5\n",
      "Corruption\n",
      "https://www.starwars.com/tv-shows/clone-wars/corruption-episode-guide\n",
      " \n",
      "306 : 3 - 6\n",
      "The Academy\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-academy-episode-guide\n",
      " \n",
      "307 : 3 - 7\n",
      "Assassin\n",
      "https://www.starwars.com/tv-shows/clone-wars/assassin-episode-guide\n",
      " \n",
      "302 : 3 - 2\n",
      "ARC Troopers\n",
      "https://www.starwars.com/tv-shows/clone-wars/arc-troopers-episode-guide\n",
      " \n",
      "304 : 3 - 4\n",
      "Sphere of Influence\n",
      "https://www.starwars.com/tv-shows/clone-wars/sphere-of-influence-episode-guide\n",
      " \n",
      "308 : 3 - 8\n",
      "Evil Plans\n",
      "https://www.starwars.com/tv-shows/clone-wars/evil-plans-episode-guide\n",
      " \n",
      "122 : 1 - 22\n",
      "Hostage Crisis\n",
      "https://www.starwars.com/tv-shows/clone-wars/hostage-crisis-episode-guide\n",
      " \n",
      "309 : 3 - 9\n",
      "Hunt for Ziro\n",
      "https://www.starwars.com/tv-shows/clone-wars/hunt-for-ziro-episode-guide\n",
      " \n",
      "310 : 3 - 10\n",
      "Heroes on Both Side\n",
      "https://www.starwars.com/tv-shows/clone-wars/heroes-on-both-sides-episode-guide\n",
      " \n",
      "311 : 3 - 11\n",
      "Pursuit of Peace\n",
      "https://www.starwars.com/tv-shows/clone-wars/pursuit-of-peace-episode-guide\n",
      " \n",
      "215 : 2 - 15\n",
      "Senate Murders\n",
      "https://www.starwars.com/tv-shows/clone-wars/senate-murders-episode-guide\n",
      " \n",
      "312 : 3 - 12\n",
      "Nightsisters\n",
      "https://www.starwars.com/tv-shows/clone-wars/nightsisters-episode-guide\n",
      " \n",
      "313 : 3 - 13\n",
      "Monster\n",
      "https://www.starwars.com/tv-shows/clone-wars/monster-episode-guide\n",
      " \n",
      "314 : 3 - 14\n",
      "Witches of the Mist\n",
      "https://www.starwars.com/tv-shows/clone-wars/witches-of-the-mist-episode-guide\n",
      " \n",
      "315 : 3 - 15\n",
      "Overlords\n",
      "https://www.starwars.com/tv-shows/clone-wars/overlords-episode-guide\n",
      " \n",
      "316 : 3 - 16\n",
      "Altar of Mortis\n",
      "https://www.starwars.com/tv-shows/clone-wars/altar-of-mortis-episode-guide\n",
      " \n",
      "317 : 3 - 17\n",
      "Ghosts of Mortis\n",
      "https://www.starwars.com/tv-shows/clone-wars/ghosts-of-mortis-episode-guide\n",
      " \n",
      "318 : 3 - 18\n",
      "The Citadel\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-citadel-episode-guide\n",
      " \n",
      "319 : 3 - 19\n",
      "Counter Attack\n",
      "https://www.starwars.com/tv-shows/clone-wars/counterattack-episode-guide\n",
      " \n",
      "320 : 3 - 20\n",
      "Citadel Rescue\n",
      "https://www.starwars.com/tv-shows/clone-wars/citadel-rescue-episode-guide\n",
      " \n",
      "321 : 3 - 21\n",
      "Padawan Lost\n",
      "https://www.starwars.com/tv-shows/clone-wars/padawan-lost-episode-guide\n",
      " \n",
      "322 : 3 - 22\n",
      "Wookiee Hunt\n",
      "https://www.starwars.com/tv-shows/clone-wars/wookiee-hunt-episode-guide\n",
      " \n",
      "401 : 4 - 1\n",
      "Water War\n",
      "https://www.starwars.com/tv-shows/clone-wars/water-war-episode-guide\n",
      " \n",
      "402 : 4 - 2\n",
      "Gungan Attack\n",
      "https://www.starwars.com/tv-shows/clone-wars/gungan-attack-episode-guide\n",
      " \n",
      "403 : 4 - 3\n",
      "Prisoners\n",
      "https://www.starwars.com/tv-shows/clone-wars/prisoners-episode-guide\n",
      " \n",
      "404 : 4 - 4\n",
      "Shadow Warrior\n",
      "https://www.starwars.com/tv-shows/clone-wars/shadow-warrior-episode-guide\n",
      " \n",
      "405 : 4 - 5\n",
      "Mercy Mission\n",
      "https://www.starwars.com/tv-shows/clone-wars/mercy-mission-episode-guide\n",
      " \n",
      "406 : 4 - 6\n",
      "Nomad Droids\n",
      "https://www.starwars.com/tv-shows/clone-wars/nomad-droids-episode-guide\n",
      " \n",
      "407 : 4 - 7\n",
      "Darkness on Umbara\n",
      "https://www.starwars.com/tv-shows/clone-wars/darkness-on-umbara-episode-guide\n",
      " \n",
      "408 : 4 - 8\n",
      "The General\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-general-episode-guide\n",
      " \n",
      "409 : 4 - 9\n",
      "Plan of Dissent\n",
      "https://www.starwars.com/tv-shows/clone-wars/plan-of-dissent-episode-guide\n",
      " \n",
      "410 : 4 - 10\n",
      "Carnage of Krell\n",
      "https://www.starwars.com/tv-shows/clone-wars/carnage-of-krell-episode-guide\n",
      " \n",
      "411 : 4 - 11\n",
      "Kidnapped\n",
      "https://www.starwars.com/tv-shows/clone-wars/kidnapped-episode-guide\n",
      " \n",
      "412 : 4 - 12\n",
      "Slaves of the Republic\n",
      "https://www.starwars.com/tv-shows/clone-wars/slaves-of-the-republic-episode-guide\n",
      " \n",
      "413 : 4 - 13\n",
      "Escape from Kadavo\n",
      "https://www.starwars.com/tv-shows/clone-wars/escape-from-kadavo-episode-guide\n",
      " \n",
      "414 : 4 - 14\n",
      "A Friend In Need\n",
      "https://www.starwars.com/series/clone-wars/-episode-guidea-friend-in-need\n",
      " \n",
      "415 : 4 - 15\n",
      "Deception\n",
      "https://www.starwars.com/series/clone-wars/deception-episode-guide\n",
      " \n",
      "416 : 4 - 16\n",
      "Friends and Enemies\n",
      "https://www.starwars.com/tv-shows/clone-wars/friends-and-enemies-episode-guide\n",
      " \n",
      "417 : 4 - 17\n",
      "The Box\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-box-episode-guide\n",
      " \n",
      "418 : 4 - 18\n",
      "Crisis on Naboo\n",
      "https://www.starwars.com/tv-shows/clone-wars/crisis-on-naboo-episode-guide\n",
      " \n",
      "419 : 4 - 19\n",
      "Massacre\n",
      "https://www.starwars.com/tv-shows/clone-wars/massacre-episode-guide\n",
      " \n",
      "420 : 4 - 20\n",
      "Bounty\n",
      "https://www.starwars.com/tv-shows/clone-wars/bounty-episode-guide\n",
      " \n",
      "421 : 4 - 21\n",
      "Brothers\n",
      "https://www.starwars.com/tv-shows/clone-wars/brothers-episode-guide\n",
      " \n",
      "422 : 4 - 22\n",
      "Revenge\n",
      "https://www.starwars.com/tv-shows/clone-wars/revenge-episode-guide\n",
      " \n",
      "502 : 5 - 2\n",
      "A War on Two Fronts\n",
      "https://www.starwars.com/tv-shows/clone-wars/a-war-on-two-fronts-episode-guide\n",
      " \n",
      "503 : 5 - 3\n",
      "Front Runners\n",
      "https://www.starwars.com/tv-shows/clone-wars/front-runners-episode-guide\n",
      " \n",
      "504 : 5 - 4\n",
      "The Soft War\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-soft-war-episode-guide\n",
      " \n",
      "505 : 5 - 5\n",
      "Tipping Points\n",
      "https://www.starwars.com/tv-shows/clone-wars/tipping-points-episode-guide\n",
      " \n",
      "506 : 5 - 6\n",
      "The Gathering\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-gathering-episode-guide\n",
      " \n",
      "507 : 5 - 7\n",
      "A Test of Strength\n",
      "https://www.starwars.com/tv-shows/clone-wars/a-test-of-strength-episode-guide\n",
      " \n",
      "508 : 5 - 8\n",
      "Bound for Rescue\n",
      "https://www.starwars.com/series/clone-wars/bound-for-rescue-episode-guide\n",
      " \n",
      "509 : 5 - 9\n",
      "A Necessary Bond\n",
      "https://www.starwars.com/series/clone-wars/a-necessary-bond-episode-guide\n",
      " \n",
      "510 : 5 - 10\n",
      "Secret Weapons\n",
      "https://www.starwars.com/tv-shows/clone-wars/secret-weapons-episode-guide\n",
      " \n",
      "511 : 5 - 11\n",
      "A Sunny Day in the Void\n",
      "https://www.starwars.com/tv-shows/clone-wars/a-sunny-day-in-the-void-episode-guide\n",
      " \n",
      "512 : 5 - 12\n",
      "Missing in Action\n",
      "https://www.starwars.com/tv-shows/clone-wars/missing-in-action-episode-guide\n",
      " \n",
      "513 : 5 - 13\n",
      "Point of No Return\n",
      "https://www.starwars.com/tv-shows/clone-wars/point-of-no-return-episode-guide\n",
      " \n",
      "501 : 5 - 1\n",
      "Revival\n",
      "https://www.starwars.com/tv-shows/clone-wars/revival-episode-guide\n",
      " \n",
      "514 : 5 - 14\n",
      "Eminence\n",
      "https://www.starwars.com/tv-shows/clone-wars/eminence-episode-guide\n",
      " \n",
      "515 : 5 - 15\n",
      "Shades of Reason\n",
      "https://www.starwars.com/tv-shows/clone-wars/shades-of-reason-episode-guide\n",
      " \n",
      "516 : 5 - 16\n",
      "The Lawless\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-lawless-episode-guide\n",
      " \n",
      "517 : 5 - 17\n",
      "Sabotage\n",
      "https://www.starwars.com/tv-shows/clone-wars/sabotage-episode-guide\n",
      " \n",
      "518 : 5 - 18\n",
      "The Jedi Who Knew Too Much\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-jedi-who-knew-too-much-episode-guide\n",
      " \n",
      "519 : 5 - 19\n",
      "To Catch a Jedi\n",
      "https://www.starwars.com/tv-shows/clone-wars/to-catch-a-jedi-episode-guide\n",
      " \n",
      "520 : 5 - 20\n",
      "The Wrong Jedi\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-wrong-jedi-episode-guide\n",
      " \n",
      "601 : 6 - 1\n",
      "The Unknown\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-unknown-episode-guide\n",
      " \n",
      "602 : 6 - 2\n",
      "Conspiracy\n",
      "https://www.starwars.com/tv-shows/clone-wars/conspiracy-episode-guide\n",
      " \n",
      "603 : 6 - 3\n",
      "Fugitive\n",
      "https://www.starwars.com/tv-shows/clone-wars/fugitive-episode-guide\n",
      " \n",
      "604 : 6 - 4\n",
      "Orders\n",
      "https://www.starwars.com/tv-shows/clone-wars/orders-episode-guide\n",
      " \n",
      "605 : 6 - 5\n",
      "An Old Friend\n",
      "https://www.starwars.com/tv-shows/clone-wars/an-old-friend-episode-guide\n",
      " \n",
      "606 : 6 - 6\n",
      "The Rise of Clovis\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-rise-of-clovis-episode-guide\n",
      " \n",
      "607 : 6 - 7\n",
      "Crisis at the Heart\n",
      "https://www.starwars.com/tv-shows/clone-wars/crisis-at-the-heart-episode-guide\n",
      " \n",
      "608 : 6 - 8\n",
      "The Disappeared\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-disappeared-part-i-episode-guide\n",
      " \n",
      "609 : 6 - 9\n",
      "The Disappeared: Pt. II\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-disappeared-part-ii-episode-guide\n",
      " \n",
      "610 : 6 - 10\n",
      "The Lost One\n",
      "https://www.starwars.com/tv-shows/clone-wars/the-lost-one-episode-guide\n",
      " \n",
      "611 : 6 - 11\n",
      "Voices\n",
      "https://www.starwars.com/tv-shows/clone-wars/voices-episode-guide\n",
      " \n",
      "612 : 6 - 12\n",
      "Destiny\n",
      "https://www.starwars.com/tv-shows/clone-wars/destiny-episode-guide\n",
      " \n",
      "613 : 6 - 13\n",
      "Sacrifice\n",
      "https://www.starwars.com/tv-shows/clone-wars/sacrifice-episode-guide\n",
      " \n",
      "705 : 7 - 5\n",
      "Gone with a Trace\n",
      "https://www.starwars.com/series/clone-wars/gone-with-a-trace-episode-guide\n",
      " \n",
      "706 : 7 - 6\n",
      "Deal No Deal\n",
      "https://www.starwars.com/series/clone-wars/deal-no-deal-episode-guide\n",
      " \n",
      "707 : 7 - 7\n",
      "Dangerous Debt\n",
      "https://www.starwars.com/series/clone-wars/dangerous-debt-episode-guide\n",
      " \n",
      "708 : 7 - 8\n",
      "Together Again\n",
      "https://www.starwars.com/series/clone-wars/together-again-episode-guide\n",
      " \n",
      "701 : 7 - 1\n",
      "The Bad Batch\n",
      "https://www.starwars.com/series/clone-wars/the-bad-batch-episode-guide\n",
      " \n",
      "702 : 7 - 2\n",
      "A Distant Echo\n",
      "https://www.starwars.com/series/clone-wars/a-distant-echo-episode-guide\n",
      " \n",
      "703 : 7 - 3\n",
      "On the Wings of Keeradaks\n",
      "https://www.starwars.com/series/clone-wars/on-the-wings-of-keeradaks-episode-guide\n",
      " \n",
      "704 : 7 - 4\n",
      "Unfinished Business\n",
      "https://www.starwars.com/series/clone-wars/unfinished-business-episode-guide\n",
      " \n",
      "709 : 7 - 9\n",
      "Old Friends Not Forgotten\n",
      "https://www.starwars.com/series/clone-wars/old-friends-not-forgotten-episode-guide\n",
      " \n",
      "710 : 7 - 10\n",
      "The Phantom Apprentice\n",
      "https://www.starwars.com/series/clone-wars/the-phantom-apprentice-episode-guide\n",
      " \n",
      "711 : 7 - 11\n",
      "Shattered\n",
      "https://www.starwars.com/series/clone-wars/shattered-episode-guide\n",
      " \n",
      "712 : 7 - 12\n",
      "Victory and Death\n",
      "https://www.starwars.com/series/clone-wars/victory-and-death-episode-guide\n",
      " \n"
     ]
    }
   ],
   "source": [
    "\n",
    "def begins_with_number(x):\n",
    "    numbers = [\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\",\"10\"];\n",
    "    return x[0] in numbers\n",
    "\n",
    "\n",
    "headers = [\"episode_code\", \"season\",\"episode_number\", \"episode_name\", \"episode_detail_page_link\"]\n",
    "\n",
    "all_episodes = []\n",
    "\n",
    "# for row in soup.find_all('td', class_=\"xl65\")[0:3]:\n",
    "for row in soup.find_all('td', class_=\"xl65\"):\n",
    "    if(row.string and begins_with_number(row.string)):\n",
    "        ep_code = row.string\n",
    "        season = ep_code[0]\n",
    "        ep_number = int(ep_code[1:])\n",
    "        \n",
    "        a_link = row.parent.find(\"a\")\n",
    "        episode_name = a_link.text\n",
    "        episode_detail_page_link = a_link['href']\n",
    "                        \n",
    "        print(ep_code,\":\", season, \"-\", ep_number)\n",
    "\n",
    "\n",
    "        print(episode_name)\n",
    "        print(episode_detail_page_link)\n",
    "\n",
    "        episode = [ep_code,season, ep_number, episode_name, episode_detail_page_link]\n",
    "        all_episodes.append(episode)\n",
    "        print(\" \")\n",
    "\n",
    "        \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>episode_code</th>\n",
       "      <th>season</th>\n",
       "      <th>episode_number</th>\n",
       "      <th>episode_name</th>\n",
       "      <th>episode_detail_page_link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>216</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>Cat and Mouse</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>116</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>Hidden Enemy</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>301</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Clone Cadets</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>303</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Supply Lines</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>101</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Ambush</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/a...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  episode_code season  episode_number   episode_name  \\\n",
       "0          216      2              16  Cat and Mouse   \n",
       "1          116      1              16   Hidden Enemy   \n",
       "2          301      3               1   Clone Cadets   \n",
       "3          303      3               3   Supply Lines   \n",
       "4          101      1               1         Ambush   \n",
       "\n",
       "                            episode_detail_page_link  \n",
       "0  https://www.starwars.com/tv-shows/clone-wars/c...  \n",
       "1  https://www.starwars.com/tv-shows/clone-wars/t...  \n",
       "2  https://www.starwars.com/tv-shows/clone-wars/c...  \n",
       "3  https://www.starwars.com/tv-shows/clone-wars/s...  \n",
       "4  https://www.starwars.com/tv-shows/clone-wars/a...  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.DataFrame(all_episodes, columns=headers)\n",
    "df.head()\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "117    (\"What is lost is often found.\", A Jedi missio...\n",
       "34     (\"Attachment is not compassion.\", Medical supp...\n",
       "99     (\"You must trust in others or success is impos...\n",
       "Name: episode_detail_page_link, dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def clean(text):\n",
    "    if(not text):\n",
    "        return text\n",
    "\n",
    "    cleaned = text.strip().replace('\\n', ' ').replace('\\r', '')\n",
    "    return cleaned\n",
    "    \n",
    "\n",
    "def parse_detailed_info_page(url):\n",
    "    \n",
    "    #     request the page\n",
    "    detail_page = requests.get(url)\n",
    "    detail_soup = BeautifulSoup(detail_page.content)\n",
    "\n",
    "    #description div has a quote and a description.\n",
    "    description_div = detail_soup.find('div', class_=\"desc\")\n",
    "        \n",
    "    start_quote_span = description_div.find('span', 'quote')\n",
    "    if(start_quote_span):\n",
    "        start_quote = start_quote_span.text\n",
    "    else:\n",
    "        start_quote = \"\"\n",
    "        \n",
    "    description = \"\"\n",
    "    \n",
    "#   first child is empty\n",
    "#   2nd child is the quote\n",
    "#   3rd child (index 2) is the description text. but it has some leading white-space.\n",
    "    for index, child in enumerate(description_div.children):\n",
    "        if(index==2):\n",
    "            description = child.strip() \n",
    "            \n",
    "    if((not start_quote) and (not description)):\n",
    "        description = description_div.text.strip()\n",
    "       \n",
    "    #print((start_quote, str(description)))\n",
    "    return (clean(start_quote), clean(description))\n",
    "\n",
    "\n",
    "# Test the function works on a few examples\n",
    "df[\"episode_detail_page_link\"].sample(n=3).map(parse_detailed_info_page)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Multi-thread it to apply it quickly across the dataframe and run requests in parallel.\n",
    "import multiprocessing as mp\n",
    "with mp.Pool(mp.cpu_count()) as pool:\n",
    "    quotes_and_description = pool.map(parse_detailed_info_page, df[\"episode_detail_page_link\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>episode_code</th>\n",
       "      <th>season</th>\n",
       "      <th>episode_number</th>\n",
       "      <th>episode_name</th>\n",
       "      <th>episode_detail_page_link</th>\n",
       "      <th>quote</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>216</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>Cat and Mouse</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "      <td>\"A wise leader knows when to follow\"</td>\n",
       "      <td>A Separatist blockade surrounds Christophsis. ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>116</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>Hidden Enemy</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Truth enlightens the mind, but won't always b...</td>\n",
       "      <td>Anakin Skywalker and Obi-Wan Kenobi lead Repub...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>301</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Clone Cadets</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "      <td>\"Brothers in arms are brothers for life.\"</td>\n",
       "      <td>Five headstrong clones struggle to complete th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>303</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Supply Lines</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/s...</td>\n",
       "      <td>\"Where there's a will, there's a way.\"</td>\n",
       "      <td>Ryloth is under siege. Trapped on the surface,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>101</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Ambush</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/a...</td>\n",
       "      <td>\"Great leaders inspire greatness in others.\"</td>\n",
       "      <td>Jedi Master Yoda and three clone troopers -- J...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  episode_code season  episode_number   episode_name  \\\n",
       "0          216      2              16  Cat and Mouse   \n",
       "1          116      1              16   Hidden Enemy   \n",
       "2          301      3               1   Clone Cadets   \n",
       "3          303      3               3   Supply Lines   \n",
       "4          101      1               1         Ambush   \n",
       "\n",
       "                            episode_detail_page_link  \\\n",
       "0  https://www.starwars.com/tv-shows/clone-wars/c...   \n",
       "1  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "2  https://www.starwars.com/tv-shows/clone-wars/c...   \n",
       "3  https://www.starwars.com/tv-shows/clone-wars/s...   \n",
       "4  https://www.starwars.com/tv-shows/clone-wars/a...   \n",
       "\n",
       "                                               quote  \\\n",
       "0               \"A wise leader knows when to follow\"   \n",
       "1  \"Truth enlightens the mind, but won't always b...   \n",
       "2          \"Brothers in arms are brothers for life.\"   \n",
       "3             \"Where there's a will, there's a way.\"   \n",
       "4       \"Great leaders inspire greatness in others.\"   \n",
       "\n",
       "                                         description  \n",
       "0  A Separatist blockade surrounds Christophsis. ...  \n",
       "1  Anakin Skywalker and Obi-Wan Kenobi lead Repub...  \n",
       "2  Five headstrong clones struggle to complete th...  \n",
       "3  Ryloth is under siege. Trapped on the surface,...  \n",
       "4  Jedi Master Yoda and three clone troopers -- J...  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df\n",
    "df2['quote'], df2['description'] = zip(*quotes_and_description)\n",
    "df2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>episode_code</th>\n",
       "      <th>season</th>\n",
       "      <th>episode_number</th>\n",
       "      <th>episode_name</th>\n",
       "      <th>episode_detail_page_link</th>\n",
       "      <th>quote</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>216</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>Cat and Mouse</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "      <td>\"A wise leader knows when to follow\"</td>\n",
       "      <td>A Separatist blockade surrounds Christophsis. ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>116</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>Hidden Enemy</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Truth enlightens the mind, but won't always b...</td>\n",
       "      <td>Anakin Skywalker and Obi-Wan Kenobi lead Repub...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>301</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Clone Cadets</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "      <td>\"Brothers in arms are brothers for life.\"</td>\n",
       "      <td>Five headstrong clones struggle to complete th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>303</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Supply Lines</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/s...</td>\n",
       "      <td>\"Where there's a will, there's a way.\"</td>\n",
       "      <td>Ryloth is under siege. Trapped on the surface,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>101</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Ambush</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/a...</td>\n",
       "      <td>\"Great leaders inspire greatness in others.\"</td>\n",
       "      <td>Jedi Master Yoda and three clone troopers -- J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>102</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Rising Malevolence</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/r...</td>\n",
       "      <td>\"Belief is not a matter of choice, but of conv...</td>\n",
       "      <td>An attack by a devastating new Separatist weap...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>103</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Shadow of Malevolence</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/s...</td>\n",
       "      <td>\"Easy is the path to wisdom for those not blin...</td>\n",
       "      <td>With the help of his Padawan Ahsoka and Jedi M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>104</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Destroy Malevolence</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/d...</td>\n",
       "      <td>\"A plan is only as good as those who see it th...</td>\n",
       "      <td>Padmé Amidala and C-3PO are taken hostage by G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>105</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Rookies</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/r...</td>\n",
       "      <td>\"The best confidence builder is experience.\"</td>\n",
       "      <td>Alone on a distant outpost, clone officers Rex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>106</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>Downfall of a Droid</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/d...</td>\n",
       "      <td>\"Trust in your friends, and they'll have reaso...</td>\n",
       "      <td>R2-D2 is lost during a fierce space battle -- ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>107</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>Duel of the Droids</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/d...</td>\n",
       "      <td>\"You hold onto friends by keeping your heart a...</td>\n",
       "      <td>Anakin, Ahsoka and replacement droid R3-S6 emb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>108</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Bombad Jedi</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/b...</td>\n",
       "      <td>\"Heroes are made by the times.\"</td>\n",
       "      <td>On a diplomatic mission to the planet Rodia, P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>109</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Cloak of Darkness</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "      <td>\"Ignore your instincts at your peril.\"</td>\n",
       "      <td>Ahsoka and Jedi Master Luminara escort the cap...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>Lair of Grievous</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/l...</td>\n",
       "      <td>\"Most powerful is he who controls his own power.\"</td>\n",
       "      <td>Jedi Master Kit Fisto and his former Padawan, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>111</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>Dooku Captured</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/d...</td>\n",
       "      <td>\"The winding path to peace is always a worthy ...</td>\n",
       "      <td>During their own attempt to kidnap Count Dooku...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>112</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>The Gungan General</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Fail with honor rather than succeed by fraud.\"</td>\n",
       "      <td>Anakin and Obi-Wan have been duped and are bei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>113</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>Jedi Crash</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/j...</td>\n",
       "      <td>\"Greed and fear of loss are the roots that lea...</td>\n",
       "      <td>Anakin and Ahsoka arrive at a pitched sky batt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>114</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>Defenders of Peace</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/d...</td>\n",
       "      <td>\"When surrounded by war, one must eventually c...</td>\n",
       "      <td>The leader of the Lurmen, Tee Watt Kaa, refuse...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>115</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>Trespass</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Arrogance diminishes wisdom.\"</td>\n",
       "      <td>Arriving on the desolate ice world of Orto Plu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>117</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>Blue Shadow Virus</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/b...</td>\n",
       "      <td>\"Fear is a disease; hope is its only cure.\"</td>\n",
       "      <td>The Republic discovers a Separatist bio-weapon...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>118</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>Mystery of a Thousand Moons</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/m...</td>\n",
       "      <td>\"A single chance is a galaxy of hope.\"</td>\n",
       "      <td>Even though the lab has been shut down, Dr. Vi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>119</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>Storm over Ryloth</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/s...</td>\n",
       "      <td>\"It is a rough road that leads to the heights ...</td>\n",
       "      <td>Ryloth, home world of the Twi'lek people, has ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>Innocents of Ryloth</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/i...</td>\n",
       "      <td>\"The costs of war can never be truly accounted...</td>\n",
       "      <td>With the space blockade around Ryloth destroye...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>121</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>Liberty on Ryloth</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/l...</td>\n",
       "      <td>\"Compromise is a virtue to be cultivated, not ...</td>\n",
       "      <td>The battle for the Twi'lek homeworld of Ryloth...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>201</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Holocron Heist</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/h...</td>\n",
       "      <td>\"A lesson learned is a lesson earned.\"</td>\n",
       "      <td>Cad Bane has been hired by Darth Sidious to st...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>202</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Cargo of Doom</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "      <td>\"Overconfidence is the most dangerous form of ...</td>\n",
       "      <td>Anakin and Ahsoka travel to the planet Devaron...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>203</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Children of the Force</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "      <td></td>\n",
       "      <td>\"The first step to correcting a mistake is pat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>217</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>Bounty Hunters</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/b...</td>\n",
       "      <td>\"Courage makes heroes, but trust builds friend...</td>\n",
       "      <td>Anakin, Obi-Wan, and Ahsoka crash on Felucia a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>218</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>The Zillo Beast</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Choose what is right, not what is easy.\"</td>\n",
       "      <td>Desperate to turn the tide of a fierce battle ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>219</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>The Zillo Beast Strikes Back</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"The most dangerous beast is the beast within.\"</td>\n",
       "      <td>Per Palpatine's order, Republic forces transpo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>516</td>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>The Lawless</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Morality separates heroes from villains.\"</td>\n",
       "      <td>Using Duchess Satine as bait, Darth Maul lures...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>517</td>\n",
       "      <td>5</td>\n",
       "      <td>17</td>\n",
       "      <td>Sabotage</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/s...</td>\n",
       "      <td>\"Sometimes even the smallest doubt can shake t...</td>\n",
       "      <td>Anakin and Ahsoka investigate a deadly bombing...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>518</td>\n",
       "      <td>5</td>\n",
       "      <td>18</td>\n",
       "      <td>The Jedi Who Knew Too Much</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Courage begins by trusting oneself.\"</td>\n",
       "      <td>As the Republic military takes over the Temple...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>519</td>\n",
       "      <td>5</td>\n",
       "      <td>19</td>\n",
       "      <td>To Catch a Jedi</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Never become desperate enough to trust the un...</td>\n",
       "      <td>The fugitive Ahsoka escapes to the criminal de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>520</td>\n",
       "      <td>5</td>\n",
       "      <td>20</td>\n",
       "      <td>The Wrong Jedi</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Never give up hope, no matter how dark things...</td>\n",
       "      <td>On trial for murder, Ahsoka faces her greatest...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>601</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>The Unknown</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"The truth about yourself is the hardest to ac...</td>\n",
       "      <td>Clone trooper Tup succumbs to a mysterious men...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>602</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>Conspiracy</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "      <td>\"The wise benefit from a second opinion.\"</td>\n",
       "      <td>In the sterile laboratories of Kamino, the ail...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>603</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>Fugitive</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/f...</td>\n",
       "      <td>\"When in doubt, go to the source.\"</td>\n",
       "      <td>The body of clone trooper Tup is scheduled for...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>604</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>Orders</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/o...</td>\n",
       "      <td>\"The popular belief isn't always the correct o...</td>\n",
       "      <td>Fives continues to push for answers regarding ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>605</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>An Old Friend</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/a...</td>\n",
       "      <td>\"To love is to trust. To trust is to believe.\"</td>\n",
       "      <td>While on Scipio to fund a mercy mission, Padmé...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>606</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>The Rise of Clovis</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Jealousy is the path to chaos.\"</td>\n",
       "      <td>Back on Coruscant, Clovis -- known traitor of ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>607</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>Crisis at the Heart</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/c...</td>\n",
       "      <td>\"Deceit is the weapon of greed.\"</td>\n",
       "      <td>Rush Clovis' deal with the Separatists backfir...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>608</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>The Disappeared</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Without darkness there can be no light.\"</td>\n",
       "      <td>The peaceful world of Bardotta and its mystic ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>609</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>The Disappeared: Pt. II</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"Wisdom is born in fools as well as wise men.\"</td>\n",
       "      <td>Jar Jar Binks' beloved Queen Julia of the plan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>610</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>The Lost One</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/t...</td>\n",
       "      <td>\"What is lost is often found.\"</td>\n",
       "      <td>A Jedi mission finds a lightsaber belonging to...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>611</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>Voices</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/v...</td>\n",
       "      <td>\"Madness can sometimes be the path to truth.\"</td>\n",
       "      <td>Yoda is deeply unsettled when he hears somethi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>612</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>Destiny</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/d...</td>\n",
       "      <td>\"Death is just the beginning.\"</td>\n",
       "      <td>Letting the Force guide him, Yoda voyages into...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>613</td>\n",
       "      <td>6</td>\n",
       "      <td>13</td>\n",
       "      <td>Sacrifice</td>\n",
       "      <td>https://www.starwars.com/tv-shows/clone-wars/s...</td>\n",
       "      <td>\"Facing all that you fear will free you from y...</td>\n",
       "      <td>After many grueling trials, Yoda next travels ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>705</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>Gone with a Trace</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/gon...</td>\n",
       "      <td>\"If there is no path before you, create your o...</td>\n",
       "      <td>Ahsoka Tano, no longer part of the Jedi Order,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>706</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>Deal No Deal</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/dea...</td>\n",
       "      <td>\"Mistakes are valuable lessons often learned t...</td>\n",
       "      <td>Rafa lands a dangerous job running spice — and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>707</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>Dangerous Debt</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/dan...</td>\n",
       "      <td>\"Who you were does not have to define who you ...</td>\n",
       "      <td>Captured by the Pyke Syndicate, Ahsoka and the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>708</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>Together Again</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/tog...</td>\n",
       "      <td>\"You can change who you are, but you cannot ru...</td>\n",
       "      <td>Captured by the Pykes once more, Ahsoka and th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>701</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>The Bad Batch</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/the...</td>\n",
       "      <td>\"Embrace others for their differences, for tha...</td>\n",
       "      <td>The clones look to uncover the source of the S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>702</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>A Distant Echo</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/a-d...</td>\n",
       "      <td>\"The search for truth begins with belief.\"</td>\n",
       "      <td>Rex, Anakin, and the Bad Batch look to uncover...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>703</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>On the Wings of Keeradaks</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/on-...</td>\n",
       "      <td>\"Survival is one step on the path to living.\"</td>\n",
       "      <td>Rex has found his friend, Echo, in the clutche...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>704</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>Unfinished Business</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/unf...</td>\n",
       "      <td>\"Trust placed in another is trust earned.\"</td>\n",
       "      <td>Echo hatches a plan to end the Separatist thre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>709</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>Old Friends Not Forgotten</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/old...</td>\n",
       "      <td></td>\n",
       "      <td>The Siege of Mandalore begins, and Ahsoka turn...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>710</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>The Phantom Apprentice</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/the...</td>\n",
       "      <td></td>\n",
       "      <td>The battle for Mandalore continues, and Ahsoka...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>711</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>Shattered</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/sha...</td>\n",
       "      <td></td>\n",
       "      <td>Maul is captured and the Siege of Mandalore is...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>712</td>\n",
       "      <td>7</td>\n",
       "      <td>12</td>\n",
       "      <td>Victory and Death</td>\n",
       "      <td>https://www.starwars.com/series/clone-wars/vic...</td>\n",
       "      <td></td>\n",
       "      <td>In the wake of Order 66, Ahsoka and Rex must w...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>133 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    episode_code season  episode_number                  episode_name  \\\n",
       "0            216      2              16                 Cat and Mouse   \n",
       "1            116      1              16                  Hidden Enemy   \n",
       "2            301      3               1                  Clone Cadets   \n",
       "3            303      3               3                  Supply Lines   \n",
       "4            101      1               1                        Ambush   \n",
       "5            102      1               2            Rising Malevolence   \n",
       "6            103      1               3         Shadow of Malevolence   \n",
       "7            104      1               4           Destroy Malevolence   \n",
       "8            105      1               5                       Rookies   \n",
       "9            106      1               6           Downfall of a Droid   \n",
       "10           107      1               7            Duel of the Droids   \n",
       "11           108      1               8                   Bombad Jedi   \n",
       "12           109      1               9             Cloak of Darkness   \n",
       "13           110      1              10              Lair of Grievous   \n",
       "14           111      1              11                Dooku Captured   \n",
       "15           112      1              12            The Gungan General   \n",
       "16           113      1              13                    Jedi Crash   \n",
       "17           114      1              14            Defenders of Peace   \n",
       "18           115      1              15                      Trespass   \n",
       "19           117      1              17             Blue Shadow Virus   \n",
       "20           118      1              18   Mystery of a Thousand Moons   \n",
       "21           119      1              19             Storm over Ryloth   \n",
       "22           120      1              20           Innocents of Ryloth   \n",
       "23           121      1              21             Liberty on Ryloth   \n",
       "24           201      2               1                Holocron Heist   \n",
       "25           202      2               2                 Cargo of Doom   \n",
       "26           203      2               3         Children of the Force   \n",
       "27           217      2              17                Bounty Hunters   \n",
       "28           218      2              18               The Zillo Beast   \n",
       "29           219      2              19  The Zillo Beast Strikes Back   \n",
       "..           ...    ...             ...                           ...   \n",
       "103          516      5              16                   The Lawless   \n",
       "104          517      5              17                      Sabotage   \n",
       "105          518      5              18    The Jedi Who Knew Too Much   \n",
       "106          519      5              19               To Catch a Jedi   \n",
       "107          520      5              20                The Wrong Jedi   \n",
       "108          601      6               1                   The Unknown   \n",
       "109          602      6               2                    Conspiracy   \n",
       "110          603      6               3                      Fugitive   \n",
       "111          604      6               4                        Orders   \n",
       "112          605      6               5                 An Old Friend   \n",
       "113          606      6               6            The Rise of Clovis   \n",
       "114          607      6               7           Crisis at the Heart   \n",
       "115          608      6               8               The Disappeared   \n",
       "116          609      6               9       The Disappeared: Pt. II   \n",
       "117          610      6              10                  The Lost One   \n",
       "118          611      6              11                        Voices   \n",
       "119          612      6              12                       Destiny   \n",
       "120          613      6              13                     Sacrifice   \n",
       "121          705      7               5             Gone with a Trace   \n",
       "122          706      7               6                  Deal No Deal   \n",
       "123          707      7               7                Dangerous Debt   \n",
       "124          708      7               8                Together Again   \n",
       "125          701      7               1                 The Bad Batch   \n",
       "126          702      7               2                A Distant Echo   \n",
       "127          703      7               3     On the Wings of Keeradaks   \n",
       "128          704      7               4           Unfinished Business   \n",
       "129          709      7               9     Old Friends Not Forgotten   \n",
       "130          710      7              10        The Phantom Apprentice   \n",
       "131          711      7              11                     Shattered   \n",
       "132          712      7              12             Victory and Death   \n",
       "\n",
       "                              episode_detail_page_link  \\\n",
       "0    https://www.starwars.com/tv-shows/clone-wars/c...   \n",
       "1    https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "2    https://www.starwars.com/tv-shows/clone-wars/c...   \n",
       "3    https://www.starwars.com/tv-shows/clone-wars/s...   \n",
       "4    https://www.starwars.com/tv-shows/clone-wars/a...   \n",
       "5    https://www.starwars.com/tv-shows/clone-wars/r...   \n",
       "6    https://www.starwars.com/tv-shows/clone-wars/s...   \n",
       "7    https://www.starwars.com/tv-shows/clone-wars/d...   \n",
       "8    https://www.starwars.com/tv-shows/clone-wars/r...   \n",
       "9    https://www.starwars.com/tv-shows/clone-wars/d...   \n",
       "10   https://www.starwars.com/tv-shows/clone-wars/d...   \n",
       "11   https://www.starwars.com/tv-shows/clone-wars/b...   \n",
       "12   https://www.starwars.com/tv-shows/clone-wars/c...   \n",
       "13   https://www.starwars.com/tv-shows/clone-wars/l...   \n",
       "14   https://www.starwars.com/tv-shows/clone-wars/d...   \n",
       "15   https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "16   https://www.starwars.com/tv-shows/clone-wars/j...   \n",
       "17   https://www.starwars.com/tv-shows/clone-wars/d...   \n",
       "18   https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "19   https://www.starwars.com/tv-shows/clone-wars/b...   \n",
       "20   https://www.starwars.com/tv-shows/clone-wars/m...   \n",
       "21   https://www.starwars.com/tv-shows/clone-wars/s...   \n",
       "22   https://www.starwars.com/tv-shows/clone-wars/i...   \n",
       "23   https://www.starwars.com/tv-shows/clone-wars/l...   \n",
       "24   https://www.starwars.com/tv-shows/clone-wars/h...   \n",
       "25   https://www.starwars.com/tv-shows/clone-wars/c...   \n",
       "26   https://www.starwars.com/tv-shows/clone-wars/c...   \n",
       "27   https://www.starwars.com/tv-shows/clone-wars/b...   \n",
       "28   https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "29   https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "..                                                 ...   \n",
       "103  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "104  https://www.starwars.com/tv-shows/clone-wars/s...   \n",
       "105  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "106  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "107  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "108  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "109  https://www.starwars.com/tv-shows/clone-wars/c...   \n",
       "110  https://www.starwars.com/tv-shows/clone-wars/f...   \n",
       "111  https://www.starwars.com/tv-shows/clone-wars/o...   \n",
       "112  https://www.starwars.com/tv-shows/clone-wars/a...   \n",
       "113  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "114  https://www.starwars.com/tv-shows/clone-wars/c...   \n",
       "115  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "116  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "117  https://www.starwars.com/tv-shows/clone-wars/t...   \n",
       "118  https://www.starwars.com/tv-shows/clone-wars/v...   \n",
       "119  https://www.starwars.com/tv-shows/clone-wars/d...   \n",
       "120  https://www.starwars.com/tv-shows/clone-wars/s...   \n",
       "121  https://www.starwars.com/series/clone-wars/gon...   \n",
       "122  https://www.starwars.com/series/clone-wars/dea...   \n",
       "123  https://www.starwars.com/series/clone-wars/dan...   \n",
       "124  https://www.starwars.com/series/clone-wars/tog...   \n",
       "125  https://www.starwars.com/series/clone-wars/the...   \n",
       "126  https://www.starwars.com/series/clone-wars/a-d...   \n",
       "127  https://www.starwars.com/series/clone-wars/on-...   \n",
       "128  https://www.starwars.com/series/clone-wars/unf...   \n",
       "129  https://www.starwars.com/series/clone-wars/old...   \n",
       "130  https://www.starwars.com/series/clone-wars/the...   \n",
       "131  https://www.starwars.com/series/clone-wars/sha...   \n",
       "132  https://www.starwars.com/series/clone-wars/vic...   \n",
       "\n",
       "                                                 quote  \\\n",
       "0                 \"A wise leader knows when to follow\"   \n",
       "1    \"Truth enlightens the mind, but won't always b...   \n",
       "2            \"Brothers in arms are brothers for life.\"   \n",
       "3               \"Where there's a will, there's a way.\"   \n",
       "4         \"Great leaders inspire greatness in others.\"   \n",
       "5    \"Belief is not a matter of choice, but of conv...   \n",
       "6    \"Easy is the path to wisdom for those not blin...   \n",
       "7    \"A plan is only as good as those who see it th...   \n",
       "8         \"The best confidence builder is experience.\"   \n",
       "9    \"Trust in your friends, and they'll have reaso...   \n",
       "10   \"You hold onto friends by keeping your heart a...   \n",
       "11                     \"Heroes are made by the times.\"   \n",
       "12              \"Ignore your instincts at your peril.\"   \n",
       "13   \"Most powerful is he who controls his own power.\"   \n",
       "14   \"The winding path to peace is always a worthy ...   \n",
       "15     \"Fail with honor rather than succeed by fraud.\"   \n",
       "16   \"Greed and fear of loss are the roots that lea...   \n",
       "17   \"When surrounded by war, one must eventually c...   \n",
       "18                      \"Arrogance diminishes wisdom.\"   \n",
       "19         \"Fear is a disease; hope is its only cure.\"   \n",
       "20              \"A single chance is a galaxy of hope.\"   \n",
       "21   \"It is a rough road that leads to the heights ...   \n",
       "22   \"The costs of war can never be truly accounted...   \n",
       "23   \"Compromise is a virtue to be cultivated, not ...   \n",
       "24              \"A lesson learned is a lesson earned.\"   \n",
       "25   \"Overconfidence is the most dangerous form of ...   \n",
       "26                                                       \n",
       "27   \"Courage makes heroes, but trust builds friend...   \n",
       "28           \"Choose what is right, not what is easy.\"   \n",
       "29     \"The most dangerous beast is the beast within.\"   \n",
       "..                                                 ...   \n",
       "103         \"Morality separates heroes from villains.\"   \n",
       "104  \"Sometimes even the smallest doubt can shake t...   \n",
       "105              \"Courage begins by trusting oneself.\"   \n",
       "106  \"Never become desperate enough to trust the un...   \n",
       "107  \"Never give up hope, no matter how dark things...   \n",
       "108  \"The truth about yourself is the hardest to ac...   \n",
       "109          \"The wise benefit from a second opinion.\"   \n",
       "110                 \"When in doubt, go to the source.\"   \n",
       "111  \"The popular belief isn't always the correct o...   \n",
       "112     \"To love is to trust. To trust is to believe.\"   \n",
       "113                   \"Jealousy is the path to chaos.\"   \n",
       "114                   \"Deceit is the weapon of greed.\"   \n",
       "115          \"Without darkness there can be no light.\"   \n",
       "116     \"Wisdom is born in fools as well as wise men.\"   \n",
       "117                     \"What is lost is often found.\"   \n",
       "118      \"Madness can sometimes be the path to truth.\"   \n",
       "119                     \"Death is just the beginning.\"   \n",
       "120  \"Facing all that you fear will free you from y...   \n",
       "121  \"If there is no path before you, create your o...   \n",
       "122  \"Mistakes are valuable lessons often learned t...   \n",
       "123  \"Who you were does not have to define who you ...   \n",
       "124  \"You can change who you are, but you cannot ru...   \n",
       "125  \"Embrace others for their differences, for tha...   \n",
       "126         \"The search for truth begins with belief.\"   \n",
       "127      \"Survival is one step on the path to living.\"   \n",
       "128         \"Trust placed in another is trust earned.\"   \n",
       "129                                                      \n",
       "130                                                      \n",
       "131                                                      \n",
       "132                                                      \n",
       "\n",
       "                                           description  \n",
       "0    A Separatist blockade surrounds Christophsis. ...  \n",
       "1    Anakin Skywalker and Obi-Wan Kenobi lead Repub...  \n",
       "2    Five headstrong clones struggle to complete th...  \n",
       "3    Ryloth is under siege. Trapped on the surface,...  \n",
       "4    Jedi Master Yoda and three clone troopers -- J...  \n",
       "5    An attack by a devastating new Separatist weap...  \n",
       "6    With the help of his Padawan Ahsoka and Jedi M...  \n",
       "7    Padmé Amidala and C-3PO are taken hostage by G...  \n",
       "8    Alone on a distant outpost, clone officers Rex...  \n",
       "9    R2-D2 is lost during a fierce space battle -- ...  \n",
       "10   Anakin, Ahsoka and replacement droid R3-S6 emb...  \n",
       "11   On a diplomatic mission to the planet Rodia, P...  \n",
       "12   Ahsoka and Jedi Master Luminara escort the cap...  \n",
       "13   Jedi Master Kit Fisto and his former Padawan, ...  \n",
       "14   During their own attempt to kidnap Count Dooku...  \n",
       "15   Anakin and Obi-Wan have been duped and are bei...  \n",
       "16   Anakin and Ahsoka arrive at a pitched sky batt...  \n",
       "17   The leader of the Lurmen, Tee Watt Kaa, refuse...  \n",
       "18   Arriving on the desolate ice world of Orto Plu...  \n",
       "19   The Republic discovers a Separatist bio-weapon...  \n",
       "20   Even though the lab has been shut down, Dr. Vi...  \n",
       "21   Ryloth, home world of the Twi'lek people, has ...  \n",
       "22   With the space blockade around Ryloth destroye...  \n",
       "23   The battle for the Twi'lek homeworld of Ryloth...  \n",
       "24   Cad Bane has been hired by Darth Sidious to st...  \n",
       "25   Anakin and Ahsoka travel to the planet Devaron...  \n",
       "26   \"The first step to correcting a mistake is pat...  \n",
       "27   Anakin, Obi-Wan, and Ahsoka crash on Felucia a...  \n",
       "28   Desperate to turn the tide of a fierce battle ...  \n",
       "29   Per Palpatine's order, Republic forces transpo...  \n",
       "..                                                 ...  \n",
       "103  Using Duchess Satine as bait, Darth Maul lures...  \n",
       "104  Anakin and Ahsoka investigate a deadly bombing...  \n",
       "105  As the Republic military takes over the Temple...  \n",
       "106  The fugitive Ahsoka escapes to the criminal de...  \n",
       "107  On trial for murder, Ahsoka faces her greatest...  \n",
       "108  Clone trooper Tup succumbs to a mysterious men...  \n",
       "109  In the sterile laboratories of Kamino, the ail...  \n",
       "110  The body of clone trooper Tup is scheduled for...  \n",
       "111  Fives continues to push for answers regarding ...  \n",
       "112  While on Scipio to fund a mercy mission, Padmé...  \n",
       "113  Back on Coruscant, Clovis -- known traitor of ...  \n",
       "114  Rush Clovis' deal with the Separatists backfir...  \n",
       "115  The peaceful world of Bardotta and its mystic ...  \n",
       "116  Jar Jar Binks' beloved Queen Julia of the plan...  \n",
       "117  A Jedi mission finds a lightsaber belonging to...  \n",
       "118  Yoda is deeply unsettled when he hears somethi...  \n",
       "119  Letting the Force guide him, Yoda voyages into...  \n",
       "120  After many grueling trials, Yoda next travels ...  \n",
       "121  Ahsoka Tano, no longer part of the Jedi Order,...  \n",
       "122  Rafa lands a dangerous job running spice — and...  \n",
       "123  Captured by the Pyke Syndicate, Ahsoka and the...  \n",
       "124  Captured by the Pykes once more, Ahsoka and th...  \n",
       "125  The clones look to uncover the source of the S...  \n",
       "126  Rex, Anakin, and the Bad Batch look to uncover...  \n",
       "127  Rex has found his friend, Echo, in the clutche...  \n",
       "128  Echo hatches a plan to end the Separatist thre...  \n",
       "129  The Siege of Mandalore begins, and Ahsoka turn...  \n",
       "130  The battle for Mandalore continues, and Ahsoka...  \n",
       "131  Maul is captured and the Siege of Mandalore is...  \n",
       "132  In the wake of Order 66, Ahsoka and Rex must w...  \n",
       "\n",
       "[133 rows x 7 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(df2)\n",
    "df2.to_csv(\"clone_wars_episode_guide.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "ep_code = \"201\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "season = ep_code[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2\n",
      "1\n"
     ]
    }
   ],
   "source": [
    "print(season)\n",
    "print(int(ep_code[1:]))"
   ]
  },
  {
   "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}