我在python中有两个多索引数据帧。我想用相同的Multiindex和column将第二个数据框更新为第一个数据框
以下是具有相同数据和代码的示例:
DataFrame 1:
arr1 = [np.array(['A','A','B','C','C']),np.array(['one','two','one','two'])]
df1 = pd.DataFrame(np.random.randn(6),index=arr1,columns=['colName'])
df1
输出df1:
colName
A one 0.596278
two -0.174721
B one -0.274034
two -0.102720
C one 0.187235
two 0.429343
DataFrame 2:
arr2 = [np.array(['D','D']),'two'])]
df2 = pd.DataFrame(np.random.randn(2),index=arr2,columns=['colName'])
df2
输出df2:
colName
D one 0.193352
two -1.067392
我正在尝试所需的输出,如下所示:
colName
A one 0.596278
two -0.174721
B one -0.274034
two -0.102720
C one 0.187235
two 0.429343
D one 0.193352
two -1.067392
如何将新的Dataframe作为行添加到DataFrame(具有相同的列)?