Making an API request

Forecasting systems start with a data pipeline that gathers new data from an API or other data source. In this exercise, you'll create the URL link and send a request to the EIA API to retrieve electricity data.

Note that working with the EIA API requires creating an API key; for this exercise, a demo API key has been set up for you.

The requests, os, and pandas packages, as pd, were imported for you.

This exercise is part of the course

Designing Forecasting Pipelines for Production

View Course

Exercise instructions

Extract the API key from the environment variable, saving it as eia_api_key.
Create the full URL path by combining api_url_path and eia_api_key.
Make the request using the correct method and passing the full link.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Extract the API key from the environment variable
eia_api_key = os.____('EIA_API_KEY')

# Create the full URL path
api_url = "https://api.eia.gov/v2/"
api_path = "electricity/rto/region-data/"
api_url_path = api_url + api_path + "data/&data[]=value"
full_path = ____ + "?api_key=" + ____

# Make the request
data = requests.____(____).json()

df = pd.DataFrame(data["response"]["data"])
print(df.head())

Edit and Run Code