跨多个列熔化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'],
    'math_score': [90, 85, 95],
    'english_score': [80, 75, 85],
    'science_score': [95, 90, 92]
}
df = pd.DataFrame(data)

# 熔化DataFrame
melted_df = pd.melt(df, id_vars=['id', 'name'], value_vars=['math_score', 'english_score', 'science_score'], var_name='subject', value_name='score')

print(melted_df)

   id     name        subject  score
0   1    Alice     math_score     90
1   2      Bob     math_score     85
2   3  Charlie     math_score     95
3   1    Alice  english_score     80
4   2      Bob  english_score     75
5   3  Charlie  english_score     85
6   1    Alice  science_score     95
7   2      Bob  science_score     90
8   3  Charlie  science_score     92