Python Project for Data Engineering Coursera Quiz Answers

Data Engineering Capstone Project Week 01 Quiz Answers

Quiz 01: Web scraping

Q1. From the lab you were asked to print out the output of the following line, and remember it as it will be a quiz question:

‘List of largest banks -‘
‘List of largest banks ‘
‘<!DOCTYPE html>\n<html cla’

Q2. Using the contents and beautiful soup load the data from the By market capitalization table into a pandas dataframe. The dataframe should have the country Name and Market Cap (US$ Billion) as column names. Display the first five rows using head.

Q3. True or False If the website changes your output will remain the same

False
True

Quiz 02: Extracting Data using API

Q1. Using the requests library call the endpoint given in the preceding lab, remember the first few characters of the output:

“rates”:
“CAD”
“KRW”

Q2. In the lab you used the data gathered and turned it into a pandas dataframe. The dataframe should have the Currency as the index and Rate as the columns. Make sure to drop unnecessary columns. What is the correct format of the index and column names

Q3. In the lab, you converted the data into a csv, but the data at the endpoint itself is best describes as: