擅长:python、mysql、java
<p>我设法用熊猫找到了解决办法。我使用的代码是:</p>
<pre><code>import pandas as pd
df=pd.read_csv("data.csv",sep=",",usecols=["Segment ID","Date Time","indicator value"])
df['Date Time'] = ['AM' if '06' <= x[11:13] < '10'
else 'IP' if '10' <= x[11:13] < '16'
else 'PM' if '16' <= x[11:13] < '19'
else 'OP' if '19' <= x[11:13] or x[11:13] < '06'
else 'Error' for x in df['Date Time']]
grouped = df.groupby(['Segment ID','Date Time']).mean()
grouped.to_csv('output.csv', sep =',')
</code></pre>
<p>我再推荐熊猫也不够。在</p>