JSON - Lab

Introduction

In this lab, you'll practice navigating JSON data structures.

Objectives

You will be able to:

• Use the JSON module to load and parse JSON documents

JSON

Open the dataset from json

#Your code here

What is the root data type of the json file?

### Your code here

Navigate to the 'data' key of your loaded json object. What data type is this?

#Your code here

Preview the first entry from the value returned by the 'data' key above.

#Your code here

Preview the Entry under meta -> view -> columns (the keys of three successively nested dictionaries)

# Your code here

Create a DataFrame from your json data

The previous two questions previewed one entry from the data object within the json file, as well as the column details associated with that data from the meta entry within the json file. Both should have 19 entries. Create a pandas DataFrame of the data. Be sure to use the information from the meta entry to add appropriate column names to your DataFrame.

#Your code here

What's wrong with the first row of the DataFrame?

#Your code here

#Your answer here

Summary

Congratulations! You've started exploring some more JSON data structures used for the web and got to practice data munging and exploring!