擅长:python、mysql、java
<p>我们可以在这里使用<code>list comprehension</code>和<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.iterrows.html" rel="nofollow noreferrer">^{<cd2>}</a>来提取<code>URL</code>标记:</p>
<pre><code>df.fillna('None', inplace=True)
df['image_url'] = [
d['image_versions2.candidates']['url'] if d['image_versions2.candidates'] != 'None' else 'None' for idx, d in df.iterrows()
]
print(df)
image_versions2.candidates image_url
0 {'width': 750, 'height': 498, 'url': 'https:/X... https:/XXX
1 None None
2 {'width': 750, 'height': 498, 'url': 'https:/Y... https:/YYY
3 {'width': 750, 'height': 498, 'url': 'https:/Z... https:/ZZZ
</code></pre>