擅长:python、mysql、java
<p>Op1<code>numpy.searchsorted</code></p>
<p>使用<code>numpy.searchsorted</code>,然后使用索引片<code>df1</code></p>
<pre><code>df1.loc[np.searchsorted(df1.A, df2.A)-1]
Out[826]:
A var1 var2
0 110.035 0.007591 0.768843
3 112.828 0.426480 0.902606
</code></pre>
<hr/>
<p>Op2<code>merge_asof</code></p>
<pre><code>pd.merge_asof(df2,df1,on='A',direction='nearest')
Out[819]:
A var1 var2
0 110.04 0.007591 0.768843
1 112.83 0.426480 0.902606
</code></pre>