如何使用Pandas将水平数据帧结构转换为垂直数据帧结构

import pandas as pd

data = {'Name': ['Alice', 'Bob', 'Charlie'],
        'Math': [90, 80, 70],
        'English': [95, 85, 75],
        'Science': [88, 92, 80]}
df = pd.DataFrame(data)

melted_df = pd.melt(df, id_vars=['Name'], value_vars=['Math', 'English', 'Science'], 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  English     95
4      Bob  English     85
5  Charlie  English     75
6    Alice  Science     88
7      Bob  Science     92
8  Charlie  Science     80