按列顺序将特定列转换为行，并在Python中保持其余列不变

import pandas as pd

# 创建一个示例DataFrame
data = {'Name': ['Alice', 'Bob', 'Charlie'],
        'Age': [25, 30, 35],
        'City': ['New York', 'London', 'Paris'],
        'Salary': [5000, 6000, 7000]}

df = pd.DataFrame(data)

# 按列顺序将特定列转换为行，并保持其余列不变
df_melted = pd.melt(df, id_vars=['Name', 'Age'], value_vars=['City', 'Salary'])

print(df_melted)

      Name  Age variable      value
0    Alice   25     City   New York
1      Bob   30     City     London
2  Charlie   35     City      Paris
3    Alice   25   Salary       5000
4      Bob   30   Salary       6000
5  Charlie   35   Salary       7000