擅长:python、mysql、java
<p>我在发布了我的按小时计算的解决方案后,偶然发现了这个宝石<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.resample.html" rel="nofollow noreferrer">^{<cd1>}</a>。在</p>
<pre><code># Construct example dataframe
times = pd.date_range('1/1/2018', periods=5, freq='25min')
values = [4,8,3,4,1]
df = pd.DataFrame({'val':values}, index=times)
# Resample by hour and calculate medians
df.resample('H').median()
</code></pre>
<p>或者,如果不想将时间作为索引,可以将<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.groupby.html" rel="nofollow noreferrer">^{<cd2>}</a>与<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Grouper.html" rel="nofollow noreferrer">^{<cd3>}</a>一起使用:</p>
^{pr2}$