擅长:python、mysql、java
<p>与<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.isin.html" rel="nofollow noreferrer">^{<cd2>}</a>、<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.where.html" rel="nofollow noreferrer">^{<cd3>}</a>一起使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.html" rel="nofollow noreferrer">^{<cd1>}</a>方法:</p>
<pre><code>s = df['Ad'].str.split('.')
m = s.str[0].isin(df['Audience'])
df['Ad'] = s.where(~m, s.str[1:]).str.join('.')
</code></pre>
<hr/>
<pre><code># print(df)
Audience Ad
0 Audience1 Ad1.image
1 Audience2 Ad4.image
2 Audience3 Ad1.image
3 Audience4 Ad3.image
4 Audience5 Ad1.image
5 Audience6 Ad2.image
6 Audience7 Ad1.image
7 Audience8 Ad3.image
8 Audience9 Ad1.image
9 Audience10 Ad1.image
</code></pre>