aa
import pandas as pd dfq=pd.read_csv('上線前.csv')dfq=dfq.sort_values(by='mean',ascending=False)
dfq=dfq.reindex(list(range(dfq.shape[0])))dfh=pd.read_csv('上線后.csv')
dfh=dfh.sort_values(by='mean',ascending=False)
dfh=dfh.reindex(list(range(dfq.shape[0])))
sql="""
with rank as(
SELECT group_id, SUM(pay_dollar) as pay_dollars, count(*) as count FROM
(select mod(player_id, 33) as group_id, pay_amount*exchange as pay_dollar FROM mafia1.offer_purchase
WHERE timestamp >='2019-10-24 16:10:00' and timestamp <='2019-10-30 18:50:00' and player_id not in (select player_id FROM mafia1.create_player where uid in (select uid from mafia1.internal_user)))group by group_id
order by pay_dollars)select group_id, pay_dollars/total_dollars as ratio, count, pay_dollars, pay_dollars/count as mean FROM rank, (select SUM(pay_dollars) as total_dollars FROM rank)
Order by pay_dollars
"""
import pandas as pd
dfg= pd.read_gbq(sql, dialect='standard')
總結
