一种将嵌套的json解压到dataframe中的有效方法。

import pandas as pd
import json

# 读取JSON文件或字符串
json_data = '''
{
  "name": "John",
  "age": 30,
  "address": {
    "street": "123 Main St",
    "city": "New York",
    "state": "NY"
  },
  "hobbies": ["reading", "traveling", "sports"]
}
'''

# 解析JSON数据
data = json.loads(json_data)

# 将解析后的数据转换为DataFrame
df = pd.json_normalize(data)

print(df)

  name  age address.street address.city address.state  \
0  John   30    123 Main St     New York            NY   

                          hobbies  
0  [reading, traveling, sports]