擅长:python、mysql、java
<p>您还可以使用<code>regex</code>在线获取它,如下所示</p>
<pre class="lang-py prettyprint-override"><code>df[df['Cluster'].isin(set(df[df['Name'].str.contains('\+|-')]['Cluster'].unique()).intersection(set(df[~df['Name'].str.contains('\+|-')]['Cluster'].unique())))]
</code></pre>
<p>结果是</p>
<pre><code> Cluster Name
0 Cluster1 NP_075076
1 Cluster1 AMN16433
2 Cluster1 YP_063711
3 Cluster1 KQ976470.1:66008-66163(-):Cattus_sylvestris
4 Cluster1 AJP07295
5 Cluster1 AMN15329
11 Cluster3 KI976478.1:66021-66123(-):Canis_lupus
12 Cluster3 AJP07232
13 Cluster3 AJP07212
14 Cluster3 AZ976430.1:66045-66190(+):Cavia_porsellus
</code></pre>