擅长:python、mysql、java
<p>您可以使用<code>merge_asof</code>:</p>
<pre><code># consider `pd.date_range` to generate range of timestamps
all_time = pd.DataFrame({'timestamp':np.arange(df.timestamp.iloc[0],
df.timestamp.iloc[-1]+1)
})
pd.merge_asof(all_time, df, on='timestamp', direction='backward')
</code></pre>
<p>输出:</p>
<pre><code> timestamp v
0 1 5
1 2 6
2 3 6
3 4 6
4 5 6
5 6 7
6 7 7
7 8 8
</code></pre>