使用Python pandas提取嵌套的JSON数据

import pandas as pd
import json

data = '''
{
  "name": "John",
  "age": 30,
  "address": {
    "street": "123 Main St",
    "city": "New York",
    "state": "NY"
  },
  "hobbies": ["reading", "traveling"]
}
'''

json_data = json.loads(data)

df = pd.json_normalize(json_data)

print(df)