牛客794288350号

分类

/ 注册

全部文章（共53篇）

题解 | 请写出计算粉丝ctr的sql语句

select sum(c.read_num) / sum(c.show_num) as fans_ctr from a join b on a.author_id = b.author_id join c on b.content_id = c.content_id ...

2025-06-03

0 57

题解 | 支付间隔平均值

SELECT CAST(AVG(ABS(timestampdiff(second,ol.logtime,sl.logtime))) AS SIGNED) AS gap FROM order_log ol JOIN select_log sl ON ol.order_id=s...

2025-06-03

0 46

题解 | 每天登陆最早的用户的内容喜好

SELECT T.log_day, ut.user_id, ut.hobby FROM ( SELECT MIN(log_time) AS earliest, DATE(log_time) as l...

2025-06-03

0 42

题解 | 统计加班员工占比

SELECT st.department, CONCAT ( ROUND( SUM( CASE WHEN TIMESTAMPDIFF (MINUTE, at.first_c...

2025-06-03

0 53

题解 | 更新用户积分信息？

SELECT ut.user_id, ut.point+a.order_price AS point FROM (SELECT user_id, sum(order_price) as order_price FROM ...

2025-05-10

0 54

题解 | 统计牛客网刷题数量500以上的大佬

import pandas as pd df=pd.read_csv('Nowcoder.csv') #df['Num_of_exercise'] = pd.to_numeric(df['Num_of_exercise'], errors='coerce') print(df.query('Nu...

2025-05-10

0 32

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

import pandas as pd file=pd.read_csv('Nowcoder.csv',dtype=object) print(file.query('Language=="Python"').Achievement_value.astype('int64')...

2025-05-10

0 40

题解 | 查看牛客网哪些用户使用Python

import pandas as pd file=pd.read_csv('Nowcoder.csv',dtype=object) print(file.query('Language=="Python"')) print(file.query('Language==&qu...

2025-05-07

0 97

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

import pandas as pd file=pd.read_csv('Nowcoder.csv',dtype=object) print(file.isna().any(axis=0)) # 1) any () 函数用于判断给定的可迭代参数 iterable 是否都为 Fals...

2025-05-06

0 51

题解 | 统计牛客网部分用户使用语言

import pandas as pd file=pd.read_csv('Nowcoder.csv',dtype=object) print(file.loc[10:20]['Language']) # loc左闭右闭# iloc左闭右开

2025-05-06

0 63