擅长:python、mysql、java
<p>试试这个:</p>
<pre><code>df3.loc[(df3['Gym'].str.contains('Hockey') == True) & (df3["Gym"].str.count("\|")>1)].sort_values("Total").tail(1)
Total Gym
0 40 Football|Baseball|Hockey|Running|Basketball|Sw...
df3.loc[(df3['Gym'].str.contains('Baseball') == True) & (df3["Gym"].str.count("\|")>1)].sort_values("Total").tail(1)
Total Gym
2 61 Basketball|Baseball|Ballet
</code></pre>