合并两个MultiIndex数据帧

import pandas as pd

# 创建两个MultiIndex数据帧
df1 = pd.DataFrame({'A': [1, 2, 3]}, index=pd.MultiIndex.from_tuples([('x', 'a'), ('y', 'b'), ('z', 'c')]))
df2 = pd.DataFrame({'B': [4, 5, 6]}, index=pd.MultiIndex.from_tuples([('x', 'a'), ('y', 'b'), ('w', 'd')]))

# 内连接
merged_inner = pd.merge(df1, df2, left_index=True, right_index=True, how='inner')
print("内连接结果：")
print(merged_inner)

# 左连接
merged_left = pd.merge(df1, df2, left_index=True, right_index=True, how='left')
print("左连接结果：")
print(merged_left)

# 右连接
merged_right = pd.merge(df1, df2, left_index=True, right_index=True, how='right')
print("右连接结果：")
print(merged_right)

# 外连接
merged_outer = pd.merge(df1, df2, left_index=True, right_index=True, how='outer')
print("外连接结果：")
print(merged_outer)

import pandas as pd

# 创建两个MultiIndex数据帧
df1 = pd.DataFrame({'A': [1, 2, 3]}, index=pd.MultiIndex.from_tuples([('x', 'a'), ('y', 'b'), ('z', 'c')]))
df2 = pd.DataFrame({'B': [4, 5, 6]}, index=pd.MultiIndex.from_tuples([('w', 'd'), ('x', 'a'), ('y', 'b')]))

# 沿行拼接
concatenated_row = pd.concat([df1, df2], axis=0)
print("沿行拼接结果：")
print(concatenated_row)

# 沿列拼接
concatenated_column = pd.concat([df1, df2], axis=1)
print("沿列拼接结果：")
print(concatenated_column)