BY: Muhammad Anas

Published on
Scene 1 (0s)

IBM Developer SKILLS NETWORK. BY: Muhammad Anas.

Scene 2 (9s)

2. OUTLINE. EXECUTIVE SUMMAR INTRODUCTION METHODOLOGY.

Scene 3 (17s)

3. SUMMARY OF METHODOLOGIES 1. Data collection via APIs & web scraping 2. Data wrangling & Exploratory Data Analysis (EDA) & data visualization 3. Dynamic data visualization & analysis with Folium 4. Data Modeling with classification models SUMMARY OF ALL RESULTS 1. Analysis with SQL 2. EDA 3. Interactive visual analytics 4. Predictive analyst.

Scene 4 (35s)

4. Introduction. Project background and context SpaceX advertised its Falcon 9 rocket launch at a cost of $62 million; Other companies cost more than $165 million. Unlike other rocket providers, SpaceX's Falcon 9 Can recover the first stage. Sometimes the first stage does not land. Sometimes it will crash. With most of the savings from first stage so if we can determine whether the first stage will land, we can determine the cost of the launch Problems you want to find answers What is the successful rate of landing ? Can weather affect the launch? Which condition is the most important for success.

Scene 5 (1m 2s)

5. IBM. DATA COLLECTION DATA WRANGLING EDA INTERACTIVE VISUAL ANALYTICS MODELS.

Scene 6 (1m 10s)

APIs Using SpaceX APIs to access the data we need, then via Request library to return a json format text . Code snippet spacex_url = https:// api.spacexdata.com/v4/launches/past response = requests.get ( spacex_url ) print( response.content ) [output] b '[,"links":," reddit ":," flickr ":," presskit ": null,"webcast":"https ://www.youtube.com/ watch?v =0a_00nJ_Y88 ",”… Then using these row data to transform to json format and product a data frame . response = requests.get ( static_json_url ). json () [output] [, 'links':, ' reddit ': {'campaign': None, 'launch': None, 'media': None ,…] GitHub.

Scene 7 (2m 11s)

Web Scraping Scraping data from Wikipedia. Code snippet static_url = https://en.wikipedia.org/w/index.php ? title=List_of_Falcon_9_and_Falcon_Heavy_launches&oldid=1027686922 response = requests.get ( static_url ). text print(response) [output] <!DOCTYPE html> <html class="client- nojs " lang ="en" dir =" ltr "> <head> <meta charset="UTF-8"/> <title>List of Falcon 9 and Falcon Heavy launches - Wikipedia</title> <script> document.documentElement.className =" clientjs ";RLCONF={" wgBreakFrames ":!1,"wgSeparatorTransformTable":["",""]," wgDigitTransformTable ":["",""]," wgDefaultDateFo rmat ":" dmy "," wgMonthNames ":[""," January","February","Marc … # Use BeautifulSoup () to create a BeautifulSoup object from a response text content soup = BeautifulSoup (response, ' html.parser ’) # Use the find_all function in the BeautifulSoup object, with element type `table` html_tables = soup.find_all ('table') print( html_tables ) [output] <table class=" wikitable plainrowheaders collapsible" style="width: 100%;"> < tbody >< tr > < th scope="col">Flight No. </ th > < th scope="col">Date and< br />time (<a href ="/wiki/ Coordinated_Universal_Time " title="Coordinated Universal Time">UTC</a>) </ th >… GitHub.

Scene 8 (2m 55s)

DATA COLLECTION. 1 2 3 4 Flight No. 2 3 4 5 Launch CCAFS CCAFS CCAFS CCAFS CCAFS Dragon Spacecraft Qualification Unit Dragon Dragon spacex CRS-I spacex CRS-2 Payload o 525 kg 4,700kg 4,877 kg Orbit LEO LEO LEO LEO LEO Customer SpaceX NASA NASA NASA NASA Launch Swcess\n Success Success Success\n F9v1.0B0003.1 F9v1.OB0004.1 F9v1.OB0005.1 F9v1.OB0006.1 F9v1.OB0007.1 Booster landing Failure Failure No attempt\n No attempt No attemptin Date 4 June 2010 8 December 2010 22 2012 8 October 2012 1 March 2013 Time 18:45 15:43 07:44 00:35 15:10.

Scene 9 (3m 13s)

Data wrangling. The process of cleaning, organizing, and unifying raw, complex, unorganized data sets so that they are more accessible for future data analysis. dft . value counts ( ) The Number and occurrence of mission outcome per orbit landing class 'Outcome' J . apply (lambda x : if x in bad outcomes else 1) landing class (output j 2 The Number Of Launches on each site df [ LaunchSite J . value_counts ( ) (output j CCAFS SLC 40 KSC LC 39Ä VAFB SLC 4E 55 22 13 type landing outcomes = landing outcomes 'Outcome' . value 3 4 counts ( ) {output] CCAFS SLC 40 KSC LC 39A VAFB SLC 4E The number and occurrence of each orbit 55 22 23 (output j True ASDS None None True RTLS False ASDS True Ocean None ASDS False Ocean False RTLS Create a landing outcome label from Outcome column 41 19 14 6 5 2 2 1.

Scene 10 (3m 38s)

Data wrangling. Date BoosterVersion PayloadMass 6104,959412 525.woo 3170,ü0Ø Orbit LaunchSite Outcome Flights GridFins Legs Block 2 3 4 2012- 2 05-22 2013. 3 03-01 2013. 4 09-29 2013- 5 12-0 Falcon 9 Falcon 9 Falcon 9 Falcon 9 Falcon 9 LEO LEO ISS GTO CCAFS SLC 40 CCAFS SLC 40 CCAFS SLC 40 VAFBSLC 4E CCAFS SLC 40 None None None None None None False None None 1 1 1 1 1 False False False False False False False False False False False False False False False NaN NaN NaN NaN NaN 1.0 1.0 1.0 0 Blü O BlØ4.

Scene 11 (3m 52s)

11. EDA with Data Visualization.

Scene 12 (3m 59s)

12. 1. Display the names of the unique launch sites in the space mission 2.Display 5 records where launch sites begin with the string 'CCA' 3.Display the total payload mass carried by boosters launched by NASA (CRS) 4.Display average payload mass carried by booster version F9 v1.1 5.List the date when the first successful landing outcome in ground pad was achieved 6.List the names of the boosters which have success in drone ship and have payload mass greater than 4000 but less than 6000 7.List the total number of successful and failure mission outcomes.

Scene 13 (4m 27s)

13. 8.List the names of the booster versions which have carried the maximum payload mass. 9. List the failed landing outcomes in drone ship, their booster versions, and launch site names for in year 2015 10.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.

Scene 14 (4m 47s)

14. Build an Interactive Map with Folium. an center NASA the the.

Scene 15 (4m 54s)

15. Results. Decision Tree KNN SVM Logistic_Rgression Accuracy 0.887500 0.848214 0.848214 0.846429 not.

Scene 16 (5m 3s)

Section 2.

Scene 17 (5m 9s)

17. Different launch sites have different success rates. CCAFS LC-40, has a success rate of 60 %, while KSC LC-39A and VAFB SLC 4E has a success rate of 77%.

Scene 18 (5m 23s)

18. The VAFB-SLC launch site there are no rockets launched for heavy payload mass (greater than 10000)..

Scene 19 (5m 34s)

19. Show a bar chart for the success rate of each orbit type Show the screenshot of the scatter plot with explanations.

Scene 20 (5m 46s)

20. In the LEO orbit the success appears related to the number of flights; on the other hand, there seems to be no relationship between flight number when in GTO orbit..

Scene 21 (6m 0s)

21. In the LEO orbit the success appears related to the number of flights; on the other hand, there seems to be no relationship between flight number when in GTO orbit..

Scene 22 (6m 14s)

22. The success rate since 2013 kept increasing till 2020.

Scene 23 (6m 23s)

23. Display the names of the unique launch sites in the space mission.

Scene 24 (6m 35s)

24. Display records where launch sites begin with the string 'CCA'.

Scene 25 (6m 55s)

25. Display the total payload mass carried by boosters launched by NASA (CRS).

Scene 26 (7m 7s)

26. Display average payload mass carried by booster version F9 v1.1.

Scene 27 (7m 18s)

27. List the names of the boosters which have success in drone ship and have payload mass greater than 4000 but less than 600.

Scene 28 (7m 35s)

28. 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.

Scene 29 (7m 53s)

Section 3.

Scene 30 (7m 59s)

30. All of launch sites are closed coasts of the United States..

Scene 31 (8m 8s)

31. The green markers represent the successful launches, and the red markers represent the fail launches..

Scene 32 (8m 23s)

32. Show the distances between CCAFS SLC 40 and coast, KSC LC 39A and highways. etc..

Scene 33 (8m 39s)

Section 4.

Scene 34 (8m 45s)

34. DASHBOARD. SpaceX Launch Records Dashboard.

Scene 35 (8m 52s)

35. DASHBOARD. SpaceX Launch Records Dashboard Total Launch for a Site.

Scene 36 (8m 59s)

36. The successful rate of low weighted payloads is better than high weighted payloads.

Scene 37 (9m 10s)

Section 5.

Scene 38 (9m 15s)

38. Classification Accuracy. 08 06 04 00 Models LqistK_Rvessjon.

Scene 39 (9m 22s)

39. All models’ performance are same in this project: Sensitivity : TP / (TP + FN) = 12 / (12 + 0) = 100 % Specificity: TN / (TN + FP) = 3 / (3 + 3) = 50 % Precision: TP / (TP + FP) = 12 / (12 + 3) = 80% Accuracy : (TP + TN) / (TP + TN + FP + FN) = (12 + 3) / (12 + 3 + 3 + 0) = 83.33%.

Scene 40 (9m 41s)

40. Overview the project: o different launch sites have different success rates . 1. CCAFS LC-40, has a success rate of 60 %, while KSC LC-39A and VAFB SLC 4E has a success rate of 77 %. 2. the VAFB-SLC launchsite there are no rockets launched for heavypayload mass(greater than 10000). 3. in the LEO orbit the Success appears related to the number of flights; on the other hand, there seems to be no relationship between flight number when in GTO orbit. 4. Orbits ES-L1, DEO, HEO, and SSO had highest successful rate. 5. KSC LC-39A had the best successful launches, but with increasing payload mass it seems to have negative impact on success. 6. the success rate since 2013 kept increasing till 2020. 7 . Decision tree model has a best performance..