在pandas DataFrame中将多列转置为1列

import pandas as pd

# 创建一个示例DataFrame
df = pd.DataFrame({
    'ID': [1, 2, 3],
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Math': [90, 80, 95],
    'Science': [85, 70, 92]
})

# 使用melt函数将Math和Science列转置为一列
melted = df.melt(id_vars=['ID', 'Name'], value_vars=['Math', 'Science'], var_name='Subject', value_name='Score')

print(melted)

   ID     Name  Subject  Score
0   1    Alice     Math     90
1   2      Bob     Math     80
2   3  Charlie     Math     95
3   1    Alice  Science     85
4   2      Bob  Science     70
5   3  Charlie  Science     92