{ "cells": [ { "cell_type": "markdown", "metadata": { "collapsed": false }, "source": [ "## Data Collection via GET request from SpaceX API" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# importing libraries\n", "import requests\n", "import pandas as pd\n", "import numpy as np\n", "import datetime" ] }, { "cell_type": "markdown", "metadata": { "collapsed": false }, "source": [ "Defining functions that use the API to extract the specfic columns we need using the launch data's unique identification number\n" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# For Booster Version\n", "def gBV(data):\n", " for x in data['rocket']:\n", " if x:\n", " response = requests.get(\"https://api.spacexdata.com/v4/rockets/\"+str(x)).json()\n", " BoosterVersion.append(response['name'])" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# For Launch Site, Longitude, Latitude\n", "def gLS(data):\n", " for x in data ['launchpad']:\n", " if x:\n", " response = requests.get(\"https://api.spacexdata.com/v4/launchpads/\"+str(x)).json()\n", " Longitude.append(response['longitude'])\n", " Latitude.append(response['latitude'])\n", " LaunchSite.append(response['name'])" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# For Payload mass_kg, orbit\n", "def gpd(data):\n", " for load in data['payloads']:\n", " if load:\n", " response = requests.get(\"https://api.spacexdata.com/v4/payloads/\"+load).json()\n", " PayloadMass.append(response['mass_kg'])\n", " Orbit.append(response['orbit'])" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# For the cores column of the dataset\n", "def gcd(data):\n", " for core in data['cores']:\n", " if core['core'] != None:\n", " response = requests.get(\"https://api.spacexdata.com/v4/cores/\"+core['core']).json()\n", " Block.append(response['block'])\n", " ReusedCount.append(response['reuse_count'])\n", " Serial.append(response['serial'])\n", " else:\n", " Block.append(None)\n", " ReusedCount.append(None)\n", " Serial.append(None)\n", " Outcome.append(str(core['landing_success'])+' '+str(core['landing_type']))\n", " Flights.append(core['flight'])\n", " GridFins.append(core['gridfins'])\n", " Reused.append(core['reused'])\n", " Legs.append(core['legs'])\n", " LandingPad.append(core['landpad'])" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# Requesting data from SpaceX API\n", "\n", "spacex_url=\"https://api.spacexdata.com/v4/launches/past\"\n", "response = requests.get(spacex_url)" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
static_fire_date_utcstatic_fire_date_unixnetwindowrocketsuccessfailuresdetailscrewshipscapsulespayloadslaunchpadflight_numbernamedate_utcdate_unixdate_localdate_precisionupcomingcoresauto_updatetbdlaunch_library_ididfairings.reusedfairings.recovery_attemptfairings.recoveredfairings.shipslinks.patch.smalllinks.patch.largelinks.reddit.campaignlinks.reddit.launchlinks.reddit.medialinks.reddit.recoverylinks.flickr.smalllinks.flickr.originallinks.presskitlinks.webcastlinks.youtube_idlinks.articlelinks.wikipediafairings
02006-03-17T00:00:00.000Z1.142554e+09False0.05e9d0d95eda69955f709d1ebFalse[{'time': 33, 'altitude': None, 'reason': 'merlin engine failure'}]Engine failure at 33 seconds and loss of vehicle[][][][5eb0e4b5b6c3bb0006eeb1e1]5e9e4502f5090995de566f861FalconSat2006-03-24T22:30:00.000Z11432394002006-03-25T10:30:00+12:00hourFalse[{'core': '5e9e289df35918033d3b2623', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}]TrueFalseNone5eb87cd9ffd86e000604b32aFalseFalseFalse[]https://images2.imgbox.com/94/f2/NN6Ph45r_o.pnghttps://images2.imgbox.com/5b/02/QcxHUb5V_o.pngNoneNoneNoneNone[][]Nonehttps://www.youtube.com/watch?v=0a_00nJ_Y880a_00nJ_Y88https://www.space.com/2196-spacex-inaugural-falcon-1-rocket-lost-launch.htmlhttps://en.wikipedia.org/wiki/DemoSatNaN
1NoneNaNFalse0.05e9d0d95eda69955f709d1ebFalse[{'time': 301, 'altitude': 289, 'reason': 'harmonic oscillation leading to premature engine shutdown'}]Successful first stage burn and transition to second stage, maximum altitude 289 km, Premature engine shutdown at T+7 min 30 s, Failed to reach orbit, Failed to recover first stage[][][][5eb0e4b6b6c3bb0006eeb1e2]5e9e4502f5090995de566f862DemoSat2007-03-21T01:10:00.000Z11744394002007-03-21T13:10:00+12:00hourFalse[{'core': '5e9e289ef35918416a3b2624', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}]TrueFalseNone5eb87cdaffd86e000604b32bFalseFalseFalse[]https://images2.imgbox.com/f9/4a/ZboXReNb_o.pnghttps://images2.imgbox.com/80/a2/bkWotCIS_o.pngNoneNoneNoneNone[][]Nonehttps://www.youtube.com/watch?v=Lk4zQ2wP-NcLk4zQ2wP-Nchttps://www.space.com/3590-spacex-falcon-1-rocket-fails-reach-orbit.htmlhttps://en.wikipedia.org/wiki/DemoSatNaN
2NoneNaNFalse0.05e9d0d95eda69955f709d1ebFalse[{'time': 140, 'altitude': 35, 'reason': 'residual stage-1 thrust led to collision between stage 1 and stage 2'}]Residual stage 1 thrust led to collision between stage 1 and stage 2[][][][5eb0e4b6b6c3bb0006eeb1e3, 5eb0e4b6b6c3bb0006eeb1e4]5e9e4502f5090995de566f863Trailblazer2008-08-03T03:34:00.000Z12177344402008-08-03T15:34:00+12:00hourFalse[{'core': '5e9e289ef3591814873b2625', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}]TrueFalseNone5eb87cdbffd86e000604b32cFalseFalseFalse[]https://images2.imgbox.com/6c/cb/na1tzhHs_o.pnghttps://images2.imgbox.com/4a/80/k1oAkY0k_o.pngNoneNoneNoneNone[][]Nonehttps://www.youtube.com/watch?v=v0w9p3U8860v0w9p3U8860http://www.spacex.com/news/2013/02/11/falcon-1-flight-3-mission-summaryhttps://en.wikipedia.org/wiki/Trailblazer_(satellite)NaN
32008-09-20T00:00:00.000Z1.221869e+09False0.05e9d0d95eda69955f709d1ebTrue[]Ratsat was carried to orbit on the first successful orbital launch of any privately funded and developed, liquid-propelled carrier rocket, the SpaceX Falcon 1[][][][5eb0e4b7b6c3bb0006eeb1e5]5e9e4502f5090995de566f864RatSat2008-09-28T23:15:00.000Z12226437002008-09-28T11:15:00+12:00hourFalse[{'core': '5e9e289ef3591855dc3b2626', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}]TrueFalseNone5eb87cdbffd86e000604b32dFalseFalseFalse[]https://images2.imgbox.com/95/39/sRqN7rsv_o.pnghttps://images2.imgbox.com/a3/99/qswRYzE8_o.pngNoneNoneNoneNone[][]Nonehttps://www.youtube.com/watch?v=dLQ2tZEH6G0dLQ2tZEH6G0https://en.wikipedia.org/wiki/Ratsathttps://en.wikipedia.org/wiki/RatsatNaN
4NoneNaNFalse0.05e9d0d95eda69955f709d1ebTrue[]None[][][][5eb0e4b7b6c3bb0006eeb1e6]5e9e4502f5090995de566f865RazakSat2009-07-13T03:35:00.000Z12474561002009-07-13T15:35:00+12:00hourFalse[{'core': '5e9e289ef359184f103b2627', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}]TrueFalseNone5eb87cdcffd86e000604b32eFalseFalseFalse[]https://images2.imgbox.com/ab/5a/Pequxd5d_o.pnghttps://images2.imgbox.com/92/e4/7Cf6MLY0_o.pngNoneNoneNoneNone[][]http://www.spacex.com/press/2012/12/19/spacexs-falcon-1-successfully-delivers-razaksat-satellite-orbithttps://www.youtube.com/watch?v=yTaIDooc8OgyTaIDooc8Oghttp://www.spacex.com/news/2013/02/12/falcon-1-flight-5https://en.wikipedia.org/wiki/RazakSATNaN
\n", "
" ], "text/plain": [ " static_fire_date_utc static_fire_date_unix net window \\\n", "0 2006-03-17T00:00:00.000Z 1.142554e+09 False 0.0 \n", "1 None NaN False 0.0 \n", "2 None NaN False 0.0 \n", "3 2008-09-20T00:00:00.000Z 1.221869e+09 False 0.0 \n", "4 None NaN False 0.0 \n", "\n", " rocket success \\\n", "0 5e9d0d95eda69955f709d1eb False \n", "1 5e9d0d95eda69955f709d1eb False \n", "2 5e9d0d95eda69955f709d1eb False \n", "3 5e9d0d95eda69955f709d1eb True \n", "4 5e9d0d95eda69955f709d1eb True \n", "\n", " failures \\\n", "0 [{'time': 33, 'altitude': None, 'reason': 'merlin engine failure'}] \n", "1 [{'time': 301, 'altitude': 289, 'reason': 'harmonic oscillation leading to premature engine shutdown'}] \n", "2 [{'time': 140, 'altitude': 35, 'reason': 'residual stage-1 thrust led to collision between stage 1 and stage 2'}] \n", "3 [] \n", "4 [] \n", "\n", " details \\\n", "0 Engine failure at 33 seconds and loss of vehicle \n", "1 Successful first stage burn and transition to second stage, maximum altitude 289 km, Premature engine shutdown at T+7 min 30 s, Failed to reach orbit, Failed to recover first stage \n", "2 Residual stage 1 thrust led to collision between stage 1 and stage 2 \n", "3 Ratsat was carried to orbit on the first successful orbital launch of any privately funded and developed, liquid-propelled carrier rocket, the SpaceX Falcon 1 \n", "4 None \n", "\n", " crew ships capsules payloads \\\n", "0 [] [] [] [5eb0e4b5b6c3bb0006eeb1e1] \n", "1 [] [] [] [5eb0e4b6b6c3bb0006eeb1e2] \n", "2 [] [] [] [5eb0e4b6b6c3bb0006eeb1e3, 5eb0e4b6b6c3bb0006eeb1e4] \n", "3 [] [] [] [5eb0e4b7b6c3bb0006eeb1e5] \n", "4 [] [] [] [5eb0e4b7b6c3bb0006eeb1e6] \n", "\n", " launchpad flight_number name \\\n", "0 5e9e4502f5090995de566f86 1 FalconSat \n", "1 5e9e4502f5090995de566f86 2 DemoSat \n", "2 5e9e4502f5090995de566f86 3 Trailblazer \n", "3 5e9e4502f5090995de566f86 4 RatSat \n", "4 5e9e4502f5090995de566f86 5 RazakSat \n", "\n", " date_utc date_unix date_local \\\n", "0 2006-03-24T22:30:00.000Z 1143239400 2006-03-25T10:30:00+12:00 \n", "1 2007-03-21T01:10:00.000Z 1174439400 2007-03-21T13:10:00+12:00 \n", "2 2008-08-03T03:34:00.000Z 1217734440 2008-08-03T15:34:00+12:00 \n", "3 2008-09-28T23:15:00.000Z 1222643700 2008-09-28T11:15:00+12:00 \n", "4 2009-07-13T03:35:00.000Z 1247456100 2009-07-13T15:35:00+12:00 \n", "\n", " date_precision upcoming \\\n", "0 hour False \n", "1 hour False \n", "2 hour False \n", "3 hour False \n", "4 hour False \n", "\n", " cores \\\n", "0 [{'core': '5e9e289df35918033d3b2623', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}] \n", "1 [{'core': '5e9e289ef35918416a3b2624', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}] \n", "2 [{'core': '5e9e289ef3591814873b2625', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}] \n", "3 [{'core': '5e9e289ef3591855dc3b2626', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}] \n", "4 [{'core': '5e9e289ef359184f103b2627', 'flight': 1, 'gridfins': False, 'legs': False, 'reused': False, 'landing_attempt': False, 'landing_success': None, 'landing_type': None, 'landpad': None}] \n", "\n", " auto_update tbd launch_library_id id \\\n", "0 True False None 5eb87cd9ffd86e000604b32a \n", "1 True False None 5eb87cdaffd86e000604b32b \n", "2 True False None 5eb87cdbffd86e000604b32c \n", "3 True False None 5eb87cdbffd86e000604b32d \n", "4 True False None 5eb87cdcffd86e000604b32e \n", "\n", " fairings.reused fairings.recovery_attempt fairings.recovered fairings.ships \\\n", "0 False False False [] \n", "1 False False False [] \n", "2 False False False [] \n", "3 False False False [] \n", "4 False False False [] \n", "\n", " links.patch.small \\\n", "0 https://images2.imgbox.com/94/f2/NN6Ph45r_o.png \n", "1 https://images2.imgbox.com/f9/4a/ZboXReNb_o.png \n", "2 https://images2.imgbox.com/6c/cb/na1tzhHs_o.png \n", "3 https://images2.imgbox.com/95/39/sRqN7rsv_o.png \n", "4 https://images2.imgbox.com/ab/5a/Pequxd5d_o.png \n", "\n", " links.patch.large links.reddit.campaign \\\n", "0 https://images2.imgbox.com/5b/02/QcxHUb5V_o.png None \n", "1 https://images2.imgbox.com/80/a2/bkWotCIS_o.png None \n", "2 https://images2.imgbox.com/4a/80/k1oAkY0k_o.png None \n", "3 https://images2.imgbox.com/a3/99/qswRYzE8_o.png None \n", "4 https://images2.imgbox.com/92/e4/7Cf6MLY0_o.png None \n", "\n", " links.reddit.launch links.reddit.media links.reddit.recovery \\\n", "0 None None None \n", "1 None None None \n", "2 None None None \n", "3 None None None \n", "4 None None None \n", "\n", " links.flickr.small links.flickr.original \\\n", "0 [] [] \n", "1 [] [] \n", "2 [] [] \n", "3 [] [] \n", "4 [] [] \n", "\n", " links.presskit \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 http://www.spacex.com/press/2012/12/19/spacexs-falcon-1-successfully-delivers-razaksat-satellite-orbit \n", "\n", " links.webcast links.youtube_id \\\n", "0 https://www.youtube.com/watch?v=0a_00nJ_Y88 0a_00nJ_Y88 \n", "1 https://www.youtube.com/watch?v=Lk4zQ2wP-Nc Lk4zQ2wP-Nc \n", "2 https://www.youtube.com/watch?v=v0w9p3U8860 v0w9p3U8860 \n", "3 https://www.youtube.com/watch?v=dLQ2tZEH6G0 dLQ2tZEH6G0 \n", "4 https://www.youtube.com/watch?v=yTaIDooc8Og yTaIDooc8Og \n", "\n", " links.article \\\n", "0 https://www.space.com/2196-spacex-inaugural-falcon-1-rocket-lost-launch.html \n", "1 https://www.space.com/3590-spacex-falcon-1-rocket-fails-reach-orbit.html \n", "2 http://www.spacex.com/news/2013/02/11/falcon-1-flight-3-mission-summary \n", "3 https://en.wikipedia.org/wiki/Ratsat \n", "4 http://www.spacex.com/news/2013/02/12/falcon-1-flight-5 \n", "\n", " links.wikipedia fairings \n", "0 https://en.wikipedia.org/wiki/DemoSat NaN \n", "1 https://en.wikipedia.org/wiki/DemoSat NaN \n", "2 https://en.wikipedia.org/wiki/Trailblazer_(satellite) NaN \n", "3 https://en.wikipedia.org/wiki/Ratsat NaN \n", "4 https://en.wikipedia.org/wiki/RazakSAT NaN " ] }, "execution_count": 9, "metadata": { }, "output_type": "execute_result" } ], "source": [ "pd.set_option('display.max_columns', None)\n", "pd.set_option('display.max_colwidth', None)\n", "data=pd.json_normalize(response.json())\n", "data.head()" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# Using the API to get information on launches using the ID's for each launch\n", "data = data[['rocket','payloads','launchpad','cores','flight_number','date_utc']]\n", "\n", "#Filtering out rows with multiple cores - indicating Falcon2 rockets \n", "data = data[data['cores'].map(len)==1]\n", "data = data[data['payloads'].map(len)==1]\n", "\n", "# Both payload and cores are lists of size 1 we take the single value and replace the current feature with the result\n", "data['cores'] = data['cores'].map(lambda x : x[0])\n", "data['payloads'] = data['payloads'].map(lambda x : x[0])\n", "\n", "# Converting the date_utc to datetime, then restricting our launches by the new date\n", "data['date'] = pd.to_datetime(data['date_utc']).dt.date\n", "data = data[data['date'] <= datetime.date(2020, 11, 13)]" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# Creating lists to store the data from our requests\n", "\n", "BoosterVersion = []\n", "PayloadMass = []\n", "Orbit = []\n", "LaunchSite = []\n", "Outcome = []\n", "Flights = []\n", "GridFins = []\n", "Reused = []\n", "Legs = []\n", "LandingPad = []\n", "Block = []\n", "ReusedCount = []\n", "Serial = []\n", "Longitude = []\n", "Latitude = []" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# Calling our defined functions to fill the lists with data \n", "gBV(data)\n", "gLS(data)\n", "gpd(data)\n", "gcd(data)" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
FlightNumberDateBoosterVersionPayloadMassOrbitLaunchSiteOutcomeFlightsGridFinsReusedLegsLandingPadBlockReusedCountSerialLongitudeLatitude
012006-03-24Falcon 120.0LEOKwajalein AtollNone None1FalseFalseFalseNoneNaN0Merlin1A167.7431299.047721
122007-03-21Falcon 1NaNLEOKwajalein AtollNone None1FalseFalseFalseNoneNaN0Merlin2A167.7431299.047721
242008-09-28Falcon 1165.0LEOKwajalein AtollNone None1FalseFalseFalseNoneNaN0Merlin2C167.7431299.047721
352009-07-13Falcon 1200.0LEOKwajalein AtollNone None1FalseFalseFalseNoneNaN0Merlin3C167.7431299.047721
462010-06-04Falcon 9NaNLEOCCSFS SLC 40None None1FalseFalseFalseNone1.00B0003-80.57736628.561857
\n", "
" ], "text/plain": [ " FlightNumber Date BoosterVersion PayloadMass Orbit \\\n", "0 1 2006-03-24 Falcon 1 20.0 LEO \n", "1 2 2007-03-21 Falcon 1 NaN LEO \n", "2 4 2008-09-28 Falcon 1 165.0 LEO \n", "3 5 2009-07-13 Falcon 1 200.0 LEO \n", "4 6 2010-06-04 Falcon 9 NaN LEO \n", "\n", " LaunchSite Outcome Flights GridFins Reused Legs LandingPad \\\n", "0 Kwajalein Atoll None None 1 False False False None \n", "1 Kwajalein Atoll None None 1 False False False None \n", "2 Kwajalein Atoll None None 1 False False False None \n", "3 Kwajalein Atoll None None 1 False False False None \n", "4 CCSFS SLC 40 None None 1 False False False None \n", "\n", " Block ReusedCount Serial Longitude Latitude \n", "0 NaN 0 Merlin1A 167.743129 9.047721 \n", "1 NaN 0 Merlin2A 167.743129 9.047721 \n", "2 NaN 0 Merlin2C 167.743129 9.047721 \n", "3 NaN 0 Merlin3C 167.743129 9.047721 \n", "4 1.0 0 B0003 -80.577366 28.561857 " ] }, "execution_count": 13, "metadata": { }, "output_type": "execute_result" } ], "source": [ "# Constructing a dictionary from our lists that now have the our requested data\n", "\n", "launch_dct = {'FlightNumber': list(data['flight_number']),\n", "'Date': list(data['date']),\n", "'BoosterVersion':BoosterVersion,\n", "'PayloadMass':PayloadMass,\n", "'Orbit':Orbit,\n", "'LaunchSite':LaunchSite,\n", "'Outcome':Outcome,\n", "'Flights':Flights,\n", "'GridFins':GridFins,\n", "'Reused':Reused,\n", "'Legs':Legs,\n", "'LandingPad':LandingPad,\n", "'Block':Block,\n", "'ReusedCount':ReusedCount,\n", "'Serial':Serial,\n", "'Longitude': Longitude,\n", "'Latitude': Latitude}\n", "\n", "# Creating a pandas df from our newly created dictionary\n", "df=pd.DataFrame(launch_dct)\n", "df.head()" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
FlightNumberDateBoosterVersionPayloadMassOrbitLaunchSiteOutcomeFlightsGridFinsReusedLegsLandingPadBlockReusedCountSerialLongitudeLatitude
412010-06-04Falcon 9NaNLEOCCSFS SLC 40None None1FalseFalseFalseNone1.00B0003-80.57736628.561857
522012-05-22Falcon 9525.0LEOCCSFS SLC 40None None1FalseFalseFalseNone1.00B0005-80.57736628.561857
632013-03-01Falcon 9677.0ISSCCSFS SLC 40None None1FalseFalseFalseNone1.00B0007-80.57736628.561857
742013-09-29Falcon 9500.0POVAFB SLC 4EFalse Ocean1FalseFalseFalseNone1.00B1003-120.61082934.632093
852013-12-03Falcon 93170.0GTOCCSFS SLC 40None None1FalseFalseFalseNone1.00B1004-80.57736628.561857
\n", "
" ], "text/plain": [ " FlightNumber Date BoosterVersion PayloadMass Orbit LaunchSite \\\n", "4 1 2010-06-04 Falcon 9 NaN LEO CCSFS SLC 40 \n", "5 2 2012-05-22 Falcon 9 525.0 LEO CCSFS SLC 40 \n", "6 3 2013-03-01 Falcon 9 677.0 ISS CCSFS SLC 40 \n", "7 4 2013-09-29 Falcon 9 500.0 PO VAFB SLC 4E \n", "8 5 2013-12-03 Falcon 9 3170.0 GTO CCSFS SLC 40 \n", "\n", " Outcome Flights GridFins Reused Legs LandingPad Block \\\n", "4 None None 1 False False False None 1.0 \n", "5 None None 1 False False False None 1.0 \n", "6 None None 1 False False False None 1.0 \n", "7 False Ocean 1 False False False None 1.0 \n", "8 None None 1 False False False None 1.0 \n", "\n", " ReusedCount Serial Longitude Latitude \n", "4 0 B0003 -80.577366 28.561857 \n", "5 0 B0005 -80.577366 28.561857 \n", "6 0 B0007 -80.577366 28.561857 \n", "7 0 B1003 -120.610829 34.632093 \n", "8 0 B1004 -80.577366 28.561857 " ] }, "execution_count": 14, "metadata": { }, "output_type": "execute_result" } ], "source": [ "# Filtering out Falcon 1 Launches by making a new dataframe\n", "f9df = df[df['BoosterVersion']!= 'Falcon 1']\n", "f9df.loc[:,'FlightNumber'] = list(range(1, f9df.shape[0]+1))\n", "f9df.head()" ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "collapsed": false }, "outputs": [ ], "source": [ "# Downloading our dataframe to a CSV file\n", "\n", "f9df.to_csv('dataset_p1_API.csv', index=False)" ] } ], "metadata": { "kernelspec": { "argv": [ "/usr/bin/python3", "-m", "ipykernel", "--HistoryManager.enabled=False", "--matplotlib=inline", "-c", "%config InlineBackend.figure_formats = set(['retina'])\nimport matplotlib; matplotlib.rcParams['figure.figsize'] = (12, 7)", "-f", "{connection_file}" ], "display_name": "Python 3 (system-wide)", "env": { }, "language": "python", "metadata": { "cocalc": { "description": "Python 3 programming language", "priority": 100, "url": "https://www.python.org/" } }, "name": "python3", "resource_dir": "/ext/jupyter/kernels/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.10.12" } }, "nbformat": 4, "nbformat_minor": 4 }