您可以尝试以下代码: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
如果File1.csv是:
^{pr2}$
而File2.csv是:Ticker Date Open Close
A 2002-03-14 580000 500000
ABB 2004-03-16 500000 420000
AD 2004-03-16 700000 670000
则上述代码的输出为: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
如果您希望File1.csv中的所有行,并且只希望File2.csv中的行匹配,则可以使用以下方法:
merged = pd.merge(a, b, how='left', on=['Ticker', 'Date'])
这将产生: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