如何根据Pandas dataframe中的两个索引将多个列值转置为一列

pandas.melt(frame, id_vars=None, value_vars=None, var_name=None, value_name='value', col_level=None)

import pandas as pd

# 创建示例DataFrame
data = {'ID': [1, 2, 3],
        'Name': ['Alice', 'Bob', 'Charlie'],
        'Maths': [90, 85, 95],
        'Physics': [80, 75, 85],
        'Chemistry': [95, 90, 85]}
df = pd.DataFrame(data)

# 将Maths、Physics和Chemistry列转置为一列
df_transposed = pd.melt(df, id_vars=['ID', 'Name'], value_vars=['Maths', 'Physics', 'Chemistry'], var_name='Subject', value_name='Score')

print(df_transposed)

   ID     Name    Subject  Score
0   1    Alice      Maths     90
1   2      Bob      Maths     85
2   3  Charlie      Maths     95
3   1    Alice    Physics     80
4   2      Bob    Physics     75
5   3  Charlie    Physics     85
6   1    Alice  Chemistry     95
7   2      Bob  Chemistry     90
8   3  Charlie  Chemistry     85