擅长:python、mysql、java
<p>在两个步骤中,我们可以使用<code>.explode</code>和<code>pd.json_normalize</code>和<code>.join</code>重新创建df</p>
<pre><code>uid = df.set_index('user_id')['user_emails'].explode().reset_index()
df1 = uid.join(pd.json_normalize(df['user_emails_data'].explode()))
print(df1)
user_id user_emails type id
0 user1 user1@workemail.example emailAddress 1
1 user1 user1@home_email.example emailAddress 2
</code></pre>