<p>您可以尝试以下代码:</p>
<pre><code>a = pd.read_csv("File1.csv", "\t")
b = pd.read_csv("File2.csv", "\t")
merged = pd.merge(a, b, how='inner', on=['Ticker', 'Date'])
print merged
</code></pre>
<p>如果<code>File1.csv</code>是:</p>
^{pr2}$
<p>而<code>File2.csv</code>是:</p>
<pre><code>Ticker Date Open Close
A 2002-03-14 580000 500000
ABB 2004-03-16 500000 420000
AD 2004-03-16 700000 670000
</code></pre>
<p>则上述代码的输出为:</p>
<pre><code> Ticker Date Marketcap Open Close
0 A 2002-03-14 600000 580000 500000
1 ABB 2004-03-16 400000 500000 420000
2 AD 2004-03-16 680000 700000 670000
</code></pre>
<p/><hr/>
如果您希望<code>File1.csv</code>中的所有行,并且只希望<code>File2.csv</code>中的行匹配,则可以使用以下方法:
<pre><code>merged = pd.merge(a, b, how='left', on=['Ticker', 'Date'])
</code></pre>
<p>这将产生:</p>
<pre><code> Ticker Date Marketcap Open Close
0 A 2002-03-14 600000 580000.0 500000.0
1 A 2002-06-18 520000 NaN NaN
2 ABB 2004-03-16 400000 500000.0 420000.0
3 ABB 2005-07-11 800000 NaN NaN
4 AD 2004-03-16 680000 700000.0 670000.0
</code></pre>