如何在多级列展平上翻转pandas列名

import pandas as pd

df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
df.columns = pd.MultiIndex.from_product([['Level1'], ['A', 'B']])
df.columns.names = ['Level1', 'Level2']

s = df.stack()

df_flattened = s.reset_index()

df_flipped = df_flattened.pivot(index='Level1', columns='Level2')

import pandas as pd

# 创建多级列的DataFrame
df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
df.columns = pd.MultiIndex.from_product([['Level1'], ['A', 'B']])
df.columns.names = ['Level1', 'Level2']

# 多级列展平为Series
s = df.stack()

# 将Series转换回DataFrame
df_flattened = s.reset_index()

# 翻转列名和数值
df_flipped = df_flattened.pivot(index='Level1', columns='Level2')

print(df_flipped)