使用python将CSV转换为结构化嵌套JSON

import csv
import json

def csv_to_json(csv_file):
    # 读取CSV文件
    with open(csv_file, 'r') as file:
        reader = csv.DictReader(file)
        # 将CSV数据转换为字典列表
        data = [row for row in reader]
    
    # 构建嵌套的JSON数据
    json_data = {}
    for row in data:
        current_dict = json_data
        for key, value in row.items():
            keys = key.split('.')
            for k in keys[:-1]:
                if k not in current_dict:
                    current_dict[k] = {}
                current_dict = current_dict[k]
            current_dict[keys[-1]] = value
    
    # 将JSON数据写入文件
    with open('output.json', 'w') as file:
        json.dump(json_data, file, indent=4)
    
    return json_data

# 使用示例
csv_file = 'data.csv'
json_data = csv_to_json(csv_file)
print(json_data)