Pandas更改数据透视表中列的顺序

import pandas as pd

# 创建一个示例数据透视表
data = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [25, 30, 35],
    'Gender': ['Female', 'Male', 'Male'],
    'Salary': [5000, 6000, 7000]
}
df = pd.DataFrame(data)

# 创建数据透视表
pivot_table = df.pivot_table(index='Name', columns='Gender', values='Salary')

# 更改列的顺序
new_order = ['Male', 'Female']  # 新的列顺序
pivot_table = pivot_table.reindex(columns=new_order)

print(pivot_table)

Gender   Male  Female
Name                 
Alice     NaN  5000.0
Bob    6000.0     NaN
Charlie  7000.0     NaN