API and Data Handling Quiz

What is the purpose of the headers dictionary in an API request?

• It stores the data we want to send.

• It holds the response from the server.

• It contains metadata like content-type and API keys.

• It initializes the HTTPS connection.

What does the http.client.HTTPSConnection("api.collectapi.com") line do?

• Sends data to the server.

• Creates a JSON object.

• Opens a secure connection to the API’s domain.

• Converts JSON to a DataFrame.

What is the role of .decode('utf-8') when handling the API response?

• It encrypts the data.

• It converts the response to a dictionary.

• It reads the headers.

• It converts bytes into a readable string.

What does json.loads() do?

• Saves data into a CSV.

• Parses a string and returns a Python dictionary.

• Sends a GET request.

• Converts a list into a dictionary.

In the line pd.DataFrame(cities_data), what is cities_data expected to be?

• A single string

• A dictionary with nested keys

• A list of dictionaries (like [{}, {}, {}])

• A list of strings

The HTTP method used to fetch data from a server is usually _______.

The pandas method used to rename a column is df.________(columns={'old': 'new'}).

To remove a column called "lowerName" from the DataFrame, you would use: df = df.________(columns=['lowerName'])

The df.head() method shows the first ______ rows of a DataFrame by default.

The JSON path to access city gas price data in this project is: parsed_data['______']['cities']