回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我是python新手,一直致力于学习pandas和xlxswriter来帮助自动化一些工作流。我附加了一个JSON文件的片段,我可以访问它,但无法转换成pandas数据帧。在</p>
<p>如果我使用<code>pd.read_json(filename)</code>:它会将variationProducts&productAttributes的内容集中在一个单元格中,从而将它们弄乱。在</p>
<p>问:我如何获取这个JSON文件,使其看起来像底部的pandas dataframe输出:</p>
<pre><code>[
{
"ID": "12345",
"productName": "Product A ",
"minPrice": "$89.00",
"maxPrice": "$89.00",
"variationProducts": [
{
"variantColor": "JJ0BVE7",
"variantSize": "080",
"sellingPrice": "$89.00",
"inventory": 3,
},
{
"variantColor": "JJ0BVE7",
"variantSize": "085",
"sellingPrice": "$89.00",
"inventory": 6,
}
],
"productAttributes": [
{
"ID": "countryOfOrigin",
"value": "Imported"
},
{
"ID": "csProductCode",
"value": "1100"
}
]
},
{
"ID": "23456",
"productName": "Product B",
"minPrice": "$29.99",
"maxPrice": "$69.00",
"variationProducts": [
{
"variantColor": "JJ169Q0",
"variantSize": "050",
"sellingPrice": "$69.00",
"inventory": 55,
},
{
"variantColor": "JJ123Q0",
"variantSize": "055",
"sellingPrice": "$69.00",
"inventory": 5,
}
],
"productAttributes": [
{
"ID": "countryOfOrigin",
"value": "Imported"
},
{
"ID": "csProductCode",
"value": "1101"
}
]
}
]
</code></pre>
<p>我在excel中输出了这个示例,变量产品在variantColor级别汇总-因此对于产品A,库存是两个变量的总和,尽管它们具有不同的variantsize:</p>
^{pr2}$