回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我正在尝试将平面结构的CSV转换为嵌套的JSON结构。CSV由SQL生成,SQL为每个主id创建多行。CSV的结构如下:</p>
<pre class="lang-none prettyprint-override"><code>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
</code></pre>
<p>所需的JSON输出是:</p>
<pre><code>{
"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"
]
}
]
}
</code></pre>
<p><a href="https://stackoverflow.com/questions/29631711/python-to-parent-child-json">this post</a>和<a href="https://stackoverflow.com/questions/17043229/create-nested-json-from-csv">this one </a>都有帮助,但我还没有创建正确的结构。</p>