擅长:python、mysql、java
<p>您可以<code>resample</code>(每周)、<code>offset</code>(移位)和<code>apply</code>聚合规则,如下所示:</p>
<pre><code>logic = {'Open' : 'first',
'High' : 'max',
'Low' : 'min',
'Close' : 'last',
'Volume': 'sum'}
offset = pd.offsets.timedelta(days=-6)
f = pd.read_clipboard(parse_dates=['Date'], index_col=['Date'])
f.resample('W', loffset=offset).apply(logic)
</code></pre>
<p>得到:</p>
<pre><code> Open High Low Close Volume
Date
2010-01-04 38.660000 40.700001 38.509998 40.290001 5925600
2010-01-11 40.209999 40.970001 39.279999 40.450001 6234600
</code></pre>