使用python将Excel中的按列JSON数据转换为分层结构

import pandas as pd
import json

df = pd.read_excel('data.xlsx')

data = {}
for column in df.columns:
    json_data = df[column].dropna().tolist()
    data[column] = [json.loads(json_str) for json_str in json_data]

result = {}
for column, json_list in data.items():
    for json_obj in json_list:
        current_level = result
        for key, value in json_obj.items():
            if key not in current_level:
                current_level[key] = {}
            current_level = current_level[key]
            if isinstance(value, list):
                if key not in current_level:
                    current_level[key] = []
                current_level[key].extend(value)
            else:
                current_level[key] = value

result_json = json.dumps(result, indent=4)
print(result_json)