擅长:python、mysql、java
<p>仅供参考,这里有<code>resample</code>选项。方便的时间序列工具。你知道吗</p>
<pre><code>import pandas as pd
df = pd.read_table('sample.txt', header=None, sep=';')
df.columns=['date', 'time', 'temp']
df['datetime'] = pd.to_datetime(df['date'] + ' ' + df['time'])
df['temp'] = df['temp'].astype(float) # dtypes should be float as jezrael mentioned.
df = df.set_index('datetime')[['temp']]
df = pd.concat([df.resample('1D', how=min),
df.resample('1D', how=max)], axis=1)
df.columns = ['temp_min', 'temp_max']
print(df)
</code></pre>
<p>结果</p>
<pre><code> temp_min temp_max
datetime
2016-02-01 8.9 15.6
</code></pre>