Python & Pandas:使用pd.json_normalize扁平化嵌套json

nested_json = {
    "id": 1,
    "name": "John Doe",
    "contact": {
        "email": "john.doe@example.com",
        "phone_numbers": [
            {"type": "home", "number": "123-456-7890"},
            {"type": "work", "number": "098-765-4321"}
        ]
    },
    "orders": [
        {"order_id": 101, "product": "Widget", "quantity": 2},
        {"order_id": 102, "product": "Gadget", "quantity": 1}
    ]
}

import pandas as pd

# 扁平化嵌套的 JSON 数据
df = pd.json_normalize(nested_json, sep='_')

print(df)

   id       name contact_email contact_phone_numbers_0_type contact_phone_numbers_0_number contact_phone_numbers_1_type contact_phone_numbers_1_number orders_0_order_id orders_0_product orders_0_quantity orders_1_order_id orders_1_product orders_1_quantity
0   1  John Doe john.doe@example.com                     home                     123-456-7890                     work                     098-765-4321                   101          Widget                  2                   102          Gadget                  1

df = pd.json_normalize(nested_json, sep='_', errors='ignore')