使用multiindex同时添加多个列

import pandas as pd

# 创建一个包含多级索引的数据框
data = {'A': [1, 2, 3, 4],
        'B': [5, 6, 7, 8],
        'C': [9, 10, 11, 12],
        'D': [13, 14, 15, 16]}
df = pd.DataFrame(data, columns=[['Group1', 'Group1', 'Group2', 'Group2'],
                                 ['Col1', 'Col2', 'Col1', 'Col2']])

# 打印数据框
print(df)

  Group1     Group2    
    Col1 Col2   Col1 Col2
0      1    5      9   13
1      2    6     10   14
2      3    7     11   15
3      4    8     12   16

# 访问Group1的Col1列
print(df['Group1', 'Col1'])

# 访问Group2的Col2列
print(df['Group2', 'Col2'])

0    1
1    2
2    3
3    4
Name: (Group1, Col1), dtype: int64
0    13
1    14
2    15
3    16
Name: (Group2, Col2), dtype: int64