python之csv 到嵌套的 JSON

我正在尝试将平面结构的 CSV 转换为嵌套的 JSON 结构。 CSV 是从 SQL 生成的，它为每个主要 ID 创建多行。 CSV 的结构如下:

PrimaryId,FirstName,LastName,City,CarName,DogName 
100,John,Smith,NewYork,Toyota,Spike 
100,John,Smith,NewYork,BMW,Spike 
100,John,Smith,NewYork,Toyota,Rusty 
100,John,Smith,NewYork,BMW,Rusty 
101,Ben,Swan,Sydney,Volkswagen,Buddy 
101,Ben,Swan,Sydney,Ford,Buddy 
101,Ben,Swan,Sydney,Audi,Buddy 
101,Ben,Swan,Sydney,Volkswagen,Max 
101,Ben,Swan,Sydney,Ford,Max 
101,Ben,Swan,Sydney,Audi,Max 
102,Julia,Brown,London,Mini,Lucy 

所需的 JSON 输出是:

{ 
    "data": [ 
        { 
            "City": "NewYork",  
            "FirstName": "John",  
            "PrimaryId": 100,  
            "LastName": "Smith",  
            "CarName": [ 
                "Toyota",  
                "BMW" 
            ],  
            "DogName": [ 
                "Spike",  
                "Rusty" 
            ] 
        },  
        { 
            "City": "Sydney",  
            "FirstName": "Ben",  
            "PrimaryId": 101,  
            "LastName": "Swan",  
            "CarName": [ 
                "Volkswagen",  
                "Ford",  
                "Audi" 
            ],  
            "DogName": [ 
                "Buddy",  
                "Max" 
            ] 
        },  
        { 
            "City": "London",  
            "FirstName": "Julia",  
            "PrimaryId": 102,  
            "LastName": "Brown",  
            "CarName": [ 
                "Mini" 
            ],  
            "DogName": [ 
                "Lucy" 
            ] 
        } 
    ] 
} 

两者都是this post和 this one 有帮助，但我还没有创建正确的结构。