<p>我建议使用<code>urllib</code>。特别是,<code>parse_qs</code>函数将获得字符串参数的字典。<a href="https://docs.python.org/3/library/urllib.parse.html" rel="nofollow noreferrer">https://docs.python.org/3/library/urllib.parse.html</a></p>
<p>使用您的示例URL,我们得到:</p>
<pre><code>from urllib.parse import parse_qs
test = 'https:_utm_source=googlebrand&utm_medium=ppc&utm_campaign=brand&utm_campaignid=351154190&keyword=aihdisadjiajdutm_matchtype=e&device=m&utm_network=g&utm_adposition=1t1&geo=9027258&gclid=CjwKCsadjjsaopdl[psdklksfdosjfidj9FOk033DKW1xoCXlwQAvD_BwE&affiliate_id=asdaskdosjadiasjdisaj-asdhasuigdyusagdyusagyk033DKW1xoCXlwQAvD_BwE&utm_content=search&utm_contentid=1251489456158180&placement&extension'
print(parse_qs(test))
</code></pre>
<pre><code>{'https:_utm_source': ['googlebrand'],
'utm_medium': ['ppc'],
'utm_campaign': ['brand'],
'utm_campaignid': ['351154190'],
'keyword': ['aihdisadjiajdutm_matchtype=e'],
'device': ['m'],
'utm_network': ['g'],
'utm_adposition': ['1t1'],
'geo': ['9027258'],
'gclid': ['CjwKCsadjjsaopdl[psdklksfdosjfidj9FOk033DKW1xoCXlwQAvD_BwE'],
'affiliate_id': ['asdaskdosjadiasjdisaj-asdhasuigdyusagdyusagyk033DKW1xoCXlwQAvD_BwE'],
'utm_content': ['search'],
'utm_contentid': ['1251489456158180']}
</code></pre>
<p>要获取整个数据帧的活动ID,我们可以使用<code>.apply</code>来完成:</p>
<pre><code># After parsing each url's arguments, we extract the first campaignid from the dictionary's list.
df['utm_campaignid'] = df['url'].apply(lambda x: parse_qs(x)['utm_campaignid'][0])
df.head()
</code></pre>
<pre><code> url utm_campaignid
0 https:_utm_source=googlebrand&utm_medium=ppc&u... 351154190
</code></pre>