将Pandas Dataframe或csv文件转换为自定义嵌套JSON

import pandas as pd
import json

# 读取Dataframe
df = pd.DataFrame({'col1': [1, 2, 3], 'col2': ['a', 'b', 'c']})

# 或者读取csv文件
df = pd.read_csv('data.csv')

def dataframe_to_nested_json(df, parent_key='', records_list=[]):
    for idx, row in df.iterrows():
        data = row.to_dict()
        for key in data:
            if '.' in key:
                new_key = key.replace('.', '_')
                data[new_key] = data.pop(key)
        if parent_key:
            nested_key = f"{parent_key}.{idx}"
        else:
            nested_key = str(idx)
        records_list.append({nested_key: data})
    return records_list

nested_json = dataframe_to_nested_json(df)
json_data = json.dumps(nested_json, indent=4)
print(json_data)