擅长:python、mysql、java
<p>我不确定我是否有最好的答案,但我认为它仍然有效。<br/>
首先,我将使用以下示例将<code>datetime64</code>转换为<code>datetime</code>:
<a href="https://stackoverflow.com/questions/13703720/converting-between-datetime-timestamp-and-datetime64">Converting between datetime, Timestamp and datetime64</a></p>
<p>然后,如果我们假设您的第一列有<code>datetime</code>,并被称为<code>TimeStamp</code>,我将执行如下操作:</p>
<pre><code>def bin_f(x):
if x.time() < datetime.time(6):
return "00:00-05:59"
elif x.time() < datetime.time(12):
return "06:00-11:59"
elif x.time() < datetime.time(18):
return "12:00-17:59"
else:
return "18:00-23:59"
df["Bin"] = df["TimeStamp"].apply(bin_f)
grouped = df.groupby("Bin")
grouped['X'].agg(np.std)
</code></pre>
<p>以<code>X</code>作为列的名称。</p>