擅长:python、mysql、java
<p>尝试这种矢量化方法:</p>
<pre><code>In [22]: fn1 = r'D:\temp\.data\38673647\Solution.csv'
In [23]: fn2 = r'D:\temp\.data\38673647\ProjectedRevenue.csv'
In [24]: df1 = pd.read_csv(fn1)
In [25]: df2 = pd.read_csv(fn2)
In [26]: df1
Out[26]:
Hospital_ID District_ID Instrument_ID
0 1 4 6
1 2 5 4
2 7 8 5
In [27]: df2
Out[27]:
Hospital_ID District_ID Instrument_ID
0 9 3 5
1 7 8 5
2 1 2 6
In [28]: pd.merge(df1, df2, on=df1.columns.tolist())
Out[28]:
Hospital_ID District_ID Instrument_ID
0 7 8 5
</code></pre>