From the course: Data Pipeline Automation with GitHub Actions Using R and Python
Challenge: Query the API - GitHub Tutorial
From the course: Data Pipeline Automation with GitHub Actions Using R and Python
Challenge: Query the API
(upbeat music) - [Instructor] We will conclude this chapter with practicing what we learned so far, using the EIA dashboard to extract metadata and querying the data from the API using R or Python. This time we're going to pull data of the San Diego Gas and Electricity balancing authority subregion. Start by going to the EIA dashboard to extract the metadata of the San Diego Gas and Electricity balancing authority subregion. This subregion is under the California Independent System Operator parent. Then with R or Python, set a GET request to pull observation between January 1st and January 31st, 2024. Last but not least, use the eia_backfill function to pull the data from January 1st, 2020 to February 1st, 2024.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
EIA API2m 47s
-
Setting an environment variable3m 22s
-
The EIA API dashboard4m 10s
-
GET request structure5m 41s
-
Querying the data via the browser4m 4s
-
Querying data with R and Python2m 50s
-
Pulling metadata from API with R3m 5s
-
Sending a simple GET request with R5m 19s
-
API limitations with R4m 43s
-
Handling a large data request with R4m 27s
-
Pulling metadata from API with Python3m 47s
-
Sending a simple GET request with Python4m 44s
-
API limitations with Python3m 54s
-
Handling a large data request with Python3m 10s
-
Challenge: Query the API1m 2s
-
Solution: Query the API with R7m 28s
-
Solution: Query the API with Python7m 45s
-
-
-
-
-
