重塑pandas数据帧(按列转置行)

import pandas as pd

# 创建示例数据帧
df = pd.DataFrame({
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Math': [90, 80, 70],
    'Science': [95, 85, 75],
    'English': [92, 82, 72]
})

# 使用melt()函数进行重塑
melted_df = pd.melt(df, id_vars=['Name'], value_vars=['Math', 'Science', 'English'], var_name='Subject', value_name='Score')

print(melted_df)

      Name  Subject  Score
0    Alice     Math     90
1      Bob     Math     80
2  Charlie     Math     70
3    Alice  Science     95
4      Bob  Science     85
5  Charlie  Science     75
6    Alice  English     92
7      Bob  English     82
8  Charlie  English     72