<p>您可以使用<a href="http://pandas.pydata.org/pandas-docs/version/0.17.0/generated/pandas.io.json.json_normalize.html" rel="nofollow noreferrer">^{<cd1>}</a>:</p>
<pre><code>In [11]: pd.io.json.json_normalize(d, "variationProducts", ["ID", "maxPrice", "minPrice", "productName"], record_prefix=".")
Out[11]:
.inventory .sellingPrice .variantColor .variantSize ID maxPrice minPrice productName
0 3 $89.00 JJ0BVE7 080 12345 $89.00 $89.00 Product A
1 6 $89.00 JJ0BVE7 085 12345 $89.00 $89.00 Product A
2 55 $69.00 JJ169Q0 050 23456 $69.00 $29.99 Product B
3 5 $69.00 JJ123Q0 055 23456 $69.00 $29.99 Product B
In [12]: pd.io.json.json_normalize(d, "productAttributes", ["ID", "maxPrice", "minPrice", "productName"], record_prefix=".")
Out[12]:
.ID .value ID maxPrice minPrice productName
0 countryOfOrigin Imported 12345 $89.00 $89.00 Product A
1 csProductCode 1100 12345 $89.00 $89.00 Product A
2 countryOfOrigin Imported 23456 $69.00 $29.99 Product B
3 csProductCode 1101 23456 $69.00 $29.99 Product B
</code></pre>
<p><em>然后您可以将这两个合并在一起。。。</em></p>