Python pandas :具有各自计数的数据透视表？

import pandas as pd

data = {
    'Date': ['2023-01-01', '2023-01-01', '2023-01-02', '2023-01-02', '2023-01-03'],
    'Product': ['A', 'B', 'A', 'B', 'A'],
    'Sales': [100, 150, 200, 250, 300]
}

df = pd.DataFrame(data)
print(df)

         Date Product  Sales
0  2023-01-01       A    100
1  2023-01-01       B    150
2  2023-01-02       A    200
3  2023-01-02       B    250
4  2023-01-03       A    300

pivot_table = pd.pivot_table(df, 
                             index='Date', 
                             columns='Product', 
                             values='Sales', 
                             aggfunc='count', 
                             fill_value=0)
print(pivot_table)

Product      A  B
Date              
2023-01-01   1  1
2023-01-02   1  1
2023-01-03   1  0

pivot_table = pd.pivot_table(df, 
                             index='Date', 
                             columns='Product', 
                             values='Sales', 
                             aggfunc={'Sales': ['sum', 'mean', 'count']}, 
                             fill_value=0)
print(pivot_table)

          Sales              
              sum   mean count
Product        A    B    A    B    A  B
Date                                    
2023-01-01   100  150  100  150    1  1
2023-01-02   200  250  200  250    1  1
2023-01-03   300    0  300    0    1  0