1. Learn
    2. /
  2. Courses
    3. /
  3. ETL and ELT in Python
Connected

Exercise

Reading JSON data into memory

When data is stored in JSON format, it's not always easy to load into a DataFrame. This is the case for the "nested_testing_scores.json" file. Here, the data will have to be manually manipulated before it can be stored in a DataFrame.

To help get you started, pandas has been loaded into the workspace as pd.

Instructions 1/2

undefined XP
  • 1
    • Use pandas to read a JSON file into a DataFrame.
    • Pass the "nested_scores.json" file path to the extract() function.
  • 2
    • Import the json library.
    • Use the json library to load the "nested_scores.json" file into memory.