Exploring and Transforming JSON Schemas

Introduction

In this lesson, you'll formalize how to explore a JSON file whose structure and schema is unknown to you. This often happens in practice when you are handed a file or stumble upon one with little documentation.

Objectives

You will be able to:

• Use the JSON module to load and parse JSON documents
• Load and explore unknown JSON schemas
• Convert JSON to a pandas dataframe

Loading the JSON file

Load the data from the file disease_data.json.

#Your code here 

Explore the first and second levels of the schema hierarchy

#Your code here

Convert to a DataFrame

Create a DataFrame from the JSON file. Be sure to retrive the column names for the dataframe. (Search within the 'meta' key of the master dictionary.) The DataFrame should include all 42 columns.

#Your code here

Level-Up

Create a bar graph of states with the highest asthma rates for adults age 18+

Summary

Well done! In this lab you got some extended practice exploring the structure of JSON files, converting json files to pandas DataFrame, and visualizing data!