擅长:python、mysql、java
<h2>将<em>bin</em>列添加到dataframe,然后<em>groupby</em></h2>
<p>一个<em>bin</em>应该是<code>td - td%binsize</code>(<code>+ binsize/2</code>,如果你想要中心)。在</p>
<p>然后只要<em>groupby</em>越过<em>bin</em>就可以绘制出</p>
<pre><code>>>> df['bin'] = df.td - df.td % 2000 + 1000
>>> s = df[['bin', 'profit_loss']].groupby('bin').sum()
>>> s
profit_loss
bin
1000 2085.0
3000 -211707.0
>>> s.plot(kind='bar')
<matplotlib.axes._subplots.AxesSubplot object at 0x7fce4fba3358>
>>> plt.show()
</code></pre>
<p><a href="https://i.stack.imgur.com/mqtMe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mqtMe.png" alt="enter image description here"/></a></p>