Loading a JSON file in Python

JSON is the king of APIs, config files, NoSQL databases, and web data.
With Python’s built-in json module (or pandas), you go from file to usable data in seconds

# Import json module (built-in, no install needed!)
import json

# Or import pandas if you want it directly as a DataFrame
import pandas as pd

# Your JSON file path
filename = "data.json"

# Load JSON file into a Python dictionary/list
with open(filename, "r", encoding="utf-8") as file:
    data = json.load(file)

# Quick look at structure and first few items
print(type(data))        # usually dict or list
print(data.keys() if isinstance(data, dict) else len(data))

# Load the json file
df = pd.read_json(filename)         


df.head()

👉Join @datascience_bds for more
Part of the @bigdataspecialist family