题解 | #牛客网连续练习题目3天及以上的用户#
牛客网连续练习题目3天及以上的用户
https://www.nowcoder.com/practice/4d77709a0ea2482282ee86852fe32f06
import pandas as pd df = pd.read_csv("./nowcoder.csv", sep=",") df["date"] = pd.to_datetime(df["date"]).dt.date df["rk"] = df.groupby("user_id")["date"].rank() df = df.groupby("user_id")["user_id"].count() print(df)