题解 | 牛客网用户练习的平均次日留存率
牛客网用户练习的平均次日留存率
https://www.nowcoder.com/practice/1f9e2b9be96b4b27a2476f8f12c5d29f
import pandas as pd
df = pd.read_csv('nowcoder.csv', sep=',')
df['date'] = pd.to_datetime(df['date']).dt.date
df1 = df.copy()
df1['date'] = df1['date'] + pd.Timedelta(days=1)
total = pd.merge(df,df1,how='inner',on=['user_id','date'])
m = total['user_id'].count()
n = df['user_id'].count()
# 计算次日留存率
print(round(m/n,2))
