使用python将JSON提取到dataframe

import pandas as pd
import json

# 从JSON文件中读取
with open('data.json') as f:
    data = json.load(f)

# 或者，将JSON字符串转换为字典
json_str = '{"name": "John", "age": 30, "city": "New York"}'
data = json.loads(json_str)

df = pd.DataFrame.from_dict(data, orient='index').T

df = pd.json_normalize(data)

import pandas as pd
import json

# 从JSON文件中读取
with open('data.json') as f:
    data = json.load(f)

# 或者，将JSON字符串转换为字典
json_str = '{"name": "John", "age": 30, "city": "New York"}'
data = json.loads(json_str)

# 将字典转换为DataFrame
df = pd.DataFrame.from_dict(data, orient='index').T

# 或者，展平处理包含嵌套结构的JSON
df = pd.json_normalize(data)