擅长:python、mysql、java
<p>您可以在<code>defaultPrice</code>列上使用<code>apply(pd.Series)</code>,将其拆分为单独的列,然后将其连接回原始数据帧</p>
<pre><code>prices = {"a": [{"Name": "name1",
"number": "number1",
"defaultPrice": {"p": "232", "currency": "CAD"},
"prices": {"DZ": {"p": "62", "currency": "RMB"},
"AU": {"p": "73", "currency": "AUD"},
"lg": "en"}},
{"Name": "name2",
"number": "number2",
"defaultPrice": {"p": "233", "currency": "CAD"},
"prices": {"DZ": {"p": "63", "currency": "RMB"},
"US": {"p": "72", "currency": "USD"},
"Lg": "en"}}]}
ndf = pd.DataFrame(prices['a'])
pd.concat([ndf, ndf['defaultPrice'].apply(pd.Series)], axis=1).drop('defaultPrice', axis=1)
</code></pre>
<p>但是,您的<code>prices</code>列仍然是字典列表。但是,由于您没有提到您希望如何处理它,所以我只保留了它的原样(不包括在输出中)</p>
<p>输出:</p>
<pre><code>Name number p currency
name1 number1 232 CAD
name2 number2 233 CAD
</code></pre>