Pandas wide格式转置为long格式

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

import pandas as pd

# 创建一个示例数据表
data = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Math': [90, 80, 70],
    'English': [85, 75, 65],
    'Science': [95, 85, 75]
}
df = pd.DataFrame(data)

# 将wide格式转换为long格式
df_long = pd.melt(df, id_vars='Name', value_vars=['Math', 'English', 'Science'], var_name='Subject', value_name='Score')

print(df_long)

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