用户行为实时分析限时秒杀

import pandas as pd
from datetime import datetime

# 模拟用户行为数据
data = {
    'user_id': [1, 2, 3, 4, 5],
    'action': ['view', 'click', 'purchase', 'view', 'click'],
    'timestamp': [
        datetime(2023, 4, 1, 12, 0, 0),
        datetime(2023, 4, 1, 12, 0, 5),
        datetime(2023, 4, 1, 12, 1, 0),
        datetime(2023, 4, 1, 12, 1, 5),
        datetime(2023, 4, 1, 12, 2, 0)
    ]
}

df = pd.DataFrame(data)

# 实时分析用户行为
def analyze_user_behavior(df):
    # 统计各动作次数
    action_counts = df['action'].value_counts()
    print("Action Counts:", action_counts)
    
    # 计算转化率（查看->点击->购买）
    view_to_click_rate = (df[df['action'] == 'click']['user_id'].nunique() / df[df['action'] == 'view']['user_id'].nunique()) * 100
    click_to_purchase_rate = (df[df['action'] == 'purchase']['user_id'].nunique() / df[df['action'] == 'click']['user_id'].nunique()) * 100
    print("View to Click Rate: {:.2f}%".format(view_to_click_rate))
    print("Click to Purchase Rate: {:.2f}%".format(click_to_purchase_rate))

analyze_user_behavior(df)