Graded Quiz: Data Collection API with Webscraping :Applied Data Science Capstone (Applied Data Science Specialization) Answers 2025

1.1. Question 1
After you performed a GET request on the Space X API and convert the response to a dataframe using pd.json_normalize. What year is located in the first row in the column static_fire_date_utc?

• ✅ 2006

• ❌ 2008

• ❌ 2010

• ❌ 2012

Explanation: The first row’s static_fire_date_utc value contains the year 2006.

---

1.2. Question 2
Using the API, how many Falcon 9 launches are there after we remove Falcon 1 launches?

• ✅ 90

• ❌ 64

• ❌ 117

• ❌ 132

Explanation: After filtering out Falcon 1 launches from the API dataset, the count of Falcon 9 launches in the lab dataset is 90.

---

1.3. Question 3
At the end of the API data collection process, how many missing values are there for the column landingPad?

• ✅ 26

• ❌ 10

• ❌ 0

• ❌ 42

Explanation: After the data-collection and cleaning steps, the landingPad column contains 26 missing values.

---

1.4. Question 4
After making a request to the Falcon9 Launch Wiki page and creating a BeautifulSoup object what is the output of:

soup.title

• ❌ < td colspan="9" > First flight of Falcon 9 v1.0. < sup class="reference" id="cite_ref-sfn20100604_17-0">

• ❌ <table class="wikitable plainrowheaders collapsible" style="width: 100%;">

• ✅ <title> List of Falcon 9 and Falcon Heavy launches - Wikipedia </title>

• ❌ (other HTML fragments)

Explanation: soup.title returns the page <title> tag; for the Falcon 9/Heavy launches wiki page it is <title> List of Falcon 9 and Falcon Heavy launches - Wikipedia </title>.

---

🧾 Summary Table