在Pandas中将列拆分为行

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

import pandas as pd

# 创建示例DataFrame
data = {
    'Name': ['John', 'Alice', 'Bob'],
    'Math': [80, 90, 75],
    'Science': [85, 95, 80],
    'English': [75, 80, 90]
}
df = pd.DataFrame(data)

# 使用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  John     Math     80
1  Alice    Math     90
2  Bob      Math     75
3  John   Science   85
4  Alice  Science   95
5  Bob    Science   80
6  John   English   75
7  Alice  English   80
8  Bob    English   90