在pandas中迭代创建多索引和多列数据帧

import pandas as pd

data = {
    ('Group 1', 'Category 1'): [1, 2, 3],
    ('Group 1', 'Category 2'): [4, 5, 6],
    ('Group 2', 'Category 1'): [7, 8, 9],
    ('Group 2', 'Category 2'): [10, 11, 12]
}

df = pd.DataFrame(data)
print(df)

  Group 1       Group 2      
Category 1 Category 2 Category 1 Category 2
0         1          4          7         10
1         2          5          8         11
2         3          6          9         12

import pandas as pd

data = [
    [1, 4, 7, 10],
    [2, 5, 8, 11],
    [3, 6, 9, 12]
]

columns = pd.MultiIndex.from_tuples([('Group 1', 'Category 1'),
                                     ('Group 1', 'Category 2'),
                                     ('Group 2', 'Category 1'),
                                     ('Group 2', 'Category 2')])

df = pd.DataFrame(data, columns=columns)
print(df)

  Group 1       Group 2      
Category 1 Category 2 Category 1 Category 2
0         1          4          7         10
1         2          5          8         11
2         3          6          9         12