用户行为路径漏斗转化计算分析

用户行为路径漏斗转化计算分析

import pandas as pd
import numpy as np
import sqlalchemy

import warnings
warnings.filterwarnings('ignore')

1、读取数据

# 读取数据。plat_flow：平台流量表；plat_check：贷款审核表

# 使用sql读取数据
engine = sqlalchemy.create_engine('mysql+pymysql://root:root1234@localhost:3306/wdfx')
sql_flow = "select * from plat_flow"
sql_check = "select * from loans_check"

# 执行sql语句，获取数据
dt_flow = pd.read_sql(sql=sql_flow, con=engine)
dt_check = pd.read_sql(sql=sql_check, con=engine)

dt_flow.rename(columns={
    "date":"日期",
    "PV":"PV",
    "UV":"UV",
    "regist_cnt":"注册数",
    "regist_rate":"访客注册率",
    "active_cnt":"激活数",
    "active_rate":"激活访问率"
},inplace=True)

dt_check.rename(columns={
    &#