Spacex_data_analysis.ipynb

{"cells":[{"cell_type":"markdown","source":["<center>\n","    <img src=\"https://gitlab.com/ibm/skills-network/courses/placeholder101/-/raw/master/labs/module%201/images/IDSNlogo.png\"  width=\"300\" alt=\"cognitiveclass.ai logo\"  />\n","</center>\n","\n","<h1 align=center><font size = 5>Assignment: SQL Notebook for Peer Assignment</font></h1>\n","\n","Estimated time needed: **60** minutes.\n","\n","## Introduction\n","\n","Using this Python notebook you will:\n","\n","1.  Understand the Spacex DataSet\n","2.  Load the dataset  into the corresponding table in a Db2 database\n","3.  Execute SQL queries to answer assignment questions\n"],"metadata":{}},{"cell_type":"markdown","source":["## Overview of the DataSet\n","\n","SpaceX has gained worldwide attention for a series of historic milestones.\n","\n","It is the only private company ever to return a spacecraft from low-earth orbit, which it first accomplished in December 2010.\n","SpaceX advertises Falcon 9 rocket launches on its website with a cost of 62 million dollars wheras other providers cost upward of 165 million dollars each, much of the savings is because Space X can reuse the first stage.\n","\n","Therefore if we can determine if the first stage will land, we can determine the cost of a launch.\n","\n","This information can be used if an alternate company wants to bid against SpaceX for a rocket launch.\n","\n","This dataset includes a record for each payload carried during a SpaceX mission into outer space.\n"],"metadata":{}},{"cell_type":"markdown","source":["### Download the datasets\n","\n","This assignment requires you to load the spacex dataset.\n","\n","In many cases the dataset to be analyzed is available as a .CSV (comma separated values) file, perhaps on the internet. Click on the link below to download and save the dataset (.CSV file):\n","\n","<a href=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBM-DS0321EN-SkillsNetwork/labs/module_2/data/Spacex.csv?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDS0321ENSkillsNetwork26802033-2021-01-01\" target=\"_blank\">Spacex DataSet</a>\n"],"metadata":{}},{"cell_type":"markdown","source":["### Store the dataset in database table\n","\n","**it is highly recommended to manually load the table using the database console LOAD tool in DB2**.\n","\n","<img src = \"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBM-DS0321EN-SkillsNetwork/labs/module_2/images/spacexload.png\">\n","\n","Now open the Db2 console, open the LOAD tool, Select / Drag the .CSV file for the  dataset, Next create a New Table, and then follow the steps on-screen instructions to load the data. Name the new table as follows:\n","\n","**SPACEXDATASET**\n","\n","**Follow these steps while using old DB2 UI which is having Open Console Screen**\n","\n","**Note:While loading Spacex dataset, ensure that detect datatypes is disabled. Later click on the pencil icon(edit option).**\n","\n","1.  Change the Date Format by manually typing DD-MM-YYYY and timestamp format as DD-MM-YYYY HH\\:MM:SS\n","\n","2.  Change the PAYLOAD_MASS\\_\\_KG\\_  datatype  to INTEGER.\n","\n","<img src = \"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBM-DS0321EN-SkillsNetwork/labs/module_2/images/spacexload2.png\">\n"],"metadata":{}},{"cell_type":"markdown","source":["**Changes to be considered when having DB2 instance with the new UI having Go to UI screen**\n","\n","*   Refer to this insruction in this <a href=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Labs_Coursera_V5/labs/Lab%20-%20Sign%20up%20for%20IBM%20Cloud%20-%20Create%20Db2%20service%20instance%20-%20Get%20started%20with%20the%20Db2%20console/instructional-labs.md.html?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDS0321ENSkillsNetwork26802033-2021-01-01\">link</a> for viewing  the new  Go to UI screen.\n","\n","*   Later click on **Data link(below SQL)**  in the Go to UI screen  and click on **Load Data** tab.\n","\n","*   Later browse for the downloaded spacex file.\n","\n","<img src=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBM-DS0321EN-SkillsNetwork/labs/module_2/images/browsefile.png\" width=\"800\"/>\n","\n","*   Once done select the schema andload the file.\n","\n"," <img src=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBM-DS0321EN-SkillsNetwork/labs/module_2/images/spacexload3.png\" width=\"800\"/>\n"],"metadata":{}},{"cell_type":"code","execution_count":1,"source":["!pip install sqlalchemy==1.3.9\r\n","!pip install ibm_db \r\n","!pip install ibm_db_sa\r\n","!pip install ipython-sql\r\n","\r\n"],"outputs":[{"output_type":"stream","name":"stdout","text":["Requirement already satisfied: sqlalchemy==1.3.9 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (1.3.9)\n","Requirement already satisfied: ibm_db in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (3.0.4)\n","Requirement already satisfied: ibm_db_sa in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (0.3.6)\n","Requirement already satisfied: sqlalchemy>=0.7.3 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ibm_db_sa) (1.3.9)\n","Requirement already satisfied: ibm-db>=2.0.0 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ibm_db_sa) (3.0.4)\n","Requirement already satisfied: ipython-sql in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (0.4.0)\n","Requirement already satisfied: ipython-genutils>=0.1.0 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython-sql) (0.2.0)\n","Requirement already satisfied: six in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython-sql) (1.15.0)\n","Requirement already satisfied: sqlparse in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython-sql) (0.4.1)\n","Requirement already satisfied: ipython>=1.0 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython-sql) (7.22.0)\n","Requirement already satisfied: prettytable<1 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython-sql) (0.7.2)\n","Requirement already satisfied: sqlalchemy>=0.6.7 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython-sql) (1.3.9)\n","Requirement already satisfied: jedi>=0.16 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython>=1.0->ipython-sql) (0.17.2)\n","Requirement already satisfied: setuptools>=18.5 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython>=1.0->ipython-sql) (52.0.0.post20210125)\n","Requirement already satisfied: traitlets>=4.2 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython>=1.0->ipython-sql) (5.0.5)\n","Requirement already satisfied: prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython>=1.0->ipython-sql) (3.0.17)\n","Requirement already satisfied: pexpect>4.3 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython>=1.0->ipython-sql) (4.8.0)\n","Requirement already satisfied: decorator in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython>=1.0->ipython-sql) (5.0.9)\n","Requirement already satisfied: backcall in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython>=1.0->ipython-sql) (0.2.0)\n","Requirement already satisfied: pickleshare in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython>=1.0->ipython-sql) (0.7.5)\n","Requirement already satisfied: pygments in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from ipython>=1.0->ipython-sql) (2.9.0)\n","Requirement already satisfied: parso<0.8.0,>=0.7.0 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from jedi>=0.16->ipython>=1.0->ipython-sql) (0.7.0)\n","Requirement already satisfied: ptyprocess>=0.5 in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from pexpect>4.3->ipython>=1.0->ipython-sql) (0.7.0)\n","Requirement already satisfied: wcwidth in /opt/conda/envs/Python-3.8-main/lib/python3.8/site-packages (from prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0->ipython>=1.0->ipython-sql) (0.2.5)\n"]}],"metadata":{}},{"cell_type":"markdown","source":["### Connect to the database\n","\n","Let us first load the SQL extension and establish a connection with the database\n"],"metadata":{}},{"cell_type":"code","execution_count":2,"source":["%load_ext sql"],"outputs":[],"metadata":{}},{"cell_type":"markdown","source":["**DB2 magic in case of old UI service credentials.**\n","\n","In the next cell enter your db2 connection string. Recall you created Service Credentials for your Db2 instance before. From the **uri** field of your Db2 service credentials copy everything after db2:// (except the double quote at the end) and paste it in the cell below after ibm_db_sa://\n","\n","<img src =\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/FinalModule_edX/images/URI.jpg\">\n","\n","in the following format\n","\n","**%sql ibm_db_sa://my-username:my-password\\@my-hostname:my-port/my-db-name**\n","\n","**DB2 magic in case of new UI service credentials.**\n","\n","<img src =\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBM-DS0321EN-SkillsNetwork/labs/module_2/images/servicecredentials.png\" width=600>  \n","\n","*   Use the following format.\n","\n","*   Add security=SSL at the end\n","\n","**%sql ibm_db_sa://my-username:my-password\\@my-hostname:my-port/my-db-name?security=SSL**\n"],"metadata":{}},{"cell_type":"code","execution_count":8,"source":["#username = vrk08248\r\n","#password = j0uV23Dn7euq0sqJ\r\n","#hostname = fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud\r\n","#port = 32731\r\n","#dbname = bludb\r\n","        "],"outputs":[],"metadata":{}},{"cell_type":"code","execution_count":3,"source":["%sql ibm_db_sa://vrk08248:j0uV23Dn7euq0sqJ@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb?security=SSL\r\n"],"outputs":[{"output_type":"stream","name":"stdout","text":["DB2/LINUXX8664\n"]}],"metadata":{}},{"cell_type":"markdown","source":["## Tasks\n","\n","Now write and execute SQL queries to solve the assignment tasks.\n","\n","### Task 1\n","\n","##### Display the names of the unique launch sites  in the space mission\n"],"metadata":{}},{"cell_type":"code","execution_count":4,"source":["#%sql SELECT UNIQUE LAUNCH_SITE FROM VRK08248.SPACEXDATASET;\r\n","%sql SELECT DISTINCT LAUNCH_SITE FROM VRK08248.SPACEX;"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>launch_site</th>\n","    </tr>\n","    <tr>\n","        <td>CCAFS LC-40</td>\n","    </tr>\n","    <tr>\n","        <td>CCAFS SLC-40</td>\n","    </tr>\n","    <tr>\n","        <td>KSC LC-39A</td>\n","    </tr>\n","    <tr>\n","        <td>VAFB SLC-4E</td>\n","    </tr>\n","</table>"],"text/plain":["[('CCAFS LC-40',), ('CCAFS SLC-40',), ('KSC LC-39A',), ('VAFB SLC-4E',)]"]},"metadata":{},"execution_count":4}],"metadata":{}},{"cell_type":"markdown","source":["### Task 2\n","\n","##### Display 5 records where launch sites begin with the string 'CCA'\n"],"metadata":{}},{"cell_type":"code","execution_count":5,"source":["%sql SELECT LAUNCH_SITE FROM VRK08248.SPACEX WHERE LAUNCH_SITE LIKE 'CCA%' LIMIT 5;"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>launch_site</th>\n","    </tr>\n","    <tr>\n","        <td>CCAFS LC-40</td>\n","    </tr>\n","    <tr>\n","        <td>CCAFS LC-40</td>\n","    </tr>\n","    <tr>\n","        <td>CCAFS LC-40</td>\n","    </tr>\n","    <tr>\n","        <td>CCAFS LC-40</td>\n","    </tr>\n","    <tr>\n","        <td>CCAFS LC-40</td>\n","    </tr>\n","</table>"],"text/plain":["[('CCAFS LC-40',),\n"," ('CCAFS LC-40',),\n"," ('CCAFS LC-40',),\n"," ('CCAFS LC-40',),\n"," ('CCAFS LC-40',)]"]},"metadata":{},"execution_count":5}],"metadata":{}},{"cell_type":"markdown","source":["Select where coustomer is NASA (CRS)"],"metadata":{}},{"cell_type":"code","execution_count":6,"source":["%sql SELECT count(CUSTOMER) FROM VRK08248.SPACEX WHERE CUSTOMER ='NASA (CRS)' ;"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>1</th>\n","    </tr>\n","    <tr>\n","        <td>20</td>\n","    </tr>\n","</table>"],"text/plain":["[(20,)]"]},"metadata":{},"execution_count":6}],"metadata":{}},{"cell_type":"markdown","source":["### Task 3\n","\n","##### Display the total payload mass carried by boosters launched by NASA (CRS)\n"],"metadata":{}},{"cell_type":"code","execution_count":7,"source":["%sql select sum(PAYLOAD_MASS__KG_) from VRK08248.SPACEX where CUSTOMER = 'NASA (CRS)';"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>1</th>\n","    </tr>\n","    <tr>\n","        <td>45596</td>\n","    </tr>\n","</table>"],"text/plain":["[(45596,)]"]},"metadata":{},"execution_count":7}],"metadata":{}},{"cell_type":"markdown","source":["### Task 4\n","\n","##### Display average payload mass carried by booster version F9 v1.1\n"],"metadata":{}},{"cell_type":"code","execution_count":9,"source":["%sql select avg(PAYLOAD_MASS__KG_) as average_payload_mass from VRK08248.SPACEX where booster_version = 'F9 v1.1';"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>average_payload_mass</th>\n","    </tr>\n","    <tr>\n","        <td>2928</td>\n","    </tr>\n","</table>"],"text/plain":["[(2928,)]"]},"metadata":{},"execution_count":9}],"metadata":{}},{"cell_type":"markdown","source":["### Task 5\n","\n","##### List the date when the first succesful landing outcome in ground pad was acheived.\n","\n","*Hint:Use min function*\n"],"metadata":{}},{"cell_type":"code","execution_count":10,"source":["%sql select date,Landing__outcome from VRK08248.SPACEX where LANDING__OUTCOME = 'Success (ground pad)';"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>DATE</th>\n","        <th>landing__outcome</th>\n","    </tr>\n","    <tr>\n","        <td>2015-12-22</td>\n","        <td>Success (ground pad)</td>\n","    </tr>\n","    <tr>\n","        <td>2016-07-18</td>\n","        <td>Success (ground pad)</td>\n","    </tr>\n","    <tr>\n","        <td>2017-02-19</td>\n","        <td>Success (ground pad)</td>\n","    </tr>\n","    <tr>\n","        <td>2017-01-05</td>\n","        <td>Success (ground pad)</td>\n","    </tr>\n","    <tr>\n","        <td>2017-03-06</td>\n","        <td>Success (ground pad)</td>\n","    </tr>\n","    <tr>\n","        <td>2017-08-14</td>\n","        <td>Success (ground pad)</td>\n","    </tr>\n","    <tr>\n","        <td>2017-07-09</td>\n","        <td>Success (ground pad)</td>\n","    </tr>\n","    <tr>\n","        <td>2017-12-15</td>\n","        <td>Success (ground pad)</td>\n","    </tr>\n","    <tr>\n","        <td>2018-08-01</td>\n","        <td>Success (ground pad)</td>\n","    </tr>\n","</table>"],"text/plain":["[(datetime.date(2015, 12, 22), 'Success (ground pad)'),\n"," (datetime.date(2016, 7, 18), 'Success (ground pad)'),\n"," (datetime.date(2017, 2, 19), 'Success (ground pad)'),\n"," (datetime.date(2017, 1, 5), 'Success (ground pad)'),\n"," (datetime.date(2017, 3, 6), 'Success (ground pad)'),\n"," (datetime.date(2017, 8, 14), 'Success (ground pad)'),\n"," (datetime.date(2017, 7, 9), 'Success (ground pad)'),\n"," (datetime.date(2017, 12, 15), 'Success (ground pad)'),\n"," (datetime.date(2018, 8, 1), 'Success (ground pad)')]"]},"metadata":{},"execution_count":10}],"metadata":{}},{"cell_type":"markdown","source":["### Task 6\n","\n","##### List the names of the boosters which have success in drone ship and have payload mass greater than 4000 but less than 6000\n"],"metadata":{}},{"cell_type":"code","execution_count":11,"source":["%sql select booster_version,PAYLOAD_MASS__KG_ from VRK08248.SPACEX where LANDING__OUTCOME = 'Success (drone ship)' AND PAYLOAD_MASS__KG_ between 4000 and 6000;"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>booster_version</th>\n","        <th>payload_mass__kg_</th>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1022</td>\n","        <td>4696</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1026</td>\n","        <td>4600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT  B1021.2</td>\n","        <td>5300</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT  B1031.2</td>\n","        <td>5200</td>\n","    </tr>\n","</table>"],"text/plain":["[('F9 FT B1022', 4696),\n"," ('F9 FT B1026', 4600),\n"," ('F9 FT  B1021.2', 5300),\n"," ('F9 FT  B1031.2', 5200)]"]},"metadata":{},"execution_count":11}],"metadata":{}},{"cell_type":"markdown","source":["### Task 7\n","\n","##### List the total number of successful and failure mission outcomes\n"],"metadata":{}},{"cell_type":"code","execution_count":12,"source":["%sql select count(mission_outcome)as count_mission_outcome from VRK08248.SPACEX where mission_outcome ='Success' OR mission_outcome = 'Failure';"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>count_mission_outcome</th>\n","    </tr>\n","    <tr>\n","        <td>99</td>\n","    </tr>\n","</table>"],"text/plain":["[(99,)]"]},"metadata":{},"execution_count":12}],"metadata":{}},{"cell_type":"markdown","source":["### Task 8\n","\n","##### List the   names of the booster_versions which have carried the maximum payload mass. Use a subquery\n"],"metadata":{}},{"cell_type":"code","execution_count":13,"source":["%sql select UNIQUE(booster_version),launch_site, customer, Landing__outcome, PAYLOAD_MASS__KG_, (select max(PAYLOAD_MASS__KG_) from VRK08248.SPACEX) as max_payload from VRK08248.SPACEX;\r\n"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>booster_version</th>\n","        <th>launch_site</th>\n","        <th>customer</th>\n","        <th>landing__outcome</th>\n","        <th>payload_mass__kg_</th>\n","        <th>max_payload</th>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.0  B0003</td>\n","        <td>CCAFS LC-40</td>\n","        <td>SpaceX</td>\n","        <td>Failure (parachute)</td>\n","        <td>0</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.0  B0004</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (COTS) NRO</td>\n","        <td>Failure (parachute)</td>\n","        <td>0</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4 B1045.1</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>NASA (LSP)</td>\n","        <td>Success (drone ship)</td>\n","        <td>362</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1038.1</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>NSPO</td>\n","        <td>Success (drone ship)</td>\n","        <td>475</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.0  B0006</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>No attempt</td>\n","        <td>500</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1  B1003</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>MDA</td>\n","        <td>Uncontrolled (ocean)</td>\n","        <td>500</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.0  B0005</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (COTS)</td>\n","        <td>No attempt</td>\n","        <td>525</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1 B1017</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>NASA (LSP) NOAA CNES</td>\n","        <td>Failure (drone ship)</td>\n","        <td>553</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1 B1013</td>\n","        <td>CCAFS LC-40</td>\n","        <td>U.S. Air Force NASA NOAA</td>\n","        <td>Controlled (ocean)</td>\n","        <td>570</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.0  B0007</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>No attempt</td>\n","        <td>677</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1063.1</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>NASA / NOAA / ESA / EUMETSAT</td>\n","        <td>Success</td>\n","        <td>1192</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1</td>\n","        <td>CCAFS LC-40</td>\n","        <td>Orbcomm</td>\n","        <td>Controlled (ocean)</td>\n","        <td>1316</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1 B1015</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Failure (drone ship)</td>\n","        <td>1898</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1 B1018</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Precluded (drone ship)</td>\n","        <td>1952</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1059.2</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success</td>\n","        <td>1977</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1019</td>\n","        <td>CCAFS LC-40</td>\n","        <td>Orbcomm</td>\n","        <td>Success (ground pad)</td>\n","        <td>2034</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT  B1038.2</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Hisdesat exactEarth SpaceX</td>\n","        <td>No attempt</td>\n","        <td>2150</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT  B1035.2</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success (ground pad)</td>\n","        <td>2205</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1 B1010</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Uncontrolled (ocean)</td>\n","        <td>2216</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1025.1</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success (ground pad)</td>\n","        <td>2257</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1056.2</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success</td>\n","        <td>2268</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Controlled (ocean)</td>\n","        <td>2296</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1 B1012</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Failure (drone ship)</td>\n","        <td>2395</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1031.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success (ground pad)</td>\n","        <td>2490</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1056.1</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success</td>\n","        <td>2495</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1050</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Failure</td>\n","        <td>2500</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1059.1</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>NASA (CRS), Kacific 1</td>\n","        <td>Success</td>\n","        <td>2617</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4  B1039.2</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>No attempt</td>\n","        <td>2647</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4 B1045.2</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>No attempt</td>\n","        <td>2697</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1035.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success (ground pad)</td>\n","        <td>2708</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1058.4</td>\n","        <td>KSC LC-39A</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success</td>\n","        <td>2972</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1048.2</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>CONAE</td>\n","        <td>Success</td>\n","        <td>3000</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1023.1</td>\n","        <td>CCAFS LC-40</td>\n","        <td>Thaicom</td>\n","        <td>Success (drone ship)</td>\n","        <td>3100</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1059.4</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>CONAE, PlanetIQ, SpaceX</td>\n","        <td>Success</td>\n","        <td>3130</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1021.1</td>\n","        <td>CCAFS LC-40</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success (drone ship)</td>\n","        <td>3136</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1</td>\n","        <td>CCAFS LC-40</td>\n","        <td>SES</td>\n","        <td>No attempt</td>\n","        <td>3170</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4 B1039.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>NASA (CRS)</td>\n","        <td>Success (ground pad)</td>\n","        <td>3310</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1</td>\n","        <td>CCAFS LC-40</td>\n","        <td>Thaicom</td>\n","        <td>No attempt</td>\n","        <td>3325</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4 B1042.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>KT Corporation</td>\n","        <td>Success (drone ship)</td>\n","        <td>3500</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5  B1046.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>Thales-Alenia/BTRC</td>\n","        <td>Success (drone ship)</td>\n","        <td>3600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1024</td>\n","        <td>CCAFS LC-40</td>\n","        <td>ABS Eutelsat</td>\n","        <td>Failure (drone ship)</td>\n","        <td>3600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT  B1029.2</td>\n","        <td>KSC LC-39A</td>\n","        <td>Bulsatcom</td>\n","        <td>Success (drone ship)</td>\n","        <td>3669</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1046.3</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Spaceflight Industries</td>\n","        <td>Success</td>\n","        <td>4000</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1 B1014</td>\n","        <td>CCAFS LC-40</td>\n","        <td>ABS Eutelsat</td>\n","        <td>No attempt</td>\n","        <td>4159</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1051.2</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Canadian Space Agency (CSA)</td>\n","        <td>Success</td>\n","        <td>4200</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT  B1032.2</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SES</td>\n","        <td>Controlled (ocean)</td>\n","        <td>4230</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1060.1</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>U.S. Space Force</td>\n","        <td>Success</td>\n","        <td>4311</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1062.1</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>USSF</td>\n","        <td>Success</td>\n","        <td>4311</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1054</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>USAF</td>\n","        <td>No attempt</td>\n","        <td>4400</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1 B1011</td>\n","        <td>CCAFS LC-40</td>\n","        <td>AsiaSat</td>\n","        <td>No attempt</td>\n","        <td>4428</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1</td>\n","        <td>CCAFS LC-40</td>\n","        <td>AsiaSat</td>\n","        <td>No attempt</td>\n","        <td>4535</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1026</td>\n","        <td>CCAFS LC-40</td>\n","        <td>SKY Perfect JSAT Group</td>\n","        <td>Success (drone ship)</td>\n","        <td>4600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1022</td>\n","        <td>CCAFS LC-40</td>\n","        <td>SKY Perfect JSAT Group</td>\n","        <td>Success (drone ship)</td>\n","        <td>4696</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 v1.1 B1016</td>\n","        <td>CCAFS LC-40</td>\n","        <td>Turkmenistan National Space Agency</td>\n","        <td>No attempt</td>\n","        <td>4707</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1048.3</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>PSN, SpaceIL / IAI</td>\n","        <td>Success</td>\n","        <td>4850</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4 B1040.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>U.S. Air Force</td>\n","        <td>Success (ground pad)</td>\n","        <td>4990</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4 B1043.1</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>Northrop Grumman</td>\n","        <td>Success (ground pad)</td>\n","        <td>5000</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT  B1031.2</td>\n","        <td>KSC LC-39A</td>\n","        <td>SES EchoStar</td>\n","        <td>Success (drone ship)</td>\n","        <td>5200</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1020</td>\n","        <td>CCAFS LC-40</td>\n","        <td>SES</td>\n","        <td>Failure (drone ship)</td>\n","        <td>5271</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1047.2</td>\n","        <td>KSC LC-39A</td>\n","        <td>Es hailSat</td>\n","        <td>Success</td>\n","        <td>5300</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT  B1021.2</td>\n","        <td>KSC LC-39A</td>\n","        <td>SES</td>\n","        <td>Success (drone ship)</td>\n","        <td>5300</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1032.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>NRO</td>\n","        <td>Success (ground pad)</td>\n","        <td>5300</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4  B1040.2</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SES</td>\n","        <td>No attempt</td>\n","        <td>5384</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1058.2</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>Republic of Korea Army, Spaceflight Industries (BlackSky)</td>\n","        <td>Success</td>\n","        <td>5500</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1030</td>\n","        <td>KSC LC-39A</td>\n","        <td>EchoStar</td>\n","        <td>No attempt</td>\n","        <td>5600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1046.2</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>Telkom Indonesia</td>\n","        <td>Success</td>\n","        <td>5800</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1034</td>\n","        <td>KSC LC-39A</td>\n","        <td>Inmarsat</td>\n","        <td>No attempt</td>\n","        <td>6070</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4 B1044</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>Hispasat  NovaWurks</td>\n","        <td>No attempt</td>\n","        <td>6092</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4  B1043.2</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Iridium Communications GFZ ‚ NASA</td>\n","        <td>No attempt</td>\n","        <td>6460</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1047.3</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>Spacecom</td>\n","        <td>No attempt</td>\n","        <td>6500</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1037</td>\n","        <td>KSC LC-39A</td>\n","        <td>Intelsat</td>\n","        <td>No attempt</td>\n","        <td>6761</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1056.3</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>Sky Perfect JSAT, Kacific 1</td>\n","        <td>Success</td>\n","        <td>6956</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1049.1</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>Telesat</td>\n","        <td>Success</td>\n","        <td>7060</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1047.1</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>Telesat</td>\n","        <td>Success</td>\n","        <td>7075</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4  B1041.2</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Iridium Communications</td>\n","        <td>No attempt</td>\n","        <td>9600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B4 B1041.1</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Iridium Communications</td>\n","        <td>Success (drone ship)</td>\n","        <td>9600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1049.2</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Iridium Communications</td>\n","        <td>Success</td>\n","        <td>9600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1048.1</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Iridium Communications</td>\n","        <td>Success</td>\n","        <td>9600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT  B1036.2</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Iridium Communications</td>\n","        <td>Controlled (ocean)</td>\n","        <td>9600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1029.1</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Iridium Communications</td>\n","        <td>Success (drone ship)</td>\n","        <td>9600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 FT B1036.1</td>\n","        <td>VAFB SLC-4E</td>\n","        <td>Iridium Communications</td>\n","        <td>Success (drone ship)</td>\n","        <td>9600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1046.4</td>\n","        <td>KSC LC-39A</td>\n","        <td>NASA (CTS)</td>\n","        <td>No attempt</td>\n","        <td>12050</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1051.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>NASA (CCD)</td>\n","        <td>Success</td>\n","        <td>12055</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1061.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>NASA (CCP)</td>\n","        <td>Success</td>\n","        <td>12500</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5B1058.1</td>\n","        <td>KSC LC-39A</td>\n","        <td>NASA (CCDev)</td>\n","        <td>Success</td>\n","        <td>12530</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1049.3</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>13620</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1051.5</td>\n","        <td>KSC LC-39A</td>\n","        <td>SpaceX, Spaceflight Industries (BlackSky), Planet Labs</td>\n","        <td>Success</td>\n","        <td>14932</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1059.3</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX, Planet Labs</td>\n","        <td>Success</td>\n","        <td>15410</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1049.6</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX, Planet Labs, PlanetIQ</td>\n","        <td>Success</td>\n","        <td>15440</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1048.4</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1048.5</td>\n","        <td>KSC LC-39A</td>\n","        <td>SpaceX</td>\n","        <td>Failure</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1049.4</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1049.5</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX, Planet Labs</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1049.7</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1051.3</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1051.4</td>\n","        <td>KSC LC-39A</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1051.6</td>\n","        <td>KSC LC-39A</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1056.4</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX</td>\n","        <td>Failure</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1058.3</td>\n","        <td>KSC LC-39A</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1060.2</td>\n","        <td>KSC LC-39A</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","    <tr>\n","        <td>F9 B5 B1060.3</td>\n","        <td>CCAFS SLC-40</td>\n","        <td>SpaceX</td>\n","        <td>Success</td>\n","        <td>15600</td>\n","        <td>15600</td>\n","    </tr>\n","</table>"],"text/plain":["[('F9 v1.0  B0003', 'CCAFS LC-40', 'SpaceX', 'Failure (parachute)', 0, 15600),\n"," ('F9 v1.0  B0004', 'CCAFS LC-40', 'NASA (COTS) NRO', 'Failure (parachute)', 0, 15600),\n"," ('F9 B4 B1045.1', 'CCAFS SLC-40', 'NASA (LSP)', 'Success (drone ship)', 362, 15600),\n"," ('F9 FT B1038.1', 'VAFB SLC-4E', 'NSPO', 'Success (drone ship)', 475, 15600),\n"," ('F9 v1.0  B0006', 'CCAFS LC-40', 'NASA (CRS)', 'No attempt', 500, 15600),\n"," ('F9 v1.1  B1003', 'VAFB SLC-4E', 'MDA', 'Uncontrolled (ocean)', 500, 15600),\n"," ('F9 v1.0  B0005', 'CCAFS LC-40', 'NASA (COTS)', 'No attempt', 525, 15600),\n"," ('F9 v1.1 B1017', 'VAFB SLC-4E', 'NASA (LSP) NOAA CNES', 'Failure (drone ship)', 553, 15600),\n"," ('F9 v1.1 B1013', 'CCAFS LC-40', 'U.S. Air Force NASA NOAA', 'Controlled (ocean)', 570, 15600),\n"," ('F9 v1.0  B0007', 'CCAFS LC-40', 'NASA (CRS)', 'No attempt', 677, 15600),\n"," ('F9 B5B1063.1', 'VAFB SLC-4E', 'NASA / NOAA / ESA / EUMETSAT', 'Success', 1192, 15600),\n"," ('F9 v1.1', 'CCAFS LC-40', 'Orbcomm', 'Controlled (ocean)', 1316, 15600),\n"," ('F9 v1.1 B1015', 'CCAFS LC-40', 'NASA (CRS)', 'Failure (drone ship)', 1898, 15600),\n"," ('F9 v1.1 B1018', 'CCAFS LC-40', 'NASA (CRS)', 'Precluded (drone ship)', 1952, 15600),\n"," ('F9 B5 B1059.2', 'CCAFS SLC-40', 'NASA (CRS)', 'Success', 1977, 15600),\n"," ('F9 FT B1019', 'CCAFS LC-40', 'Orbcomm', 'Success (ground pad)', 2034, 15600),\n"," ('F9 FT  B1038.2', 'VAFB SLC-4E', 'Hisdesat exactEarth SpaceX', 'No attempt', 2150, 15600),\n"," ('F9 FT  B1035.2', 'CCAFS SLC-40', 'NASA (CRS)', 'Success (ground pad)', 2205, 15600),\n"," ('F9 v1.1 B1010', 'CCAFS LC-40', 'NASA (CRS)', 'Uncontrolled (ocean)', 2216, 15600),\n"," ('F9 FT B1025.1', 'CCAFS LC-40', 'NASA (CRS)', 'Success (ground pad)', 2257, 15600),\n"," ('F9 B5 B1056.2', 'CCAFS SLC-40', 'NASA (CRS)', 'Success', 2268, 15600),\n"," ('F9 v1.1', 'CCAFS LC-40', 'NASA (CRS)', 'Controlled (ocean)', 2296, 15600),\n"," ('F9 v1.1 B1012', 'CCAFS LC-40', 'NASA (CRS)', 'Failure (drone ship)', 2395, 15600),\n"," ('F9 FT B1031.1', 'KSC LC-39A', 'NASA (CRS)', 'Success (ground pad)', 2490, 15600),\n"," ('F9 B5B1056.1', 'CCAFS SLC-40', 'NASA (CRS)', 'Success', 2495, 15600),\n"," ('F9 B5B1050', 'CCAFS SLC-40', 'NASA (CRS)', 'Failure', 2500, 15600),\n"," ('F9 B5B1059.1', 'CCAFS SLC-40', 'NASA (CRS), Kacific 1', 'Success', 2617, 15600),\n"," ('F9 B4  B1039.2', 'CCAFS SLC-40', 'NASA (CRS)', 'No attempt', 2647, 15600),\n"," ('F9 B4 B1045.2', 'CCAFS SLC-40', 'NASA (CRS)', 'No attempt', 2697, 15600),\n"," ('F9 FT B1035.1', 'KSC LC-39A', 'NASA (CRS)', 'Success (ground pad)', 2708, 15600),\n"," ('F9 B5 B1058.4', 'KSC LC-39A', 'NASA (CRS)', 'Success', 2972, 15600),\n"," ('F9 B5 B1048.2', 'VAFB SLC-4E', 'CONAE', 'Success', 3000, 15600),\n"," ('F9 FT B1023.1', 'CCAFS LC-40', 'Thaicom', 'Success (drone ship)', 3100, 15600),\n"," ('F9 B5 B1059.4', 'CCAFS SLC-40', 'CONAE, PlanetIQ, SpaceX', 'Success', 3130, 15600),\n"," ('F9 FT B1021.1', 'CCAFS LC-40', 'NASA (CRS)', 'Success (drone ship)', 3136, 15600),\n"," ('F9 v1.1', 'CCAFS LC-40', 'SES', 'No attempt', 3170, 15600),\n"," ('F9 B4 B1039.1', 'KSC LC-39A', 'NASA (CRS)', 'Success (ground pad)', 3310, 15600),\n"," ('F9 v1.1', 'CCAFS LC-40', 'Thaicom', 'No attempt', 3325, 15600),\n"," ('F9 B4 B1042.1', 'KSC LC-39A', 'KT Corporation', 'Success (drone ship)', 3500, 15600),\n"," ('F9 B5  B1046.1', 'KSC LC-39A', 'Thales-Alenia/BTRC', 'Success (drone ship)', 3600, 15600),\n"," ('F9 FT B1024', 'CCAFS LC-40', 'ABS Eutelsat', 'Failure (drone ship)', 3600, 15600),\n"," ('F9 FT  B1029.2', 'KSC LC-39A', 'Bulsatcom', 'Success (drone ship)', 3669, 15600),\n"," ('F9 B5 B1046.3', 'VAFB SLC-4E', 'Spaceflight Industries', 'Success', 4000, 15600),\n"," ('F9 v1.1 B1014', 'CCAFS LC-40', 'ABS Eutelsat', 'No attempt', 4159, 15600),\n"," ('F9 B5 B1051.2', 'VAFB SLC-4E', 'Canadian Space Agency (CSA)', 'Success', 4200, 15600),\n"," ('F9 FT  B1032.2', 'CCAFS SLC-40', 'SES', 'Controlled (ocean)', 4230, 15600),\n"," ('F9 B5B1060.1', 'CCAFS SLC-40', 'U.S. Space Force', 'Success', 4311, 15600),\n"," ('F9 B5B1062.1', 'CCAFS SLC-40', 'USSF', 'Success', 4311, 15600),\n"," ('F9 B5B1054', 'CCAFS SLC-40', 'USAF', 'No attempt', 4400, 15600),\n"," ('F9 v1.1 B1011', 'CCAFS LC-40', 'AsiaSat', 'No attempt', 4428, 15600),\n"," ('F9 v1.1', 'CCAFS LC-40', 'AsiaSat', 'No attempt', 4535, 15600),\n"," ('F9 FT B1026', 'CCAFS LC-40', 'SKY Perfect JSAT Group', 'Success (drone ship)', 4600, 15600),\n"," ('F9 FT B1022', 'CCAFS LC-40', 'SKY Perfect JSAT Group', 'Success (drone ship)', 4696, 15600),\n"," ('F9 v1.1 B1016', 'CCAFS LC-40', 'Turkmenistan National Space Agency', 'No attempt', 4707, 15600),\n"," ('F9 B5 B1048.3', 'CCAFS SLC-40', 'PSN, SpaceIL / IAI', 'Success', 4850, 15600),\n"," ('F9 B4 B1040.1', 'KSC LC-39A', 'U.S. Air Force', 'Success (ground pad)', 4990, 15600),\n"," ('F9 B4 B1043.1', 'CCAFS SLC-40', 'Northrop Grumman', 'Success (ground pad)', 5000, 15600),\n"," ('F9 FT  B1031.2', 'KSC LC-39A', 'SES EchoStar', 'Success (drone ship)', 5200, 15600),\n"," ('F9 FT B1020', 'CCAFS LC-40', 'SES', 'Failure (drone ship)', 5271, 15600),\n"," ('F9 B5 B1047.2', 'KSC LC-39A', 'Es hailSat', 'Success', 5300, 15600),\n"," ('F9 FT  B1021.2', 'KSC LC-39A', 'SES', 'Success (drone ship)', 5300, 15600),\n"," ('F9 FT B1032.1', 'KSC LC-39A', 'NRO', 'Success (ground pad)', 5300, 15600),\n"," ('F9 B4  B1040.2', 'CCAFS SLC-40', 'SES', 'No attempt', 5384, 15600),\n"," ('F9 B5 B1058.2', 'CCAFS SLC-40', 'Republic of Korea Army, Spaceflight Industries (BlackSky)', 'Success', 5500, 15600),\n"," ('F9 FT B1030', 'KSC LC-39A', 'EchoStar', 'No attempt', 5600, 15600),\n"," ('F9 B5 B1046.2', 'CCAFS SLC-40', 'Telkom Indonesia', 'Success', 5800, 15600),\n"," ('F9 FT B1034', 'KSC LC-39A', 'Inmarsat', 'No attempt', 6070, 15600),\n"," ('F9 B4 B1044', 'CCAFS SLC-40', 'Hispasat  NovaWurks', 'No attempt', 6092, 15600),\n"," ('F9 B4  B1043.2', 'VAFB SLC-4E', 'Iridium Communications GFZ ‚ NASA', 'No attempt', 6460, 15600),\n"," ('F9 B5 B1047.3', 'CCAFS SLC-40', 'Spacecom', 'No attempt', 6500, 15600),\n"," ('F9 FT B1037', 'KSC LC-39A', 'Intelsat', 'No attempt', 6761, 15600),\n"," ('F9 B5 B1056.3', 'CCAFS SLC-40', 'Sky Perfect JSAT, Kacific 1', 'Success', 6956, 15600),\n"," ('F9 B5B1049.1', 'CCAFS SLC-40', 'Telesat', 'Success', 7060, 15600),\n"," ('F9 B5B1047.1', 'CCAFS SLC-40', 'Telesat', 'Success', 7075, 15600),\n"," ('F9 B4  B1041.2', 'VAFB SLC-4E', 'Iridium Communications', 'No attempt', 9600, 15600),\n"," ('F9 B4 B1041.1', 'VAFB SLC-4E', 'Iridium Communications', 'Success (drone ship)', 9600, 15600),\n"," ('F9 B5 B1049.2', 'VAFB SLC-4E', 'Iridium Communications', 'Success', 9600, 15600),\n"," ('F9 B5B1048.1', 'VAFB SLC-4E', 'Iridium Communications', 'Success', 9600, 15600),\n"," ('F9 FT  B1036.2', 'VAFB SLC-4E', 'Iridium Communications', 'Controlled (ocean)', 9600, 15600),\n"," ('F9 FT B1029.1', 'VAFB SLC-4E', 'Iridium Communications', 'Success (drone ship)', 9600, 15600),\n"," ('F9 FT B1036.1', 'VAFB SLC-4E', 'Iridium Communications', 'Success (drone ship)', 9600, 15600),\n"," ('F9 B5 B1046.4', 'KSC LC-39A', 'NASA (CTS)', 'No attempt', 12050, 15600),\n"," ('F9 B5B1051.1', 'KSC LC-39A', 'NASA (CCD)', 'Success', 12055, 15600),\n"," ('F9 B5B1061.1', 'KSC LC-39A', 'NASA (CCP)', 'Success', 12500, 15600),\n"," ('F9 B5B1058.1', 'KSC LC-39A', 'NASA (CCDev)', 'Success', 12530, 15600),\n"," ('F9 B5 B1049.3', 'CCAFS SLC-40', 'SpaceX', 'Success', 13620, 15600),\n"," ('F9 B5 B1051.5', 'KSC LC-39A', 'SpaceX, Spaceflight Industries (BlackSky), Planet Labs', 'Success', 14932, 15600),\n"," ('F9 B5 B1059.3', 'CCAFS SLC-40', 'SpaceX, Planet Labs', 'Success', 15410, 15600),\n"," ('F9 B5 B1049.6', 'CCAFS SLC-40', 'SpaceX, Planet Labs, PlanetIQ', 'Success', 15440, 15600),\n"," ('F9 B5 B1048.4', 'CCAFS SLC-40', 'SpaceX', 'Success', 15600, 15600),\n"," ('F9 B5 B1048.5', 'KSC LC-39A', 'SpaceX', 'Failure', 15600, 15600),\n"," ('F9 B5 B1049.4', 'CCAFS SLC-40', 'SpaceX', 'Success', 15600, 15600),\n"," ('F9 B5 B1049.5', 'CCAFS SLC-40', 'SpaceX, Planet Labs', 'Success', 15600, 15600),\n"," ('F9 B5 B1049.7', 'CCAFS SLC-40', 'SpaceX', 'Success', 15600, 15600),\n"," ('F9 B5 B1051.3', 'CCAFS SLC-40', 'SpaceX', 'Success', 15600, 15600),\n"," ('F9 B5 B1051.4', 'KSC LC-39A', 'SpaceX', 'Success', 15600, 15600),\n"," ('F9 B5 B1051.6', 'KSC LC-39A', 'SpaceX', 'Success', 15600, 15600),\n"," ('F9 B5 B1056.4', 'CCAFS SLC-40', 'SpaceX', 'Failure', 15600, 15600),\n"," ('F9 B5 B1058.3', 'KSC LC-39A', 'SpaceX', 'Success', 15600, 15600),\n"," ('F9 B5 B1060.2', 'KSC LC-39A', 'SpaceX', 'Success', 15600, 15600),\n"," ('F9 B5 B1060.3', 'CCAFS SLC-40', 'SpaceX', 'Success', 15600, 15600)]"]},"metadata":{},"execution_count":13}],"metadata":{}},{"cell_type":"markdown","source":["### Task 9\n","\n","##### List the failed landing_outcomes in drone ship, their booster versions, and launch site names for the in year 2015\n"],"metadata":{}},{"cell_type":"code","execution_count":15,"source":["%sql select Date, Booster_version, Launch_site, Landing__outcome from VRK08248.SPACEX where Landing__outcome = 'Failure (drone ship)' And Date like '%2015%';"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>DATE</th>\n","        <th>booster_version</th>\n","        <th>launch_site</th>\n","        <th>landing__outcome</th>\n","    </tr>\n","    <tr>\n","        <td>2015-10-01</td>\n","        <td>F9 v1.1 B1012</td>\n","        <td>CCAFS LC-40</td>\n","        <td>Failure (drone ship)</td>\n","    </tr>\n","    <tr>\n","        <td>2015-04-14</td>\n","        <td>F9 v1.1 B1015</td>\n","        <td>CCAFS LC-40</td>\n","        <td>Failure (drone ship)</td>\n","    </tr>\n","</table>"],"text/plain":["[(datetime.date(2015, 10, 1), 'F9 v1.1 B1012', 'CCAFS LC-40', 'Failure (drone ship)'),\n"," (datetime.date(2015, 4, 14), 'F9 v1.1 B1015', 'CCAFS LC-40', 'Failure (drone ship)')]"]},"metadata":{},"execution_count":15}],"metadata":{}},{"cell_type":"markdown","source":["### Task 10\n","\n","##### Rank the count of landing outcomes (such as Failure (drone ship) or Success (ground pad)) between the date 2010-06-04 and 2017-03-20, in descending order\n"],"metadata":{}},{"cell_type":"code","execution_count":18,"source":["%sql select Landing__outcome, count(landing__outcome) as landing_counts from VRK08248.SPACEX where  Date Between '2010-06-05' And '2017-03-20' group by LANDING__OUTCOME;"],"outputs":[{"output_type":"stream","name":"stdout","text":[" * ibm_db_sa://vrk08248:***@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud:32731/bludb\n","Done.\n"]},{"output_type":"execute_result","data":{"text/html":["<table>\n","    <tr>\n","        <th>landing__outcome</th>\n","        <th>landing_counts</th>\n","    </tr>\n","    <tr>\n","        <td>Controlled (ocean)</td>\n","        <td>3</td>\n","    </tr>\n","    <tr>\n","        <td>Failure (drone ship)</td>\n","        <td>5</td>\n","    </tr>\n","    <tr>\n","        <td>Failure (parachute)</td>\n","        <td>1</td>\n","    </tr>\n","    <tr>\n","        <td>No attempt</td>\n","        <td>9</td>\n","    </tr>\n","    <tr>\n","        <td>Precluded (drone ship)</td>\n","        <td>1</td>\n","    </tr>\n","    <tr>\n","        <td>Success (drone ship)</td>\n","        <td>5</td>\n","    </tr>\n","    <tr>\n","        <td>Success (ground pad)</td>\n","        <td>5</td>\n","    </tr>\n","    <tr>\n","        <td>Uncontrolled (ocean)</td>\n","        <td>2</td>\n","    </tr>\n","</table>"],"text/plain":["[('Controlled (ocean)', 3),\n"," ('Failure (drone ship)', 5),\n"," ('Failure (parachute)', 1),\n"," ('No attempt', 9),\n"," ('Precluded (drone ship)', 1),\n"," ('Success (drone ship)', 5),\n"," ('Success (ground pad)', 5),\n"," ('Uncontrolled (ocean)', 2)]"]},"metadata":{},"execution_count":18}],"metadata":{}},{"cell_type":"markdown","source":["### Reference Links\n","\n","*   <a href =\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Labs_Coursera_V5/labs/Lab%20-%20String%20Patterns%20-%20Sorting%20-%20Grouping/instructional-labs.md.html?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDS0321ENSkillsNetwork26802033-2021-01-01&origin=www.coursera.org\">Hands-on Lab : String Patterns, Sorting and Grouping</a>\n","\n","*   <a  href=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Labs_Coursera_V5/labs/Lab%20-%20Built-in%20functions%20/Hands-on_Lab__Built-in_Functions.md.html?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDS0321ENSkillsNetwork26802033-2021-01-01&origin=www.coursera.org\">Hands-on Lab: Built-in functions</a>\n","\n","*   <a  href=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Labs_Coursera_V5/labs/Lab%20-%20Sub-queries%20and%20Nested%20SELECTs%20/instructional-labs.md.html?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDS0321ENSkillsNetwork26802033-2021-01-01&origin=www.coursera.org\">Hands-on Lab : Sub-queries and Nested SELECT Statements</a>\n","\n","*   <a href=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Module%205/DB0201EN-Week3-1-3-SQLmagic.ipynb?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDS0321ENSkillsNetwork26802033-2021-01-01\">Hands-on Tutorial: Accessing Databases with SQL magic</a>\n","\n","*   <a href= \"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Module%205/DB0201EN-Week3-1-4-Analyzing.ipynb?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDS0321ENSkillsNetwork26802033-2021-01-01\">Hands-on Lab: Analyzing a real World Data Set</a>\n"],"metadata":{}},{"cell_type":"markdown","source":["## Author(s)\n","\n","<h4> Lakshmi Holla </h4>\n"],"metadata":{}},{"cell_type":"markdown","source":["## Other Contributors\n","\n","<h4> Rav Ahuja </h4>\n"],"metadata":{}},{"cell_type":"markdown","source":["## Change log\n","\n","| Date       | Version | Changed by    | Change Description        |\n","| ---------- | ------- | ------------- | ------------------------- |\n","| 2021-08-24 | 0.3     | Lakshmi Holla | Added library update      |\n","| 2021-07-09 | 0.2     | Lakshmi Holla | Changes made in magic sql |\n","| 2021-05-20 | 0.1     | Lakshmi Holla | Created Initial Version   |\n"],"metadata":{}},{"cell_type":"markdown","source":["## <h3 align=\"center\"> © IBM Corporation 2021. All rights reserved. <h3/>\n"],"metadata":{}}],"metadata":{"kernelspec":{"name":"python3","display_name":"Python 3.8","language":"python"},"language_info":{"name":"python","version":"3.8.10","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":4}