如何确定列中最常见的值是否出现超过X%次？

import pandas as pd

# 假设有一个包含值的列
data = ['A', 'B', 'C', 'A', 'B', 'A', 'A', 'B', 'C', 'C']

# 创建一个DataFrame对象
df = pd.DataFrame(data, columns=['Column'])

# 统计每个值的出现次数
value_counts = df['Column'].value_counts()

# 计算总数
total_count = df['Column'].count()

# 找到出现次数最多的值及其对应的出现次数
most_common_value = value_counts.index[0]
most_common_count = value_counts.values[0]

# 计算出现次数最多的值的百分比
most_common_percentage = most_common_count / total_count * 100

# 设定给定的百分比阈值
threshold_percentage = 50

# 判断是否超过给定的百分比
if most_common_percentage > threshold_percentage:
    print(f"The most common value '{most_common_value}' appears more than {threshold_percentage}% of the time.")
else:
    print(f"The most common value '{most_common_value}' does not appear more than {threshold_percentage}% of the time.")