擅长:python、mysql、java
<p>以下是我将如何着手:</p>
<pre><code>d['user_emails'] = d['user_emails'][0]
d["user_emails_data"] = d["user_emails_data"][0]
d["user_emails_data_type"] = []
d["user_emails_data_id"] = []
for val in d["user_emails_data"]:
d["user_emails_data_type"].append(val["type"])
d["user_emails_data_id"].append(val['id'])
del d["user_emails_data"]
pd.DataFrame(d)
</code></pre>
<p>这将产生:</p>
<pre><code> user_id user_emails user_emails_data_type user_emails_data_id
0 user1 user1@workemail.example emailAddress 1
1 user1 user1@home_email.example emailAddress 2
</code></pre>
<p>它假定<code>dict</code>的其余部分具有相同的结构</p>