擅长:python、mysql、java
<p>假设您的datetime索引是按升序排序的,您可以按如下方式进行</p>
<p><strong>创建虚拟数据帧</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
df = pd.DataFrame(np.random.rand(100,3), columns=list("ABC"))
df.set_index(pd.date_range("oct-27-2019", periods=100, freq="min"), inplace=True)
</code></pre>
<p><strong>解决方案</strong></p>
<pre class="lang-py prettyprint-override"><code>## add new row for next minute
df.loc[df.iloc[-1].name + pd.Timedelta(1, "min")] = [0.1,0.1,0.1]
## remove the oldest row in the dataframe
df.drop(index=df.iloc[0].name, inplace=True)
df
</code></pre>