回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有两条格言如下:</p>
<pre><code>{
"states":
[
{
"status": "BV",
"median": 240.0
},
{
"status": "CORR",
"median": 720.0
},
]
}
</code></pre>
<p>以及</p>
<pre><code>{
"diseases": [
{
"status": "BV",
"median": 100.0,
"disease_name": "Lupus"
},
{
"status": "BV",
"median": 128.0,
"disease_name": "Pulmonary Arterial Hypertension"
},
{
"status": "CORR",
"median": 321.0,
"disease_name": "Pulmonary Arterial Hypertension"
},
{
"status": "CORR",
"median": 670.0,
"disease_name": "Rheumatology"
}
]
}
</code></pre>
<p>如何使用pandas将两个dict合并成一个dict,以便输出如下:</p>
<pre><code>{
"states":
[
{
"status": "BV",
"median": 240.0,
"drilldown": "BV"
},
{
"status": "CORR",
"median": 720.0,
"drilldown": "CORR"
}
],
"drilldown":
[
{
"name":"BV",
"data":
[
{
"median": 100.0,
"disease_name": "Lupus"
},
{
"median": 128.0,
"disease_name": "Pulmonary Arterial Hypertension"
}
]
},
{
"name":"CORR",
"data":
[
{
"median": 321.0,
"disease_name": "Lupus"
},
{
"median": 670.0,
"disease_name": "Rheumatology"
}
]
}
]
}
</code></pre>
<p>我确实试着通过遍历列表来尝试一下,但它看起来非常粗糙,而且计算复杂很贵。是吗想知道有没有更好的方法来对付熊猫?你知道吗</p>