在Python中合并多索引序列的列表

import pandas as pd

# 创建两个示例Series
index = pd.MultiIndex.from_tuples([('A', 1), ('A', 2), ('B', 1)], names=['letter', 'number'])
s1 = pd.Series([10, 20, 30], index=index)
s2 = pd.Series([15, 25, 35], index=index)

# 将Series放入列表中
series_list = [s1, s2]

# 使用concat合并Series
merged_series = pd.concat(series_list, axis=1)

print(merged_series)

              0   1
letter number      
A      1       10  15
       2       20  25
B      1       30  35

# 假设有两个索引不完全匹配的Series
index1 = pd.MultiIndex.from_tuples([('A', 1), ('B', 2)], names=['letter', 'number'])
index2 = pd.MultiIndex.from_tuples([('A', 1), ('B', 1)], names=['letter', 'number'])
s1 = pd.Series([10, 20], index=index1)
s2 = pd.Series([15, 35], index=index2)

# 使用reindex确保索引匹配
s1 = s1.reindex(index2.union(index1), fill_value=0)
s2 = s2.reindex(index1.union(index2), fill_value=0)

# 现在可以安全地合并
merged_series = pd.concat([s1, s2], axis=1)