擅长:python、mysql、java
<p>你可以查一下</p>
<pre><code>s1=df.groupby('subjectID').subjectMark.transform('max').eq(df.subjectMark)# check the max score with each student
s2=df.overallScore.eq(df.overallScore.max())# get the max score of overall
s2&((~s1).groupby(df['studentID']).transform('all'))# get the above conditions and both met should return True
Out[1066]:
0 False
1 False
2 True
3 True
4 False
5 False
dtype: bool
</code></pre>