木流_牛马

分类

/ 注册

全部文章（共23篇）

题解 | 牛客直播开始时各直播间在线人数

#19;00 在线人数 #per subject #asc course id select ct.course_id, ct.course_name,count(distinct at.user_id) as online_num from attend_tb at join course_tb...

2025-04-22

0 38

题解 | 2021年11月每天新用户的次日留存率

#2021 11 #新用户 #第二天是否回来--->datediff=1 #跨天也行--> union with tnew as ( select distinct t.uid, date(in_time) as regtime from tb_user_log t ...

2025-04-22

0 19

题解 | 最长连续登录天数

#20230101-20230131 #max #lianxudenglu with trn as ( select fdate, user_id, row_number() over(partition by user_id order by fdate asc) as rn ...

2025-04-22

0 29

题解 | 国庆期间每类视频点赞量和转发量

# 10.01 guo qin tou san tian #by tag by day sum(like) from previous 7 days max(retweet) from previous 7 days # tag desc # day asc #t1 统计每天的每个视频的点赞和转...

2025-04-18

1 30

题解 | 各个视频的平均完播率

#2021 #有播放 #完播率 diff>= shiping shichang by shiping #round 3 #desc with t1 as( select t.*,(case when timestampdiff(second,t.start_time,t.end_t...

2025-04-18

0 27

题解 | 牛客用户刷题量的方差与提交次数的标准差

import sys import pandas as pd for line in sys.stdin: a = line.split() print(int(a[0]) + int(a[1])) df=pd.read_csv('Nowcoder.csv') print(round...

2025-04-15

0 28

题解 | 牛客网每日正确与错误的答题次数

import sys import pandas as pd for line in sys.stdin: a = line.split() print(int(a[0]) + int(a[1])) df=pd.read_csv('nowcoder.csv') df["da...

2025-04-15

0 29

题解 | 2020年毕业的人中最喜欢用Java的用户

import sys import pandas as pd pd.set_option('display.width', 300) # 设置字符显示宽度 pd.set_option('display.max_rows', None) # 设置显示最大行 pd.set_option('displa...

2025-04-15

0 28

题解 | 牛客网Python用户的成就值

import sys import pandas as pd for line in sys.stdin: a = line.split() print(int(a[0]) + int(a[1])) df=pd.read_csv('Nowcoder.csv') print(df[...

2025-04-15

0 26

题解 | 牛客网用户没有补全的信息

import sys import pandas as pd for line in sys.stdin: a = line.split() print(int(a[0]) + int(a[1])) df= pd.read_csv('./Nowcoder.csv') print(...

2025-04-15

0 23