擅长:python、mysql、java
<p>您可以使用<code>groupby()</code>、<code>agg()</code>和{<cd3>}:</p>
<p><code>df.groupby(['Grade','HeatNumber']).agg({'Ontime': 'max'}).mean(level=0)</code></p>
<p>下面是一个工作示例:</p>
<pre><code>df = pd.DataFrame({'Grade': ['150HP', '150HP', '150HP', 'A100C', 'A100C', 'A100X', 'A100X', 'A100X', 'LOWO2A100'],
'HeatNumber': ['19258', '19258', '19260','19187', '19787', '19261', '19261', '19237', '19262'],
'Ontime': [45.8, 39.5, 42.8, 31.6, 65.5, 25.4, 65.1, 21.5, 32.4]})
</code></pre>
<p>给出:</p>
^{pr2}$
<p>应用上一行:</p>
<pre><code> Ontime
Grade
150HP 44.30
A100C 48.55
A100X 43.30
LOWO2A100 32.40
</code></pre>