Pandas会根据两个或多个二进制列来融化数据

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

import pandas as pd

# 创建一个示例数据框
data = {
    'id': [1, 2, 3],
    'name': ['Alice', 'Bob', 'Charlie'],
    'math_score': [90, 80, 70],
    'english_score': [95, 85, 75]
}
df = pd.DataFrame(data)

# 融化数据
melted_df = pd.melt(df, id_vars=['id', 'name'], value_vars=['math_score', 'english_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     80
2   3  Charlie    math_score     70
3   1    Alice  english_score     95
4   2      Bob  english_score     85
5   3  Charlie  english_score     75