Pandas — Read JSON

Read JSON

import pandas as pd

# From file
df = pd.read_json('data.json')

# From string
json_str = '[{"name": "Alice", "age": 25}, {"name": "Bob", "age": 30}]'
df = pd.read_json(json_str)

Write JSON

df.to_json('output.json')
df.to_json('output.json', orient='records')

Nested JSON

import json

with open('nested.json') as f:
    data = json.load(f)

df = pd.json_normalize(data, record_path='items')

JSON options

# Different orientations
df.to_json(orient='records')   # [{col: val}, ...]
df.to_json(orient='columns')   # {col: {idx: val}}
df.to_json(orient='index')     # {idx: {col: val}}

Mini Practice

1. Read JSON file
2. Write JSON file
3. Handle nested JSON
4. Use different orientations

Up Next

Continue with Excel - Working with Excel files.