pd.pivot_table(data, values=None, index=None, columns=None, 
               aggfunc='mean', fill_value=None, margins=False, 
               dropna=True, margins_name='All')

import pandas as pd

# 创建示例数据帧
df1 = pd.DataFrame({
    'Date': ['2023-01-01', '2023-01-02', '2023-01-03'],
    'Product': ['A', 'B', 'A'],
    'Sales': [100, 150, 200]
})

df2 = pd.DataFrame({
    'Date': ['2023-01-01', '2023-01-02', '2023-01-04'],
    'Product': ['B', 'A', 'C'],
    'Sales': [120, 180, 90]
})

# 合并数据帧
combined_df = pd.concat([df1, df2])

# 创建透视表
pivot = pd.pivot_table(combined_df, 
                       values='Sales', 
                       index='Product', 
                       columns='Date', 
                       aggfunc='sum',
                       fill_value=0)

print(pivot)

# 分别创建透视表
pivot1 = pd.pivot_table(df1, 
                       values='Sales', 
                       index='Product', 
                       columns='Date', 
                       aggfunc='sum',
                       fill_value=0)

pivot2 = pd.pivot_table(df2, 
                       values='Sales', 
                       index='Product', 
                       columns='Date', 
                       aggfunc='sum',
                       fill_value=0)

# 合并透视表
combined_pivot = pivot1.add(pivot2, fill_value=0).fillna(0)
print(combined_pivot)

# 添加地区信息
df1['Region'] = ['North', 'South', 'North']
df2['Region'] = ['South', 'North', 'East']

combined_df = pd.concat([df1, df2])

# 多级索引透视表
multi_pivot = pd.pivot_table(combined_df, 
                            values='Sales', 
                            index=['Region', 'Product'], 
                            columns='Date', 
                            aggfunc='sum',
                            fill_value=0)

print(multi_pivot)

# 使用多个聚合函数
multi_agg = pd.pivot_table(combined_df, 
                          values='Sales', 
                          index='Product', 
                          columns='Date', 
                          aggfunc=['sum', 'mean', 'count'],
                          fill_value=0)

print(multi_agg)

# 添加总计
pivot_with_margins = pd.pivot_table(combined_df, 
                                   values='Sales', 
                                   index='Product', 
                                   columns='Date', 
                                   aggfunc='sum',
                                   fill_value=0,
                                   margins=True,
                                   margins_name='Total')

print(pivot_with_margins)

combined_df = pd.concat([df1, df2], keys=['df1', 'df2'])