木流_牛马

分类

/ 注册

全部文章（共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') df["da...

2025-04-15

0 49

题解 | 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 46

题解 | 牛客网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 45

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

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 38

题解 | 每天的日活数及新用户占比

#rihuo == mei tian , distinct, yonghuzongshu #xinyonghu zhanbi=dangtian xinyonghu /rihuo with tnew as ( select date(tb.in_time) as date_in_time,co...

2025-04-12

0 46

题解 | 计算商城中2021年每月的GMV

#shengxu #2021nian #meiyue #gmv>10w shuchu # gmv shi 0 +1 #baoliuzhengshu select date_format(event_time,'%Y-%m') as month,round(sum(total_amount),0...

2025-04-12

0 43

题解 | 每个创作者每月的涨粉率及截止当前的总粉丝量

#2021 #per creater per month #growth nb(jiafeng-diaofeng) growth rate(growth nb / bofang) (round 3) with fans_grow_nb as (select tbv.author as auth...

2025-04-11

1 56

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

with td as ( select id,uid,date(in_time) as indate,date(out_time) as outdate from tb_user_log ), tnew as ( select t.indate,count(t.uid) ...

2025-04-11

0 46

题解 | 平均播放进度大于60%的视频类别

with t1 as ( select tbv.video_id as video_id,tbv.tag as tag, sum(least(time_to_sec(timediff((time(tbu.end_time)),time((tbu.start_time)))),tbv.dura...

2025-04-10

1 50

题解 | 每类视频近一个月的转发量/率

with T_tot_per_video as ( select tv.*, count(tu.uid) as tot_vue_perv,sum(coalesce(tu.if_retweet,0)) as tot_retweet_perv from tb_video_info tv left joi...

2025-04-07

0 53