将嵌套字典从json转换为以值为列的dataframe

import pandas as pd
import json

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

flatten_data = {}
for key, value in data.items():
    if isinstance(value, dict):
        for k, v in value.items():
            new_key = key + '_' + k
            flatten_data[new_key] = v
    else:
        flatten_data[key] = value

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