擅长:python、mysql、java
<p>除了前面的答案,您还可以尝试以下内容-</p>
<pre><code>import pandas as pd
df = pd.DataFrame({'timestamp' : ['2020-04-14 00:00:23', '2020-04-14 00:00:37', '2020-04-14 00:01:01', '2020-04-14 00:01:05', '2020-04-14 00:01:19'], 'sensor' : ['sound', 'air', 'sound', 'air', 'sound']})
df["timestamp"] = pd.to_datetime(df.timestamp)
df
</code></pre>
<blockquote>
<pre><code>mask = df['sensor'] == 'air'
df.loc[mask, 'timestamp'] = df.loc[mask, 'timestamp'].dt.round('5min')
</code></pre>
</blockquote>
<p><a href="https://i.stack.imgur.com/DndnL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DndnL.png" alt="enter image description here"/></a></p>