将JSON转换为Pandas dataframe，允许复杂的dict结构

import json
import pandas as pd

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

def flatten_dict(d, parent_key='', sep='_'):
    items = []
    for k, v in d.items():
        new_key = f"{parent_key}{sep}{k}" if parent_key else k
        if isinstance(v, dict):
            items.extend(flatten_dict(v, new_key, sep=sep).items())
        else:
            items.append((new_key, v))
    return dict(items)

flat_data = flatten_dict(data)

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