1. 学ぶ
    2. /
  2. コース
    3. /
  3. ETL and ELT in Python
Connected

演習

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.

指示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.