mysql复购率_python执行mysql 计数复购率+pyechart+Excel+Tableau绘制双Y轴图

现有某超市的订单数据，内容如下：

demo库订单表.png

先求每个会员在每个月的订单数sql = ''' --

select MemberID, count(SheetID) AS 每个会员的订单数,substring(STime,1,7) as YearMonth

from OrderList

where MemberID IS NOT NULL

group by MemberID ,YearMonth

order by YearMonth

;

'''

df = pd.read_sql_query(sql, engine)

df.head(8)

每个会员每个月的订单数.png

给上表新增一列，判断其是否在本月多次购买select temp.YearMonth,temp.MemberID, temp.每个会员的订单数,

case when temp.每个会员的订单数>1 then 1 else null

end as 是否在本月多次购买

from

(

select MemberID, count(SheetID) AS 每个会员的订单数,substring(STim