mysql 留存率统计_基于MySQL分析线上充值留存率

1.数据清洗

步骤：

1.查询charge_record表业务类型为充值且订单状态为成功的数据

2.将上述数据转移到本地数据库

使用如下脚本：

# coding=utf-8

import pymysql

# 原数据库链接

db1 = pymysql.connect(

host='***',

port=3306, user='***',

passwd='***',

db='***',

charset='utf8')

cursor1 = db1.cursor()

# 定义查询语句

len1 = cursor1.execute('select uid,update_time from charge_record where buss_type=0 and charge_status=2 and charge_prod_id is not null')

# 迁移数据库链接

db2 = pymysql.connect(

host='127.0.0.1',

port=3306, user='root',

passwd='123456',

db='test',

charset='utf8')

cursor2 = db2.cursor()

# 批量插入语句

sql = 'inser