熊猫交叉表平均值

import pandas as pd

# 创建一个示例数据集
data = {
    'Gender': ['Male', 'Female', 'Male', 'Female', 'Male', 'Female'],
    'Age': [25, 30, 35, 40, 45, 50],
    'Height': [170, 165, 180, 155, 175, 160],
    'Weight': [70, 60, 80, 50, 75, 55]
}

df = pd.DataFrame(data)

# 使用pivot_table计算交叉表平均值
cross_table = pd.pivot_table(df, values='Age', index='Gender', columns='Height', aggfunc='mean')

print(cross_table)

Height  155   160   165   170   175   180
Gender                                  
Female  NaN  40.0  30.0   NaN   NaN   NaN
Male    NaN   NaN   NaN  25.0  45.0  35.0