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': ['Alice', 'Bob', 'Charlie'],
        'Age': [25, 30, 35],
        'Salary': [5000, 6000, 7000]}
df = pd.DataFrame(data)

# 使用melt()函数将Age和Salary列转换为行
melted_df = pd.melt(df, id_vars=['Name'], value_vars=['Age', 'Salary'], var_name='Attribute', value_name='Value')

print(melted_df)

      Name Attribute  Value
0    Alice       Age     25
1      Bob       Age     30
2  Charlie       Age     35
3    Alice    Salary   5000
4      Bob    Salary   6000
5  Charlie    Salary   7000