擅长:python、mysql、java
<p>我不确定这方面的性能会有多好,尽管我认为如果您将<code>'Participants'</code>列的元素保留为列表,那么投资是值得的</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
df = pd.DataFrame(data={'Title': ['ShowA', 'ShowB', 'ShowC'],
'Participants': ['B. Smith,C. Ball', 'T. Smooth', 'K. Dulls,L. Allen,B. Smith']})
target_participants = {'B. Smith', 'K. Dulls'}
df['Participants'] = df['Participants'].str.split(',')
print(df, end='\n\n')
contains_parts = ~df['Participants'].map(target_participants.isdisjoint)
print(contains_parts)
</code></pre>
<p>输出:</p>
<pre class="lang-none prettyprint-override"><code> Title Participants
0 ShowA [B. Smith, C. Ball]
1 ShowB [T. Smooth]
2 ShowC [K. Dulls, L. Allen, B. Smith]
0 True
1 False
2 True
Name: Participants, dtype: bool
</code></pre>