擅长:python、mysql、java
<p>对于这个问题(信息有限),我建议:</p>
<p>如果您的df如下所示:</p>
<pre><code>df = pd.DataFrame(data={"url": ["http//mysportswebsite.com/shop/?Baseball+Bat=5", "http//memoribilia.com/checkout?autograph=1"]})
url
0 http//mysportswebsite.com/shop/?Baseball+Bat=5
1 http//memoribilia.com/checkout?autograph=1
</code></pre>
<p>你可以这样做:</p>
<pre><code>df['product_count_tuple'] = df.url.apply(lambda x: x.split('?')[1].split('='))
df['product'] = df.product_count_tuple.apply(lambda x: x[0].replace('+', ' '))
df['count'] = df.product_count_tuple.apply(lambda x: x[1])
df = df.drop('product_count_tuple', 1)
</code></pre>
<p>结果是:</p>
<pre><code> url product count
0 http//mysportswebsite.com/shop/?Baseball+Bat=5 Baseball Bat 5
1 http//memoribilia.com/checkout?autograph=1 autograph 1
</code></pre>