擅长:python、mysql、java
<p>为了清楚起见,您正在从API接收一个json,因此您可以尝试使用函数<code>json_normalize</code>。
试试这个:</p>
<pre><code>import pandas as pd
from pandas.io.json import json_normalize
# DataFrame initialization
df = pd.DataFrame({"orderId": [1], "date": ["1-12"], "oderItems": [{ 'orderItemId': 'dfs13', 'ean': '34234'}]})
# Serializing inner dict
sub_df = json_normalize(df["oderItems"])
# Dropping the unserialized column
df = df.drop(["oderItems"], axis=1)
# joining both dataframes.
df.join(sub_df)
</code></pre>
<p>因此,输出为:</p>
<pre><code> orderId date ean orderItemId
0 1 1-12 34234 dfs13
</code></pre>