对比对照组与实验组,统计转化差异,验证实验效果
使用 ab_test 数据集,包含用户ID、实验组别、转化情况、消费金额、点击量等信息。
首先读取A/B测试数据集。
使用 groupby 按实验组别分组查看。
转化率 = 转化用户数 / 总用户数。
比较对照组和实验组的平均消费。
查看点击量大于10的用户表现。
import pandas as pd df = pd.read_csv('ab_test.csv')
print(df.info())
print(df.describe())
user_count = df.groupby('group')['user_id'].count() print(user_count)
conversion_mean = df.groupby('group')['conversion'].mean() print(conversion_mean)
total_spent = df.groupby('group')['spent'].sum() print(total_spent)
converted_users = df[df['conversion'] == 1] avg_clicks = converted_users['clicks'].mean() print(avg_clicks)
control = df[df['group'] == 'control']['spent'].mean() treatment = df[df['group'] == 'treatment']['spent'].mean() diff = treatment - control print(diff)