擅长:python、mysql、java
<p>我想你想要</p>
<pre><code>bins = [650,1000,1350,1700,2050,2400,2750,3000]
a_bins = df.groupby([pd.cut(df['A'],bins), 'ID']).B
a_bins.agg('mean').reset_index().pivot(index='ID', columns='A', values='B')
</code></pre>
<p>这样你会得到:</p>
<pre><code>A (650, 1000] (1000, 1350] ... (2400, 2750] (2750, 3000]
ID ...
101 5.952381 7.142857 ... NaN NaN
</code></pre>