Skip to main content
 首页 » 编程设计

python之如何获得两个 MultiIndex DataFrame 的并集

2025年05月04日20davidwang456

如何合并两个多索引数据帧?

例如,假设我有:

index1 = pd.MultiIndex.from_tuples([('2010-01-01', 'Jim'), 
                                    ('2010-01-01', 'Mike'),  
                                    ('2010-01-02', 'Sam')]) 
index2 = pd.MultiIndex.from_tuples([('2010-01-02', 'Jim'),  
                                    ('2010-01-02', 'Sam'),  
                                    ('2010-01-03', 'Joe')]) 
df1 = pd.DataFrame([[7,0,7],[4,3,2],[6,2,6]],  
                   index=index1, columns=['a', 'b', 'c']) 
df2 = pd.DataFrame([[4,2,0],[8,8,4],[5,5,3]],  
                   index=index2, columns=['a', 'b', 'c']) 

这导致:

>> df1 
                  a  b  c 
2010-01-01  Jim   7  0  7 
            Mike  4  3  2 
2010-01-02  Sam   6  2  6 
 
>> df2 
                  a  b  c 
2010-01-02  Jim   4  2  0 
            Sam   8  8  4 
2010-01-03  Joe   5  5  3 

我想合并 df1 和 df2 生成:

>> df3 
                    a1  b1  c1  a2  b2  c2 
2010-01-01  Jim     7   0   7   NaN NaN NaN 
            Mike    4   3   2   NaN NaN NaN 
2010-01-02  Jim     NaN NaN NaN 4   2   0 
            Sam     6   2   6   8   8   4 
2010-01-03  Joe     NaN NaN NaN 5   5   3 

我正在努力寻找一个好的方法来做到这一点。有什么建议吗?

请您参考如下方法:

尝试:

df3 = df1.join(df2, how='outer', lsuffix='1', rsuffix='2') 

或者

df3 = pd.merge(df1, df2, how='outer', left_index=True, right_index=True)