擅长:python、mysql、java
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Index.searchsorted.html" rel="nofollow noreferrer">^{<cd1>}</a>作为索引,然后选择<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.iloc.html" rel="nofollow noreferrer">^{<cd2>}</a>和最后一个<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.concat.html" rel="nofollow noreferrer">^{<cd3>}</a>:</p>
<pre><code>df = pd.concat([df1.reset_index(),
df2.iloc[df2.index.searchsorted(df1.index + .5)].reset_index()], axis=1)
print (df)
Index Fruit Index Taste
0 1 Apple 1.5 Rotten
1 2 Banana 2.6 Tasty
2 3 Peach 4.0 Tasty
</code></pre>
<p>详细信息:</p>
^{pr2}$