如何在python中编写交叉表查询？

pip install pandas

import pandas as pd

data = {'Category': ['A', 'B', 'A', 'B', 'A', 'B'],
        'Value': [1, 2, 3, 4, 5, 6]}
df = pd.DataFrame(data)

cross_tab = pd.crosstab(df['Category'], df['Value'])

print(cross_tab)

import pandas as pd

data = {'Category': ['A', 'B', 'A', 'B', 'A', 'B'],
        'Value': [1, 2, 3, 4, 5, 6]}
df = pd.DataFrame(data)

cross_tab = pd.crosstab(df['Category'], df['Value'])
print(cross_tab)