1. सीखें
  2. /
  3. पाठ्यक्रम
  4. /
  5. 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.