New York Solar Resource Data
- Guided Project
- 0.1 hours
- Intermediate
- R
Practice extracting solar resource data from an API, parsing JSON responses, and converting complex lists into dataframes in R.
Overview
In this project, you'll assume the role of a data analyst tasked with extracting solar resource data for New York City using the Data Gov API. You'll apply your skills in API querying, JSON parsing, and data structure manipulation in R to retrieve the data and convert it into a suitable format for analysis.
This hands-on project allows you to combine the key concepts covered in the APIs and Web Scraping in R course, providing practical experience in extracting and preparing real-world data from web APIs. You'll gain valuable data wrangling skills as you work through the challenges of parsing complex JSON responses and converting nested list structures into a dataframe.
Objective: Use R to extract New York City solar resource data from the Data Gov API, parse the JSON response, and convert it into a dataframe for analysis.
What You'll Learn
- ✓ Expand your portfolio with a guided API project
- ✓ Overcome common setbacks in data analysis
Before You Start
- ✓ Querying data from external APIs
- ✓ Making API requests in R
- ✓ Parsing JSON responses from APIs
- ✓ Working with the JSON data format
- ✓ Authenticating with APIs that require authentication
Project Steps
10 steps
- 1 Introduction
- 2 Finding the Suitable Endpoint and Parameters to Query the API
- 3 Extracting the New York Solar Resource Data
- 4 Parsing the JSON into an R Object
- 5 How to Create a Dataframe from a Complex List
- 6 Building a Dataframe from a Complex List
- 7 Extracting a Dataframe from a Complex List
- 8 Putting It All together
- 9 Visualizing New York City Solar Resource Data
- 10 Next Steps
Join 1M+ data learners on Dataquest.
- 1
Create a free account
- 2
Choose a learning path
- 3
Complete exercises and projects
- 4
Advance your career