jupyter-labs-webscraping.ipynb

{"cells":[{"cell_type":"markdown","id":"d6ba5f37-d2e8-4c27-9d68-da5f75bb76ec","metadata":{},"source":["<p style=\"text-align:center\">\n","    <a href=\"https://skills.network\" target=\"_blank\">\n","    <img src=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/assets/logos/SN_web_lightmode.png\" width=\"200\" alt=\"Skills Network Logo\">\n","    </a>\n","</p>\n"]},{"cell_type":"markdown","id":"b6705847-5681-4929-9cac-4345ea8255a8","metadata":{},"source":["# **Space X  Falcon 9 First Stage Landing Prediction**\n"]},{"cell_type":"markdown","id":"5159c469-8a49-4c42-a65d-d6fa3583c7b1","metadata":{},"source":["## Web scraping Falcon 9 and Falcon Heavy Launches Records from Wikipedia\n"]},{"cell_type":"markdown","id":"da32a7c8-9d55-4a99-a24f-22697db62448","metadata":{},"source":["Estimated time needed: **40** minutes\n"]},{"cell_type":"markdown","id":"cde166dc-e8cc-4aba-a8d4-07b78dacf4f4","metadata":{},"source":["In this lab, you will be performing web scraping to collect Falcon 9 historical launch records from a Wikipedia page titled `List of Falcon 9 and Falcon Heavy launches`\n","\n","https://en.wikipedia.org/wiki/List_of_Falcon_9_and_Falcon_Heavy_launches\n"]},{"cell_type":"markdown","id":"812d5c6a-6a8b-484d-b881-c6d8f5506de1","metadata":{},"source":["![](https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBM-DS0321EN-SkillsNetwork/labs/module_1_L2/images/Falcon9_rocket_family.svg)\n"]},{"cell_type":"markdown","id":"6f73dc38-3517-4005-9abc-0adc2f149c96","metadata":{},"source":["Falcon 9 first stage will land successfully\n"]},{"cell_type":"markdown","id":"c70f4eac-b60f-4f12-b9e3-0d04d8ac4c15","metadata":{},"source":["![](https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DS0701EN-SkillsNetwork/api/Images/landing_1.gif)\n"]},{"cell_type":"markdown","id":"e602025b-902c-41f4-8b4c-5580535e7bca","metadata":{},"source":["Several examples of an unsuccessful landing are shown here:\n"]},{"cell_type":"markdown","id":"c61bdf55-9538-4356-a0b6-ae95b9270f87","metadata":{},"source":["![](https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DS0701EN-SkillsNetwork/api/Images/crash.gif)\n"]},{"cell_type":"markdown","id":"f02dca7a-c9d6-4c64-9741-999247032b54","metadata":{},"source":["More specifically, the launch records are stored in a HTML table shown below:\n"]},{"cell_type":"markdown","id":"f8e601b6-2fda-4524-9e18-a3a26db0446c","metadata":{},"source":["![](https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBM-DS0321EN-SkillsNetwork/labs/module_1_L2/images/falcon9-launches-wiki.png)\n"]},{"cell_type":"markdown","id":"78b4c601-5556-4f25-808c-c6b55fadb593","metadata":{},"source":["  ## Objectives\n","Web scrap Falcon 9 launch records with `BeautifulSoup`: \n","- Extract a Falcon 9 launch records HTML table from Wikipedia\n","- Parse the table and convert it into a Pandas data frame\n"]},{"cell_type":"markdown","id":"806faaa2-5bc8-4c5f-8560-a09278ee1a35","metadata":{},"source":["First let's import required packages for this lab\n"]},{"cell_type":"code","execution_count":null,"id":"a2a7c4a5-dc2a-4d6f-9742-50018e52e881","metadata":{},"outputs":[],"source":["!pip3 install beautifulsoup4\n","!pip3 install requests"]},{"cell_type":"code","execution_count":4,"id":"7c8d3cc9-5877-4b5f-9e31-8ea50f8cf029","metadata":{},"outputs":[],"source":["import sys\n","\n","import requests\n","from bs4 import BeautifulSoup\n","import re\n","import unicodedata\n","import pandas as pd"]},{"cell_type":"markdown","id":"8c352dd2-7d80-4e13-94d0-f50d56ea43fc","metadata":{},"source":["and we will provide some helper functions for you to process web scraped HTML table\n"]},{"cell_type":"code","execution_count":5,"id":"f2c6c9f4-3a62-45e6-800f-6faef30117c4","metadata":{},"outputs":[],"source":["def date_time(table_cells):\n","    \"\"\"\n","    This function returns the data and time from the HTML  table cell\n","    Input: the  element of a table data cell extracts extra row\n","    \"\"\"\n","    return [data_time.strip() for data_time in list(table_cells.strings)][0:2]\n","\n","def booster_version(table_cells):\n","    \"\"\"\n","    This function returns the booster version from the HTML  table cell \n","    Input: the  element of a table data cell extracts extra row\n","    \"\"\"\n","    out=''.join([booster_version for i,booster_version in enumerate( table_cells.strings) if i%2==0][0:-1])\n","    return out\n","\n","def landing_status(table_cells):\n","    \"\"\"\n","    This function returns the landing status from the HTML table cell \n","    Input: the  element of a table data cell extracts extra row\n","    \"\"\"\n","    out=[i for i in table_cells.strings][0]\n","    return out\n","\n","\n","def get_mass(table_cells):\n","    mass=unicodedata.normalize(\"NFKD\", table_cells.text).strip()\n","    if mass:\n","        mass.find(\"kg\")\n","        new_mass=mass[0:mass.find(\"kg\")+2]\n","    else:\n","        new_mass=0\n","    return new_mass\n","\n","\n","def extract_column_from_header(row):\n","    \"\"\"\n","    This function returns the landing status from the HTML table cell \n","    Input: the  element of a table data cell extracts extra row\n","    \"\"\"\n","    if (row.br):\n","        row.br.extract()\n","    if row.a:\n","        row.a.extract()\n","    if row.sup:\n","        row.sup.extract()\n","        \n","    colunm_name = ' '.join(row.contents)\n","    \n","    # Filter the digit and empty names\n","    if not(colunm_name.strip().isdigit()):\n","        colunm_name = colunm_name.strip()\n","        return colunm_name    \n"]},{"cell_type":"markdown","id":"d6d67823-0c37-47f9-9534-893059126d1f","metadata":{},"source":["To keep the lab tasks consistent, you will be asked to scrape the data from a snapshot of the  `List of Falcon 9 and Falcon Heavy launches` Wikipage updated on\n","`9th June 2021`\n"]},{"cell_type":"code","execution_count":6,"id":"9a2a0107-2cb2-487b-a064-83213465278f","metadata":{},"outputs":[],"source":["static_url = \"https://en.wikipedia.org/w/index.php?title=List_of_Falcon_9_and_Falcon_Heavy_launches&oldid=1027686922\""]},{"cell_type":"markdown","id":"67b0cd55-40eb-41b9-9ecc-988688157222","metadata":{},"source":["Next, request the HTML page from the above URL and get a `response` object\n"]},{"cell_type":"markdown","id":"ec540cbf-717c-450d-923e-e1080830ecc7","metadata":{},"source":["### TASK 1: Request the Falcon9 Launch Wiki page from its URL\n"]},{"cell_type":"markdown","id":"f81f9361-d844-41fb-b0c7-0c044e119338","metadata":{},"source":["First, let's perform an HTTP GET method to request the Falcon9 Launch HTML page, as an HTTP response.\n"]},{"cell_type":"code","execution_count":7,"id":"27209bf6-7bb3-4a02-ade6-e637c0c145ad","metadata":{},"outputs":[],"source":["# use requests.get() method with the provided static_url\n","# assign the response to a object\n","\n","response = requests.get(static_url)"]},{"cell_type":"code","execution_count":9,"metadata":{},"outputs":[{"data":{"text/plain":["200"]},"execution_count":9,"metadata":{},"output_type":"execute_result"}],"source":["response.status_code"]},{"cell_type":"markdown","id":"ff539ad6-eee9-48f9-ba1a-190006e91669","metadata":{},"source":["Create a `BeautifulSoup` object from the HTML `response`\n"]},{"cell_type":"code","execution_count":12,"id":"91ea6dde-5579-4e99-b761-6337cd0313d8","metadata":{},"outputs":[],"source":["# Use BeautifulSoup() to create a BeautifulSoup object from a response text content\n","\n","soup = BeautifulSoup(response.content, 'html.parser')"]},{"cell_type":"markdown","id":"666031e6-2570-410e-8a4a-3661b3b574cd","metadata":{},"source":["Print the page title to verify if the `BeautifulSoup` object was created properly \n"]},{"cell_type":"code","execution_count":13,"id":"1517d648-d512-4ac9-99e5-9c4b2eb53eec","metadata":{},"outputs":[{"data":{"text/plain":["<title>List of Falcon 9 and Falcon Heavy launches - Wikipedia</title>"]},"execution_count":13,"metadata":{},"output_type":"execute_result"}],"source":["# Use soup.title attribute\n","soup.title"]},{"cell_type":"markdown","id":"87db314c-5342-48f4-9973-431fd0281e27","metadata":{},"source":["### TASK 2: Extract all column/variable names from the HTML table header\n"]},{"cell_type":"markdown","id":"c7e5769a-db7e-44ff-99c2-40984d88edb6","metadata":{},"source":["Next, we want to collect all relevant column names from the HTML table header\n"]},{"cell_type":"markdown","id":"ba9f8358-9095-4db1-a969-a223a17c2b22","metadata":{},"source":["Let's try to find all tables on the wiki page first. If you need to refresh your memory about `BeautifulSoup`, please check the external reference link towards the end of this lab\n"]},{"cell_type":"code","execution_count":14,"id":"f345ea64-4f62-4212-b1f2-ec4cca23b0f4","metadata":{},"outputs":[{"name":"stdout","output_type":"stream","text":["Found 25 tables on the page.\n","\n","Table 1:\n","<table class=\"col-begin\" role=\"presentation\">\n"," <tbody>\n","  <tr>\n","   <td class=\"col-break\">\n","    <h3>\n","     <span class=\"mw-headline\" id=\"Rocket_configurations\">\n","      Rocket configurations\n","     </span>\n","    </h3>\n","    <div class=\"chart noresize\" style=\"padding-top:10px;margin-top:1em;max-width:420px;\">\n","     <div style=\"position:relative;min-height:320px;min-width:420px;max-width:420px;\">\n","      <div style=\"float:right;position:relative;min-height:240px;min-width:320px;max-width:320px;border-left:1px bla\n","\n","Table 2:\n","<table class=\"col-begin\" role=\"presentation\">\n"," <tbody>\n","  <tr>\n","   <td class=\"col-break\">\n","    <h3>\n","     <span class=\"mw-headline\" id=\"Launch_outcomes\">\n","      Launch outcomes\n","     </span>\n","    </h3>\n","    <div class=\"chart noresize\" style=\"padding-top:10px;margin-top:1em;max-width:480px;\">\n","     <div style=\"position:relative;min-height:320px;min-width:480px;max-width:480px;\">\n","      <div style=\"float:right;position:relative;min-height:240px;min-width:380px;max-width:380px;border-left:1px black solid;bor\n","\n","Table 3:\n","<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\">\n","    Flight No.\n","   </th>\n","   <th scope=\"col\">\n","    Date and\n","    <br/>\n","    time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"referen\n","\n","Table 4:\n","<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\">\n","    Flight No.\n","   </th>\n","   <th scope=\"col\">\n","    Date and\n","    <br/>\n","    time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"referen\n","\n","Table 5:\n","<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\">\n","    Flight No.\n","   </th>\n","   <th scope=\"col\">\n","    Date and\n","    <br/>\n","    time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"referen\n","\n","Table 6:\n","<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\">\n","    Flight No.\n","   </th>\n","   <th scope=\"col\">\n","    Date and\n","    <br/>\n","    time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"referen\n","\n","Table 7:\n","<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\">\n","    Flight No.\n","   </th>\n","   <th scope=\"col\">\n","    Date and\n","    <br/>\n","    time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"referen\n","\n","Table 8:\n","<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\">\n","    Flight No.\n","   </th>\n","   <th scope=\"col\">\n","    Date and\n","    <br/>\n","    time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"referen\n","\n","Table 9:\n","<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\">\n","    Flight No.\n","   </th>\n","   <th scope=\"col\">\n","    Date and\n","    <br/>\n","    time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"referen\n","\n","Table 10:\n","<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\">\n","    Flight No.\n","   </th>\n","   <th scope=\"col\">\n","    Date and\n","    <br/>\n","    time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"referen\n","\n","Table 11:\n","<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\">\n","    Flight\n","    <p>\n","     No.\n","    </p>\n","   </th>\n","   <th scope=\"col\">\n","    Date and\n","    <br/>\n","    time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n"," \n","\n","Table 12:\n","<table class=\"wikitable\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\" style=\"width: 10%;\">\n","    Date and time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"reference\" id=\"cite_ref-booster_11-9\">\n","     <a href=\"#cite_note-booster-1\n","\n","Table 13:\n","<table class=\"wikitable\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\" style=\"width: 10%;\">\n","    Date and time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"reference\" id=\"cite_ref-booster_11-10\">\n","     <a href=\"#cite_note-booster-\n","\n","Table 14:\n","<table class=\"wikitable\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\" style=\"width: 10%;\">\n","    Date and time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"reference\" id=\"cite_ref-booster_11-11\">\n","     <a href=\"#cite_note-booster-\n","\n","Table 15:\n","<table class=\"wikitable\" style=\"width: 100%;\">\n"," <tbody>\n","  <tr>\n","   <th scope=\"col\" style=\"width: 10%;\">\n","    Date and time (\n","    <a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">\n","     UTC\n","    </a>\n","    )\n","   </th>\n","   <th scope=\"col\">\n","    <a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">\n","     Version,\n","     <br/>\n","     Booster\n","    </a>\n","    <sup class=\"reference\" id=\"cite_ref-booster_11-12\">\n","     <a href=\"#cite_note-booster-\n","\n","Table 16:\n","<table class=\"nowraplinks hlist mw-collapsible autocollapse navbox-inner\" style=\"border-spacing:0;background:transparent;color:inherit\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-title\" colspan=\"2\" scope=\"col\">\n","    <link href=\"mw-data:TemplateStyles:r1129693374\" rel=\"mw-deduplicated-inline-style\"/>\n","    <style data-mw-deduplicate=\"TemplateStyles:r1063604349\">\n","     .mw-parser-output .navbar{display:inline;font-size:88%;font-weight:normal}.mw-parser-output .navbar-collapse{float:left;text-align:left}.mw\n","\n","Table 17:\n","<table class=\"nowraplinks navbox-subgroup\" style=\"border-spacing:0\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-group\" scope=\"row\" style=\"width:1%\">\n","    Demonstration\n","   </th>\n","   <td class=\"navbox-list-with-group navbox-list navbox-odd\" style=\"width:100%;padding:0\">\n","    <div style=\"padding:0 0.25em\">\n","     <ul>\n","      <li>\n","       <a href=\"/wiki/Dragon_Spacecraft_Qualification_Unit\" title=\"Dragon Spacecraft Qualification Unit\">\n","        Dragon test flight\n","       </a>\n","      </li>\n","      <li>\n","       <a href=\n","\n","Table 18:\n","<table class=\"nowraplinks navbox-subgroup\" style=\"border-spacing:0\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-group\" scope=\"row\" style=\"width:1%\">\n","    Transporter\n","   </th>\n","   <td class=\"navbox-list-with-group navbox-list navbox-odd\" style=\"width:100%;padding:0\">\n","    <div style=\"padding:0 0.25em\">\n","     <ul>\n","      <li>\n","       2021\n","       <ul>\n","        <li>\n","         <a href=\"/wiki/List_of_spaceflight_launches_in_January%E2%80%93June_2021#SpXTransporter1\" title=\"List of spaceflight launches in January–Ju\n","\n","Table 19:\n","<table class=\"nowraplinks mw-collapsible mw-collapsed navbox-inner\" style=\"border-spacing:0;background:transparent;color:inherit\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-title\" colspan=\"3\" scope=\"col\">\n","    <link href=\"mw-data:TemplateStyles:r1129693374\" rel=\"mw-deduplicated-inline-style\"/>\n","    <link href=\"mw-data:TemplateStyles:r1063604349\" rel=\"mw-deduplicated-inline-style\"/>\n","    <div class=\"navbar plainlinks hlist navbar-mini\">\n","     <ul>\n","      <li class=\"nv-view\">\n","       <a href=\"/wiki/Template:\n","\n","Table 20:\n","<table class=\"nowraplinks navbox-subgroup\" style=\"border-spacing:0\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-group\" scope=\"row\" style=\"width:1%\">\n","    Current\n","   </th>\n","   <td class=\"navbox-list-with-group navbox-list navbox-odd\" style=\"width:100%;padding:0\">\n","    <div style=\"padding:0 0.25em\">\n","     <ul>\n","      <li>\n","       <a href=\"/wiki/Falcon_9\" title=\"Falcon 9\">\n","        Falcon 9\n","       </a>\n","       <ul>\n","        <li>\n","         <a href=\"/wiki/Falcon_9_Block_5\" title=\"Falcon 9 Block 5\">\n","          Block 5\n","\n","Table 21:\n","<table class=\"nowraplinks navbox-subgroup\" style=\"border-spacing:0\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-group\" scope=\"row\" style=\"width:1%\">\n","    Cargo\n","   </th>\n","   <td class=\"navbox-list-with-group navbox-list navbox-odd\" style=\"width:100%;padding:0\">\n","    <div style=\"padding:0 0.25em\">\n","     <ul>\n","      <li>\n","       <a href=\"/wiki/SpaceX_Dragon_1\" title=\"SpaceX Dragon 1\">\n","        Dragon 1 Cargo\n","       </a>\n","      </li>\n","      <li>\n","       <a href=\"/wiki/SpaceX_Dragon_2\" title=\"SpaceX Dragon 2\">\n","     \n","\n","Table 22:\n","<table class=\"nowraplinks navbox-subgroup\" style=\"border-spacing:0\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-group\" scope=\"row\" style=\"width:1%\">\n","    Current\n","   </th>\n","   <td class=\"navbox-list-with-group navbox-list navbox-odd\" style=\"width:100%;padding:0\">\n","    <div style=\"padding:0 0.25em\">\n","     <ul>\n","      <li>\n","       Starship prototypes\n","       <ul>\n","        <li>\n","         <a href=\"/wiki/SpaceX_Super_Heavy#Development\" title=\"SpaceX Super Heavy\">\n","          first stage booster\n","         </a>\n","        <\n","\n","Table 23:\n","<table class=\"nowraplinks navbox-subgroup\" style=\"border-spacing:0\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-group\" scope=\"row\" style=\"width:1%\">\n","    Orbital\n","   </th>\n","   <td class=\"navbox-list-with-group navbox-list navbox-even\" style=\"width:100%;padding:0\">\n","    <div style=\"padding:0 0.25em\">\n","     <ul>\n","      <li>\n","       <a href=\"/wiki/Cape_Canaveral_Space_Force_Station\" title=\"Cape Canaveral Space Force Station\">\n","        CCSFS\n","       </a>\n","       <a href=\"/wiki/Cape_Canaveral_Space_Launch_Complex_40\n","\n","Table 24:\n","<table class=\"nowraplinks hlist mw-collapsible autocollapse navbox-inner\" style=\"border-spacing:0;background:transparent;color:inherit\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-title\" colspan=\"2\" scope=\"col\">\n","    <link href=\"mw-data:TemplateStyles:r1129693374\" rel=\"mw-deduplicated-inline-style\"/>\n","    <link href=\"mw-data:TemplateStyles:r1063604349\" rel=\"mw-deduplicated-inline-style\"/>\n","    <div class=\"navbar plainlinks hlist navbar-mini\">\n","     <ul>\n","      <li class=\"nv-view\">\n","       <a href=\"/wiki/Tem\n","\n","Table 25:\n","<table class=\"nowraplinks navbox-subgroup\" style=\"border-spacing:0\">\n"," <tbody>\n","  <tr>\n","   <th class=\"navbox-group\" scope=\"row\" style=\"width:1%\">\n","    General\n","   </th>\n","   <td class=\"navbox-list-with-group navbox-list navbox-even\" style=\"width:100%;padding:0\">\n","    <div style=\"padding:0 0.25em\">\n","     <ul>\n","      <li>\n","       <a href=\"/wiki/List_of_crewed_spacecraft\" title=\"List of crewed spacecraft\">\n","        Crewed spacecraft\n","       </a>\n","       <ul>\n","        <li>\n","         <a href=\"/wiki/List_of_human_spa\n"]}],"source":["# Use the find_all function in the BeautifulSoup object, with element type `table`\n","# Assign the result to a list called `html_tables`\n","\n","html_tables = soup.find_all('table')\n","    \n","    # Output the result\n","print(f\"Found {len(html_tables)} tables on the page.\")\n","for i, table in enumerate(html_tables):\n","    print(f\"\\nTable {i+1}:\\n{table.prettify()[:500]}\")  # Print the first 500 characters of each table for brevity\n"]},{"cell_type":"markdown","id":"75479d6e-7283-4fdd-b52d-8c4eb283f069","metadata":{},"source":["Starting from the third table is our target table contains the actual launch records.\n"]},{"cell_type":"code","execution_count":15,"id":"39127b09-9bc8-4afa-b7df-6cb3f57bd59b","metadata":{},"outputs":[{"name":"stdout","output_type":"stream","text":["<table class=\"wikitable plainrowheaders collapsible\" style=\"width: 100%;\">\n","<tbody><tr>\n","<th scope=\"col\">Flight No.\n","</th>\n","<th scope=\"col\">Date and<br/>time (<a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">UTC</a>)\n","</th>\n","<th scope=\"col\"><a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">Version,<br/>Booster</a> <sup class=\"reference\" id=\"cite_ref-booster_11-0\"><a href=\"#cite_note-booster-11\">[b]</a></sup>\n","</th>\n","<th scope=\"col\">Launch site\n","</th>\n","<th scope=\"col\">Payload<sup class=\"reference\" id=\"cite_ref-Dragon_12-0\"><a href=\"#cite_note-Dragon-12\">[c]</a></sup>\n","</th>\n","<th scope=\"col\">Payload mass\n","</th>\n","<th scope=\"col\">Orbit\n","</th>\n","<th scope=\"col\">Customer\n","</th>\n","<th scope=\"col\">Launch<br/>outcome\n","</th>\n","<th scope=\"col\"><a href=\"/wiki/Falcon_9_first-stage_landing_tests\" title=\"Falcon 9 first-stage landing tests\">Booster<br/>landing</a>\n","</th></tr>\n","<tr>\n","<th rowspan=\"2\" scope=\"row\" style=\"text-align:center;\">1\n","</th>\n","<td>4 June 2010,<br/>18:45\n","</td>\n","<td><a href=\"/wiki/Falcon_9_v1.0\" title=\"Falcon 9 v1.0\">F9 v1.0</a><sup class=\"reference\" id=\"cite_ref-MuskMay2012_13-0\"><a href=\"#cite_note-MuskMay2012-13\">[7]</a></sup><br/>B0003.1<sup class=\"reference\" id=\"cite_ref-block_numbers_14-0\"><a href=\"#cite_note-block_numbers-14\">[8]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Cape_Canaveral_Space_Force_Station\" title=\"Cape Canaveral Space Force Station\">CCAFS</a>,<br/><a href=\"/wiki/Cape_Canaveral_Space_Launch_Complex_40\" title=\"Cape Canaveral Space Launch Complex 40\">SLC-40</a>\n","</td>\n","<td><a href=\"/wiki/Dragon_Spacecraft_Qualification_Unit\" title=\"Dragon Spacecraft Qualification Unit\">Dragon Spacecraft Qualification Unit</a>\n","</td>\n","<td>\n","</td>\n","<td><a href=\"/wiki/Low_Earth_orbit\" title=\"Low Earth orbit\">LEO</a>\n","</td>\n","<td><a href=\"/wiki/SpaceX\" title=\"SpaceX\">SpaceX</a>\n","</td>\n","<td class=\"table-success\" style=\"background: #9EFF9E; vertical-align: middle; text-align: center;\">Success\n","</td>\n","<td class=\"table-failure\" style=\"background: #FFC7C7; vertical-align: middle; text-align: center;\">Failure<sup class=\"reference\" id=\"cite_ref-ns20110930_15-0\"><a href=\"#cite_note-ns20110930-15\">[9]</a></sup><sup class=\"reference\" id=\"cite_ref-16\"><a href=\"#cite_note-16\">[10]</a></sup><br/><small>(parachute)</small>\n","</td></tr>\n","<tr>\n","<td colspan=\"9\">First flight of Falcon 9 v1.0.<sup class=\"reference\" id=\"cite_ref-sfn20100604_17-0\"><a href=\"#cite_note-sfn20100604-17\">[11]</a></sup> Used a boilerplate version of Dragon capsule which was not designed to separate from the second stage.<small>(<a href=\"#First_flight_of_Falcon_9\">more details below</a>)</small> Attempted to recover the first stage by parachuting it into the ocean, but it burned up on reentry, before the parachutes even deployed.<sup class=\"reference\" id=\"cite_ref-parachute_18-0\"><a href=\"#cite_note-parachute-18\">[12]</a></sup>\n","</td></tr>\n","<tr>\n","<th rowspan=\"2\" scope=\"row\" style=\"text-align:center;\">2\n","</th>\n","<td>8 December 2010,<br/>15:43<sup class=\"reference\" id=\"cite_ref-spaceflightnow_Clark_Launch_Report_19-0\"><a href=\"#cite_note-spaceflightnow_Clark_Launch_Report-19\">[13]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Falcon_9_v1.0\" title=\"Falcon 9 v1.0\">F9 v1.0</a><sup class=\"reference\" id=\"cite_ref-MuskMay2012_13-1\"><a href=\"#cite_note-MuskMay2012-13\">[7]</a></sup><br/>B0004.1<sup class=\"reference\" id=\"cite_ref-block_numbers_14-1\"><a href=\"#cite_note-block_numbers-14\">[8]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Cape_Canaveral_Space_Force_Station\" title=\"Cape Canaveral Space Force Station\">CCAFS</a>,<br/><a href=\"/wiki/Cape_Canaveral_Space_Launch_Complex_40\" title=\"Cape Canaveral Space Launch Complex 40\">SLC-40</a>\n","</td>\n","<td><a href=\"/wiki/SpaceX_Dragon\" title=\"SpaceX Dragon\">Dragon</a> <a class=\"mw-redirect\" href=\"/wiki/COTS_Demo_Flight_1\" title=\"COTS Demo Flight 1\">demo flight C1</a><br/>(Dragon C101)\n","</td>\n","<td>\n","</td>\n","<td><a href=\"/wiki/Low_Earth_orbit\" title=\"Low Earth orbit\">LEO</a> (<a href=\"/wiki/International_Space_Station\" title=\"International Space Station\">ISS</a>)\n","</td>\n","<td><style data-mw-deduplicate=\"TemplateStyles:r1126788409\">.mw-parser-output .plainlist ol,.mw-parser-output .plainlist ul{line-height:inherit;list-style:none;margin:0;padding:0}.mw-parser-output .plainlist ol li,.mw-parser-output .plainlist ul li{margin-bottom:0}</style><div class=\"plainlist\">\n","<ul><li><a href=\"/wiki/NASA\" title=\"NASA\">NASA</a> (<a href=\"/wiki/Commercial_Orbital_Transportation_Services\" title=\"Commercial Orbital Transportation Services\">COTS</a>)</li>\n","<li><a href=\"/wiki/National_Reconnaissance_Office\" title=\"National Reconnaissance Office\">NRO</a></li></ul>\n","</div>\n","</td>\n","<td class=\"table-success\" style=\"background: #9EFF9E; vertical-align: middle; text-align: center;\">Success<sup class=\"reference\" id=\"cite_ref-ns20110930_15-1\"><a href=\"#cite_note-ns20110930-15\">[9]</a></sup>\n","</td>\n","<td class=\"table-failure\" style=\"background: #FFC7C7; vertical-align: middle; text-align: center;\">Failure<sup class=\"reference\" id=\"cite_ref-ns20110930_15-2\"><a href=\"#cite_note-ns20110930-15\">[9]</a></sup><sup class=\"reference\" id=\"cite_ref-20\"><a href=\"#cite_note-20\">[14]</a></sup><br/><small>(parachute)</small>\n","</td></tr>\n","<tr>\n","<td colspan=\"9\">Maiden flight of <a class=\"mw-redirect\" href=\"/wiki/Dragon_capsule\" title=\"Dragon capsule\">Dragon capsule</a>, consisting of over 3 hours of testing thruster maneuvering and reentry.<sup class=\"reference\" id=\"cite_ref-spaceflightnow_Clark_unleashing_Dragon_21-0\"><a href=\"#cite_note-spaceflightnow_Clark_unleashing_Dragon-21\">[15]</a></sup> Attempted to recover the first stage by parachuting it into the ocean, but it disintegrated upon reentry, before the parachutes were deployed.<sup class=\"reference\" id=\"cite_ref-parachute_18-1\"><a href=\"#cite_note-parachute-18\">[12]</a></sup> <small>(<a href=\"#COTS_demo_missions\">more details below</a>)</small> It also included two <a href=\"/wiki/CubeSat\" title=\"CubeSat\">CubeSats</a>,<sup class=\"reference\" id=\"cite_ref-NRO_Taps_Boeing_for_Next_Batch_of_CubeSats_22-0\"><a href=\"#cite_note-NRO_Taps_Boeing_for_Next_Batch_of_CubeSats-22\">[16]</a></sup> and a wheel of <a href=\"/wiki/Brou%C3%A8re\" title=\"Brouère\">Brouère</a> cheese.\n","</td></tr>\n","<tr>\n","<th rowspan=\"2\" scope=\"row\" style=\"text-align:center;\">3\n","</th>\n","<td>22 May 2012,<br/>07:44<sup class=\"reference\" id=\"cite_ref-BBC_new_era_23-0\"><a href=\"#cite_note-BBC_new_era-23\">[17]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Falcon_9_v1.0\" title=\"Falcon 9 v1.0\">F9 v1.0</a><sup class=\"reference\" id=\"cite_ref-MuskMay2012_13-2\"><a href=\"#cite_note-MuskMay2012-13\">[7]</a></sup><br/>B0005.1<sup class=\"reference\" id=\"cite_ref-block_numbers_14-2\"><a href=\"#cite_note-block_numbers-14\">[8]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Cape_Canaveral_Space_Force_Station\" title=\"Cape Canaveral Space Force Station\">CCAFS</a>,<br/><a href=\"/wiki/Cape_Canaveral_Space_Launch_Complex_40\" title=\"Cape Canaveral Space Launch Complex 40\">SLC-40</a>\n","</td>\n","<td><a href=\"/wiki/SpaceX_Dragon\" title=\"SpaceX Dragon\">Dragon</a> <a class=\"mw-redirect\" href=\"/wiki/Dragon_C2%2B\" title=\"Dragon C2+\">demo flight C2+</a><sup class=\"reference\" id=\"cite_ref-C2_24-0\"><a href=\"#cite_note-C2-24\">[18]</a></sup><br/>(Dragon C102)\n","</td>\n","<td>525 kg (1,157 lb)<sup class=\"reference\" id=\"cite_ref-25\"><a href=\"#cite_note-25\">[19]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Low_Earth_orbit\" title=\"Low Earth orbit\">LEO</a> (<a href=\"/wiki/International_Space_Station\" title=\"International Space Station\">ISS</a>)\n","</td>\n","<td><a href=\"/wiki/NASA\" title=\"NASA\">NASA</a> (<a href=\"/wiki/Commercial_Orbital_Transportation_Services\" title=\"Commercial Orbital Transportation Services\">COTS</a>)\n","</td>\n","<td class=\"table-success\" style=\"background: #9EFF9E; vertical-align: middle; text-align: center;\">Success<sup class=\"reference\" id=\"cite_ref-26\"><a href=\"#cite_note-26\">[20]</a></sup>\n","</td>\n","<td class=\"table-noAttempt\" style=\"background: #EEE; vertical-align: middle; white-space: nowrap; text-align: center;\">No attempt\n","</td></tr>\n","<tr>\n","<td colspan=\"9\">Dragon spacecraft demonstrated a series of tests before it was allowed to approach the <a href=\"/wiki/International_Space_Station\" title=\"International Space Station\">International Space Station</a>. Two days later, it became the first commercial spacecraft to board the ISS.<sup class=\"reference\" id=\"cite_ref-BBC_new_era_23-1\"><a href=\"#cite_note-BBC_new_era-23\">[17]</a></sup> <small>(<a href=\"#COTS_demo_missions\">more details below</a>)</small>\n","</td></tr>\n","<tr>\n","<th rowspan=\"3\" scope=\"row\" style=\"text-align:center;\">4\n","</th>\n","<td rowspan=\"2\">8 October 2012,<br/>00:35<sup class=\"reference\" id=\"cite_ref-SFN_LLog_27-0\"><a href=\"#cite_note-SFN_LLog-27\">[21]</a></sup>\n","</td>\n","<td rowspan=\"2\"><a href=\"/wiki/Falcon_9_v1.0\" title=\"Falcon 9 v1.0\">F9 v1.0</a><sup class=\"reference\" id=\"cite_ref-MuskMay2012_13-3\"><a href=\"#cite_note-MuskMay2012-13\">[7]</a></sup><br/>B0006.1<sup class=\"reference\" id=\"cite_ref-block_numbers_14-3\"><a href=\"#cite_note-block_numbers-14\">[8]</a></sup>\n","</td>\n","<td rowspan=\"2\"><a href=\"/wiki/Cape_Canaveral_Space_Force_Station\" title=\"Cape Canaveral Space Force Station\">CCAFS</a>,<br/><a href=\"/wiki/Cape_Canaveral_Space_Launch_Complex_40\" title=\"Cape Canaveral Space Launch Complex 40\">SLC-40</a>\n","</td>\n","<td><a href=\"/wiki/SpaceX_CRS-1\" title=\"SpaceX CRS-1\">SpaceX CRS-1</a><sup class=\"reference\" id=\"cite_ref-sxManifest20120925_28-0\"><a href=\"#cite_note-sxManifest20120925-28\">[22]</a></sup><br/>(Dragon C103)\n","</td>\n","<td>4,700 kg (10,400 lb)\n","</td>\n","<td><a href=\"/wiki/Low_Earth_orbit\" title=\"Low Earth orbit\">LEO</a> (<a href=\"/wiki/International_Space_Station\" title=\"International Space Station\">ISS</a>)\n","</td>\n","<td><a href=\"/wiki/NASA\" title=\"NASA\">NASA</a> (<a href=\"/wiki/Commercial_Resupply_Services\" title=\"Commercial Resupply Services\">CRS</a>)\n","</td>\n","<td class=\"table-success\" style=\"background: #9EFF9E; vertical-align: middle; text-align: center;\">Success\n","</td>\n","<td rowspan=\"2\" style=\"background:#ececec; text-align:center;\"><span class=\"nowrap\">No attempt</span>\n","</td></tr>\n","<tr>\n","<td><a href=\"/wiki/Orbcomm_(satellite)\" title=\"Orbcomm (satellite)\">Orbcomm-OG2</a><sup class=\"reference\" id=\"cite_ref-Orbcomm_29-0\"><a href=\"#cite_note-Orbcomm-29\">[23]</a></sup>\n","</td>\n","<td>172 kg (379 lb)<sup class=\"reference\" id=\"cite_ref-gunter-og2_30-0\"><a href=\"#cite_note-gunter-og2-30\">[24]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Low_Earth_orbit\" title=\"Low Earth orbit\">LEO</a>\n","</td>\n","<td><a href=\"/wiki/Orbcomm\" title=\"Orbcomm\">Orbcomm</a>\n","</td>\n","<td class=\"table-partial\" style=\"background: #FE9; vertical-align: middle; text-align: center;\">Partial failure<sup class=\"reference\" id=\"cite_ref-nyt-20121030_31-0\"><a href=\"#cite_note-nyt-20121030-31\">[25]</a></sup>\n","</td></tr>\n","<tr>\n","<td colspan=\"9\">CRS-1 was successful, but the <a href=\"/wiki/Secondary_payload\" title=\"Secondary payload\">secondary payload</a> was inserted into an abnormally low orbit and subsequently lost. This was due to one of the nine <a href=\"/wiki/SpaceX_Merlin\" title=\"SpaceX Merlin\">Merlin engines</a> shutting down during the launch, and NASA declining a second reignition, as per <a href=\"/wiki/International_Space_Station\" title=\"International Space Station\">ISS</a> visiting vehicle safety rules, the primary payload owner is contractually allowed to decline a second reignition. NASA stated that this was because SpaceX could not guarantee a high enough likelihood of the second stage completing the second burn successfully which was required to avoid any risk of secondary payload's collision with the ISS.<sup class=\"reference\" id=\"cite_ref-OrbcommTotalLoss_32-0\"><a href=\"#cite_note-OrbcommTotalLoss-32\">[26]</a></sup><sup class=\"reference\" id=\"cite_ref-sn20121011_33-0\"><a href=\"#cite_note-sn20121011-33\">[27]</a></sup><sup class=\"reference\" id=\"cite_ref-34\"><a href=\"#cite_note-34\">[28]</a></sup>\n","</td></tr>\n","<tr>\n","<th rowspan=\"2\" scope=\"row\" style=\"text-align:center;\">5\n","</th>\n","<td>1 March 2013,<br/>15:10\n","</td>\n","<td><a href=\"/wiki/Falcon_9_v1.0\" title=\"Falcon 9 v1.0\">F9 v1.0</a><sup class=\"reference\" id=\"cite_ref-MuskMay2012_13-4\"><a href=\"#cite_note-MuskMay2012-13\">[7]</a></sup><br/>B0007.1<sup class=\"reference\" id=\"cite_ref-block_numbers_14-4\"><a href=\"#cite_note-block_numbers-14\">[8]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Cape_Canaveral_Space_Force_Station\" title=\"Cape Canaveral Space Force Station\">CCAFS</a>,<br/><a href=\"/wiki/Cape_Canaveral_Space_Launch_Complex_40\" title=\"Cape Canaveral Space Launch Complex 40\">SLC-40</a>\n","</td>\n","<td><a href=\"/wiki/SpaceX_CRS-2\" title=\"SpaceX CRS-2\">SpaceX CRS-2</a><sup class=\"reference\" id=\"cite_ref-sxManifest20120925_28-1\"><a href=\"#cite_note-sxManifest20120925-28\">[22]</a></sup><br/>(Dragon C104)\n","</td>\n","<td>4,877 kg (10,752 lb)\n","</td>\n","<td><a href=\"/wiki/Low_Earth_orbit\" title=\"Low Earth orbit\">LEO</a> (<a class=\"mw-redirect\" href=\"/wiki/ISS\" title=\"ISS\">ISS</a>)\n","</td>\n","<td><a href=\"/wiki/NASA\" title=\"NASA\">NASA</a> (<a href=\"/wiki/Commercial_Resupply_Services\" title=\"Commercial Resupply Services\">CRS</a>)\n","</td>\n","<td class=\"table-success\" style=\"background: #9EFF9E; vertical-align: middle; text-align: center;\">Success\n","</td>\n","<td class=\"table-noAttempt\" style=\"background: #EEE; vertical-align: middle; white-space: nowrap; text-align: center;\">No attempt\n","</td></tr>\n","<tr>\n","<td colspan=\"9\">Last launch of the original Falcon 9 v1.0 <a href=\"/wiki/Launch_vehicle\" title=\"Launch vehicle\">launch vehicle</a>, first use of the unpressurized trunk section of Dragon.<sup class=\"reference\" id=\"cite_ref-sxf9_20110321_35-0\"><a href=\"#cite_note-sxf9_20110321-35\">[29]</a></sup>\n","</td></tr>\n","<tr>\n","<th rowspan=\"2\" scope=\"row\" style=\"text-align:center;\">6\n","</th>\n","<td>29 September 2013,<br/>16:00<sup class=\"reference\" id=\"cite_ref-pa20130930_36-0\"><a href=\"#cite_note-pa20130930-36\">[30]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Falcon_9_v1.1\" title=\"Falcon 9 v1.1\">F9 v1.1</a><sup class=\"reference\" id=\"cite_ref-MuskMay2012_13-5\"><a href=\"#cite_note-MuskMay2012-13\">[7]</a></sup><br/>B1003<sup class=\"reference\" id=\"cite_ref-block_numbers_14-5\"><a href=\"#cite_note-block_numbers-14\">[8]</a></sup>\n","</td>\n","<td><a class=\"mw-redirect\" href=\"/wiki/Vandenberg_Air_Force_Base\" title=\"Vandenberg Air Force Base\">VAFB</a>,<br/><a href=\"/wiki/Vandenberg_Space_Launch_Complex_4\" title=\"Vandenberg Space Launch Complex 4\">SLC-4E</a>\n","</td>\n","<td><a href=\"/wiki/CASSIOPE\" title=\"CASSIOPE\">CASSIOPE</a><sup class=\"reference\" id=\"cite_ref-sxManifest20120925_28-2\"><a href=\"#cite_note-sxManifest20120925-28\">[22]</a></sup><sup class=\"reference\" id=\"cite_ref-CASSIOPE_MDA_37-0\"><a href=\"#cite_note-CASSIOPE_MDA-37\">[31]</a></sup>\n","</td>\n","<td>500 kg (1,100 lb)\n","</td>\n","<td><a href=\"/wiki/Polar_orbit\" title=\"Polar orbit\">Polar orbit</a> <a href=\"/wiki/Low_Earth_orbit\" title=\"Low Earth orbit\">LEO</a>\n","</td>\n","<td><a href=\"/wiki/Maxar_Technologies\" title=\"Maxar Technologies\">MDA</a>\n","</td>\n","<td class=\"table-success\" style=\"background: #9EFF9E; vertical-align: middle; text-align: center;\">Success<sup class=\"reference\" id=\"cite_ref-pa20130930_36-1\"><a href=\"#cite_note-pa20130930-36\">[30]</a></sup>\n","</td>\n","<td class=\"table-no2\" style=\"background: #FFE3E3; color: black; vertical-align: middle; text-align: center;\">Uncontrolled<br/><small>(ocean)</small><sup class=\"reference\" id=\"cite_ref-ocean_landing_38-0\"><a href=\"#cite_note-ocean_landing-38\">[d]</a></sup>\n","</td></tr>\n","<tr>\n","<td colspan=\"9\">First commercial mission with a private customer, first launch from Vandenberg, and demonstration flight of Falcon 9 v1.1 with an improved 13-tonne to LEO capacity.<sup class=\"reference\" id=\"cite_ref-sxf9_20110321_35-1\"><a href=\"#cite_note-sxf9_20110321-35\">[29]</a></sup> After separation from the second stage carrying Canadian commercial and scientific satellites, the first stage booster performed a controlled reentry,<sup class=\"reference\" id=\"cite_ref-39\"><a href=\"#cite_note-39\">[32]</a></sup> and an <a href=\"/wiki/Falcon_9_first-stage_landing_tests\" title=\"Falcon 9 first-stage landing tests\">ocean touchdown test</a> for the first time. This provided good test data, even though the booster started rolling as it neared the ocean, leading to the shutdown of the central engine as the roll depleted it of fuel, resulting in a hard impact with the ocean.<sup class=\"reference\" id=\"cite_ref-pa20130930_36-2\"><a href=\"#cite_note-pa20130930-36\">[30]</a></sup> This was the first known attempt of a rocket engine being lit to perform a supersonic retro propulsion, and allowed SpaceX to enter a public-private partnership with <a href=\"/wiki/NASA\" title=\"NASA\">NASA</a> and its Mars entry, descent, and landing technologies research projects.<sup class=\"reference\" id=\"cite_ref-40\"><a href=\"#cite_note-40\">[33]</a></sup> <small>(<a href=\"#Maiden_flight_of_v1.1\">more details below</a>)</small>\n","</td></tr>\n","<tr>\n","<th rowspan=\"2\" scope=\"row\" style=\"text-align:center;\">7\n","</th>\n","<td>3 December 2013,<br/>22:41<sup class=\"reference\" id=\"cite_ref-sfn_wwls20130624_41-0\"><a href=\"#cite_note-sfn_wwls20130624-41\">[34]</a></sup>\n","</td>\n","<td><a href=\"/wiki/Falcon_9_v1.1\" title=\"Falcon 9 v1.1\">F9 v1.1</a><br/>B1004\n","</td>\n","<td><a href=\"/wiki/Cape_Canaveral_Space_Force_Station\" title=\"Cape Canaveral Space Force Station\">CCAFS</a>,<br/><a href=\"/wiki/Cape_Canaveral_Space_Launch_Complex_40\" title=\"Cape Canaveral Space Launch Complex 40\">SLC-40</a>\n","</td>\n","<td><a href=\"/wiki/SES-8\" title=\"SES-8\">SES-8</a><sup class=\"reference\" id=\"cite_ref-sxManifest20120925_28-3\"><a href=\"#cite_note-sxManifest20120925-28\">[22]</a></sup><sup class=\"reference\" id=\"cite_ref-spx-pr_42-0\"><a href=\"#cite_note-spx-pr-42\">[35]</a></sup><sup class=\"reference\" id=\"cite_ref-aw20110323_43-0\"><a href=\"#cite_note-aw20110323-43\">[36]</a></sup>\n","</td>\n","<td>3,170 kg (6,990 lb)\n","</td>\n","<td><a href=\"/wiki/Geostationary_transfer_orbit\" title=\"Geostationary transfer orbit\">GTO</a>\n","</td>\n","<td><a class=\"mw-redirect\" href=\"/wiki/SES_S.A.\" title=\"SES S.A.\">SES</a>\n","</td>\n","<td class=\"table-success\" style=\"background: #9EFF9E; vertical-align: middle; text-align: center;\">Success<sup class=\"reference\" id=\"cite_ref-SNMissionStatus7_44-0\"><a href=\"#cite_note-SNMissionStatus7-44\">[37]</a></sup>\n","</td>\n","<td class=\"table-noAttempt\" style=\"background: #EEE; vertical-align: middle; white-space: nowrap; text-align: center;\">No attempt<br/><sup class=\"reference\" id=\"cite_ref-sf10120131203_45-0\"><a href=\"#cite_note-sf10120131203-45\">[38]</a></sup>\n","</td></tr>\n","<tr>\n","<td colspan=\"9\">First <a href=\"/wiki/Geostationary_transfer_orbit\" title=\"Geostationary transfer orbit\">Geostationary transfer orbit</a> (GTO) launch for Falcon 9,<sup class=\"reference\" id=\"cite_ref-spx-pr_42-1\"><a href=\"#cite_note-spx-pr-42\">[35]</a></sup> and first successful reignition of the second stage.<sup class=\"reference\" id=\"cite_ref-46\"><a href=\"#cite_note-46\">[39]</a></sup> SES-8 was inserted into a <a href=\"/wiki/Geostationary_transfer_orbit\" title=\"Geostationary transfer orbit\">Super-Synchronous Transfer Orbit</a> of 79,341 km (49,300 mi) in apogee with an <a href=\"/wiki/Orbital_inclination\" title=\"Orbital inclination\">inclination</a> of 20.55° to the <a href=\"/wiki/Equator\" title=\"Equator\">equator</a>.\n","</td></tr></tbody></table>\n"]}],"source":["# Let's print the third table and check its content\n","first_launch_table = html_tables[2]\n","print(first_launch_table)"]},{"cell_type":"markdown","id":"c1d4191c-6f61-451c-acbc-8951747f2320","metadata":{},"source":["You should able to see the columns names embedded in the table header elements `<th>` as follows:\n"]},{"cell_type":"markdown","id":"852b4c4c-8af5-4968-a71d-3b2d5e4e137b","metadata":{},"source":["```\n","<tr>\n","<th scope=\"col\">Flight No.\n","</th>\n","<th scope=\"col\">Date and<br/>time (<a href=\"/wiki/Coordinated_Universal_Time\" title=\"Coordinated Universal Time\">UTC</a>)\n","</th>\n","<th scope=\"col\"><a href=\"/wiki/List_of_Falcon_9_first-stage_boosters\" title=\"List of Falcon 9 first-stage boosters\">Version,<br/>Booster</a> <sup class=\"reference\" id=\"cite_ref-booster_11-0\"><a href=\"#cite_note-booster-11\">[b]</a></sup>\n","</th>\n","<th scope=\"col\">Launch site\n","</th>\n","<th scope=\"col\">Payload<sup class=\"reference\" id=\"cite_ref-Dragon_12-0\"><a href=\"#cite_note-Dragon-12\">[c]</a></sup>\n","</th>\n","<th scope=\"col\">Payload mass\n","</th>\n","<th scope=\"col\">Orbit\n","</th>\n","<th scope=\"col\">Customer\n","</th>\n","<th scope=\"col\">Launch<br/>outcome\n","</th>\n","<th scope=\"col\"><a href=\"/wiki/Falcon_9_first-stage_landing_tests\" title=\"Falcon 9 first-stage landing tests\">Booster<br/>landing</a>\n","</th></tr>\n","```\n"]},{"cell_type":"markdown","id":"587b33ae-9057-4a1d-8362-9b45b064d8d6","metadata":{},"source":["Next, we just need to iterate through the `<th>` elements and apply the provided `extract_column_from_header()` to extract column name one by one\n"]},{"cell_type":"code","execution_count":18,"id":"3fa46d57-df59-47d8-9572-0ee238d81fcf","metadata":{},"outputs":[],"source":["column_names = []\n","\n","# Apply find_all() function with `th` element on first_launch_table\n","# Iterate each th element and apply the provided extract_column_from_header() to get a column name\n","# Append the Non-empty column name (`if name is not None and len(name) > 0`) into a list called column_names\n","\n","\n","# List to store column names\n","column_names = []\n","\n","# Iterate through each table and extract column names from <th> elements\n","th_elements = first_launch_table.find_all('th')\n","for th in th_elements:\n","    column_name = extract_column_from_header(th)\n","    if column_name and len(column_name) > 0:\n","        column_names.append(column_name)"]},{"cell_type":"markdown","id":"79a7ca6a-0650-4171-b03f-9d04802df440","metadata":{},"source":["Check the extracted column names\n"]},{"cell_type":"code","execution_count":19,"id":"0c6cd4cd-b399-4d3b-8c8a-38ec6c4028e2","metadata":{},"outputs":[{"name":"stdout","output_type":"stream","text":["['Flight No.', 'Date and time ( )', 'Launch site', 'Payload', 'Payload mass', 'Orbit', 'Customer', 'Launch outcome']\n"]}],"source":["print(column_names)"]},{"cell_type":"markdown","id":"63600678-6581-4cbc-b6cb-1d733fbf247f","metadata":{},"source":["## TASK 3: Create a data frame by parsing the launch HTML tables\n"]},{"cell_type":"markdown","id":"dfb1dfb0-ee73-4587-b38d-ddebe4f41940","metadata":{},"source":["We will create an empty dictionary with keys from the extracted column names in the previous task. Later, this dictionary will be converted into a Pandas dataframe\n"]},{"cell_type":"code","execution_count":95,"id":"0aa18a5d-916e-4785-a732-fba1c9086c4e","metadata":{},"outputs":[],"source":["launch_dict= dict.fromkeys(column_names)\n","\n","# Remove an irrelvant column\n","del launch_dict['Date and time ( )']\n","\n","# Let's initial the launch_dict with each value to be an empty list\n","launch_dict['Flight No.'] = []\n","launch_dict['Launch site'] = []\n","launch_dict['Payload'] = []\n","launch_dict['Payload mass'] = []\n","launch_dict['Orbit'] = []\n","launch_dict['Customer'] = []\n","launch_dict['Launch outcome'] = []\n","# Added some new columns\n","launch_dict['Version booster']=[]\n","launch_dict['Booster landing']=[]\n","launch_dict['Date']=[]\n","launch_dict['Time']=[]"]},{"cell_type":"markdown","id":"132fda4c-66b9-4ffd-8716-a8e11ab666ac","metadata":{},"source":["Next, we just need to fill up the `launch_dict` with launch records extracted from table rows.\n"]},{"cell_type":"markdown","id":"f390337b-f7e9-4f19-a07e-ffd3c1585974","metadata":{},"source":["Usually, HTML tables in Wiki pages are likely to contain unexpected annotations and other types of noises, such as reference links `B0004.1[8]`, missing values `N/A [e]`, inconsistent formatting, etc.\n"]},{"cell_type":"markdown","id":"66e239d2-0d35-4f9c-b614-d92ac20d360d","metadata":{},"source":["To simplify the parsing process, we have provided an incomplete code snippet below to help you to fill up the `launch_dict`. Please complete the following code snippet with TODOs or you can choose to write your own logic to parse all launch tables:\n"]},{"cell_type":"code","execution_count":96,"id":"746e8516-ec12-4695-9a7d-062402ffd212","metadata":{},"outputs":[{"name":"stdout","output_type":"stream","text":["1\n","4 June 2010\n","18:45\n","F9 v1.0B0003.1\n","CCAFS\n","Dragon Spacecraft Qualification Unit\n","0\n","LEO\n","2\n","8 December 2010\n","15:43\n","F9 v1.0B0004.1\n","CCAFS\n","Dragon\n","0\n","LEO\n","3\n","22 May 2012\n","07:44\n","F9 v1.0B0005.1\n","CCAFS\n","Dragon\n","525 kg\n","LEO\n","4\n","8 October 2012\n","00:35\n","F9 v1.0B0006.1\n","CCAFS\n","SpaceX CRS-1\n","4,700 kg\n","LEO\n","5\n","1 March 2013\n","15:10\n","F9 v1.0B0007.1\n","CCAFS\n","SpaceX CRS-2\n","4,877 kg\n","LEO\n","6\n","29 September 2013\n","16:00\n","F9 v1.1B1003\n","VAFB\n","CASSIOPE\n","500 kg\n","Polar orbit\n","7\n","3 December 2013\n","22:41\n","F9 v1.1\n","CCAFS\n","SES-8\n","3,170 kg\n","GTO\n","8\n","6 January 2014\n","22:06\n","F9 v1.1\n","CCAFS\n","Thaicom 6\n","3,325 kg\n","GTO\n","9\n","18 April 2014\n","19:25\n","F9 v1.1\n","Cape Canaveral\n","SpaceX CRS-3\n","2,296 kg\n","LEO\n","10\n","14 July 2014\n","15:15\n","F9 v1.1\n","Cape Canaveral\n","Orbcomm-OG2\n","1,316 kg\n","LEO\n","11\n","5 August 2014\n","08:00\n","F9 v1.1\n","Cape Canaveral\n","AsiaSat 8\n","4,535 kg\n","GTO\n","12\n","7 September 2014\n","05:00\n","F9 v1.1\n","Cape Canaveral\n","AsiaSat 6\n","4,428 kg\n","GTO\n","13\n","21 September 2014\n","05:52\n","F9 v1.1\n","Cape Canaveral\n","SpaceX CRS-4\n","2,216 kg\n","LEO\n","14\n","10 January 2015\n","09:47\n","F9 v1.1\n","Cape Canaveral\n","SpaceX CRS-5\n","2,395 kg\n","LEO\n","15\n","11 February 2015\n","23:03\n","F9 v1.1\n","Cape Canaveral\n","DSCOVR\n","570 kg\n","HEO\n","16\n","2 March 2015\n","03:50\n","F9 v1.1\n","Cape Canaveral\n","ABS-3A\n","4,159 kg\n","GTO\n","17\n","14 April 2015\n","20:10\n","F9 v1.1\n","Cape Canaveral\n","SpaceX CRS-6\n","1,898 kg\n","LEO\n","18\n","27 April 2015\n","23:03\n","F9 v1.1\n","Cape Canaveral\n","TürkmenÄlem 52°E / MonacoSAT\n","4,707 kg\n","GTO\n","19\n","28 June 2015\n","14:21\n","F9 v1.1\n","Cape Canaveral\n","SpaceX CRS-7\n","1,952 kg\n","LEO\n","20\n","22 December 2015\n","01:29\n","F9 FT\n","Cape Canaveral\n","Orbcomm-OG2\n","2,034 kg\n","LEO\n","21\n","17 January 2016\n","18:42\n","F9 v1.1\n","VAFB\n","Jason-3\n","553 kg\n","LEO\n","22\n","4 March 2016\n","23:35\n","F9 FT\n","Cape Canaveral\n","SES-9\n","5,271 kg\n","GTO\n","23\n","8 April 2016\n","20:43\n","F9 FT\n","Cape Canaveral\n","SpaceX CRS-8\n","3,136 kg\n","LEO\n","24\n","6 May 2016\n","05:21\n","F9 FT\n","Cape Canaveral\n","JCSAT-14\n","4,696 kg\n","GTO\n","25\n","27 May 2016\n","21:39\n","F9 FT\n","Cape Canaveral\n","Thaicom 8\n","3,100 kg\n","GTO\n","26\n","15 June 2016\n","14:29\n","F9 FT\n","Cape Canaveral\n","ABS-2A\n","3,600 kg\n","GTO\n","27\n","18 July 2016\n","04:45\n","F9 FT\n","Cape Canaveral\n","SpaceX CRS-9\n","2,257 kg\n","LEO\n","28\n","14 August 2016\n","05:26\n","F9 FT\n","Cape Canaveral\n","JCSAT-16\n","4,600 kg\n","GTO\n","29\n","14 January 2017\n","17:54\n","F9 FT\n","VAFB\n","Iridium NEXT\n","9,600 kg\n","Polar\n","30\n","19 February 2017\n","14:39\n","F9 FT\n","KSC\n","SpaceX CRS-10\n","2,490 kg\n","LEO\n","31\n","16 March 2017\n","06:00\n","F9 FT\n","KSC\n","EchoStar 23\n","5,600 kg\n","GTO\n","32\n","30 March 2017\n","22:27\n","F9 FT♺\n","KSC\n","SES-10\n","5,300 kg\n","GTO\n","33\n","1 May 2017\n","11:15\n","F9 FT\n","KSC\n","NROL-76\n","C\n","LEO\n","34\n","15 May 2017\n","23:21\n","F9 FT\n","KSC\n","Inmarsat-5 F4\n","6,070 kg\n","GTO\n","35\n","3 June 2017\n","21:07\n","F9 FT\n","KSC\n","SpaceX CRS-11\n","2,708 kg\n","LEO\n","36\n","23 June 2017\n","19:10\n","F9 FTB1029.2\n","KSC\n","BulgariaSat-1\n","3,669 kg\n","GTO\n","37\n","25 June 2017\n","20:25\n","F9 FT\n","VAFB\n","Iridium NEXT\n","9,600 kg\n","LEO\n","38\n","5 July 2017\n","23:38\n","F9 FT\n","KSC\n","Intelsat 35e\n","6,761 kg\n","GTO\n","39\n","14 August 2017\n","16:31\n","F9 B4\n","KSC\n","SpaceX CRS-12\n","3,310 kg\n","LEO\n","40\n","24 August 2017\n","18:51\n","F9 FT\n","VAFB\n","Formosat-5\n","475 kg\n","SSO\n","41\n","7 September 2017\n","14:00\n","F9 B4\n","KSC\n","Boeing X-37B\n","4,990 kg\n","LEO\n","42\n","9 October 2017\n","12:37\n","F9 B4\n","VAFB\n","Iridium NEXT\n","9,600 kg\n","Polar\n","43\n","11 October 2017\n","22:53:00\n","F9 FTB1031.2\n","KSC\n","SES-11\n","5,200 kg\n","GTO\n","44\n","30 October 2017\n","19:34\n","F9 B4\n","KSC\n","Koreasat 5A\n","3,500 kg\n","GTO\n","45\n","15 December 2017\n","15:36\n","F9 FTB1035.2\n","Cape Canaveral\n","SpaceX CRS-13\n","2,205 kg\n","LEO\n","46\n","23 December 2017\n","01:27\n","F9 FTB1036.2\n","VAFB\n","Iridium NEXT\n","9,600 kg\n","Polar\n","47\n","8 January 2018\n","01:00\n","F9 B4\n","CCAFS\n","Zuma\n","C\n","LEO\n","48\n","31 January 2018\n","21:25\n","F9 FTB1032.2\n","CCAFS\n","GovSat-1\n","4,230 kg\n","GTO\n","49\n","22 February 2018\n","14:17\n","F9 FTB1038.2\n","VAFB\n","Paz\n","2,150 kg\n","SSO\n","50\n","6 March 2018\n","05:33\n","F9 B4\n","CCAFS\n","Hispasat 30W-6\n","6,092 kg\n","GTO\n","51\n","30 March 2018\n","14:14\n","F9 B4B1041.2\n","VAFB\n","Iridium NEXT\n","9,600 kg\n","Polar\n","52\n","2 April 2018\n","20:30\n","F9 B4B1039.2\n","CCAFS\n","SpaceX CRS-14\n","2,647 kg\n","LEO\n","53\n","18 April 2018\n","22:51\n","F9 B4\n","CCAFS\n","Transiting Exoplanet Survey Satellite\n","362 kg\n","HEO\n","54\n","11 May 2018\n","20:14\n","F9 B5B1046.1\n","KSC\n","Bangabandhu-1\n","3,600 kg\n","GTO\n","55\n","22 May 2018\n","19:47\n","F9 B4B1043.2\n","VAFB\n","Iridium NEXT\n","6,460 kg\n","Polar\n","56\n","4 June 2018\n","04:45\n","F9 B4B1040.2\n","CCAFS\n","SES-12\n","5,384 kg\n","GTO\n","57\n","29 June 2018\n","09:42\n","F9 B4B1045.2\n","CCAFS\n","SpaceX CRS-15\n","2,697 kg\n","LEO\n","58\n","22 July 2018\n","05:50\n","F9 B5\n","CCAFS\n","Telstar 19V\n","7,075 kg\n","GTO\n","59\n","25 July 2018\n","11:39\n","F9 B5B1048\n","VAFB\n","Iridium NEXT\n","9,600 kg\n","Polar\n","60\n","7 August 2018\n","05:18\n","F9 B5B1046.2\n","CCAFS\n","Merah Putih\n","5,800 kg\n","GTO\n","61\n","10 September 2018\n","04:45\n","F9 B5\n","CCAFS\n","Telstar 18V\n","7,060 kg\n","GTO\n","62\n","8 October 2018\n","02:22\n","F9 B5B1048.2\n","VAFB\n","SAOCOM 1A\n","3,000 kg\n","SSO\n","63\n","15 November 2018\n","20:46\n","F9 B5B1047.2\n","KSC\n","Es'hail 2\n","5,300 kg\n","GTO\n","64\n","3 December 2018\n","18:34:05\n","F9 B5B1046.3\n","VAFB\n","SSO-A\n","~4,000 kg\n","SSO\n","65\n","5 December 2018\n","18:16\n","F9 B5\n","CCAFS\n","SpaceX CRS-16\n","2,500 kg\n","LEO\n","66\n","23 December 2018\n","13:51\n","F9 B5\n","CCAFS\n","GPS III\n","4,400 kg\n","MEO\n","67\n","11 January 2019\n","15:31\n","F9 B5B1049.2\n","VAFB\n","Iridium NEXT\n","9,600 kg\n","Polar\n","68\n","22 February 2019\n","01:45\n","F9 B5B1048.3\n","CCAFS\n","Nusantara Satu\n","4,850 kg\n","GTO\n","69\n","2 March 2019\n","07:49\n","F9 B5[268]\n","KSC\n","Crew Dragon Demo-1\n","12,055 kg\n","LEO\n","70\n","4 May 2019\n","06:48\n","F9 B5\n","CCAFS\n","SpaceX CRS-17\n","2,495 kg\n","LEO\n","71\n","24 May 2019\n","02:30\n","F9 B5B1049.3\n","CCAFS\n","Starlink\n","13,620 kg\n","LEO\n","72\n","12 June 2019\n","14:17\n","F9 B5B1051.2\n","VAFB\n","RADARSAT Constellation\n","4,200 kg\n","SSO\n","73\n","25 July 2019\n","22:01\n","F9 B5B1056.2\n","CCAFS\n","SpaceX CRS-18\n","2,268 kg\n","LEO\n","74\n","6 August 2019\n","23:23\n","F9 B5B1047.3\n","CCAFS\n","AMOS-17\n","6,500 kg\n","GTO\n","75\n","11 November 2019\n","14:56\n","F9 B5\n","CCAFS\n","Starlink\n","15,600 kg\n","LEO\n","76\n","5 December 2019\n","17:29\n","F9 B5\n","CCAFS\n","SpaceX CRS-19\n","2,617 kg\n","LEO\n","77\n","17 December 2019\n","00:10\n","F9 B5B1056.3\n","CCAFS\n","JCSat-18\n","6,956 kg\n","GTO\n","78\n","7 January 2020\n","02:19:21\n","F9 B5\n","CCAFS\n","Starlink\n","15,600 kg\n","LEO\n","79\n","19 January 2020\n","15:30\n","F9 B5\n","KSC\n","Crew Dragon in-flight abort test\n","12,050 kg\n","Sub-orbital\n","80\n","29 January 2020\n","14:07\n","F9 B5\n","CCAFS\n","Starlink\n","15,600 kg\n","LEO\n","81\n","17 February 2020\n","15:05\n","F9 B5\n","CCAFS\n","Starlink\n","15,600 kg\n","LEO\n","82\n","7 March 2020\n","04:50\n","F9 B5\n","CCAFS\n","SpaceX CRS-20\n","1,977 kg\n","LEO\n","83\n","18 March 2020\n","12:16\n","F9 B5\n","KSC\n","Starlink\n","15,600 kg\n","LEO\n","84\n","22 April 2020\n","19:30\n","F9 B5\n","KSC\n","Starlink\n","15,600 kg\n","LEO\n","85\n","30 May 2020\n","19:22\n","F9 B5\n","KSC\n","Crew Dragon Demo-2\n","12,530 kg\n","LEO\n","86\n","4 June 2020\n","01:25\n","F9 B5\n","CCAFS\n","Starlink\n","15,600 kg\n","LEO\n","87\n","13 June 2020\n","09:21\n","F9 B5\n","CCAFS\n","Starlink\n","15,410 kg\n","LEO\n","88\n","30 June 2020\n","20:10:46\n","F9 B5\n","CCAFS\n","GPS III\n","4,311 kg\n","MEO\n","89\n","20 July 2020\n","21:30\n","F9 B5B1058.2\n","CCAFS\n","ANASIS-II\n","5,000–6,000 kg\n","GTO\n","90\n","7 August 2020\n","05:12\n","F9 B5\n","KSC\n","Starlink\n","14,932 kg\n","LEO\n","91\n","18 August 2020\n","14:31\n","F9 B5B1049.6\n","CCAFS\n","Starlink\n","~15,440 kg\n","LEO\n","92\n","30 August 2020\n","23:18\n","F9 B5\n","CCAFS\n","SAOCOM 1B\n","3,130 kg\n","SSO\n","93\n","3 September 2020\n","12:46:14\n","F9 B5B1060.2\n","KSC\n","Starlink\n","15,600 kg\n","LEO\n","94\n","6 October 2020\n","11:29:34\n","F9 B5B1058.3\n","KSC\n","Starlink\n","15,600 kg\n","LEO\n","95\n","18 October 2020\n","12:25:57\n","F9 B5B1051.6\n","KSC\n","Starlink\n","15,600 kg\n","LEO\n","96\n","24 October 2020\n","15:31:34\n","F9 B5\n","CCAFS\n","Starlink\n","15,600 kg\n","LEO\n","97\n","5 November 2020\n","23:24:23\n","F9 B5\n","CCAFS\n","GPS III\n","4,311 kg\n","MEO\n","98\n","16 November 2020\n","00:27\n","F9 B5\n","KSC\n","Crew-1\n","~12,500 kg\n","LEO\n","99\n","21 November 2020\n","17:17:08\n","F9 B5\n","VAFB\n","Sentinel-6 Michael Freilich (Jason-CS A)\n","1,192 kg\n","LEO\n","100\n","25 November 2020\n","02:13\n","F9 B5 ♺\n","CCAFS\n","Starlink\n","15,600 kg\n","LEO\n","101\n","6 December 2020\n","16:17:08\n","F9 B5 ♺\n","KSC\n","SpaceX CRS-21\n","2,972 kg\n","LEO\n","102\n","13 December 2020\n","17:30:00\n","F9 B5 ♺\n","CCSFS\n","SXM-7\n","7,000 kg\n","GTO\n","103\n","19 December 2020\n","14:00:00\n","F9 B5 ♺\n","KSC\n","NROL-108\n","C\n","LEO\n","104\n","8 January 2021\n","02:15\n","F9 B5\n","CCSFS\n","Türksat 5A\n","3,500 kg\n","GTO\n","105\n","20 January 2021\n","13:02\n","F9 B5B1051.8\n","KSC\n","Starlink\n","15,600 kg\n","LEO\n","106\n","24 January 2021\n","15:00\n","F9 B5B1058.5\n","CCSFS\n","Transporter-1\n","~5,000 kg\n","SSO\n","107\n","4 February 2021\n","06:19\n","F9 B5 ♺\n","CCSFS\n","Starlink\n","15,600 kg\n","LEO\n","108\n","16 February 2021\n","03:59:37\n","F9 B5 ♺\n","CCSFS\n","Starlink\n","15,600 kg\n","LEO\n","109\n","4 March 2021\n","08:24\n","F9 B5 ♺\n","KSC\n","Starlink\n","15,600 kg\n","LEO\n","110\n","11 March 2021\n","08:13:29\n","F9 B5 ♺\n","CCSFS\n","Starlink\n","15,600 kg\n","LEO\n","111\n","14 March 2021\n","10:01\n","F9 B5 ♺\n","KSC\n","Starlink\n","15,600 kg\n","LEO\n","112\n","24 March 2021\n","08:28\n","F9 B5B1060.6\n","CCSFS\n","Starlink\n","15,600 kg\n","LEO\n","113\n","7 April 2021\n","16:34\n","F9 B5 ♺\n","CCSFS\n","Starlink\n","15,600 kg\n","LEO\n","114\n","23 April 2021\n","9:49\n","F9 B5B1061.2\n","KSC\n","Crew-2\n","~13,000 kg\n","LEO\n","115\n","29 April 2021\n","03:44\n","F9 B5B1060.7\n","CCSFS\n","Starlink\n","15,600 kg\n","LEO\n","116\n","4 May 2021\n","19:01\n","F9 B5B1049.9\n","KSC\n","Starlink\n","15,600 kg\n","LEO\n","117\n","9 May 2021\n","06:42\n","F9 B5B1051.10\n","CCSFS\n","Starlink\n","15,600 kg\n","LEO\n","118\n","15 May 2021\n","22:56\n","F9 B5B1058.8\n","KSC\n","Starlink\n","~14,000 kg\n","LEO\n","119\n","26 May 2021\n","18:59\n","F9 B5B1063.2\n","CCSFS\n","Starlink\n","15,600 kg\n","LEO\n","120\n","3 June 2021\n","17:29\n","F9 B5B1067.1\n","KSC\n","SpaceX CRS-22\n","3,328 kg\n","LEO\n","121\n","6 June 2021\n","04:26\n","F9 B5\n","CCSFS\n","SXM-8\n","7,000 kg\n","GTO\n"]}],"source":["extracted_row = 0\n","#Extract each table \n","for table_number,table in enumerate(soup.find_all('table',\"wikitable plainrowheaders collapsible\")):\n","   # get table row \n","    for rows in table.find_all(\"tr\"):\n","        #check to see if first table heading is as number corresponding to launch a number \n","        if rows.th:\n","            if rows.th.string:\n","                flight_number=rows.th.string.strip()\n","                flag=flight_number.isdigit()\n","        else:\n","            flag=False\n","        #get table element \n","        row=rows.find_all('td')\n","        #if it is number save cells in a dictonary \n","        if flag:\n","            extracted_row += 1\n","            # Flight Number value\n","            # TODO: Append the flight_number into launch_dict with key `Flight No.`\n","            launch_dict['Flight No.'].append(flight_number)\n","            #launch_dict['Flight No.'] = flight_number\n","            print(flight_number)\n","            datatimelist=date_time(row[0])\n","            \n","            # Date value\n","            # TODO: Append the date into launch_dict with key `Date`\n","            date = datatimelist[0].strip(',')\n","            launch_dict['Date'].append(date)\n","            print(date)\n","            \n","            # Time value\n","            # TODO: Append the time into launch_dict with key `Time`\n","            time = datatimelist[1]\n","            launch_dict['Time'].append(time)\n","            print(time)\n","              \n","            # Booster version\n","            # TODO: Append the bv into launch_dict with key `Version booster`\n","            bv=booster_version(row[1])\n","            if not(bv):\n","                bv=row[1].a.string\n","            #print(bv)\n","            launch_dict['Version booster'].append(bv)\n","            print(bv)\n","            \n","            # Launch Site\n","            # TODO: Append the bv into launch_dict with key `Launch site`\n","            launch_site = row[2].a.string\n","            launch_dict['Launch site'].append(launch_site)\n","            print(launch_site)\n","            \n","            # Payload\n","            # TODO: Append the payload into launch_dict with key `Payload`\n","            payload = row[3].a.string\n","            launch_dict['Payload'].append(payload)\n","            print(payload)\n","            \n","            # Payload Mass\n","            # TODO: Append the payload_mass into launch_dict with key `Payload mass`\n","            payload_mass = get_mass(row[4])\n","            launch_dict['Payload mass'].append(payload_mass)\n","            print(payload_mass)\n","            \n","            # Orbit\n","            # TODO: Append the orbit into launch_dict with key `Orbit`\n","            orbit = row[5].a.string\n","            launch_dict['Orbit'].append(orbit) \n","            print(orbit)\n","            \n","            # Customer\n","            # TODO: Append the customer into launch_dict with key `Customer`\n","            customer = row[6].text.strip()\n","            launch_dict['Customer'].append(customer)\n","            #print(customer)\n","            \n","            #customer = 'Various'\n","            #if len(row) > 6 and row[6].a:\n","            #    customer = row[6].a.string\n","            #    launch_dict['Customer'] = customer\n","            #print(customer)\n","\n","            # Launch outcome\n","            # TODO: Append the launch_outcome into launch_dict with key `Launch outcome`\n","            launch_outcome = list(row[7].strings)[0]\n","            launch_dict['Launch outcome'].append(launch_outcome)\n","            #print(launch_outcome)\n","            \n","            # Booster landing\n","            # TODO: Append the launch_outcome into launch_dict with key `Booster landing`\n","            booster_landing = landing_status(row[8])\n","            launch_dict['Booster landing'].append(booster_landing)\n","            #print(booster_landing)\n","\n","            \n","            "]},{"cell_type":"code","execution_count":97,"metadata":{},"outputs":[{"data":{"text/plain":["{'Flight No.': ['1',\n","  '2',\n","  '3',\n","  '4',\n","  '5',\n","  '6',\n","  '7',\n","  '8',\n","  '9',\n","  '10',\n","  '11',\n","  '12',\n","  '13',\n","  '14',\n","  '15',\n","  '16',\n","  '17',\n","  '18',\n","  '19',\n","  '20',\n","  '21',\n","  '22',\n","  '23',\n","  '24',\n","  '25',\n","  '26',\n","  '27',\n","  '28',\n","  '29',\n","  '30',\n","  '31',\n","  '32',\n","  '33',\n","  '34',\n","  '35',\n","  '36',\n","  '37',\n","  '38',\n","  '39',\n","  '40',\n","  '41',\n","  '42',\n","  '43',\n","  '44',\n","  '45',\n","  '46',\n","  '47',\n","  '48',\n","  '49',\n","  '50',\n","  '51',\n","  '52',\n","  '53',\n","  '54',\n","  '55',\n","  '56',\n","  '57',\n","  '58',\n","  '59',\n","  '60',\n","  '61',\n","  '62',\n","  '63',\n","  '64',\n","  '65',\n","  '66',\n","  '67',\n","  '68',\n","  '69',\n","  '70',\n","  '71',\n","  '72',\n","  '73',\n","  '74',\n","  '75',\n","  '76',\n","  '77',\n","  '78',\n","  '79',\n","  '80',\n","  '81',\n","  '82',\n","  '83',\n","  '84',\n","  '85',\n","  '86',\n","  '87',\n","  '88',\n","  '89',\n","  '90',\n","  '91',\n","  '92',\n","  '93',\n","  '94',\n","  '95',\n","  '96',\n","  '97',\n","  '98',\n","  '99',\n","  '100',\n","  '101',\n","  '102',\n","  '103',\n","  '104',\n","  '105',\n","  '106',\n","  '107',\n","  '108',\n","  '109',\n","  '110',\n","  '111',\n","  '112',\n","  '113',\n","  '114',\n","  '115',\n","  '116',\n","  '117',\n","  '118',\n","  '119',\n","  '120',\n","  '121'],\n"," 'Launch site': ['CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'VAFB',\n","  'CCAFS',\n","  'CCAFS',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'VAFB',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'Cape Canaveral',\n","  'VAFB',\n","  'KSC',\n","  'KSC',\n","  'KSC',\n","  'KSC',\n","  'KSC',\n","  'KSC',\n","  'KSC',\n","  'VAFB',\n","  'KSC',\n","  'KSC',\n","  'VAFB',\n","  'KSC',\n","  'VAFB',\n","  'KSC',\n","  'KSC',\n","  'Cape Canaveral',\n","  'VAFB',\n","  'CCAFS',\n","  'CCAFS',\n","  'VAFB',\n","  'CCAFS',\n","  'VAFB',\n","  'CCAFS',\n","  'CCAFS',\n","  'KSC',\n","  'VAFB',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'VAFB',\n","  'CCAFS',\n","  'CCAFS',\n","  'VAFB',\n","  'KSC',\n","  'VAFB',\n","  'CCAFS',\n","  'CCAFS',\n","  'VAFB',\n","  'CCAFS',\n","  'KSC',\n","  'CCAFS',\n","  'CCAFS',\n","  'VAFB',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'KSC',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'KSC',\n","  'KSC',\n","  'KSC',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'CCAFS',\n","  'KSC',\n","  'CCAFS',\n","  'CCAFS',\n","  'KSC',\n","  'KSC',\n","  'KSC',\n","  'CCAFS',\n","  'CCAFS',\n","  'KSC',\n","  'VAFB',\n","  'CCAFS',\n","  'KSC',\n","  'CCSFS',\n","  'KSC',\n","  'CCSFS',\n","  'KSC',\n","  'CCSFS',\n","  'CCSFS',\n","  'CCSFS',\n","  'KSC',\n","  'CCSFS',\n","  'KSC',\n","  'CCSFS',\n","  'CCSFS',\n","  'KSC',\n","  'CCSFS',\n","  'KSC',\n","  'CCSFS',\n","  'KSC',\n","  'CCSFS',\n","  'KSC',\n","  'CCSFS'],\n"," 'Payload': ['Dragon Spacecraft Qualification Unit',\n","  'Dragon',\n","  'Dragon',\n","  'SpaceX CRS-1',\n","  'SpaceX CRS-2',\n","  'CASSIOPE',\n","  'SES-8',\n","  'Thaicom 6',\n","  'SpaceX CRS-3',\n","  'Orbcomm-OG2',\n","  'AsiaSat 8',\n","  'AsiaSat 6',\n","  'SpaceX CRS-4',\n","  'SpaceX CRS-5',\n","  'DSCOVR',\n","  'ABS-3A',\n","  'SpaceX CRS-6',\n","  'TürkmenÄlem 52°E / MonacoSAT',\n","  'SpaceX CRS-7',\n","  'Orbcomm-OG2',\n","  'Jason-3',\n","  'SES-9',\n","  'SpaceX CRS-8',\n","  'JCSAT-14',\n","  'Thaicom 8',\n","  'ABS-2A',\n","  'SpaceX CRS-9',\n","  'JCSAT-16',\n","  'Iridium NEXT',\n","  'SpaceX CRS-10',\n","  'EchoStar 23',\n","  'SES-10',\n","  'NROL-76',\n","  'Inmarsat-5 F4',\n","  'SpaceX CRS-11',\n","  'BulgariaSat-1',\n","  'Iridium NEXT',\n","  'Intelsat 35e',\n","  'SpaceX CRS-12',\n","  'Formosat-5',\n","  'Boeing X-37B',\n","  'Iridium NEXT',\n","  'SES-11',\n","  'Koreasat 5A',\n","  'SpaceX CRS-13',\n","  'Iridium NEXT',\n","  'Zuma',\n","  'GovSat-1',\n","  'Paz',\n","  'Hispasat 30W-6',\n","  'Iridium NEXT',\n","  'SpaceX CRS-14',\n","  'Transiting Exoplanet Survey Satellite',\n","  'Bangabandhu-1',\n","  'Iridium NEXT',\n","  'SES-12',\n","  'SpaceX CRS-15',\n","  'Telstar 19V',\n","  'Iridium NEXT',\n","  'Merah Putih',\n","  'Telstar 18V',\n","  'SAOCOM 1A',\n","  \"Es'hail 2\",\n","  'SSO-A',\n","  'SpaceX CRS-16',\n","  'GPS III',\n","  'Iridium NEXT',\n","  'Nusantara Satu',\n","  'Crew Dragon Demo-1',\n","  'SpaceX CRS-17',\n","  'Starlink',\n","  'RADARSAT Constellation',\n","  'SpaceX CRS-18',\n","  'AMOS-17',\n","  'Starlink',\n","  'SpaceX CRS-19',\n","  'JCSat-18',\n","  'Starlink',\n","  'Crew Dragon in-flight abort test',\n","  'Starlink',\n","  'Starlink',\n","  'SpaceX CRS-20',\n","  'Starlink',\n","  'Starlink',\n","  'Crew Dragon Demo-2',\n","  'Starlink',\n","  'Starlink',\n","  'GPS III',\n","  'ANASIS-II',\n","  'Starlink',\n","  'Starlink',\n","  'SAOCOM 1B',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'GPS III',\n","  'Crew-1',\n","  'Sentinel-6 Michael Freilich (Jason-CS A)',\n","  'Starlink',\n","  'SpaceX CRS-21',\n","  'SXM-7',\n","  'NROL-108',\n","  'Türksat 5A',\n","  'Starlink',\n","  'Transporter-1',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'Crew-2',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'Starlink',\n","  'SpaceX CRS-22',\n","  'SXM-8'],\n"," 'Payload mass': [0,\n","  0,\n","  '525 kg',\n","  '4,700 kg',\n","  '4,877 kg',\n","  '500 kg',\n","  '3,170 kg',\n","  '3,325 kg',\n","  '2,296 kg',\n","  '1,316 kg',\n","  '4,535 kg',\n","  '4,428 kg',\n","  '2,216 kg',\n","  '2,395 kg',\n","  '570 kg',\n","  '4,159 kg',\n","  '1,898 kg',\n","  '4,707 kg',\n","  '1,952 kg',\n","  '2,034 kg',\n","  '553 kg',\n","  '5,271 kg',\n","  '3,136 kg',\n","  '4,696 kg',\n","  '3,100 kg',\n","  '3,600 kg',\n","  '2,257 kg',\n","  '4,600 kg',\n","  '9,600 kg',\n","  '2,490 kg',\n","  '5,600 kg',\n","  '5,300 kg',\n","  'C',\n","  '6,070 kg',\n","  '2,708 kg',\n","  '3,669 kg',\n","  '9,600 kg',\n","  '6,761 kg',\n","  '3,310 kg',\n","  '475 kg',\n","  '4,990 kg',\n","  '9,600 kg',\n","  '5,200 kg',\n","  '3,500 kg',\n","  '2,205 kg',\n","  '9,600 kg',\n","  'C',\n","  '4,230 kg',\n","  '2,150 kg',\n","  '6,092 kg',\n","  '9,600 kg',\n","  '2,647 kg',\n","  '362 kg',\n","  '3,600 kg',\n","  '6,460 kg',\n","  '5,384 kg',\n","  '2,697 kg',\n","  '7,075 kg',\n","  '9,600 kg',\n","  '5,800 kg',\n","  '7,060 kg',\n","  '3,000 kg',\n","  '5,300 kg',\n","  '~4,000 kg',\n","  '2,500 kg',\n","  '4,400 kg',\n","  '9,600 kg',\n","  '4,850 kg',\n","  '12,055 kg',\n","  '2,495 kg',\n","  '13,620 kg',\n","  '4,200 kg',\n","  '2,268 kg',\n","  '6,500 kg',\n","  '15,600 kg',\n","  '2,617 kg',\n","  '6,956 kg',\n","  '15,600 kg',\n","  '12,050 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '1,977 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '12,530 kg',\n","  '15,600 kg',\n","  '15,410 kg',\n","  '4,311 kg',\n","  '5,000–6,000 kg',\n","  '14,932 kg',\n","  '~15,440 kg',\n","  '3,130 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '4,311 kg',\n","  '~12,500 kg',\n","  '1,192 kg',\n","  '15,600 kg',\n","  '2,972 kg',\n","  '7,000 kg',\n","  'C',\n","  '3,500 kg',\n","  '15,600 kg',\n","  '~5,000 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '~13,000 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '15,600 kg',\n","  '~14,000 kg',\n","  '15,600 kg',\n","  '3,328 kg',\n","  '7,000 kg'],\n"," 'Orbit': ['LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'Polar orbit',\n","  'GTO',\n","  'GTO',\n","  'LEO',\n","  'LEO',\n","  'GTO',\n","  'GTO',\n","  'LEO',\n","  'LEO',\n","  'HEO',\n","  'GTO',\n","  'LEO',\n","  'GTO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'GTO',\n","  'LEO',\n","  'GTO',\n","  'GTO',\n","  'GTO',\n","  'LEO',\n","  'GTO',\n","  'Polar',\n","  'LEO',\n","  'GTO',\n","  'GTO',\n","  'LEO',\n","  'GTO',\n","  'LEO',\n","  'GTO',\n","  'LEO',\n","  'GTO',\n","  'LEO',\n","  'SSO',\n","  'LEO',\n","  'Polar',\n","  'GTO',\n","  'GTO',\n","  'LEO',\n","  'Polar',\n","  'LEO',\n","  'GTO',\n","  'SSO',\n","  'GTO',\n","  'Polar',\n","  'LEO',\n","  'HEO',\n","  'GTO',\n","  'Polar',\n","  'GTO',\n","  'LEO',\n","  'GTO',\n","  'Polar',\n","  'GTO',\n","  'GTO',\n","  'SSO',\n","  'GTO',\n","  'SSO',\n","  'LEO',\n","  'MEO',\n","  'Polar',\n","  'GTO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'SSO',\n","  'LEO',\n","  'GTO',\n","  'LEO',\n","  'LEO',\n","  'GTO',\n","  'LEO',\n","  'Sub-orbital',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'MEO',\n","  'GTO',\n","  'LEO',\n","  'LEO',\n","  'SSO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'MEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'GTO',\n","  'LEO',\n","  'GTO',\n","  'LEO',\n","  'SSO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'LEO',\n","  'GTO'],\n"," 'Customer': ['SpaceX',\n","  'NASA (COTS)\\nNRO',\n","  'NASA (COTS)',\n","  'NASA (CRS)',\n","  'NASA (CRS)',\n","  'MDA',\n","  'SES',\n","  'Thaicom',\n","  'NASA (CRS)',\n","  'Orbcomm',\n","  'AsiaSat',\n","  'AsiaSat',\n","  'NASA (CRS)',\n","  'NASA (CRS)',\n","  'USAF\\nNASA\\nNOAA',\n","  'ABS\\nEutelsat',\n","  'NASA (CRS)',\n","  'Turkmenistan NationalSpace Agency[88]',\n","  'NASA (CRS)',\n","  'Orbcomm',\n","  'NASA (LSP)\\nNOAA\\nCNES',\n","  'SES',\n","  'NASA (CRS)',\n","  'SKY Perfect JSAT Group',\n","  'Thaicom',\n","  'ABS\\nEutelsat',\n","  'NASA (CRS)',\n","  'SKY Perfect JSAT Group',\n","  'Iridium Communications',\n","  'NASA (CRS)',\n","  'EchoStar',\n","  'SES',\n","  'NRO',\n","  'Inmarsat',\n","  'NASA (CRS)',\n","  'Bulsatcom',\n","  'Iridium Communications',\n","  'Intelsat',\n","  'NASA (CRS)',\n","  'NSPO',\n","  'USAF',\n","  'Iridium Communications',\n","  'SES S.A.\\nEchoStar',\n","  'KT Corporation',\n","  'NASA (CRS)',\n","  'Iridium Communications',\n","  'Northrop Grumman [f][238]',\n","  'SES',\n","  'Hisdesat\\nexactEarth\\nSpaceX',\n","  'Hispasat[277]\\nNovaWurks',\n","  'Iridium Communications',\n","  'NASA (CRS)',\n","  'NASA (LSP)',\n","  'Thales-Alenia / BTRC',\n","  'Iridium Communications\\nGFZ\\xa0• NASA',\n","  'SES',\n","  'NASA (CRS)',\n","  'Telesat',\n","  'Iridium Communications',\n","  'Telkom Indonesia',\n","  'Telesat',\n","  'CONAE',\n","  \"Es'hailSat\",\n","  'Spaceflight Industries',\n","  'NASA (CRS)',\n","  'USAF',\n","  'Iridium Communications',\n","  'PSN\\nSpaceIL / IAI\\nAir Force Research',\n","  'NASA (CCD)',\n","  'NASA (CRS)',\n","  'SpaceX',\n","  'Canadian Space Agency (CSA)',\n","  'NASA (CRS)',\n","  'Spacecom',\n","  'SpaceX',\n","  'NASA (CRS)',\n","  'Sky Perfect JSATKacific 1',\n","  'SpaceX',\n","  'NASA (CTS)[497]',\n","  'SpaceX',\n","  'SpaceX',\n","  'NASA (CRS)',\n","  'SpaceX',\n","  'SpaceX',\n","  'NASA (CCDev)',\n","  'SpaceX',\n","  'SpaceXPlanet Labs',\n","  'U.S. Space Force[530]',\n","  'Republic of Korea Army',\n","  'SpaceXSpaceflight Industries (BlackSky)',\n","  'SpaceXPlanet Labs',\n","  'CONAEPlanetIQTyvak',\n","  'SpaceX',\n","  'SpaceX',\n","  'SpaceX',\n","  'SpaceX',\n","  'USSF',\n","  'NASA (CCP)[497]',\n","  'NASA / NOAA / ESA / EUMETSAT',\n","  'SpaceX',\n","  'NASA (CRS)',\n","  'Sirius XM',\n","  'NRO',\n","  'Türksat',\n","  'SpaceX',\n","  'Various',\n","  'SpaceX',\n","  'SpaceX',\n","  'SpaceX',\n","  'SpaceX',\n","  'SpaceX',\n","  'SpaceX',\n","  'SpaceX',\n","  'NASA (CTS)[497]',\n","  'SpaceX',\n","  'SpaceX',\n","  'SpaceX',\n","  'SpaceX Capella Space and Tyvak',\n","  'SpaceX',\n","  'NASA (CRS)',\n","  'Sirius XM'],\n"," 'Launch outcome': ['Success\\n',\n","  'Success',\n","  'Success',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success\\n',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Failure',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success\\n',\n","  'Success',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n',\n","  'Success\\n'],\n"," 'Version booster': ['F9 v1.0B0003.1',\n","  'F9 v1.0B0004.1',\n","  'F9 v1.0B0005.1',\n","  'F9 v1.0B0006.1',\n","  'F9 v1.0B0007.1',\n","  'F9 v1.1B1003',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 v1.1',\n","  'F9 FT',\n","  'F9 v1.1',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT♺',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 FTB1029.2',\n","  'F9 FT',\n","  'F9 FT',\n","  'F9 B4',\n","  'F9 FT',\n","  'F9 B4',\n","  'F9 B4',\n","  'F9 FTB1031.2',\n","  'F9 B4',\n","  'F9 FTB1035.2',\n","  'F9 FTB1036.2',\n","  'F9 B4',\n","  'F9 FTB1032.2',\n","  'F9 FTB1038.2',\n","  'F9 B4',\n","  'F9 B4B1041.2',\n","  'F9 B4B1039.2',\n","  'F9 B4',\n","  'F9 B5B1046.1',\n","  'F9 B4B1043.2',\n","  'F9 B4B1040.2',\n","  'F9 B4B1045.2',\n","  'F9 B5',\n","  'F9 B5B1048',\n","  'F9 B5B1046.2',\n","  'F9 B5',\n","  'F9 B5B1048.2',\n","  'F9 B5B1047.2',\n","  'F9 B5B1046.3',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5B1049.2',\n","  'F9 B5B1048.3',\n","  'F9 B5[268]',\n","  'F9 B5',\n","  'F9 B5B1049.3',\n","  'F9 B5B1051.2',\n","  'F9 B5B1056.2',\n","  'F9 B5B1047.3',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5B1056.3',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5B1058.2',\n","  'F9 B5',\n","  'F9 B5B1049.6',\n","  'F9 B5',\n","  'F9 B5B1060.2',\n","  'F9 B5B1058.3',\n","  'F9 B5B1051.6',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5',\n","  'F9 B5 ♺',\n","  'F9 B5 ♺',\n","  'F9 B5 ♺',\n","  'F9 B5 ♺',\n","  'F9 B5',\n","  'F9 B5B1051.8',\n","  'F9 B5B1058.5',\n","  'F9 B5 ♺',\n","  'F9 B5 ♺',\n","  'F9 B5 ♺',\n","  'F9 B5 ♺',\n","  'F9 B5 ♺',\n","  'F9 B5B1060.6',\n","  'F9 B5 ♺',\n","  'F9 B5B1061.2',\n","  'F9 B5B1060.7',\n","  'F9 B5B1049.9',\n","  'F9 B5B1051.10',\n","  'F9 B5B1058.8',\n","  'F9 B5B1063.2',\n","  'F9 B5B1067.1',\n","  'F9 B5'],\n"," 'Booster landing': ['Failure',\n","  'Failure',\n","  'No attempt\\n',\n","  'No attempt',\n","  'No attempt\\n',\n","  'Uncontrolled',\n","  'No attempt',\n","  'No attempt',\n","  'Controlled',\n","  'Controlled',\n","  'No attempt',\n","  'No attempt\\n',\n","  'Uncontrolled',\n","  'Failure ',\n","  'Controlled',\n","  'No attempt',\n","  'Failure',\n","  'No attempt',\n","  'Precluded',\n","  'Success',\n","  'Failure',\n","  'Failure',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Failure',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'No attempt',\n","  'Success',\n","  'Success',\n","  'No attempt',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'No attempt',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Controlled',\n","  'Success',\n","  'Controlled',\n","  'No attempt',\n","  'No attempt',\n","  'No attempt',\n","  'No attempt',\n","  'Success',\n","  'Success',\n","  'No attempt',\n","  'No attempt',\n","  'No attempt',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Failure',\n","  'No attempt',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'No attempt',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'No attempt\\n',\n","  'Success',\n","  'Failure',\n","  'Success',\n","  'Failure',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Failure',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success',\n","  'Success'],\n"," 'Date': ['4 June 2010',\n","  '8 December 2010',\n","  '22 May 2012',\n","  '8 October 2012',\n","  '1 March 2013',\n","  '29 September 2013',\n","  '3 December 2013',\n","  '6 January 2014',\n","  '18 April 2014',\n","  '14 July 2014',\n","  '5 August 2014',\n","  '7 September 2014',\n","  '21 September 2014',\n","  '10 January 2015',\n","  '11 February 2015',\n","  '2 March 2015',\n","  '14 April 2015',\n","  '27 April 2015',\n","  '28 June 2015',\n","  '22 December 2015',\n","  '17 January 2016',\n","  '4 March 2016',\n","  '8 April 2016',\n","  '6 May 2016',\n","  '27 May 2016',\n","  '15 June 2016',\n","  '18 July 2016',\n","  '14 August 2016',\n","  '14 January 2017',\n","  '19 February 2017',\n","  '16 March 2017',\n","  '30 March 2017',\n","  '1 May 2017',\n","  '15 May 2017',\n","  '3 June 2017',\n","  '23 June 2017',\n","  '25 June 2017',\n","  '5 July 2017',\n","  '14 August 2017',\n","  '24 August 2017',\n","  '7 September 2017',\n","  '9 October 2017',\n","  '11 October 2017',\n","  '30 October 2017',\n","  '15 December 2017',\n","  '23 December 2017',\n","  '8 January 2018',\n","  '31 January 2018',\n","  '22 February 2018',\n","  '6 March 2018',\n","  '30 March 2018',\n","  '2 April 2018',\n","  '18 April 2018',\n","  '11 May 2018',\n","  '22 May 2018',\n","  '4 June 2018',\n","  '29 June 2018',\n","  '22 July 2018',\n","  '25 July 2018',\n","  '7 August 2018',\n","  '10 September 2018',\n","  '8 October 2018',\n","  '15 November 2018',\n","  '3 December 2018',\n","  '5 December 2018',\n","  '23 December 2018',\n","  '11 January 2019',\n","  '22 February 2019',\n","  '2 March 2019',\n","  '4 May 2019',\n","  '24 May 2019',\n","  '12 June 2019',\n","  '25 July 2019',\n","  '6 August 2019',\n","  '11 November 2019',\n","  '5 December 2019',\n","  '17 December 2019',\n","  '7 January 2020',\n","  '19 January 2020',\n","  '29 January 2020',\n","  '17 February 2020',\n","  '7 March 2020',\n","  '18 March 2020',\n","  '22 April 2020',\n","  '30 May 2020',\n","  '4 June 2020',\n","  '13 June 2020',\n","  '30 June 2020',\n","  '20 July 2020',\n","  '7 August 2020',\n","  '18 August 2020',\n","  '30 August 2020',\n","  '3 September 2020',\n","  '6 October 2020',\n","  '18 October 2020',\n","  '24 October 2020',\n","  '5 November 2020',\n","  '16 November 2020',\n","  '21 November 2020',\n","  '25 November 2020',\n","  '6 December 2020',\n","  '13 December 2020',\n","  '19 December 2020',\n","  '8 January 2021',\n","  '20 January 2021',\n","  '24 January 2021',\n","  '4 February 2021',\n","  '16 February 2021',\n","  '4 March 2021',\n","  '11 March 2021',\n","  '14 March 2021',\n","  '24 March 2021',\n","  '7 April 2021',\n","  '23 April 2021',\n","  '29 April 2021',\n","  '4 May 2021',\n","  '9 May 2021',\n","  '15 May 2021',\n","  '26 May 2021',\n","  '3 June 2021',\n","  '6 June 2021'],\n"," 'Time': ['18:45',\n","  '15:43',\n","  '07:44',\n","  '00:35',\n","  '15:10',\n","  '16:00',\n","  '22:41',\n","  '22:06',\n","  '19:25',\n","  '15:15',\n","  '08:00',\n","  '05:00',\n","  '05:52',\n","  '09:47',\n","  '23:03',\n","  '03:50',\n","  '20:10',\n","  '23:03',\n","  '14:21',\n","  '01:29',\n","  '18:42',\n","  '23:35',\n","  '20:43',\n","  '05:21',\n","  '21:39',\n","  '14:29',\n","  '04:45',\n","  '05:26',\n","  '17:54',\n","  '14:39',\n","  '06:00',\n","  '22:27',\n","  '11:15',\n","  '23:21',\n","  '21:07',\n","  '19:10',\n","  '20:25',\n","  '23:38',\n","  '16:31',\n","  '18:51',\n","  '14:00',\n","  '12:37',\n","  '22:53:00',\n","  '19:34',\n","  '15:36',\n","  '01:27',\n","  '01:00',\n","  '21:25',\n","  '14:17',\n","  '05:33',\n","  '14:14',\n","  '20:30',\n","  '22:51',\n","  '20:14',\n","  '19:47',\n","  '04:45',\n","  '09:42',\n","  '05:50',\n","  '11:39',\n","  '05:18',\n","  '04:45',\n","  '02:22',\n","  '20:46',\n","  '18:34:05',\n","  '18:16',\n","  '13:51',\n","  '15:31',\n","  '01:45',\n","  '07:49',\n","  '06:48',\n","  '02:30',\n","  '14:17',\n","  '22:01',\n","  '23:23',\n","  '14:56',\n","  '17:29',\n","  '00:10',\n","  '02:19:21',\n","  '15:30',\n","  '14:07',\n","  '15:05',\n","  '04:50',\n","  '12:16',\n","  '19:30',\n","  '19:22',\n","  '01:25',\n","  '09:21',\n","  '20:10:46',\n","  '21:30',\n","  '05:12',\n","  '14:31',\n","  '23:18',\n","  '12:46:14',\n","  '11:29:34',\n","  '12:25:57',\n","  '15:31:34',\n","  '23:24:23',\n","  '00:27',\n","  '17:17:08',\n","  '02:13',\n","  '16:17:08',\n","  '17:30:00',\n","  '14:00:00',\n","  '02:15',\n","  '13:02',\n","  '15:00',\n","  '06:19',\n","  '03:59:37',\n","  '08:24',\n","  '08:13:29',\n","  '10:01',\n","  '08:28',\n","  '16:34',\n","  '9:49',\n","  '03:44',\n","  '19:01',\n","  '06:42',\n","  '22:56',\n","  '18:59',\n","  '17:29',\n","  '04:26']}"]},"execution_count":97,"metadata":{},"output_type":"execute_result"}],"source":["launch_dict"]},{"cell_type":"markdown","id":"efbe10b6-f06d-46d2-8a3e-a8a429008d0d","metadata":{},"source":["After you have fill in the parsed launch record values into `launch_dict`, you can create a dataframe from it.\n"]},{"cell_type":"code","execution_count":98,"id":"959c9d53-80e0-4ebb-9146-8aad02ceb63a","metadata":{},"outputs":[],"source":["df= pd.DataFrame({ key:pd.Series(value) for key, value in launch_dict.items() })"]},{"cell_type":"code","execution_count":103,"metadata":{},"outputs":[{"data":{"text/plain":["Flight No.                     106\n","Launch site                  CCSFS\n","Payload              Transporter-1\n","Payload mass             ~5,000 kg\n","Orbit                          SSO\n","Customer                   Various\n","Launch outcome           Success\\n\n","Version booster       F9 B5B1058.5\n","Booster landing            Success\n","Date               24 January 2021\n","Time                         15:00\n","Name: 105, dtype: object"]},"execution_count":103,"metadata":{},"output_type":"execute_result"}],"source":["specific_row = df.iloc[105]\n","specific_row"]},{"cell_type":"code","execution_count":104,"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>Flight No.</th>\n","      <th>Launch site</th>\n","      <th>Payload</th>\n","      <th>Payload mass</th>\n","      <th>Orbit</th>\n","      <th>Customer</th>\n","      <th>Launch outcome</th>\n","      <th>Version booster</th>\n","      <th>Booster landing</th>\n","      <th>Date</th>\n","      <th>Time</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>CCAFS</td>\n","      <td>Dragon Spacecraft Qualification Unit</td>\n","      <td>0</td>\n","      <td>LEO</td>\n","      <td>SpaceX</td>\n","      <td>Success\\n</td>\n","      <td>F9 v1.0B0003.1</td>\n","      <td>Failure</td>\n","      <td>4 June 2010</td>\n","      <td>18:45</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>CCAFS</td>\n","      <td>Dragon</td>\n","      <td>0</td>\n","      <td>LEO</td>\n","      <td>NASA (COTS)\\nNRO</td>\n","      <td>Success</td>\n","      <td>F9 v1.0B0004.1</td>\n","      <td>Failure</td>\n","      <td>8 December 2010</td>\n","      <td>15:43</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3</td>\n","      <td>CCAFS</td>\n","      <td>Dragon</td>\n","      <td>525 kg</td>\n","      <td>LEO</td>\n","      <td>NASA (COTS)</td>\n","      <td>Success</td>\n","      <td>F9 v1.0B0005.1</td>\n","      <td>No attempt\\n</td>\n","      <td>22 May 2012</td>\n","      <td>07:44</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4</td>\n","      <td>CCAFS</td>\n","      <td>SpaceX CRS-1</td>\n","      <td>4,700 kg</td>\n","      <td>LEO</td>\n","      <td>NASA (CRS)</td>\n","      <td>Success\\n</td>\n","      <td>F9 v1.0B0006.1</td>\n","      <td>No attempt</td>\n","      <td>8 October 2012</td>\n","      <td>00:35</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5</td>\n","      <td>CCAFS</td>\n","      <td>SpaceX CRS-2</td>\n","      <td>4,877 kg</td>\n","      <td>LEO</td>\n","      <td>NASA (CRS)</td>\n","      <td>Success\\n</td>\n","      <td>F9 v1.0B0007.1</td>\n","      <td>No attempt\\n</td>\n","      <td>1 March 2013</td>\n","      <td>15:10</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>116</th>\n","      <td>117</td>\n","      <td>CCSFS</td>\n","      <td>Starlink</td>\n","      <td>15,600 kg</td>\n","      <td>LEO</td>\n","      <td>SpaceX</td>\n","      <td>Success\\n</td>\n","      <td>F9 B5B1051.10</td>\n","      <td>Success</td>\n","      <td>9 May 2021</td>\n","      <td>06:42</td>\n","    </tr>\n","    <tr>\n","      <th>117</th>\n","      <td>118</td>\n","      <td>KSC</td>\n","      <td>Starlink</td>\n","      <td>~14,000 kg</td>\n","      <td>LEO</td>\n","      <td>SpaceX Capella Space and Tyvak</td>\n","      <td>Success\\n</td>\n","      <td>F9 B5B1058.8</td>\n","      <td>Success</td>\n","      <td>15 May 2021</td>\n","      <td>22:56</td>\n","    </tr>\n","    <tr>\n","      <th>118</th>\n","      <td>119</td>\n","      <td>CCSFS</td>\n","      <td>Starlink</td>\n","      <td>15,600 kg</td>\n","      <td>LEO</td>\n","      <td>SpaceX</td>\n","      <td>Success\\n</td>\n","      <td>F9 B5B1063.2</td>\n","      <td>Success</td>\n","      <td>26 May 2021</td>\n","      <td>18:59</td>\n","    </tr>\n","    <tr>\n","      <th>119</th>\n","      <td>120</td>\n","      <td>KSC</td>\n","      <td>SpaceX CRS-22</td>\n","      <td>3,328 kg</td>\n","      <td>LEO</td>\n","      <td>NASA (CRS)</td>\n","      <td>Success\\n</td>\n","      <td>F9 B5B1067.1</td>\n","      <td>Success</td>\n","      <td>3 June 2021</td>\n","      <td>17:29</td>\n","    </tr>\n","    <tr>\n","      <th>120</th>\n","      <td>121</td>\n","      <td>CCSFS</td>\n","      <td>SXM-8</td>\n","      <td>7,000 kg</td>\n","      <td>GTO</td>\n","      <td>Sirius XM</td>\n","      <td>Success\\n</td>\n","      <td>F9 B5</td>\n","      <td>Success</td>\n","      <td>6 June 2021</td>\n","      <td>04:26</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>121 rows × 11 columns</p>\n","</div>"],"text/plain":["    Flight No. Launch site                               Payload Payload mass  \\\n","0            1       CCAFS  Dragon Spacecraft Qualification Unit            0   \n","1            2       CCAFS                                Dragon            0   \n","2            3       CCAFS                                Dragon       525 kg   \n","3            4       CCAFS                          SpaceX CRS-1     4,700 kg   \n","4            5       CCAFS                          SpaceX CRS-2     4,877 kg   \n","..         ...         ...                                   ...          ...   \n","116        117       CCSFS                              Starlink    15,600 kg   \n","117        118         KSC                              Starlink   ~14,000 kg   \n","118        119       CCSFS                              Starlink    15,600 kg   \n","119        120         KSC                         SpaceX CRS-22     3,328 kg   \n","120        121       CCSFS                                 SXM-8     7,000 kg   \n","\n","    Orbit                        Customer Launch outcome Version booster  \\\n","0     LEO                          SpaceX      Success\\n  F9 v1.0B0003.1   \n","1     LEO                NASA (COTS)\\nNRO        Success  F9 v1.0B0004.1   \n","2     LEO                     NASA (COTS)        Success  F9 v1.0B0005.1   \n","3     LEO                      NASA (CRS)      Success\\n  F9 v1.0B0006.1   \n","4     LEO                      NASA (CRS)      Success\\n  F9 v1.0B0007.1   \n","..    ...                             ...            ...             ...   \n","116   LEO                          SpaceX      Success\\n   F9 B5B1051.10   \n","117   LEO  SpaceX Capella Space and Tyvak      Success\\n    F9 B5B1058.8   \n","118   LEO                          SpaceX      Success\\n    F9 B5B1063.2   \n","119   LEO                      NASA (CRS)      Success\\n    F9 B5B1067.1   \n","120   GTO                       Sirius XM      Success\\n           F9 B5   \n","\n","    Booster landing             Date   Time  \n","0           Failure      4 June 2010  18:45  \n","1           Failure  8 December 2010  15:43  \n","2      No attempt\\n      22 May 2012  07:44  \n","3        No attempt   8 October 2012  00:35  \n","4      No attempt\\n     1 March 2013  15:10  \n","..              ...              ...    ...  \n","116         Success       9 May 2021  06:42  \n","117         Success      15 May 2021  22:56  \n","118         Success      26 May 2021  18:59  \n","119         Success      3 June 2021  17:29  \n","120         Success      6 June 2021  04:26  \n","\n","[121 rows x 11 columns]"]},"execution_count":104,"metadata":{},"output_type":"execute_result"}],"source":["df"]},{"cell_type":"markdown","id":"3d11ac33-1484-4e62-832a-73d4a9092c7f","metadata":{},"source":["We can now export it to a <b>CSV</b> for the next section, but to make the answers consistent and in case you have difficulties finishing this lab. \n","\n","Following labs will be using a provided dataset to make each lab independent. \n"]},{"cell_type":"markdown","id":"acc1243d-72af-4e63-ac6e-88d57274dc0c","metadata":{},"source":["<code>df.to_csv('spacex_web_scraped.csv', index=False)</code>\n"]},{"cell_type":"code","execution_count":105,"metadata":{},"outputs":[],"source":["df.to_csv('spacex_web_scraped.csv', index=False)"]},{"cell_type":"markdown","id":"1e003580-a101-4947-8d47-3fb4229a510b","metadata":{},"source":["## Authors\n"]},{"cell_type":"markdown","id":"864217cd-044a-4fdb-bed9-556a775d57b2","metadata":{},"source":["<a href=\"https://www.linkedin.com/in/yan-luo-96288783/\">Yan Luo</a>\n"]},{"cell_type":"markdown","id":"58e63045-8b3b-4264-b7d8-c73025118d5a","metadata":{},"source":["<a href=\"https://www.linkedin.com/in/nayefaboutayoun/\">Nayef Abou Tayoun</a>\n"]},{"cell_type":"markdown","id":"d714bd34-d64c-412c-b095-28d73cb8717d","metadata":{},"source":["## Change Log\n"]},{"cell_type":"markdown","id":"b90dce1e-0239-4167-af29-d9403e8e1f7e","metadata":{},"source":["| Date (YYYY-MM-DD) | Version | Changed By | Change Description      |\n","| ----------------- | ------- | ---------- | ----------------------- |\n","| 2021-06-09        | 1.0     | Yan Luo    | Tasks updates           |\n","| 2020-11-10        | 1.0     | Nayef      | Created the initial version |\n"]},{"cell_type":"markdown","id":"4c9c9339-b67d-4ecc-99df-98233721a8e8","metadata":{},"source":["Copyright © 2021 IBM Corporation. All rights reserved.\n"]}],"metadata":{"kernelspec":{"display_name":"base","language":"python","name":"python3"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.11.5"}},"nbformat":4,"nbformat_minor":4}