使用value_counts和python中的多列对百分比进行分组

import pandas as pd

# 创建一个示例数据集
data = {'A': ['a', 'b', 'a', 'b', 'a'],
        'B': ['x', 'y', 'x', 'y', 'x'],
        'C': [1, 2, 3, 4, 5]}
df = pd.DataFrame(data)

# 使用value_counts()计算每列的频率
counts_A = df['A'].value_counts()
counts_B = df['B'].value_counts()
counts_C = df['C'].value_counts()

# 使用groupby()对多列进行分组，并计算百分比
grouped = df.groupby(['A', 'B']).size().reset_index(name='count')
grouped['percentage'] = grouped['count'] / len(df) * 100

print(counts_A)
print(counts_B)
print(counts_C)
print(grouped)

a    3
b    2
Name: A, dtype: int64
x    3
y    2
Name: B, dtype: int64
5    1
4    1
3    1
2    1
1    1
Name: C, dtype: int64
   A  B  count  percentage
0  a  x      2        40.0
1  b  y      1        20.0
2  a  y      1        20.0
3  b  x      1        20.0