题解 | 牛客网用户练习的平均次日留存率

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))