擅长:python、mysql、java
<p>我要做的是:</p>
<pre><code># toy data
df = pd.DataFrame({'speaker':['Stanley & Kevin', 'Everybody',
'Kevin speaks', 'The speaker is Franck', 'Nobody']})
personnages = ['Stanley','Kevin', 'Franck']
pattern = '|'.join(personnages)
s = (df['speaker'].str
.extractall(f'({pattern})') # extract all personnages
.groupby(level=0)[0] # group by df's row
.nunique().eq(1) # count the unique number
)
df.loc[s.index[s]]
</code></pre>
<p>输出:</p>
<pre><code> speaker
2 Kevin speaks
3 The speaker is Franck
</code></pre>