擅长:python、mysql、java
<p>首先,您可以使用<code>groupby</code>按日期分组,<code>sort</code>按第三个索引高度分组。此处为示例代码:</p>
<pre><code> from itertools import groupby
from operator import itemgetter
data = [['Thursday 4 January', 11.58, 0.38], ['Thursday 4 January', 16.95, 0.73], ['Thursday 4 January', 23.68, 0.02],
['Friday 5 January', 6.48, 0.83], ['Friday 5 January', 12.42, 0.33]]
for k, g in groupby(data, key=itemgetter(0)):
a = sorted(g, key=itemgetter(2))
print('{}: {} meters at lowest and {} meters at highest'.format(k, a[0][2], a[-1][2]))
</code></pre>
<p>输出:</p>
<pre><code>Thursday 4 January: 0.02 meters at lowest and 0.73 meters at highest
Friday 5 January: 0.33 meters at lowest and 0.83 meters at highest
</code></pre>
<p>顺便说一下,在date中使用<code>groupby</code>之前,请确保您的数据是按日期排序的。你知道吗</p>
<p>希望这能对你有所帮助,如果你有进一步的问题,请发表评论。:)</p>